Track Manager - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
HCLTech
HCLTech
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.
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.
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.
HCLTech
IT Consulting