Datavail Infotech Pvt. Ltd. is seeking an Associate Database Administrator to join our PostgreSQL Global Practice. In this role, you will manage PostgreSQL database systems across on-premises and cloud platforms, focusing on installation, configuration, performance, and reliability for a diverse client base.
What You'll Do
- Install and configure PostgreSQL using source code, RPM, and one-click methods, both on-premises and in cloud environments like AWS, Azure, and GCP.
- Handle database logical and physical backups and perform restoration using techniques like pg_restore and Point-in-Time Recovery (PITR).
- Apply database patches and execute major and minor upgrades of PostgreSQL databases across multiple platforms.
- Implement PostgreSQL DR servers and load balancing using pgpool.
- Configure Streaming Replication, including Cascading Replication.
- Configure pgbouncer for connection pooling and pgbadger for generating statistical reports.
- Diagnose and resolve database corruption issues.
- Perform Oracle to PostgreSQL migrations for multiple clients.
- Tune PostgreSQL configuration parameters for optimal database health.
- Manage users and tablespace on PostgreSQL servers.
- Configure heterogeneous database connections between Oracle and PostgreSQL.
- Write Shell scripts for performing online backup and maintenance activities.
- Set up, configure, and tune RDS & Aurora Clusters, including configuring for Read Replicas.
- Configure RDS & Aurora PostgreSQL logs to be pushed to an S3 Bucket.
- Review performance metrics on Aurora PostgreSQL.
- Configure Query Store and Analytics workspace on MS Azure Cloud.
What We're Looking For
- 5 to 8 years of relevant PostgreSQL database administration experience.
- A graduate degree in a relevant field.
- Good knowledge of PostgreSQL Database Architecture.
- Strong experience in handling database logical and physical backups.
- Hands-on experience with PostgreSQL restoration techniques.
- Expertise in applying database patches and performing major/minor upgrades.
- Expertise in configuring Streaming Replication (including Cascading Replication).
- Experience handling database corruption issues.
- Experience with Oracle to PostgreSQL Migration projects.
- Strong knowledge of PostgreSQL configuration parameters for performance tuning.
- Expertise in writing Shell scripts for online backup and maintenance activities.
- Strong experience setting up RDS & Aurora Clusters.
- Experience reviewing performance metrics on Aurora PostgreSQL.
Technical Stack
- Databases: PostgreSQL Open Source, EDB PostgreSQL
- Cloud Platforms: AWS, Microsoft Azure, GCP
- Tools & Utilities: Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni, pg_repack, pgpool
- Scripting: Shell scripting
Team & Environment
You will be part of the PostgreSQL Global Practice, working with a global team of experts and serving multiple customers in a multi-domain environment.
Benefits & Compensation
- Learn from a vast pool of global PostgreSQL DBAs with over 500 combined years of industry experience.
- Work with multiple customers in a multi-domain environment.
- Your certifications would be sponsored by us.
- Future opportunity for permanent deputation on an H1B visa to work in the US.
- Leverage the DV Training program to upscale your technical skills.
Work Mode
This position operates on a local-country work mode and is based in Bengaluru, Hyderabad, or Mumbai.
Datavail Infotech is an equal opportunity employer.
