Job Title: Senior PostgreSQL Database Administrator Location : Remote Job Type : Contract Overview: We are seeking an experienced Senior PostgreSQL Database Administrator to join our team. This is a remote position, and the ideal candidate will have a deep understanding of PostgreSQL, advanced database administration skills, and the ability to manage complex database environments. Key Responsibilities:
- Database Management: Design, implement, and maintain PostgreSQL databases to ensure their performance, availability, and security.
- Performance Tuning: Monitor database performance, identify bottlenecks, and implement solutions for performance improvements.
- Backup and Recovery: Develop and manage backup and recovery strategies to ensure data integrity and availability.
- Security Management: Implement and manage database security policies to protect sensitive data.
- Replication & High Availability: Configure and manage database replication, clustering, and high-availability solutions.
- SQL Optimization: Write and optimize complex SQL queries for better performance and efficiency.
- Database Upgrades: Plan and execute database upgrades and migrations.
- Automation: Automate routine tasks related to database management and deployment.
- Troubleshooting: Diagnose and resolve database-related issues promptly.
- Collaboration: Work closely with development teams to design and optimize database schemas and queries.
- Documentation: Maintain detailed documentation of database configurations, processes, and procedures.
Required Qualifications:
- Minimum of 10 years of hands-on experience with PostgreSQL database administration.
- Proficiency in PostgreSQL performance tuning, backup and recovery processes.
- Experience with replication, clustering, and high-availability solutions.
- Expertise in SQL query optimization and database security best practices.
- Familiarity with PostgreSQL management tools (e.g., pgAdmin, psql) and monitoring tools (e.g., Nagios, Zabbix).
- Strong problem-solving, analytical, and communication skills.
- Ability to work independently in a remote setting.
Preferred Qualifications:
- Certifications: PostgreSQL certification(s) is a plus.
- Scripting: Proficiency in scripting languages (e.g., Python, Bash) for automation.
- DevOps: Experience with CI/CD pipelines and DevOps practices.
- Cloud: Experience with cloud infrastructure and services.