PostgreSQL/Aurora DBA Professional
Highbar Technologies · Remote · remote · Posted 1d ago
Undisclosed2–8 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
We need someone who can serve as a PostgreSQL/Aurora subject-matter expert and actively improve the production environment. The person should be capable of diagnosing difficult production performance issues, tuning PostgreSQL and Aurora workloads, using AWS telemetry to identify bottlenecks, building proactive monitoring, and developing automation and permanent fixes that reduce recurring operational issues.
- Expert PostgreSQL expertise, particularly supporting high-volume, business-critical production environments.
- Strong AWS experience, with hands-on expertise supporting Amazon RDS for PostgreSQL or Aurora PostgreSQL.
- Ability to troubleshoot complex PostgreSQL performance issues and rapidly determine whether the bottleneck is query, database, infrastructure, or application related.
- Advanced SQL/query tuning, including execution-plan analysis using EXPLAIN / EXPLAIN ANALYZE, indexing strategies, join optimization, statistics, and identifying inefficient queries.
- Strong understanding of PostgreSQL configuration and parameter tuning, including memory, WAL, checkpoints, autovacuum, connection management, planner settings, and workload-specific optimization.
- Hands-on experience with AWS Performance Insights / Database Insights to identify database load, expensive SQL, waits, locking, and other performance bottlenecks.
- Strong understanding of Aurora PostgreSQL architecture, including clusters, reader/writer instances, replicas, failover, scaling, parameter groups, maintenance, and backup/recovery.
- Ability to develop proactive monitoring and alerting that identifies developing problems before they become production incidents
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
queryH1BAutomationPostgresqlsubject matter expertamazon web servicesMonitoringSQLoperationsDatabase
About Highbar Technologies
Highbar Technologies
IT Services & Consulting
125
employees
2010
16 years old
Navi Mumbai, Maharashtra
India
₹9.3L PA avg
Avg at Highbar Technologies
About
Highbar Technologies provides IT solutions tailored for the infrastructure sector, enhancing efficiency across various public and private projects.
Industries
IT Services & Consulting
Employee ratings
10 reviews
4.4/ 5
Culture
3.9
Career growth
3.1
Work-life
3.5
Employees rate it well for
Overall Company44Job Security43
Find them on