This position reports to the Director of the DAIR Department.
DESCRIPTION OF DUTIES:

• Develops and maintains systems created in-house for a variety of purposes. These systems generally use Oracle's APEX/ORDS framework, presenting web applications backed by databases, but this position should also be flexible in utilizing alternatives to Oracle, if there is a better solution.

o Works with users to define system needs.
o Identifies tasks suitable for automation.
o Develops relational schemas to fit the needs.
o Creates constraints to ensure relational integrity.
o Develops stored procedures to implement requirements, enforce business rules, etc.

• Develops and maintains scripts for various purposes, generally run as "cron" jobs or as database-scheduled jobs. Examples include

o Scripts to maintain important Google Groups.
o Scripts to generate Google Sheets for reporting and billing purposes.
o Jobs to create daysheets for staff to report their allocation of time.

• Manages databases in the Oracle cloud and on-premises.
• Advises on directions to be taken in system development.
• Manages the infrastructure staff in efficiently serving data to affiliates.
• Works collaboratively with the DAIR web development team to build new systems using alternative frameworks outside of Oracle both for internal AFL-CIO use and broader labor movement usage.
• As needed, helps the Accounting Department with special tasks related to its Great Plains accounting system.
• As needed, helps IT with the Trackit inventory system.
• Establishes and documents procedures for the tasks named.
• Other duties as assigned.

Qualifications

• Bachelor's degree or equivalent technical experience, with a minimum of six years working in programming and database administration.
• Demonstrated experience leading or managing the work of a team of data engineers or database developers;
• Thorough knowledge of relational databases and SQL, preferably with experience in Oracle, SQL Server, and Postgres.
• A knowledge of database procedural languages, preferably to include PL/SQL and T-SQL.
• Practice in diagnosing and resolving database performance issues.
• Proficiency in scripting languages, to include Python and Javascript.
• Experience in the development of web applications, preferably including the use of Oracle ORDS/APEX.
• Proficiency in the use and management of Linux servers.
• Proficiency in the use and troubleshooting of Windows systems.
• Proficiency in writing scripts that use remote APIs, for example Google Admin API.
• Experience in the use of cloud-based systems.
• Demonstrated experience project managing development of internal systems to make work more efficient;
• Ability to communicate and present complex technical concepts and analysis to technical and non-technical audiences;
• Sound knowledge of debugging and troubleshooting generally.
• Ability to communicate well orally and in writing.
• Interpersonal skills, including the ability to work comfortably with bargaining unit staff.
• Ability to work independently as well as lead and work in a team environment;
• Strong project management and problem-solving skills;
• Effective time management skills, including prioritizing and managing multiple tasks, and in developing campaign and personal work plans and goals;
• Demonstrated ability to work effectively in politically sensitive and high-pressure environments;
• Ability to work well under tight deadlines;
• Ability to work long and irregular hours, including weekends; and to travel as needed.