MySQL Database Administrator

4 weeks ago

Lahore, Punjab, Pakistan AppifyTech Full time

We are seeking an experienced MySQL Database Administrator with 2 to 3 years of experience to manage, optimize, and maintain our mission-critical MySQL databases. The ideal candidate will be responsible for ensuring high availability, performance, security, and reliability of our databases while supporting business-critical applications.

Key Responsibilities:

  • Install, configure, and maintain MySQL databases (Percona, Oracle MySQL) in a high-availability production environment.
  • Manage and optimize MySQL replication, including master-master and master-slave configurations.
  • Implement and maintain backup and recovery strategies using Percona XtraBackup.
  • Monitor database performance and proactively address bottlenecks and slow queries.
  • Troubleshoot and resolve database issues, including replication lag, data inconsistencies, and performance degradation.
  • Perform schema changes, indexing strategies, and query optimization for efficient database performance.
  • Manage user privileges, authentication, and security policies to ensure database integrity.
  • Perform database migrations and upgrades, including MySQL 5.7 to MySQL 8.x.
  • Develop and maintain scripts for automation and monitoring database activities.
  • Support MySQL instances running on RHEL-based environments, ensuring compliance with best practices.
  • Work closely with developers to optimize SQL queries and database structures for application performance.
  • Implement and maintain disaster recovery and failover mechanisms.
  • Conduct database audits and performance tuning to ensure system stability.
  • Migrate databases from on-premises environments to Oracle Cloud Infrastructure (OCI).

Required Skills & Qualifications:

  • 2 to 3 years of experience in administering MySQL databases in a production environment.
  • Hands-on experience with MySQL replication, clustering, and high-availability solutions.
  • Strong knowledge of Percona XtraBackup for backup and restore processes.
  • Experience with Linux (RHEL, CentOS) system administration related to database management.
  • Proficiency in writing complex SQL queries, stored procedures, and performance tuning.
  • Experience with monitoring tools like Percona Monitoring and Management (PMM), Nagios, or Zabbix.
  • Knowledge of scripting languages (Bash, Python) for automation.
  • Familiarity with MySQL user management, roles, and privileges.
  • Experience with database migration and version upgrades.
  • Familiarity with disk space optimization, table partitioning, and defragmentation strategies.
  • Experience with Oracle Cloud Infrastructure (OCI) for MySQL database management.
  • Strong experience in query writing, performance tuning, and database migration from on-premises to OCI cloud.
  • Strong problem-solving skills with the ability to work in a fast-paced environment.
#J-18808-Ljbffr

  • MySQL Database Developer and API Specialist

    7 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    MySQL Database Developer and API SpecialistWe are seeking a skilled professional to join our team as a MySQL database developer and API specialist. This role requires expertise in both MySQL databases and RESTful APIs, maintenance, testing, and integration.Responsibilities:Maintain and implement MySQL database systems that underpin applications.Optimize...

  • Mysql Database And Restful Apis Developer

    4 weeks ago

    Lahore, Punjab, Pakistan Vertex Electronics Full time

    Mysql Database And Restful Apis DeveloperWe are seeking a versatile and skilled professional to join our team as a MySQL Database developer & hands-on experience as RESTful API Developer. This role requires expertise in both MySQL databases and RESTful APIs, maintenance, testing and integration. The ideal candidate will play a pivotal role in ensuring the...

  • MySQL Database

    2 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    This role offers the opportunity to work on challenging projects and develop your skills in MySQL database development and RESTful API design. If you are passionate about technology and enjoy working in a collaborative environment, we encourage you to apply.Job Summary:Maintain and implement MySQL databases to support application functionality.Optimize...

  • MySQL Database Developer

    3 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    As a MySQL Database Developer & RESTful API Specialist, you will be responsible for maintaining and implementing MySQL databases that underpin our applications. This role requires expertise in both MySQL databases and RESTful APIs, including maintenance, testing, and integration.Responsibilities:Maintain and implement MySQL database systems to support...

  • Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan Kreativstorm Full time

    Step into the crucial role of database administration with an exciting opportunity offered by Kreativstorm, a dynamic and innovative management-consulting firm based in Berlin, Germany. Work remotely with our multinational team and ensure the integrity and performance of our database systemsIf you're passionate about database management and have strong...

  • Database Administrator

    3 weeks ago

    Lahore, Punjab, Pakistan ibex. Pakistan Full time

    Database Administrator RoleWe are seeking a skilled Database Administrator to join our team at ibex Pakistan.Key ResponsibilitiesDatabase Management: Install, configure, and maintain SQL technologies such as MySQL, PostgreSQL, and MSSQL.NoSQL Technologies: Install, configure, and maintain NoSQL technologies like Elasticsearch and MongoDB.Performance...

  • Database Administrator Expert

    2 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    We are seeking a highly skilled DBA Specialist to join our team and take charge of our database systems.This individual will be responsible for managing, maintaining, and optimizing our database systems to ensure high levels of performance, availability, and security.Closely collaborate with various teams to support application development and data...

  • Database Administrator

    1 week ago

    Lahore, Punjab, Pakistan ibex Full time

    Join to apply for the Database Administrator role at ibex.Get AI-powered advice on this job and access more exclusive features.ResponsibilitiesInstall, configure, and maintain SQL technologies such as MySQL, PostgreSQL, and MSSQL.Install, configure, and maintain NoSQL technologies such as Elasticsearch and MongoDB.Ensure high availability and perform...

  • Database Administrator

    4 weeks ago

    Lahore, Punjab, Pakistan ibex. Pakistan Full time

    Join to apply for the Database Administrator role at ibex. Pakistan.Get AI-powered advice on this job and enjoy more exclusive features.ResponsibilitiesInstall, configure, and maintain SQL technologies such as MySQL, PostgreSQL, and MSSQL.Install, configure, and maintain NoSQL technologies like Elasticsearch and MongoDB.Ensure high availability and perform...

  • Postgres & MySQL Database Specialist

    7 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Database Administration RoleWe are looking for an experienced Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, implementing, and maintaining databases that meet the needs of our organization.Main ResponsibilitiesDesign and implement database solutions that meet business requirementsMaintain database...