Senior Database Engineer

Company: Apex Systems
Location: West Jordan
Posted on: April 15, 2025

Job Description:

We see you're coming in from Europe. Are you interested in a position with Apex Systems? Send us your information and resume or call us at our Cork office +353 21 2330 150Job#: 2066008Job 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.
    #J-18808-Ljbffr

Keywords: Apex Systems, Murray , Senior Database Engineer, Engineering , West Jordan, Utah