Senior Lead DBA: SQL to PostgreSQL on AWS Migration

iCIMS, Inc.; Holmdel Township (NJ); On-site; USD 175,000 - 215,000; Full time

Job summary

ICIMS is seeking a Tech Lead DBA to guide a 4-7 member team through a complex migration from SQL Server to PostgreSQL on AWS RDS. You will set direction, timelines, and ensure data integrity across environments while maintaining operational continuity and alignment with enterprise standards.

You will collaborate with engineering, architecture, and application teams, shape long-term database strategy, and develop playbooks and runbooks to enable a smooth handoff to PostgreSQL as the primary

Qualifications

• 10+ Years of Hands-on experience with AWS, specifically RDS for PostgreSQL, MSSQL, and Aurora.
• 8+ Years of Strong experience with PostgreSQL administration in production environments.
• Proven track record in production support, including on-call responsibilities.
• Experience with database monitoring, alerting, and troubleshooting tools.
• Deep knowledge of backup, recovery, and HA/DR strategies.
• Strong analytical and problem-solving skills.
• Ability to work in a fast-paced global environment.
• Effective communicator and collaborator across technical teams.

Responsibilities

• Lead and manage the multi-phase migration program from SQL Server to PostgreSQL on AWS RDS, setting direction and timelines.
• Oversee and mentor the DBA team responsible for both SQL Server and PostgreSQL during the transition.
• Develop and govern migration strategies, including schema modernization and cutover execution.
• Provide operational oversight with root-cause analysis and proactive issue detection.
• Collaborate with engineering, application teams, cloud architects, and leadership stakeholders.
• Drive documentation, standards, and knowledge-sharing frameworks for long-term maintainability.

Skills

AWS RDS PostgreSQL

SQL Server

PostgreSQL

Aurora

Leadership

Monitoring

Communication

Team coaching

Job description

ICIMS is seeking a Tech Lead DBA to guide a 4-7 member team through a complex migration from SQL Server to PostgreSQL on AWS RDS. You will set direction, timelines, and ensure data integrity across environments while maintaining operational continuity and alignment with enterprise standards.

You will collaborate with engineering, architecture, and application teams, shape long-term database strategy, and develop playbooks and runbooks to enable a smooth handoff to PostgreSQL as the primary