PostgreSQL/Aurora DBA
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- 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.
Summary
Role: PostgreSQL/Aurora DBA
Location: Remote
Job Description:
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
- Dice Id: 91142794
- Position Id: 9118111
- Posted 1 hour ago
Company Info
About SSTech LLC
SSTech LLC specializes in IT consulting, focusing on understanding client needs and providing skilled professionals to meet those requirements. Whether it’s through project-based consulting, staff augmentation, or full-scale IT solutions, the firm likely works closely with clients to identify technology gaps and deliver the right talent and expertise.
SSTech LLC is a dynamic and rapidly growing IT staffing and consulting firm headquartered in Irving, TX. With years of experience in the industry, we specialize in delivering innovative technology solutions and augmenting our clients’ IT teams with top-tier professionals. We pride ourselves on our commitment to integrity, honesty, and excellence in service.
Founded on the core values of integrity, technological insight, and customer satisfaction, SSTech LLC has built a reputation for providing reliable, high-quality IT staffing solutions. Our team works closely with clients to understand their unique needs and ensure that the right talent is deployed at the right time, empowering businesses to achieve their technology goals.Whether you’re looking to expand your IT staff, implement a cutting-edge technology solution, or need specialized expertise for a critical project, SSTech LLC is your trusted partner in success
SSTech LLC provides premier IT staffing services designed to help businesses develop and deploy innovative IT solutions that reduce costs and enhance performance across large enterprises worldwide. Our primary focus is on building mission-critical business applications engineered for optimal performance, scalability, and reliability.
With a deep understanding of the complexities facing modern enterprises, SSTech LLC ensures that our IT solutions not only meet the current needs of our clients but are also flexible and scalable to adapt to future demands. We specialize in delivering high-performance systems that are built to scale predictably, while maintaining the highest levels of reliability, security, and efficiency.
Whether you’re looking to streamline operations, enhance productivity, or develop cutting-edge applications, SSTech LLC is your trusted partner for building technology solutions that power business success on a global scale.
We are driven by core value and we are confident that when you select us as your IT Business Solutions Partner, we help businesses to move forward , faster by combining deep industry experience and frictionless technology delivery. Businesses today require transformational change at a scale and speed that defies traditional ways of working. We spark change through our digital transformation hub that delivers deep digital engineering and industry expertise through client-specific and integrated agile scrum teams.The SSTech LLC team is focused on delivering customer satisfaction by providing world-class IT services to the dynamic and developing high-technology market
SSTech LLC is a dynamic and fast growing company with headquarters in Dallas, Texas, USA. Through close relationships with partners , SSTech LLC has an extended presence in India.
