Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

Noida, Uttar Pradesh

Job Summary

L2 PostgreSQL Database Administrator is responsible for the administration, monitoring, maintenance, and support of PostgreSQL databases in production and non-production environments. This role focuses on database availability, performance optimization, backup and recovery, incident resolution, security compliance, and supporting business-critical applications. The position works closely with application teams, infrastructure teams, cloud teams, and L3 database SMEs to ensure stable and secure database operations. Enterprise database operations and transformation activities are identified as key components of managed services delivery.

Key Responsibilities Database Administration & Operations Perform daily administration of PostgreSQL databases. Monitor database health, availability, and performance. Manage database instances across Linux and cloud environments. Execute database start/stop, maintenance, and validation activities. Support database provisioning and decommissioning activities. Ensure database uptime and operational stability. Incident & Problem Management Handle and resolve P2, P3, and P4 database incidents. Participate in major incident bridge calls when required. Perform initial root cause analysis for database-related issues. Escalate complex issues to L3 database engineers. Maintain incident documentation and resolution records. Database Performance Management Monitor query performance and database utilization. Analyze slow-running SQL queries. Support index optimization and statistics maintenance. Monitor CPU, memory, I/O, storage, and connection utilization. Assist application teams during performance investigations. Backup & Recovery Execute backup verification and restore testing. Monitor backup job completion and success status. Perform database restoration activities as per approved procedures. Support disaster recovery testing and validation. Security & Compliance Manage database users, roles, and privileges. Ensure compliance with security policies and audit requirements. Support vulnerability remediation and database hardening. Review database access requests and implement approved changes. Change & Release Support Implement approved database changes. Support application releases and deployments. Execute schema changes, patches, and upgrades. Participate in CAB reviews when required.

Required Technical Skills Database Technologies PostgreSQL 12/13/14/15/16 PostgreSQL Administration SQL & PL/pgSQL Database Backup & Recovery PostgreSQL Administration Areas User & Role Management Tablespaces Index Management Partitioning Replication High Availability Concepts Database Monitoring Database Security Operating Systems Linux (RHEL, CentOS, Oracle Linux) Basic Shell Scripting Cloud Database Platforms Good understanding of: Amazon RDS PostgreSQL Azure Database for PostgreSQL Cloud-based database operations and lifecycle management. Monitoring & Observability Grafana Splunk PostgreSQL Monitoring Tools Cloud Monitoring Platforms Enterprise Observability Platforms. ITSM Tools ServiceNow Incident Management Change Management Problem Management ITIL Processes

Experience 3–6 years of Database Administration experience. Minimum 2 years supporting PostgreSQL databases. Experience supporting production environments. Experience working in 24x7 operations and support models.

NA

51939509

Preferred Certifications\\\\r\\\\nPostgreSQL Associate Certification\\\\r\\\\nPostgreSQL Professional Certification\\\\r\\\\nAWS Certified Database Specialty (Preferred)\\\\r\\\\nMicrosoft Azure Database Certifications\\\\r\\\\nITIL Foundation

Key Responsibilities

L2 PostgreSQL Database Administrator is responsible for the administration, monitoring, maintenance, and support of PostgreSQL databases in production and non-production environments. This role focuses on database availability, performance optimization, backup and recovery, incident resolution, security compliance, and supporting business-critical applications. The position works closely with application teams, infrastructure teams, cloud teams, and L3 database SMEs to ensure stable and secure database operations. Enterprise database operations and transformation activities are identified as key components of managed services delivery.

