PostgreSQL Database Administrator
Share
Job Location:
Yearly Salary:
Posted on:
2 days ago
Vacancies:
1 Vacancy
Job Summary
- 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 Pgdump and PgRestore.
- 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.
Required Experience:
Manager
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About 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 ... View more
