Job Title: Database Administrator
We are seeking a skilled and experienced Database Administrator to manage, maintain, and optimize PostgreSQL databases ensuring their reliability and performance.
Key Responsibilities:
* Database Management: Ensure the integrity and availability of databases through effective management practices.
* Performance Optimization: Continuously monitor database performance and implement strategies to improve efficiency and scalability.
* Backup and Recovery: Develop and implement robust backup and recovery strategies to prevent data loss.
* High Availability: Design and implement high availability setups to minimize downtime and ensure business continuity.
* SQL and PL/pgSQL Programming: Proficient in writing efficient SQL and PL/pgSQL code to meet business requirements.
* Data Modeling and Schema Design: Knowledgeable about data modeling and schema design best practices to ensure data consistency and integrity.
* PostgreSQL Tools and Utilities: Experienced with using PostgreSQL tools and utilities such as pgAdmin and psql.
Requirements:
* Proven experience as a PostgreSQL Database Administrator or in a similar role.
* Strong knowledge of PostgreSQL database architecture and administration.
* Hands-on experience with database design, performance tuning, and optimization.
* Proficiency in SQL and PL/pgSQL programming.
* Knowledge of data modeling and schema design best practices.
* Familiarity with PostgreSQL tools and utilities.
Benefits:
Working at {company} offers opportunities for professional growth and development in a collaborative and dynamic environment.