Job Description: PostgreSQL DBA
Position Title: PostgreSQL DBA
Experience Required: 3-8 Years
Compensation Range: 11,00,000 - 12,00,000 per annum
About the Role:
We are seeking a highly skilled PostgreSQL DBA to join our database management team. This role involves managing PostgreSQL databases to ensure their performance, availability, and security, as well as optimizing database systems and supporting development teams.
Key Responsibilities:
- Database Management: Install, configure, and maintain PostgreSQL databases, ensuring high levels of performance, availability, and security.
- Performance Tuning: Monitor database performance, identify bottlenecks, and implement optimizations to enhance system efficiency.
- Backup and Recovery: Develop and implement backup and recovery strategies to ensure data integrity and availability in case of system failures.
- Security: Implement and manage database security measures, including access controls, encryption, and regular security audits.
- Database Design: Collaborate with development teams to design and optimize database schemas and queries, ensuring efficient data storage and retrieval.
- Automation: Develop scripts and automation tools to streamline database administration tasks and improve operational efficiency.
- Documentation: Maintain comprehensive documentation of database configurations, procedures, and security protocols.
- Support: Provide technical support to development teams and users, troubleshooting database-related issues and ensuring smooth operations.
Qualifications:
Educational Background: Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience: 3-8 years of experience in database administration with a focus on PostgreSQL.
Skills:
- Proficiency in PostgreSQL database administration and optimization.
- Strong knowledge of SQL and database performance tuning techniques.
- Experience with backup and recovery strategies and tools.
- Knowledge of database security practices and tools.
- Familiarity with scripting languages such as Bash, Python, or Perl.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration abilities.
Industry: Information Technology
