Database Administrator

We are actively seeking a highly skilled and experienced Postgres Database Administrator to join our client's dynamic IT team. As a crucial member of the organization, you will be responsible for the design, implementation, and maintenance of our Postgres database systems. The ideal candidate should possess a minimum of 4 years of professional experience in database administration, with a specialization in PostgreSQL.

Responsibilities

Database Design and Implementation

1. Database Architecture: Design and implement robust and scalable database architectures based on business requirements, ensuring optimal performance and reliability.
2. Schema Design: Develop and optimize database schemas to support efficient data storage, retrieval, and manipulation.
3. Indexing and Optimization: Implement and maintain proper indexing strategies to enhance query performance and overall database efficiency.
4. Data Modeling: Work closely with application developers to create and refine data models that align with application requirements.

Database Administration

1. Installation and Configuration: Install, configure, and upgrade PostgreSQL database software, ensuring adherence to security best practices.
2. Monitoring and Performance Tuning: Implement monitoring solutions to track database performance and conduct regular performance tuning activities for optimal efficiency.
3. Backup and Recovery: Develop and maintain robust backup and recovery strategies to protect against data loss and ensure business continuity.
4. Security Management: Implement and manage database security measures, including access controls, encryption, and auditing, to safeguard sensitive data.
5. Replication and High Availability: Configure and manage database replication and clustering for high availability and fault tolerance.

Database Maintenance and Support

1. Patch Management: Apply patches and updates to the database system to address vulnerabilities and ensure a secure environment.
2. Data Migration: Plan and execute data migration tasks between different PostgreSQL instances and versions.
3. Troubleshooting: Investigate and resolve database-related issues, working closely with development and infrastructure teams.
4. Capacity Planning: Monitor database growth and conduct capacity planning to ensure the database can handle future data volumes.

Documentation and Knowledge Sharing

1. Documentation: Maintain comprehensive documentation of database configurations, processes, and troubleshooting procedures.
2. Knowledge Sharing: Share expertise and best practices with team members, promoting a collaborative and learning-oriented culture.

Automation and Scripting

1. Automation: Develop and implement automation scripts for routine database tasks, reducing manual efforts and improving efficiency.
2. Scripting Languages: Utilize scripting languages, such as SQL, PL/SQL, and shell scripting, for automation and administration tasks.

Collaboration and Communication

1. Collaboration: Work closely with application developers, system administrators, and other IT teams to ensure the seamless integration of database systems with other components of the infrastructure.
2. Communication: Provide clear and effective communication on database-related matters, both written and verbal, to technical and non-technical stakeholders.

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
• Minimum of 4 years of professional experience as a Database Administrator, with a focus on PostgreSQL.
• In-depth knowledge of PostgreSQL architecture, internals, and best practices.
• Proficiency in SQL and scripting languages for automation tasks (e.g., PL/pgSQL, shell scripting).
• Experience with database performance tuning, optimization, and monitoring tools.
• Strong understanding of database security concepts and hands-on experience implementing security measures.
• Familiarity with database backup and recovery strategies.
• Experience with database replication, clustering, and high availability configurations.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and collaboratively within a team.