company logo

Postgre SQL Database Administrator

Mumbai
Delhi
Pune
Full-Time
Mid-Level: 4 to 8 years
Posted on Jul 30 2024

About the Job

Skills

Database Management
Postgre SQL
Database Administration
SQL Query Optimization
Backup and Recovery
Performance Tuning
Monitoring Tools
Troubleshooting
  • The Senior Postgre SQL DBA would need to have at least 4 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 24×7 support rotation.
  • Support complex web-based applications.
  • Automatic Switchover & Failover.


About the company

We are the force behind the meteoric rise of Indias leading telecom operator Jio with 400 Million+ customers. In Addition to this we have also powered an exhaustive list of digital apps & services that have delivered functionality, usability, engagement, scale and loyalty. We provide solutions for customers (B2C) and enterprise (B2B). We have an end to end 5G solution consisting of 5G Radio, a com ...Show More

Industry

Media & Telecommunication...

Company Size

51-200 Employees

Headquarter

Navi Mumbai, Maharashtra

Other open jobs from Jio