Database Administrator

On behalf of our client, we are looking to recruit a Database Administrator

Job summary

We are seeking an experienced Database Administrator with 2 to 3 years of relevant experience in managing and optimizing SQL, MySQL, and PostgreSQL databases in Linux and Windows environments. The ideal candidate will have a strong understanding of database management principles, excellent problem-solving skills, and a deep knowledge of SQL, MySQL, and PostgreSQL. As a Database Administrator, you will be responsible for ensuring the stability, performance, and security of our database systems, with a focus on effective problem-solving

Responsibilities

• Database Installation and Configuration: Install, configure, and maintain SQL, MySQL,and PostgreSQL database systems on both Linux and Windows platforms, ensuringoptimal performance and high availability.
• Database Design and Development: Collaborate with application developers to designand implement efficient and scalable database structures. Create and modify databaseobjects such as tables, views, indexes, and stored procedures across SQL, MySQL, andPostgreSQL.
• Database Performance Tuning: Identify and resolve database performancebottlenecks, optimizing SQL queries, and fine-tuning database configurations. Utilizeproblem-solving skills to analyze and address performance issues and ensure optimalsystem performance across SQL, MySQL, and PostgreSQL.
• Data Security and Integrity: Implement and enforce security measures to protectsensitive data. Set up user accounts, permissions, and access controls. Utilizeproblem-solving skills to address security vulnerabilities and ensure database integrityacross SQL, MySQL, and PostgreSQL.
• Database Monitoring and Troubleshooting: Monitor database systems to identify andresolve issues proactively. Utilize strong problem-solving skills to investigate andtroubleshoot database-related problems, such as connectivity, performance, and dataintegrity issues across SQL, MySQL, and PostgreSQL.
• Database Documentation: Maintain accurate and up-to-date documentation ofdatabase configurations, schemas, and processes. Utilize problem-solving skills todevelop and implement database policies, procedures, and standards across SQL,MySQL, and PostgreSQL.
• Database Upgrades and Patches: Plan and execute database upgrades and applypatches as required, ensuring compatibility and minimal disruption to productionsystems. Utilize problem-solving skills to address any compatibility or performanceissues during the upgrade process across SQL, MySQL, and PostgreSQL.
• Database Replication and High Availability: Implement and maintain databasereplication and clustering solutions to ensure high availability and disaster recoveryacross SQL, MySQL, and PostgreSQL. Utilize problem-solving skills to address anyreplication or clustering issues that may arise.
• Database Backup and Recovery: Develop and maintain database backup and recoverystrategies, including disaster recovery plans. Utilize problem-solving skills to addressany backup or recovery challenges and minimize data loss and downtime across SQL,MySQL, and PostgreSQL.
• Stay Current with Technology: Keep abreast of the latest developments and trends indatabase administration, SQL, MySQL, and PostgreSQL technologies. Utilize problem[1]solving skills to adapt to new technologies and address any challenges that may arise.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field (orequivalent experience).
• 2 to 3 years of proven experience as a Database Administrator, specifically with SQL,MySQL, and PostgreSQL databases.
• Strong knowledge of database management principles, practices, and techniques.
• Proficiency in SQL and experience with query optimization and performance tuning across SQL, MySQL, and PostgreSQL.
• Experience with database installation, configuration, and administration on both Linuxand Windows platforms.
• Familiarity with database backup and recovery strategies across SQL, MySQL, andPostgreSQL.
• Understanding of database security concepts and best practices across SQL, MySQL,and PostgreSQL.
• Knowledge of database replication and clustering technologies across SQL, MySQL,and PostgreSQL.
• Excellent problem-solving and troubleshooting skills, with the ability to analyzecomplex database issues and propose effective solutions across SQL, MySQL, andPostgreSQL.
• Strong attention to detail and ability to work in a fast-paced environment.
• Effective communication and collaboration skills.