The Senior Database Analyst/Programmer is responsible for the design, development, and administration of enterprise data systems including Snowflake, Informix, and Oracle platforms. This role drives ETL processes, data migration strategies, and database performance tuning to support federal reporting, analytics, and operational requirements.

Responsibilities

• Plan and execute data migration strategies between Salesforce, Informix, and Snowflake, ensuring data integrity throughout transitions.
• Develop and maintain ETL processes to facilitate seamless data integration and synchronization across systems.
• Design, develop, and maintain core upgrades and regulatory changes using the Oracle Data Integrator platform.
• Monitor database performance, troubleshoot issues, and implement tuning measures including indexing, partitioning, and query optimization.
• Establish and manage backup and recovery procedures to safeguard data in compliance with federal regulations.
• Work closely with the Product Owner and IT Federal Project Manager to understand functional and technical requirements for DOL system changes.
• Collaborate with the Business Intelligence team to provide data necessary for BI reporting.
• Actively contribute to design decisions and work with BAs, SMEs, and system owners to understand mission, architecture, and security needs.
• Implement and maintain database security protocols; manage user access, roles, and permissions to enforce data privacy.
• Maintain accurate documentation of database architecture, configurations, and change logs.
• Prepare and present performance reports and proposed improvements to project stakeholders.
• Other duties as assigned.

Qualifications

• Bachelor of Science in Computer Science, Mathematics, or Engineering; Master's degree preferred.
• Minimum 4 years of experience in software development, including ETL tools such as Oracle Warehouse Builder or Oracle Data Integrator.
• Demonstrated experience with Oracle, Snowflake, and Informix databases.
• Experience gathering and mapping business requirements to data processes.
• Understanding of fundamental web development concepts.
• Familiarity with ODBC and JDBC connectivity for Snowflake is desirable.
• Strong analytical, verbal, and written communication skills with attention to detail.

Background/Clearance

• Federal Public Trust Background

Status

• Contingent on win

Physical Requirements

Employees must be able to sit at a workstation for extended periods of time. They should be able to use their hands to handle or feel objects, tools, or controls, as well as reach with their hands and arms. The ability to talk, see, and hear is also required. Employees must be capable of working on a desktop or laptop computer for long durations. Occasionally, they may need to lift and move moderate amounts of weight, typically no more than 30 pounds. Regular and predictable attendance is essential.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Alesig will make reasonable accommodations to enable individuals with disabilities to perform the essential functions and in compliance with the Americans with Disabilities Act of 1990.

Pre-Employment Screening Requirements

Must be able to successfully complete Alesig Consulting's pre-employment screening process and any additional pre-employment screens required for your position by the client.

If hired for the position, you must be able to provide proof of eligibility to work in the United States.

This job description lists the major duties and requirements of the job and is not all-inclusive. Incumbent(s) may be expected to perform job-related duties other than those contained in this document and may be required to have specific job-related knowledge and skills.

Alesig Consulting is an Equal Opportunity/Affirmative Action Employer