3 days onsite at Boston, MA or Atlanta/Alpharetta, GA
Fulltime/Direct Hire role
Key Responsibilities:
- Architect, design and building of PostgresSQL ,MySQL Server Infrastructure Onprem and public Cloud (AWS or Google Cloud Platform or Azure) ensuring high standards of performance, scalability, and reliability.
- Develop alerting and monitoring solutions using Internal Views, Extensions, and other tools.
- Implement monitors and alerts using modern observability approaches, including SLI/SLOs and Error Budget.
- Troubleshoot and resolve performance-related issues for EDB & Community PostgreSQL servers, reporting, ETL, and data warehouse-related issues.
- Create, develop, and maintain database maintenance solutions, DB setup, and configuration PL/SQL scripts.
- Implement and maintain EFM, replication solutions, and standby servers.
- Review problematic code and suggest improvements.
- Develop team policies, procedures, and techniques.
- Ensure the health and quality of services and incidents, proactively identifying and addressing issues.
- Provide technical mentorship and guidance, fostering a culture of learning and continuous improvement.
- Develop and maintain comprehensive technical documentation for database systems. Continuously review and update existing best practices/SOPs.
- Stay current with emerging technologies and industry trends.
- Participate in the on-call rotations and provide critical support for production systems.
Knowledge, Skills, and Abilities:
- Support production and other environments consisting of EDB & Community PostgreSQL, EFM, PGBouncer and Linux.
- Installation, configuration, maintenance, and administration of PostgreSQL.
- Disaster Recovery Planning and Implementation (Replication of different types).
- Strong knowledge of PL/SQL, Stored Procedures, Monitoring tools, and Performance monitoring.
- Experience in planning and implementing backup policies.
- Practical experience in managing internal and external database security.
- Knowledge of hosting/SaaS environments and focusing on systems performance and high availability.
- Knowledge of server hardware systems and operating systems.
- Hands-on experience with scripting and automation using Python, Go, and Google Cloud Scripting.
- Familiarity with various database technologies, including SQL (MySQL, SQL Server, Oracle), NoSQL (Cassandra, Astra), and SaaS DB instances (Cloud SQL, ASTRA).
Minimum Qualifications:
- Bachelor's or master's degree in computer science, Engineering, or a related technical field.
- 9+ years of professional experience as a PostgreSQL Server DBA or Similar roles
- Advanced skills with scripting and automation using Python, Go, PowerShell, Google Cloud Scripting and Infrastructure Code (IaC)
- Proficiency with cloud technologies like Azure, AWS, Google Cloud Platform (Preferable)
- Strong problem-solving skills and attention to detail, with a commitment to delivering high-quality software solutions.
- Proficiency in building telemetry or observability implementation of SLI /SLO for database operations meeting high Standards.
- Strong leadership, communication, and interpersonal skills.
- PostgreSQL (or)MySQL Certification is Must and preferable to have other Cloud certifications in AWS, Google Cloud Platform.