PostgreSQL Database Administrator

Jio

4 - 9 years

8 - 18 Lacs

Guwahati

Posted:2 days ago| Platform:

Apply

Skills Required

database administration postgresql replication backup performance tuning recovery monitoring tools customer support sql database design database management high availability sql optimization backup and recovery linux troubleshooting communication skills

Work Mode

Work from Office

Job Type

Full Time

Job Description

The Postgre SQL DBA would need to have at least 3 years of experience with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing.
PostgreSQL database cloning by using Pg_dump and Pg_Restore.
Review all PostgreSQL logs and problems.
Experience with Postgres Connection Pooling (PgBouncer).
Hands-on operational DBA expertise in the areas of Replication, High Availability and Backup/Recovery.
Advanced performance-tuning skills to review performance data and prepare reports.
SQL and Linux scripting skills are required skills.
Strong communication skills are a requirement for this position.
Ability to manage customer or in-house escalation calls is required
Experience working on an Application/Development team or experience as an Application DBA.
Responsible for managing Development, QA, Staging and Production databases and applications and implementing future enhancements to meet the business needs of the end users.
Monitor database health - availability, reliability, performance, capacity planning.
Upgrading PostgreSQL Databases.
Responsible for the monitoring and uptime of all production databases.
Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
Responsible for pro-active remediation of database operational problems.
Participate in a 247 support rotation.
Support complex web-based applications.
Automatic Switchover & Failover.

More Jobs at Jio

Technician Electrician - Utility

Navi Mumbai, Mumbai

4 - 6 yrs

INR 2 - 6 Lacs

Robotic Software Engineer

Navi Mumbai

2 - 7 yrs

INR 10 - 20 Lacs

Partner Account Manager

Vijayawada

8 - 12 yrs

INR 15 - 18 Lacs

Python Scripter

Mumbai Metropolitan Region

5 - 7 yrs

Salary: Not disclosed

Core Maintenance Utilities Engineer

Ahmedabad, Gujarat, India

8 - 12 yrs

₹ 5 - 10 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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.