Database Administrator - Diligente Technologies

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.