Lead Database Administrator

We Core Solutions are hiring for the role of Lead DBA to join our Team.

Role Lead DBA (MSSQL DBA with AWS RDS).

Experience 12 - 14 years.

Location Chennai.

Work Mode Work from Office (Flexible Working hours).

Notice Period Immediate to 45 Days.

Position Summary :

We are seeking a Lead DBA to be part of the Infrastructure and Operations team through our journey of transformation as we transition to a SaaS-first organization. This role will be responsible for leading the design, implementation, maintenance, and optimization of database systems in the cloud (AWS RDS, Aurora, etc. This role combines hands-on technical expertise with leadership responsibilities, ensuring databases are secure, scalable, highly available, and cost-efficient while guiding a team of DBAs.

Role and Responsibilities :

Database Administration & Leadership :

- Lead and mentor a team of DBAs/engineers, providing technical direction and best practices.

- Oversee installation, configuration, patching, and upgrades of SQL Server and AWS-managed databases.

- Ensure database systems meet business performance, security, and availability requirements.

- Act as the escalation point for complex database performance and reliability issues.

Database Design & Architecture :

- Design and implement database solutions for high availability (HA) and disaster recovery (DR).

- Lead data modeling and schema design to support application requirements.

- Architect hybrid environments integrating on-prem SQL Server with AWS RDS/Aurora.

- Optimize database storage, partitioning, and indexing strategies.

Performance Tuning & Optimization :

- Conduct performance analysis, query tuning, and optimization of SQL workloads.

- Identify and resolve bottlenecks in database systems.

- Establish database monitoring solutions (CloudWatch, Performance Monitor, third-party tools).

- Drive automation for routine DBA tasks (backups, health checks, indexing).

Cloud Database Management (AWS) :

- Manage AWS RDS, Aurora, DynamoDB, Redshift, and other cloud-native database services.

- Implement automated backup, replication, and failover strategies in AWS.

- Monitor and optimize AWS costs for database workloads.

- Ensure secure integration between applications and AWS-managed databases.

Security & Compliance :

- Enforce database security best practices, encryption, and access controls.

- Ensure compliance with regulatory requirements (GDPR, HIPAA, PCI-DSS, etc.

- Manage identity and access policies (IAM) for AWS databases.

- Conduct audits and vulnerability assessments on database environments.

Backup, Recovery & DR Strategy :

- Define and implement backup and recovery strategies across SQL and AWS databases.

- Perform regular DR drills and ensure RPO/RTO objectives are met.

- Maintain replication and clustering for mission-critical systems.

Stakeholder & Project Management :

- Collaborate with developers, DevOps, and architects to support application and analytics workloads.

- Work with business stakeholders to understand data requirements and SLAs.

- Provide database-related input for cloud migration, modernization, and digital transformation initiatives.

- Prepare documentation, SOPs, and knowledge transfer for DB teams.

What we are looking for :

- Bachelor's degree in Computer Science, or a related field.

- 12-14 years of experience working in SQL Server administration including performance tuning, replication, clustering, Always ON).

- 4-5 years of experience working in AWS database services (RDS, Aurora, Redshift).

- Experience in DB migrations, upgrades to the cloud and on the cloud.

- Strong knowledge of backup/recovery strategies, HA/DR design, and monitoring tools.

- Strong analytical, problem-solving skills.

- Excellent communication skills, both written and verbal, with ability to convey complex technical concepts clearly and concisely.

- Should be able to lead from the front while directing the team and taking direction from the leadership as necessary.

- Knowledge of IT Service Management (ITIL4, ISO 20000) and understanding of security standards (ISO 27001, NIST, SOC2).

Nice to have :

- AWS certification(s).

- Familiarity with DevOps/CI-CD for databases (e.g., Liquibase, Flyway).

- Knowledge of scripting/automation (PowerShell, Python, Bash, or SQL scripts).

- Ability to work independently and as part of a team.

- Highly motivated and results oriented.

About us Core Solutions Inc. :

- Core Solutions (CORE), headquartered in King of Prussia, Pennsylvania, is the progressive leader in transforming the behavioral, medical and social services experience for behavioral health providers, consumers and state agencies.

- Our integrated behavioral health EHR platform, Cx360, allows for the improvement of the provider, consumer and payer relationship through increased consumer-centric collaboration which results in improved outcomes.

- Accomplishment through our ability to simplify the end-to-end behavioral health experience, deliver integrated care coordination, improve consumer engagement and streamline accurate provider more information visit.

- CORE believes the key to successful implementation of EHR solutions is aligning people and processes with technology.
Cores strong Cx360 EHR Technology Platform (versus traditional EHR Products).

- CORE, an equal opportunity employer is currently acquiring talents in diversified areas, including a team of Software Engineers/Developers/Senior Software Engineers/Technical Lead etc.

Our recruitment team has come across your resume in a leading job site. Should you be looking out for a change, please reply to this mail immediately with your updated resume, current salary, expected salary and notice period. Our team shall get in touch with you to take it up further.