[LPS] Database Administrator Team Lead
LPS
Job Description
We are seeking an experienced Hybrid DBA Lead with both on-premise and cloud DBA expertise and a solid understanding of ITIL practices to manage and optimize our clients on-premise & cloud-based database systems. The ideal candidate will have hands-on experience with SQL Server, Oracle, AWS RDS, SQL/NoSQL databases, capable of ensuring high availability, performance, and compliance through structured processes, leading and mentoring a team of DBAs in terms of resource and technical matters.
Key Responsibilities:Lead a team of DBAs in the team resourcing and work plans, technical mentoring & support.Drive the standardization of database maintenance activities in terms of process, procedures, automation for all clients to drive efficient operations.Install, configure, and maintain database instances for different varieties of database when required.Monitor database performance, analyze resource utilization, and optimize SQL queries. Design and implement high availability solutions such as Log Shipping, Mirroring, Replication, Clustering, and Always On Availability Groups. Perform database backups, restores, and support disaster recovery processes.
Apply security patches and updates to ensure security compliance. Troubleshoot and resolve issues across the database stack, including software, hardware, OS, and network layers.Implement database security measures to protect data integrity and confidentiality. Support application development teams by analyzing database requirements and optimizing database-related code.
Address system vulnerabilities, apply fixes, and support legacy systems. Develop and maintain scripts for automation of routine tasks such as backups, monitoring, health checks, housekeeping and reporting. Create, maintain and update comprehensive documentation related to configurations, procedures, and issue resolution.Provide regular reports on database health, patch level, back as per requirements.Work collaboratively across teams to ensure database reliability, scalability, and performance.Participate in 24x7 on-call rotation, ensuring timely response to incidents as per SLAs.
Collaborate with DevOps, Security, and Application teams to support change releases and service transitions.Apply ITIL-aligned incident, change, and problem management practices in daily operations.
Technical Skillsets RequirementsMS SQL ServerInstall, configure, maintain, and upgrade SQL Server (2016/2019/2022) instances in cloud/on-prem environments.Configure Always On Availability Groups, Log Shipping, Replication, and other HA/DR solutions.Conduct performance tuning, query optimization, and implement indexing strategies.Automate administrative tasks using T-SQL and PowerShell.Migrate databases to AWS RDS and EC2 using best practices.Implement and manage security, including access control, encryption, and auditing.Oracle DatabaseInstall, configure, and administer Oracle 12c, 19c databases (on-prem and AWS-hosted).Set up and manage Oracle Data Guard, RMAN backups, and tuning/diagnostics.Perform routine health checks, patching, schema changes, and space management.AWS RDS (SQL Server & Oracle 19c), NoSQL databases (e.g. DynamoDB, MongoDB)Manage provisioning, configuration, and maintenance of RDS SQL Server and Oracle 19c instances.Monitor RDS performance, configure backup retention, parameter groups, and apply patches.Handle snapshots, restore operations, and troubleshoot RDS-related issues.
Required Skills and Experience:At least 8 years of DBA experience with strong focus on Microsoft SQL Server.5+ years of hands-on experience managing Oracle 12c, 19c databases.Experience with AWS RDS (SQL Server and Oracle), and performance tuning in cloud environments.Strong scripting skills in T-SQL, PL/SQL, and PowerShell.Deep understanding of HA/DR, backup/restore strategies, and cloud migration approaches.Experience with monitoring, alerting, and automation tools including CloudWatch, Azure Monitor.Mandatory Certifications:Microsoft Certified: SQL Server DBA or Azure Administrator AssociateAWS Certified Database – Specialty or AWS Certified Solution Architect AssociateOracle Database 12c, 19c Administrator Certified ProfessionalSoft Skills:Experienced in leading a team and ability to motivate, coach, and develop team members.Excellent communication, problem-solving, and documentation skillsAbility to work independently and collaboratively in a remote or hybrid environmentFlexible to support critical issues and on-call rotations if requiredGood to Have:Working knowledge of MySQL and PostgreSQL in cloud environments (especially AWS RDS)Exposure to DevOps tools, Terraform, CloudFormation, or CI/CD pipelinesExperience with multi-region/multi-AZ deployments and cost optimization in AWSExposure to WOG/GCC and GCC+ environments is a strong advantage
#LPS