الوصف الوظيفي
On behalf of our client, we are looking to recruit a Database AdministratorJob 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-solvingResponsibilities: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.
