Datavail

Associate Database Administrator - PostgreSQL DBA

Posted 15 Days Ago

Be an Early Applicant

3 Locations

Hybrid

2M-3M Annually

Senior level

Database

The Role

The role requires managing PostgreSQL databases, performing installations, backups, restorations, upgrades, and migrations, and ensuring database performance and security in cloud environments.

Summary Generated by Built In

Job Title: Senior Associate Database Administrator - PostgreSQL DBA

Education: Any Graduate

Experience: 5+years

Location: Bengaluru, Hyderabad, Mumbai.

Key Skills: PostgreSQL Open Source and EDB PostgreSQL. AWS, Microsoft Azure and GCP - PostgreSQL.Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repack.

Job Description:

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.

About UsDatavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. About the Team

Datavail’s Team of PostgreSQL Experts Can Save You Time and Money

We have extensive experience with just about everything in PostgreSQL. Our consultants, architects, DBAs, and database development team have extensive hands-on experience in traditional on-prem PostgreSQL and in Cloud too. Our experts have an average of 15 years of experience. They’ve overcome every obstacle in helping clients manage everything from databases, analytics, reporting, migrations, and upgrades to monitoring and overall data management.

You can free up your IT resources to focus on growing your business rather than fighting fires. Our PostgreSQL experts can guide you through strategic initiatives or support routine database management.

Datavail’s Comprehensive PostgreSQL Database Services

Datavail offers PostgreSQL consulting services that allow you to take advantage of all the features of the PostgreSQL database. By providing high availability solutions, building high end database systems, architectural support, and managed service support our team can ensure optimal performance for your database on-prem or in the cloud.

PostgreSQL Database Managed Services

Datavail’s business focuses on helping you use your data to drive business results through cost-saving services. The success of your business depends on how well you understand and manage your data. Our managed cloud services give you the power to unleash your organization’s potential. We provide comprehensive and technically advanced support for PostgreSQL installations to ensure that your databases are safe, secure, and managed with the utmost level of care.

Our delivery performance in data management leads the industry. We offer highly trained PostgreSQL database administrators via a 24×7, always on, always available, global delivery model. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the database experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.

Are you a seasoned PostgreSQL Database Administrator? Does working in a multi customer, multi domain environment on global scale motivates you? If yes, this role could be a good fit for you.

Datavail is seeking a highly skilled, self-motivated, and passionate PostgreSQL DBA to join our PostgreSQL Global Practice. As a PostgreSQL DBA, you will be working on the latest Opensource technologies in the industry. This position is based out of our global delivery centers in Mumbai, Hyderabad, and Bangalore in India.

Datavail is one of the largest data-focused services company in North America and provides both professional and managed services and expertise in Database Management, Application Development and Management, Cloud & Infrastructure Management, Packaged Applications and BI/Analytics.

Why should you work at Datavail?

Learn from a vast pool of global PostgreSQL DBAs with over 500 combined years of industry experience.
You would be working with multiple customers in a multi domain environments.Work range: On-Prem core PostgreSQL DBs, AWS RDS & Aurora, and Azure - PostgreSQL.
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.

Top Skills

AWS

Barman

GCP

Azure

Patroni

Pg_Repack

Pgadmin

Pgbackrest

Pgbadger

Pgbouncer

Postgres

Repmgr

View all jobs at Datavail

View Datavail Profile

Report Job

Am I A Good Fit?

beta

Get Personalized Job Insights.

Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

HQ: Broomfield, CO

263 Employees

Year Founded: 2007

What We Do

A premiere data services company serving clients in North America, Datavail has 1,000 data professionals, data engineers, developers, project managers, consultants, and business experts, supported by industry-leading automation and intellectual property. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. At Datavail, we look for more than smarts, experience and proficiency. On top of those requirements, we seek people who mesh with our corporate values. We seek brilliance without bravado and know-how without a know-it-all attitude. We hold low ego in high regard, embrace problem-solving as a passion and welcome every day as a new opportunity to learn. We’re flexible and hard working. We’re committed to our clients and colleagues. We help our people grow so they can help our clients grow. That makes us grow so we can help even more customers leverage organizational data for business value. Our Core Values: 1. We desire to serve. 2. We embody flexibility for availability 3. We exemplify low ego. 4. We work hard. 5. We strive for continuous improvement. 6. We are growth-oriented.