Senior Associate Database Administrator specializing in PostgreSQL at Datavail. Overseeing database installations, configurations, and ensuring optimal performance across cloud services.
Responsibilities
5+ years of relevant experience.
Good knowledge of PostgreSQL Database Architecture.
Installing, configuring PostgreSQL using source code, RPM, one-click installation on-prem and Cloud Technologies.
Strong experience in handling Database Logical and Physical Backups.
Hands on experience on restoration techniques on PostgreSQL like pg_restore and Point in time recovery (PITR).
Expertise in Applying database patches from lower version to higher version.
Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg_dump/pg_restore & pg_upgrade).
Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool.
Expertise in Streaming Replication (Including Cascading Replication).
Configuring pgbouncer for connection pooling.
Configuring pgbadger for generating statistic report on the basis PostgreSQL log file.
Handling Database corruption issues.
Have done Oracle to PostgreSQL Migration for multiple clients.
Strong knowledge on PostgreSQL configuration parameter for tuning the DB health.
Managed Users and Tablespace on PostgreSQL Servers.
Configuring Heterogeneous DB connections between Oracle, PostgreSQL.
Expertise in Shell scripts for performing Online Backup and maintenance activity.
Strong experience in setting up RDS & Aurora Cluster.
Tuning parameter group and configuring Aurora cluster for Read Replica.
Configuring RDS & Aurora PostgreSQL Logs to push to S3 Bucket.
Experience on Reviewing performance Metrics on Aurora PostgreSQL.
Configured Query Store and Analytics workspace on MS Azure Cloud.
Requirements
5+ years of relevant experience.
Good knowledge of PostgreSQL Database Architecture.
Installing, configuring PostgreSQL using source code, RPM, one-click installation on-prem and Cloud Technologies.
Strong experience in handling Database Logical and Physical Backups.
Hands on experience on restoration techniques on PostgreSQL like pg_restore and Point in time recovery (PITR).
Expertise in Applying database patches from lower version to higher version.
Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg_dump/pg_restore & pg_upgrade).
Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool.
Expertise in Streaming Replication (Including Cascading Replication).
Configuring pgbouncer for connection pooling.
Configuring pgbadger for generating statistic report on the basis PostgreSQL log file.
Handling Database corruption issues.
Have done Oracle to PostgreSQL Migration for multiple clients.
Strong knowledge on PostgreSQL configuration parameter for tuning the DB health.
Managed Users and Tablespace on PostgreSQL Servers.
Configuring Heterogeneous DB connections between Oracle, PostgreSQL.
Expertise in Shell scripts for performing Online Backup and maintenance activity.
Strong experience in setting up RDS & Aurora Cluster.
Tuning parameter group and configuring Aurora cluster for Read Replica.
Configuring RDS & Aurora PostgreSQL Logs to push to S3 Bucket.
Experience on Reviewing performance Metrics on Aurora PostgreSQL.
Configured Query Store and Analytics workspace on MS Azure Cloud.
Benefits
Your Certifications would be on us.
Future Opportunity for permanent deputation on H1B to work in US.
Leverage the DV Training program to upscale the technical skills.
Senior Database Administrator managing database systems and migrations at Cayuse Civil Services. Leading efforts in database management and performance optimization with a commitment to security standards.
Database Administrator at CIEE, monitoring and optimizing database performance, documenting processes, and managing access security. Working at a philanthropic institution supporting youth employment.
Database Management Architect responsible for system architecture and security management. Configuring, maintaining databases while collaborating with diverse teams in Kyndryl.
Sr. PostgreSQL Database Administrator delivering technical solutions within federal government. Managing databases for mission - critical applications with a high level of responsibility and expertise.
Database Administrator supporting federal client by providing architectural guidance in a SecDevOps environment. Focused on building modern, cloud - native applications and optimizing database systems.
Senior Database Administrator responsible for GCP database services for healthcare systems at BCBST. Involves designing, securing, and automating cloud - native databases, while supporting DB2 LUW.
MS SQL Server DBA III role responsible for operational database services and incident management. Engage with cross - functional teams and databases for optimal solutions.
Database Administrator managing SQL, Oracle, and PostgreSQL for a technology company. Responsible for administration, security, performance tuning, and team collaboration.
Database Administrator supporting federal government programs with Agile development and test planning. Requires strong database and cloud service experience with a focus on PostgreSQL.
Senior Database Administrator supporting Oracle systems for the State of Michigan. Participating in 24x7 software and hardware support without on - call coverage.