Job Description:
• Administer, configure, and maintain PostgreSQL databases across multiple environments, ensuring high availability and security.
• Perform regular database backups, recovery, and disaster recovery planning.
• Monitor and tune database performance, including query optimization, index management, and resource utilization.
• Troubleshoot database-related issues, including performance degradation, connectivity issues, and data integrity problems.
• Work closely with application developers to design and implement efficient database schemas, queries, and indexing strategies.
• Implement security policies and ensure compliance with internal and external regulations regarding data storage and access.
• Perform routine database upgrades and patch management to ensure systems are up-to-date and secure.
• Collaborate with cross-functional teams to optimize database systems for scalability and capacity planning.
• Conduct performance analysis, capacity planning, and tuning to improve overall system performance and availability.
• Maintain and troubleshoot database replication and clustering for high availability and disaster recovery solutions.
• Provide technical support and mentoring to junior database team members.
Requirements:
• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience
• 6+ years of hands-on experience managing PostgreSQL databases in production environments
• Expertise in database design, optimization, and performance tuning in PostgreSQL
• Solid understanding of SQL and experience with writing complex queries, stored procedures, and triggers
• Proficiency with PostgreSQL administration tools and utilities such as pgAdmin, psql, and others
• Experience with database backup and recovery strategies, including Point-in-Time Recovery (PITR)
• Strong knowledge of replication (e.g., streaming replication, logical replication) and clustering
• Familiarity with cloud-based database solutions (AWS RDS, Azure, Google Cloud, etc.)
• Experience with monitoring tools (e.g., Prometheus, Nagios, or others) for database health checks
• Solid understanding of security best practices and encryption methods for database systems
• Knowledge of scripting languages such as Bash, Python, or Perl is a plus
• Strong analytical and troubleshooting skills with the ability to work under pressure
• Excellent communication skills and the ability to collaborate with both technical and non-technical teams
Benefits:
• Comprehensive healthcare for the employee at no monthly cost
• Healthcare benefit covers medical, prescription drug, dental, and vision
• Personal Time Off (PTO) Policy plus paid holidays
• Highly competitive compensation plan regularly calibrated against industry and location benchmarks
• 401(k) retirement plan with company-matching
• Employee Stock Ownership Plan (ESOP) – we’re all company owners!
• Flexible spending accounts
• Employee assistance program (EAP)
• Short- and long-term disability insurance
• Life and accident insurance
• Tuition assistance/Training/Workforce improvement reimbursement per year
• Spot bonuses for exceptional performance
• Annual Employee Recognition Awards with bonuses
• Employee Referral Program
• Free centralized, self-directed Learning Management System to learn at your own pace
• Personalized career growth plans for every employee