Key Responsibilities Database Administration & Operations Perform daily administration of PostgreSQL databases. Monitor database health, availability, and performance. Manage database instances across Linux and cloud environments. Execute database start/stop, maintenance, and validation activities. Support database provisioning and decommissioning activities. Ensure database uptime and operational stability. Incident & Problem Management Handle and resolve P2, P3, and P4 database incidents. Participate in major incident bridge calls when required. Perform initial root cause analysis for database-related issues. Escalate complex issues to L3 database engineers. Maintain incident documentation and resolution records. Database Performance Management Monitor query performance and database utilization. Analyze slow-running SQL queries. Support index optimization and statistics maintenance. Monitor CPU, memory, I/O, storage, and connection utilization. Assist application teams during performance investigations. Backup & Recovery Execute backup verification and restore testing. Monitor backup job completion and success status. Perform database restoration activities as per approved procedures. Support disaster recovery testing and validation. Security & Compliance Manage database users, roles, and privileges. Ensure compliance with security policies and audit requirements. Support vulnerability remediation and database hardening. Review database access requests and implement approved changes. Change & Release Support Implement approved database changes. Support application releases and deployments. Execute schema changes, patches, and upgrades. Participate in CAB reviews when required.

Required Technical Skills Database Technologies PostgreSQL 12/13/14/15/16 PostgreSQL Administration SQL & PL/pgSQL Database Backup & Recovery PostgreSQL Administration Areas User & Role Management Tablespaces Index Management Partitioning Replication High Availability Concepts Database Monitoring Database Security Operating Systems Linux (RHEL, CentOS, Oracle Linux) Basic Shell Scripting Cloud Database Platforms Good understanding of: Amazon RDS PostgreSQL Azure Database for PostgreSQL Cloud-based database operations and lifecycle management. Monitoring & Observability Grafana Splunk PostgreSQL Monitoring Tools Cloud Monitoring Platforms Enterprise Observability Platforms. ITSM Tools ServiceNow Incident Management Change Management Problem Management ITIL Processes

Experience 3–6 years of Database Administration experience. Minimum 2 years supporting PostgreSQL databases. Experience supporting production environments. Experience working in 24x7 operations and support models.

NA

51939509

Preferred Certifications\\\\r\\\\nPostgreSQL Associate Certification\\\\r\\\\nPostgreSQL Professional Certification\\\\r\\\\nAWS Certified Database Specialty (Preferred)\\\\r\\\\nMicrosoft Azure Database Certifications\\\\r\\\\nITIL Foundation

Skill Requirements

L2 PostgreSQL Database Administrator is responsible for the administration, monitoring, maintenance, and support of PostgreSQL databases in production and non-production environments. This role focuses on database availability, performance optimization, backup and recovery, incident resolution, security compliance, and supporting business-critical applications. The position works closely with application teams, infrastructure teams, cloud teams, and L3 database SMEs to ensure stable and secure database operations. Enterprise database operations and transformation activities are identified as key components of managed services delivery.

Key Responsibilities Database Administration & Operations Perform daily administration of PostgreSQL databases. Monitor database health, availability, and performance. Manage database instances across Linux and cloud environments. Execute database start/stop, maintenance, and validation activities. Support database provisioning and decommissioning activities. Ensure database uptime and operational stability. Incident & Problem Management Handle and resolve P2, P3, and P4 database incidents. Participate in major incident bridge calls when required. Perform initial root cause analysis for database-related issues. Escalate complex issues to L3 database engineers. Maintain incident documentation and resolution records. Database Performance Management Monitor query performance and database utilization. Analyze slow-running SQL queries. Support index optimization and statistics maintenance. Monitor CPU, memory, I/O, storage, and connection utilization. Assist application teams during performance investigations. Backup & Recovery Execute backup verification and restore testing. Monitor backup job completion and success status. Perform database restoration activities as per approved procedures. Support disaster recovery testing and validation. Security & Compliance Manage database users, roles, and privileges. Ensure compliance with security policies and audit requirements. Support vulnerability remediation and database hardening. Review database access requests and implement approved changes. Change & Release Support Implement approved database changes. Support application releases and deployments. Execute schema changes, patches, and upgrades. Participate in CAB reviews when required.

