PostgreSQL Database Administrator (DBA)

Overview:

We are seeking a skilled PostgreSQL Database Administrator (DBA) to manage and optimize our PostgreSQL database infrastructure. As a PostgreSQL DBA, you will be responsible for ensuring the performance, availability, and security of our databases. You will collaborate with our development, operations, and security teams to design and implement efficient database solutions that meet our business needs.

About Gradient Cyber:

Gradient Cyber is a leading player in the cyber security industry, dedicated to delivering innovative solutions that transform businesses. We focus on providing 24/7 protection with our Managed Extended Detection and Response (MXDR) services, specifically designed for the mid-market. Our customer-centric approach and innovative product roadmap set us apart in the industry. At Gradient Cyber, we are committed to fostering an environment that promotes individual growth and success. We recruit exceptional individuals who are eager to excel, contribute innovative ideas, and advance within a company brimming with possibilities. Join us and play a pivotal role in shaping the future of our product portfolio and customer experience.

Key Responsibilities:

• Database Administration: Manage, monitor, and maintain PostgreSQL database systems to ensure optimal performance, reliability, and security.
• Performance Tuning: Proactively identify and address performance bottlenecks and optimize SQL queries and database configurations for improved efficiency.
• Backup and Recovery: Develop and implement robust backup and recovery strategies to safeguard data integrity and minimize downtime in case of system failures.
• High Availability and Disaster Recovery: Design, implement, and manage high availability (HA) and disaster recovery (DR) solutions, such as replication, clustering, and failover mechanisms.
• Security: Implement and enforce security policies and access controls to protect sensitive data against unauthorized access, data breaches, and other security threats.
• Capacity Planning: Monitor database growth trends and plan for future capacity requirements by scaling resources and infrastructure as needed.
• Automation and Scripting: Develop automation scripts and tools to streamline database administration tasks, deployments, and maintenance processes.
• Database Upgrades and Patching: Plan and execute database upgrades, patches, and migrations in coordination with the development and operations teams to ensure minimal disruption to business operations.
• Documentation: Maintain comprehensive documentation of database configurations, procedures, and best practices for reference and knowledge sharing.
• Collaboration: Work closely with developers, system administrators, and other stakeholders to troubleshoot database-related issues, provide technical guidance, and support application development and deployment efforts.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Proven experience as a PostgreSQL Database Administrator or similar role in a production environment.
• In-depth knowledge of PostgreSQL architecture, configuration, performance tuning, and troubleshooting.
• Proficiency in SQL and database query optimization techniques.
• Experience with database backup and recovery solutions, including point-in-time recovery (PITR) and disaster recovery planning.
• Familiarity with database security best practices and regulatory compliance requirements (e.g., GDPR, HIPAA).
• Strong scripting skills (e.g., Bash, Python) for automation and task orchestration.
• Experience with database migration, replication, clustering, and high availability solutions (e.g., PostgreSQL replication, Patroni, Pgpool-II).
• Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.

Preferred Qualifications:

• PostgreSQL certification (e.g., PostgreSQL Certified Administrator).
• Experience with other database technologies (e.g., MySQL, Oracle, MongoDB).
• Knowledge of cloud platforms and database services (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL).
• Familiarity with DevOps practices and tools (e.g., Docker, Kubernetes, Terraform).
• Experience with performance monitoring and diagnostic tools (e.g., pg_stat_statements, pgBadger, pg_top).
  

Equal Opportunity Statement:

Gradient Cyber is an equal opportunity employer. We are committed to creating a diverse and inclusive workplace where all employees feel valued and respected. We encourage applications from individuals of all backgrounds and experiences.