Sr. MySQL Database Administrator

3 days ago

Lahore, Punjab, Pakistan AppifyTech Full time $90,000 - $120,000 per year

We are seeking an experienced MySQL Database Administrator with 5 to 6 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:

  • 5 to 6 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.

  • Sr. MySQL Database Administrator

    2 weeks ago

    Lahore, Punjab, Pakistan AppifyTech Full time

    2 days ago Be among the first 25 applicantsDirect message the job poster from AppifyTech5k+ Followers | Acquisition Professional | Technical Recruiter | Recruitment Consultant | HR Manager | HIPPA Certified | Payroll Manager | Admin…We are seeking an experienced MySQL Database Administrator with 5 to 6 years of experience to manage, optimize, and maintain...

  • Sr Database Administrator

    5 days ago

    Lahore, Punjab, Pakistan Ascertia Limited Full time

    OverviewSr Database Administrator (1-Year Contract, Extendable)Ascertia is seeking an experienced and highly skilled Database Administrator (DBA) to manage, design, and optimize databases for our .NET and cloud-based applications. We are building best-in-class platforms engineered to handle millions of transactions with high scalability and availability....

  • Sr Database Administrator

    5 days ago

    Lahore, Punjab, Pakistan Ascertia Full time

    Sr Database Administrator (1-Year Contract, Extendable)About Ascertia: Ascertia delivers digital trust products and services globally for Enterprises, Governments and Trust Service Providers. Ascertia solutions enable digital business processes which are fundamentally underpinned by digital trust to ensure that digital identities are proven, and business...

  • Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan Aitomation Pvt Ltd. Full time 85,000 per year

    Job Description:We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing...

  • Associate Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan Aitomation Pvt Ltd. Full time $60,000 - $120,000 per year

    We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations...

  • MySQL Database Developer

    2 days ago

    Lahore, Punjab, Pakistan beBeeDatabase Full time 900,000 - 1,200,000

    Database Architect and API SpecialistWe are seeking a highly skilled professional to lead our database architecture and RESTful API development efforts. This role requires expertise in designing, implementing, and maintaining scalable MySQL databases and RESTful APIs that power our applications.Key Responsibilities:Design and implement high-performance MySQL...

  • MySQL DBA

    6 days ago

    Lahore, Punjab, Pakistan Contour Software Full time

    Join to apply for the MySQL DBA role at Contour SoftwareAbout ContourContour Software has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years. As a subsidiary of Constellation Software Inc., we are part of a global enterprise software conglomerate with a presence in 100+ countries. We serve CSI divisions across time zones...

  • Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan ibex Full time 900,000 - 1,200,000 per year

    Install, configure and maintain SQL Technologies MySQL, PostgreSQL and MSSQL.Install, configure and maintain NoSQL Technologies Elasticsearch and MongoDB.Monitor database performance, identify and resolve bottlenecks, and optimize database structures.Ensure the accuracy, consistency, and overall integrity of data.Provide technical support and resolve...

  • Database Administrator

    2 weeks ago

    Lahore, Punjab, Pakistan ibex Full time

    Install, configure and maintain SQL Technologies MySQL, PostgreSQL and MSSQL.Install, configure and maintain NoSQL Technologies Elasticsearch and MongoDB.Monitor database performance, identify and resolve bottlenecks, and optimize database structures.Ensure the accuracy, consistency, and overall integrity of data.Provide technical support and resolve...

  • MySQL DBA

    1 day ago

    Lahore, Punjab, Pakistan Contour Software Full time

    About ContourContour Software has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years. As a subsidiary of Constellation Software Inc., we are proud to be part of a global enterprise software conglomerate that has grown to become one of the top 10 software companies in the world, with employees and customers in 100+ countries....