Job Description
Basic Qualifications:
5 Plus years of experience on PostgreSQL in database administration, in an enterprise environment with multiple database servers
Database Health - Validations and Monitoring.
Database Migrations - Dedicated support for application migration waves
Automation capabilities - Validating and assisting in the enablement of automated capabilities for DBMS Configuration and Management
Provision, Build, Configure, Patch & Maintain PostgreSQL Clusters.
Vendor Engagement - Triage support to remediate identified issues during migrations
Job ResponsibilitiesJob Responsibilities:
Providing 24x7 support for production databases.
PostgreSQL database administration skills include Installation, Configuration, Security management, and Audit SQL server with PBM, Patch management, Performance tuning, Query optimization, Storage management.
Experience in Installation, Creation, Maintenance of Databases, Performance Tuning, Backup and Recovery, Providing and Configuring Disaster Recovery Solutions and Database Security.
Managing PostgreSQL 12, 13, 14, 15 & 16 instances.
Managing , Open Prem, AWS and Azure (PostgreSQL).
Experience in Streaming, Logical and Trigger Based Replication (repmgr, Patroni).
Installation and Configuration of Backup and Recovery (pgbackrest)
Formulated backup-recovery strategies for various Databases.
Installation and Configuration of repmgr 3.x, PgBouncer.
Implementation of database maintenance jobs to ensure optimal performance.
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: Infinite
Location(s): Chennai
Keyskills:
Patch management
Performance tuning
Automation
Postgresql
Disaster recovery
Database administration
DBMS
Monitoring
SQL
Auditing