Track Manager - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)

HCLTech

8–10 yrs Bengaluru, Chennai Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking an experienced PostgreSQL DBA L3 professional to manage global database operations. This role involves rotational shifts and requires a deep understanding of various RDBMS, including Oracle, MySQL, and MS SQL. The ideal candidate will be responsible for ensuring 24/7 database availability and performance.

This position offers an exciting opportunity to work on diverse client and infrastructure projects, focusing on database patching, upgrades, and migrations. You will also contribute to automation initiatives and collaborate with application teams to provide robust solutions. A strong background in troubleshooting complex performance issues and managing large-scale database environments is essential.

Responsibilities

Key responsibilities include maintaining 24/7 database support, handling incidents, requests, problems, and changes. You will also provide on-call support during weekends and off-hours, and own the delivery of client and infrastructure projects. Planning and executing database patching, upgrades, and migrations are crucial tasks.

Further duties involve managing database tools and scripts, overseeing primary DBA roles for multiple applications, and driving automation for recurring tasks. Reducing ticket volumes through proactive problem management and conducting disaster recovery tests are also part of the role. Identifying and delivering Proof of Concepts for new RDBMS features and technologies is encouraged.

Qualifications

Candidates must possess hands-on experience with database standards and end-user applications, with specific expertise in PostgreSQL versions 12 through 15. Excellent knowledge of PostgreSQL RDBMS architecture, design, backup, recovery (PITTR), replication, and performance tuning is required. Proficiency in using tools like REPMGR, PGBACKREST, and pg_bouncer, along with a good understanding of configuration files such as Pg_hba.Conf and Postgresql.Conf, is essential.

Scripting skills in Ansible and Shell are mandatory, with Python or Perl being a plus. The role demands proven ability in troubleshooting complex performance problems, managing patching, upgrades, and migrations, and conducting performance analysis using open-source tools. Experience with RDS for PostgreSQL on AWS and managing large-scale environments (1000+ databases) is highly valued. Familiarity with ITIL processes and strong communication skills for global team collaboration are expected.

Essential Skills

PostgreSQLOracle AdministrationMYSQLMS SQLDatabase ArchitectureBackup and RecoveryReplicationPerformance TuningPG_DUMPPG_DUMPALLWAL ArchivingPoint in Time RecoveryREPMGRPGBACKRESTpg_repackpg_cryptopg_auditData Wrapperpg_bouncerPg_hba.ConfPostgresql.ConfAnsibleShell ScriptingTroubleshootingPerformance AnalysisOpen Source ToolsDisaster RecoveryRDS for PostgreSQLAWSITILIncident ManagementProblem ManagementChange ManagementQuality ManagementCSI

Good to Have

Python ScriptingPerl ScriptingBanking Domain Experience

Highlights

  • Actively hiring

More Details

RoleTrack Manager - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
DepartmentDatabase Administration
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting

Track Manager - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN) at HCLTech | SkillMX | SkillMX