Job#: 2066008
Job Description:
Job Description:
- 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
- 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
- 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
- Conduct thorough assessments of current database structures, data volumes, and system integrations
- Design and manage database schemas ensuring they meet functional requirements and performance goals
- Lead the migration process, including data cleansing, migration scripting, data validation, and post-migration testing
- Collaborate with IT teams to ensure smooth integration with other enterprise applications
- 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
- Develop and enforce best practices for database management, security measures, and disaster recovery plans
- Document all processes related to database migration and routine maintenance as well as documentation of existing database systems
- Lead database designs and development for applications based on user requirements and specifications provided by Business or Technical Leads
- Build, migrate, and maintain databases for on-premise and cloud service systems
- Assist the Technical Project Leads in addressing technical issues
- Submit all test and production turnovers to Project Technical Lead to be installed
- Provide data modeling support to development projects as needed
- Assist application developers with complex query development and tuning
- Create database tables, indexes, constraints, stored procedures, and other database components and functions
- Prepare, deliver, install, and upgrade software databases into development, quality assurance, and production environments
- Design, implement, and enforce strong security structures and mechanisms for databases
- Create and update data schematics and dictionary structures to document and describe system databases, interfaces, and security
- Design, create, install, and manage automated databases, data reports, and chronological report runs
- Perform data validation to test the integrity of data, database relationships, calculations, references, and data reports
- Participate in the development of system database standards and development processes
- Interact with and support project leaders and teams, business analysts, and users in analysis, design, and testing processes on projects
- Coordinate with System Administrators on databases installations, upgrades, releases, problem solutions, and technical architecture changes
Must Haves:
- Proven experience as a Database Administrator with specific experience in data migration projects
- Extensive knowledge of database design, documentation, and coding
- Knowledge of the development and management of computer system databases and data warehouses
- Knowledge and/or experience with mainstream SQL databases
- Strong analytical, research, and organization skills, with impeccable attention to detail
- System administration skills are desired
- Knowledge of CI/CD Pipelines
- Strong understanding of database version control
- Ability to test and troubleshoot software using appropriate methodologies and techniques
- Excellent written/verbal communication, interpersonal, and organizational skills required
- Understand the principles, theories, and practices of computer science
- 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.


