Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in india
>
Go Digital Technology Consulting
>
Postgres Database Administrator

Postgres Database Administrator

Go Digital Technology Consulting

3 years

0 Lacs

india

Posted:3 days ago| Platform: GlassDoor logo

Apply

Skills Required

database postgresql tuning backup strategies aws security indexes constraints maintenance statistics replication logical clustering failover query storage analyze sql checks analysis encryption audit patching monitoring iam support planning automate python schedule development design data model pgadmin reports technology linux unix troubleshooting certification automation terraform ansible mysql mongodb devops integration communication documentation learning

Work Mode

On-site

Job Type

Part Time

Job Description

We are seeking a skilled PostgreSQL Database Administrator (DBA) with 3–6 years of experience to manage, maintain, and optimize our database systems. The ideal candidate will have hands-on expertise in PostgreSQL administration, database performance tuning, and backup strategies, along with working knowledge of AWS database services (such as RDS, EC2, S3, and CloudWatch). You will be responsible for ensuring database availability, security, and performance in both on-premise and cloud environments.

Key Responsibilities

Database Administration

Install, configure, and upgrade PostgreSQL database servers and related tools.
Manage database schemas, tables, indexes, constraints, and relationships.
Perform routine database maintenance, including vacuuming, reindexing, and statistics updates.
Manage database replication (streaming or logical), clustering, and failover setups.
Implement and manage database backup and recovery procedures using tools like pg_dump, pg_basebackup, and WAL archiving.
Monitor database health, query performance, and storage utilization.
Troubleshoot database errors, crashes, and performance bottlenecks.

Performance Tuning and Optimization

Analyze slow queries and optimize SQL statements and indexes.
Perform regular health checks, query plan analysis, and database tuning.
Configure PostgreSQL parameters (e.g., shared buffers, work_mem, autovacuum) for optimal performance.

Security and Compliance

Implement and maintain user access control and
Ensure database security through encryption, SSL, and audit trails.
Perform regular database patching and version upgrades to maintain compliance.
AWS Cloud Database Operations
Deploy and manage PostgreSQL databases on AWS services such as Amazon RDS, Aurora PostgreSQL, or EC2.
Configure automated backups, snapshots, and monitoring via CloudWatch.
Manage parameter groups, security groups, and IAM roles for database access.
Support DR (Disaster Recovery) planning and cross-region replication.

Maintenance and Automation

Automate repetitive DBA tasks using scripts (Python, Bash, or SQL).
Schedule and monitor maintenance tasks such as backups, reindexing, and vacuuming.
Support CI/CD pipelines for database schema deployment.
Collaborate with development teams for schema design and data model optimization.

Monitoring and Reporting

Set up and maintain monitoring tools (e.g., pgAdmin, Prometheus + Grafana, AWS CloudWatch, or Datadog).
Generate performance reports and provide insights to improve database efficiency.

Required Skills and Qualifications

Bachelor’s degree in computer science, Information Technology, or related field.
3–4 years of experience as a PostgreSQL DBA in production environments.
Strong understanding of PostgreSQL internals, performance tuning, and SQL optimization.
Experience with AWS cloud services related to database hosting and management.
Proficiency with Linux/Unix environments and shell scripting.
Hands-on experience with backup and recovery strategies, replication, and clustering.
Familiarity with monitoring tools (e.g., CloudWatch, pg_stat_statements, or similar).
Strong troubleshooting and analytical skills.

Preferred Qualifications

Certification in AWS (e.g., AWS Certified Database – Specialty or AWS Solutions Architect Associate).
Experience with automation tools (Terraform, Ansible) for database provisioning.
Exposure to other database platforms (MySQL, MongoDB) is a plus.
Understanding of DevOps pipelines and CI/CD integration with databases.

Soft Skills

Excellent communication and documentation skills.
Strong problem-solving and analytical mindset.
Ability to work independently and collaborate in a cross-functional team environment.
Commitment to continuous learning and staying updated with PostgreSQL and AWS trends.

More Jobs at Go Digital Technology Consulting

Associate Data Test Engineer

Mumbai

1.0 - 4.0 yrs

INR 2 - 6 Lacs

Associate Data Scientist

Mumbai

2.0 - 5.0 yrs

INR 6 - 10 Lacs

Associate Data Engineer

Mumbai

Experience: Not specified

INR 2 - 3 Lacs

Data Scientist

Pune, Mumbai (All Areas)

3.0 - 5.0 yrs

INR 4 - 9 Lacs

Senior Full Stack Developer

Mumbai, Pune

3.0 - 8.0 yrs

INR 9 - 19 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Go Digital Technology Consulting

Technology Consulting

Tech City

Login to

Please Verify Your Phone or Email

Confirm Action

Postgres Database Administrator