Job Description
• PostgreSQL Database Administrator
• Looking for PostgreSQL database administrator with good experience in database creation, managing, monitoring DB, running backup tasks.
• Hands-on experience on database administration, backup recovery and troubleshooting Installing and configuring new servers as per customer's request.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Implement and monitor replication for high availability and disaster scenarios.
• Monitor and manage database indexes for optimal performance.
• Monitoring PostgreSQL databases using PMM monitoring tool. Daily log analysis using pgbadger tool.
• Controlling and monitoring user access to the database.
• Maintaining custom vacuum strategies at table and DB level.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Monitoring bloat on every table and performing maintenance with minimal downtime.
• Performing minor and major level upgrades. Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Backup & Restore activities performing backups using SQL dump utilities
• Looking for PostgreSQL database administrator with good experience in database creation, managing, monitoring DB, running backup tasks.
• Hands-on experience on database administration, backup recovery and troubleshooting Installing and configuring new servers as per customer's request.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Implement and monitor replication for high availability and disaster scenarios.
• Monitor and manage database indexes for optimal performance.
• Monitoring PostgreSQL databases using PMM monitoring tool. Daily log analysis using pgbadger tool.
• Controlling and monitoring user access to the database.
• Maintaining custom vacuum strategies at table and DB level.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Monitoring bloat on every table and performing maintenance with minimal downtime.
• Performing minor and major level upgrades. Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Backup & Restore activities performing backups using SQL dump utilities
💡 Quick Summary
Seeking a career-building opportunity? The SQL|Post Grace SQL position is now open for candidates interested in the Database Administrator sector. This role in Jaipur offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
