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 problemsolving 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 problemsolving
Responsibilities
- Database Installation and Configuration: Install configure and maintain SQL MySQL
and PostgreSQL database systems on both Linux and Windows platforms ensuring
optimal performance and high availability.
- Database Design and Development: Collaborate with application developers to design
and implement efficient and scalable database structures. Create and modify database
objects such as tables views indexes and stored procedures across SQL MySQL and
PostgreSQL.
- Database Performance Tuning: Identify and resolve database performance
bottlenecks optimizing SQL queries and finetuning database configurations. Utilize
problemsolving skills to analyze and address performance issues and ensure optimal
system performance across SQL MySQL and PostgreSQL.
- Data Security and Integrity: Implement and enforce security measures to protect
sensitive data. Set up user accounts permissions and access controls. Utilize
problemsolving skills to address security vulnerabilities and ensure database integrity
across SQL MySQL and PostgreSQL.
- Database Monitoring and Troubleshooting: Monitor database systems to identify and
resolve issues proactively. Utilize strong problemsolving skills to investigate and
troubleshoot databaserelated problems such as connectivity performance and data
integrity issues across SQL MySQL and PostgreSQL.
- Database Documentation: Maintain accurate and uptodate documentation of
database configurations schemas and processes. Utilize problemsolving skills to
develop and implement database policies procedures and standards across SQL
MySQL and PostgreSQL.
- Database Upgrades and Patches: Plan and execute database upgrades and apply
patches as required ensuring compatibility and minimal disruption to production
systems. Utilize problemsolving skills to address any compatibility or performance
issues during the upgrade process across SQL MySQL and PostgreSQL.
- Database Replication and High Availability: Implement and maintain database
replication and clustering solutions to ensure high availability and disaster recovery
across SQL MySQL and PostgreSQL. Utilize problemsolving skills to address any
replication or clustering issues that may arise.
- Database Backup and Recovery: Develop and maintain database backup and recovery
strategies including disaster recovery plans. Utilize problemsolving skills to address
any 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 in
database administration SQL MySQL and PostgreSQL technologies. Utilize problem1solving skills to adapt to new technologies and address any challenges that may arise.
Requirements
- Bachelors degree in Computer Science Information Technology or a related field (or
equivalent 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 Linux
and Windows platforms.
- Familiarity with database backup and recovery strategies across SQL MySQL and
PostgreSQL.
- 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 problemsolving and troubleshooting skills with the ability to analyze
complex database issues and propose effective solutions across SQL MySQL and
PostgreSQL.
- Strong attention to detail and ability to work in a fastpaced environment.
- Effective communication and collaboration skills.