We are looking for PostgreSQL Aurora Database Administrator - Remote / Telecommute for our client in Holmdel, NJ
Job Title: PostgreSQL Aurora Database Administrator - Remote / Telecommute
Job Location: Holmdel, NJ
Job Type: Contract
Pay Range: $55.00hr - $60.00hr
Job Overview:
The candidate will serve as a PostgreSQL/Aurora subject-matter expert and actively improve the production environment. The candidate 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.
Requirements:
- 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.
====
Benefits
Our Benefits Include:
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.
