Assistant Manager IT - DBA

Job Purpose :

1. The Assistant Manager – DBA will be responsible for ensuring the 24x7 availability, performance, and security of the enterprise database environment supporting mission-critical applications. This role will serve as a senior technical resource and advisor to project teams, providing expertise in database administration, architecture, performance optimization, and best-practice maintenance.

Job Responsibilities:

1. Administer, install, migrate, and upgrade Oracle, MySQL, PostgreSQL, and SQL Server databases.
2. Manage and optimize database maintenance activities, including backups, indexing, integrity checks, and consistency verification.
3. Monitor database systems to ensure high availability, reliability, and error-free operations.
4. Diagnose and resolve complex performance issues, including debugging stored procedures, triggers, and packages.
5. Provide operational support to developers, operations teams, and data warehouse teams.
6. Implement database lifecycle management strategies, including archiving, compression, and capacity planning.
7. Perform physical and logical backups, RMAN scripting, restores, and disaster recovery operations.
8. Configure, administer, and manage Disaster Recovery (DR) environments using technologies such as Oracle Data Guard (ODG), Log Shipping, MySQL/PostgreSQL replication, or cluster-based solutions to ensure business continuity.
9. Deploy and manage Oracle RAC 12c/19c with ASM, ensuring scalability and resilience.
10. Apply security patching, bug fixes, and best practices for database security and compliance.
11. Design and implement high-availability and replication solutions such as Oracle Data Guard, InnoDB Cluster, Patroni, and SQL Server Always-On.
12. Lead initiatives for database upgrades, large-scale migrations, and performance enhancements.
13. Coordinate with vendors for support, licensing, and technology adoption.
14. Utilize tools such as Oracle Enterprise Manager Grid and VERITAS NetBackup for monitoring and backup management.
15. Contribute to database architecture planning, middleware integration, and infrastructure optimization.
16. Prepare and deliver comprehensive documentation, technical presentations, and RFPs in support of projects and management initiatives.

Eligibility Criteria (Education, Knowledge, Experience and Skills):

Education :

1. Should have Bachelor’s Degree / Equivalent, preferably in Computer Sciences / Engineering.

Work Experience:

1. Should have 5+ years of experience in database administration, engineering, or architecture.
2. Should have experience in the telecom sector or handling large-scale, high-transaction databases is a plus.

Skills – Generic:

1. Self-driven, structured, and solution-oriented with a strong focus on deliverables.
2. Excellent analytical, troubleshooting, and performance-tuning skills.
3. Self-motivated, organized, and focused on achieving results.
4. Strong analytical, troubleshooting, and performance-tuning abilities.
5. Good interpersonal and communication skills with proficiency in English.
6. Ability to build trust, encourage teamwork, and work effectively with cross-functional teams.
7. Able to work under pressure and meet deadlines while maintaining quality.

Skills – Job Specific :

1. Strong in Oracle Database administration (Standalone & Cluster).
2. Solid experience with Oracle RAC, ASM, and Data Guard.
3. Hands-on with MySQL, PostgreSQL, and SQL Server.
4. Good knowledge of Linux/Solaris administration.
5. Skilled in Oracle Enterprise Manager Grid.
6. Strong in performance tuning and troubleshooting.
7. Good knowledge of backup and recovery using RMAN and VERITAS NetBackup.
8. Skilled in Data Guard, Log Shipping, MySQL/Postgres replication, InnoDB Cluster, Patroni, and Always-On.