Postgre SQL Database Administrator
Postgre SQL Database Administrator379
Applications
379
Applications
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
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 complete 5G Core Network, AI/ML ATOM platform for 4G/5G, MANO for cloud CNF orchestration, ACI for cloud infrastructure deployment as well as the Cloud-native OSS Platforms. In addition to these core platforms, we have also created our own cloud-native probing solutions for radio and core networks, simplifying network debugging and not requiring any systems integration with probe providers. To enable a SAAS-based model, JPL has also developed a sophisticated array of BSS solutions. The entire product line is cloud native and can be deployed either on a public cloud or a private cloud. ...Show Less
Industry
Media & Telecommunication...
Company Size
51-200 Employees
Headquarter
Navi Mumbai, Maharashtra
Other open jobs from Jio