Senior Oracle Administrator - PostgreMS SQL, MYMS SQL
India
Apply now
Job Description
Senior Oracle Administrator - PostgreMS SQL, MYMS SQL
Gautam Buddha Nagar, Uttar Pradesh

Job Summary

PostgreSQL Database Admin – Key Responsibilities • Perform detailed assessments of Oracle schemas, PL/SQL code, and database features to design equivalent PostgreSQL implementations. • Install, configure, and maintain PostgreSQL databases, including patching, version upgrades, and environment optimization. • Configure, administer, and manage PostgreSQL for high performance, availability, and security. • Implement and manage HA/DR solutions using tools such as Patroni and pgBackRest, ensuring robust replication and recovery capabilities. • Develop and execute performance tuning strategies including query optimization, indexing, and database configuration adjustments. • Manage backup and recovery processes, ensuring compliance with defined RTO/RPO metrics. • Collaborate with application teams to rewrite and optimize PL/SQL code into PostgreSQL-compatible PL/pgSQL functions and procedures. • Monitor database health, capacity, and growth trends while proactively troubleshooting and resolving incidents. • Prepare and maintain documentation for migration strategies, configuration standards, and operational procedures

Key Responsibilities

PostgreSQL Database Admin – Key Responsibilities • Perform detailed assessments of Oracle schemas, PL/SQL code, and database features to design equivalent PostgreSQL implementations. • Install, configure, and maintain PostgreSQL databases, including patching, version upgrades, and environment optimization. • Configure, administer, and manage PostgreSQL for high performance, availability, and security. • Implement and manage HA/DR solutions using tools such as Patroni and pgBackRest, ensuring robust replication and recovery capabilities. • Develop and execute performance tuning strategies including query optimization, indexing, and database configuration adjustments. • Manage backup and recovery processes, ensuring compliance with defined RTO/RPO metrics. • Collaborate with application teams to rewrite and optimize PL/SQL code into PostgreSQL-compatible PL/pgSQL functions and procedures. • Monitor database health, capacity, and growth trends while proactively troubleshooting and resolving incidents. • Prepare and maintain documentation for migration strategies, configuration standards, and operational procedures

Skill Requirements

PostgreSQL Database Admin – Key Responsibilities • Perform detailed assessments of Oracle schemas, PL/SQL code, and database features to design equivalent PostgreSQL implementations. • Install, configure, and maintain PostgreSQL databases, including patching, version upgrades, and environment optimization. • Configure, administer, and manage PostgreSQL for high performance, availability, and security. • Implement and manage HA/DR solutions using tools such as Patroni and pgBackRest, ensuring robust replication and recovery capabilities. • Develop and execute performance tuning strategies including query optimization, indexing, and database configuration adjustments. • Manage backup and recovery processes, ensuring compliance with defined RTO/RPO metrics. • Collaborate with application teams to rewrite and optimize PL/SQL code into PostgreSQL-compatible PL/pgSQL functions and procedures. • Monitor database health, capacity, and growth trends while proactively troubleshooting and resolving incidents. • Prepare and maintain documentation for migration strategies, configuration standards, and operational procedures

Other Requirements

PostgreSQL Database Admin – Key Responsibilities • Perform detailed assessments of Oracle schemas, PL/SQL code, and database features to design equivalent PostgreSQL implementations. • Install, configure, and maintain PostgreSQL databases, including patching, version upgrades, and environment optimization. • Configure, administer, and manage PostgreSQL for high performance, availability, and security. • Implement and manage HA/DR solutions using tools such as Patroni and pgBackRest, ensuring robust replication and recovery capabilities. • Develop and execute performance tuning strategies including query optimization, indexing, and database configuration adjustments. • Manage backup and recovery processes, ensuring compliance with defined RTO/RPO metrics. • Collaborate with application teams to rewrite and optimize PL/SQL code into PostgreSQL-compatible PL/pgSQL functions and procedures. • Monitor database health, capacity, and growth trends while proactively troubleshooting and resolving incidents. • Prepare and maintain documentation for migration strategies, configuration standards, and operational procedures
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.