Required Technical Skills Database Technologies PostgreSQL 12/13/14/15/16 PostgreSQL Administration SQL & PL/pgSQL Database Backup & Recovery PostgreSQL Administration Areas User & Role Management Tablespaces Index Management Partitioning Replication High Availability Concepts Database Monitoring Database Security Operating Systems Linux (RHEL, CentOS, Oracle Linux) Basic Shell Scripting Cloud Database Platforms Good understanding of: Amazon RDS PostgreSQL Azure Database for PostgreSQL Cloud-based database operations and lifecycle management. Monitoring & Observability Grafana Splunk PostgreSQL Monitoring Tools Cloud Monitoring Platforms Enterprise Observability Platforms. ITSM Tools ServiceNow Incident Management Change Management Problem Management ITIL Processes

Experience 3–6 years of Database Administration experience. Minimum 2 years supporting PostgreSQL databases. Experience supporting production environments. Experience working in 24x7 operations and support models.

NA

51939509

Preferred Certifications\\\\r\\\\nPostgreSQL Associate Certification\\\\r\\\\nPostgreSQL Professional Certification\\\\r\\\\nAWS Certified Database Specialty (Preferred)\\\\r\\\\nMicrosoft Azure Database Certifications\\\\r\\\\nITIL Foundation

Other Requirements

L2 PostgreSQL Database Administrator is responsible for the administration, monitoring, maintenance, and support of PostgreSQL databases in production and non-production environments. This role focuses on database availability, performance optimization, backup and recovery, incident resolution, security compliance, and supporting business-critical applications. The position works closely with application teams, infrastructure teams, cloud teams, and L3 database SMEs to ensure stable and secure database operations. Enterprise database operations and transformation activities are identified as key components of managed services delivery.

Key Responsibilities Database Administration & Operations Perform daily administration of PostgreSQL databases. Monitor database health, availability, and performance. Manage database instances across Linux and cloud environments. Execute database start/stop, maintenance, and validation activities. Support database provisioning and decommissioning activities. Ensure database uptime and operational stability. Incident & Problem Management Handle and resolve P2, P3, and P4 database incidents. Participate in major incident bridge calls when required. Perform initial root cause analysis for database-related issues. Escalate complex issues to L3 database engineers. Maintain incident documentation and resolution records. Database Performance Management Monitor query performance and database utilization. Analyze slow-running SQL queries. Support index optimization and statistics maintenance. Monitor CPU, memory, I/O, storage, and connection utilization. Assist application teams during performance investigations. Backup & Recovery Execute backup verification and restore testing. Monitor backup job completion and success status. Perform database restoration activities as per approved procedures. Support disaster recovery testing and validation. Security & Compliance Manage database users, roles, and privileges. Ensure compliance with security policies and audit requirements. Support vulnerability remediation and database hardening. Review database access requests and implement approved changes. Change & Release Support Implement approved database changes. Support application releases and deployments. Execute schema changes, patches, and upgrades. Participate in CAB reviews when required.

Required Technical Skills Database Technologies PostgreSQL 12/13/14/15/16 PostgreSQL Administration SQL & PL/pgSQL Database Backup & Recovery PostgreSQL Administration Areas User & Role Management Tablespaces Index Management Partitioning Replication High Availability Concepts Database Monitoring Database Security Operating Systems Linux (RHEL, CentOS, Oracle Linux) Basic Shell Scripting Cloud Database Platforms Good understanding of: Amazon RDS PostgreSQL Azure Database for PostgreSQL Cloud-based database operations and lifecycle management. Monitoring & Observability Grafana Splunk PostgreSQL Monitoring Tools Cloud Monitoring Platforms Enterprise Observability Platforms. ITSM Tools ServiceNow Incident Management Change Management Problem Management ITIL Processes

Experience 3–6 years of Database Administration experience. Minimum 2 years supporting PostgreSQL databases. Experience supporting production environments. Experience working in 24x7 operations and support models.

NA

51939509

Preferred Certifications\\\\r\\\\nPostgreSQL Associate Certification\\\\r\\\\nPostgreSQL Professional Certification\\\\r\\\\nAWS Certified Database Specialty (Preferred)\\\\r\\\\nMicrosoft Azure Database Certifications\\\\r\\\\nITIL Foundation