Lead DBA

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

Job Overview

The Tech Lead DBA will provide technical and organizational leadership for a Team of 4-7 Database Administrators in a large-scale, multi-phase modernization of the company’s database platforms. This role will guide teams through the transition from Microsoft SQL Server to PostgreSQL on AWS RDS, ensuring operational continuity, strategic alignment, and smooth adoption of the new database ecosystem. The ideal candidate brings strong database expertise, proven leadership experience, and the ability to collaborate across engineering, architecture, and application organizations while shaping standards, processes, and long-term database strategy.

About Us

ICIMS is a leading enterprise hiring platform that combines the scale and reliability of enterprise software with the transformative power of AI. Thousands of organizations across more than 200 countries and territories trust ICIMS to find and hire the people who shape their future and drive their business forward. Powered by insights from billions of hiring interactions, continuous AI innovation, and a highly extensible platform, ICIMS helps organizations turn talent acquisition into a competitive advantage. For more than 25 years, ICIMS has delivered end-to-end hiring solutions that improve recruiting efficiency, reduce costs and create exceptional candidate experiences.

ICIMS helps solve one of the biggest challenges businesses face today: building a workforce that can adapt, scale, and perform in an increasingly competitive and unpredictable talent market. We uniquely do that by combining enterprise-grade hiring technology, AI-powered insights and automation, and connected talent experiences to help organizations improve hiring outcomes while driving measurable impact.

Responsibilities

• Lead and manage the multi-phase migration program from SQL Server to PostgreSQL on AWS RDS, setting direction, defining timelines, allocating resources, and ensuring minimal downtime and full data integrity across all environments.
• Oversee and mentor the DBA team responsible for administering both SQL Server and PostgreSQL during the transition, guiding them in performance tuning, monitoring, incident response, capacity planning, and security hardening.
• Develop and govern migration strategies, including schema modernization, data replication patterns, cutover execution, and application compatibility validation using AWS-native tools and best practices.
• Provide operational oversight by establishing processes for root-cause analysis, proactive issue detection, and environment stabilization while ensuring consistent and reliable platform operations across both database systems. Off hours support as needed
• Collaborate closely with engineering, application teams, cloud architects, and leadership stakeholders to ensure database architecture aligns with business goals, future scalability, and security/compliance standards.
• Drive documentation, standards, and knowledge-sharing frameworks including playbooks, runbooks, and onboarding materials to ensure long-term maintainability and smooth operational handoff once PostgreSQL becomes the primary platform.

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.
• Proactive, detail-oriented, and committed to operational excellence
• Experience with SQL and NoSQL data platform deployments and management

Preferred

• Scripting and automation skills in Python.
• Exposure to other database technologies or data platforms; MSSQL, MongoDB, MySQL.
• Experience with infrastructure-as-code and CI/CD pipelines.
• Experience migrating MSSQL to PostgreSQL
• Exposure to other cloud technologies like Azure and GCP

EEO Statement

ICIMS is a place where everyone belongs. We celebrate diversity and are committed to creating an inclusive environment for all employees. Our approach helps us to build a winning team that represents a variety of backgrounds, perspectives, and abilities. So, regardless of how your diversity expresses itself, you can find a home here at ICIMS. We are proud to be an equal opportunity and affirmative action employer. We prohibit discrimination and harassment of any kind based on race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity, gender expression, age, veteran status, genetic information, disability, or other applicable legally protected characteristics. If you’d like to view a copy of the company’s affirmative action plan or policy statement and/or if you would like to request an accommodation due to a disability, please contact us [e-mail].

Compensation and Benefits

The anticipated base pay range for this position is $175,000-$215,000.00 annually. Final compensation will be based on factors such as relevant experience, skills, education, internal equity, and market data. This range aligns with our commitment to equitable and transparent compensation practices, as required by applicable law.

Competitive health and wellness benefits include medical, dental, vision, 401(k), dependent care, short term and long-term disability, life and AD&D insurance, bonding and parental leave, mindfulness resources, an open vacation policy, sick days, paid holidays, quiet hours each workday, and tuition reimbursement. Benefits and eligibility may vary by location, role, and tenure.Learn more here: https://careers.icims.com/benefits.