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
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
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
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
HCLTech is a global technology company, home to more than 226,600 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 September 2025 totaled $14.2 billion. To learn how we can supercharge progress for you, visit hcltech.com.
