Track Manager
Full Job Description
Job Summary
We are seeking a Senior Database Administrator / Database Engineer (L3) with over 9 years of experience to lead enterprise database administration for Oracle, PostgreSQL, Amazon Aurora, MongoDB, and Amazon DynamoDB environments. This role focuses on advanced engineering, performance tuning, high availability, backup/recovery strategies, security governance, and operational leadership across relational and NoSQL platforms.
Key Responsibilities
- Lead end-to-end administration of Oracle, PostgreSQL, Amazon Aurora, MongoDB, and DynamoDB platforms including installation, configuration, upgrades, patching, migrations, and lifecycle management.
- Troubleshoot complex issues related to database performance, connectivity, locking, replication, storage optimization, and availability.
- Perform advanced SQL/query tuning, indexing strategies, execution-plan analysis, and comprehensive performance optimization initiatives.
- Design, implement, and support robust High Availability (HA), replication, backup/recovery solutions, and Disaster Recovery plans to ensure business continuity.
- Take the lead in resolving critical database incidents with detailed Root Cause Analysis (RCA) reporting and prevention strategies.
- Spearhead database migration projects and modernization efforts across on-premises data centers, cloud environments, relational databases, and NoSQL systems.
- Administer and optimize AWS managed services such as Amazon Aurora and DynamoDB to ensure efficiency and scalability.
- Manage comprehensive database security protocols including user roles, privileges, authentication mechanisms, encryption standards, and access controls. Lead vulnerability remediation, patching schedules, security hardening, and compliance audits.
- Monitor database capacity planning, availability metrics, utilization trends, and performance indicators to recommend strategic improvements for cost optimization and resource efficiency.
- Develop robust automation scripts using Python, Shell scripting, Ansible, or Terraform to streamline administration, monitoring, maintenance tasks, and operational activities.
- Support cloud cost management initiatives and drive database-related resource optimization projects within AWS environments.
- Foster cross-functional collaboration with Application Development, Cloud Engineering, Infrastructure teams, Cybersecurity units, DevOps practitioners, and external vendors to ensure cohesive operations.
- Provide expert technical guidance, escalation support, and mentorship to Level 1 and Level 2 database support teams.
- Maintain up-to-date architecture documentation, Standard Operating Procedures (SOPs), operational runbooks, configuration standards, and a centralized knowledge base for team access.
Company
HCLTech
HCLTech is a leading global technology services company specializing in digital transformation, cloud solutions, and infrastructure management.
Practice this interview
A voice mock interview for Track Manager - Oracle Administration,PostgreSQL,MYSQL, MS SQL at HCLTech, with questions from this job description and your resume, and a scored report afterwards.
Set up interview