SQL/Post Grace SQL
Published date: 2024/01/10
- Location: Jaipur, Rajasthan, India
• 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
0 page views
Related listings
-
Database AdministratorDatabase AdministratorShould have experience as a database specialist in Microsoft SQL Server Experience and expertise with Microsoft SQL database development, Microsoft SQL networking and Data Partition. Database monitoring and health check along with exposure on Brent O...2026/11/07
-
Linux Administrator/ InternDatabase AdministratorWe are looking for a Linux intern who will be responsible for designing, implementing, and monitoring the company infrastructure. This includes maintaining networks, servers and security programs and systems. IT Administrators manage the upgrade and ...2026/11/07
-
SQL Database AdministratorDatabase AdministratorWe are Hiring for IT Company Post - SQL Database Administrator Location - Jaipur Salary - Upto 12 LPA Eligibility - B.Tech/BCA/ MCA or any web development course diploma Experience - 1 to 5 Years Responsibilities: - · Gathering all salient informatio...2026/11/07