Database Administrator - PostgreSQL
- 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
Apply Now
Apply Now