Job#: 2066008

Job Description:

Job Description:

1. Apex Systems is looking for an experienced Engineer working on SQL databases hosted on Windows and Linux servers with a strong focus on database migration, re-platforming, and adoption of cloud computing services
2. The ideal candidate will lead a transition from Informix to a more modern, mainstream database management system, PostgreSQL hosted on AWS cloud services to enhance data processing capabilities and support future scalability and performance needs
3. Provide interim database maintenance, support, and administration supporting various applications while cross-training in-house support staff to assume those duties and responsibilities long-term
4. Conduct thorough assessments of current database structures, data volumes, and system integrations
5. Design and manage database schemas ensuring they meet functional requirements and performance goals
6. Lead the migration process, including data cleansing, migration scripting, data validation, and post-migration testing
7. Collaborate with IT teams to ensure smooth integration with other enterprise applications
8. Monitor system performance post-migration and optimize as needed to meet performance targets and provide ongoing maintenance, support, database integrity, troubleshooting, performance assessments, and enhancements in databases services
9. Develop and enforce best practices for database management, security measures, and disaster recovery plans
10. Document all processes related to database migration and routine maintenance as well as documentation of existing database systems
11. Lead database designs and development for applications based on user requirements and specifications provided by Business or Technical Leads
12. Build, migrate, and maintain databases for on-premise and cloud service systems
13. Assist the Technical Project Leads in addressing technical issues
14. Submit all test and production turnovers to Project Technical Lead to be installed
15. Provide data modeling support to development projects as needed
16. Assist application developers with complex query development and tuning
17. Create database tables, indexes, constraints, stored procedures, and other database components and functions
18. Prepare, deliver, install, and upgrade software databases into development, quality assurance, and production environments
19. Design, implement, and enforce strong security structures and mechanisms for databases
20. Create and update data schematics and dictionary structures to document and describe system databases, interfaces, and security
21. Design, create, install, and manage automated databases, data reports, and chronological report runs
22. Perform data validation to test the integrity of data, database relationships, calculations, references, and data reports
23. Participate in the development of system database standards and development processes
24. Interact with and support project leaders and teams, business analysts, and users in analysis, design, and testing processes on projects
25. Coordinate with System Administrators on databases installations, upgrades, releases, problem solutions, and technical architecture changes

Must Haves:

1. Proven experience as a Database Administrator with specific experience in data migration projects
2. Extensive knowledge of database design, documentation, and coding
3. Knowledge of the development and management of computer system databases and data warehouses
4. Knowledge and/or experience with mainstream SQL databases
5. Strong analytical, research, and organization skills, with impeccable attention to detail
6. System administration skills are desired
7. Knowledge of CI/CD Pipelines
8. Strong understanding of database version control
9. Ability to test and troubleshoot software using appropriate methodologies and techniques
10. Excellent written/verbal communication, interpersonal, and organizational skills required
11. Understand the principles, theories, and practices of computer science
12. Deal with people in a manner that shows sensitivity, tact, and professionalism

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.