Sr. MySQL Database Administrator

2 days ago

Lahore, Punjab, Pakistan AppifyTech Full time

2 days ago Be among the first 25 applicants

Direct message the job poster from AppifyTech

5k+ 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 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.
Seniority level
  • Seniority levelMid-Senior level
Employment type
  • Employment typeFull-time
Job function
  • Job functionInformation Technology
  • IndustriesSoftware Development

Referrals increase your chances of interviewing at AppifyTech by 2x

Get notified about new Senior Database Administrator jobs in Lahore District, Punjab, Pakistan.

We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

  • Database Administrator

    3 weeks ago

    Lahore, Punjab, Pakistan CloudCard Full time

    Job briefWe are looking for a 2 – 4 years experienced Database Administrator to join our team As a Database Administrator at our company, you will be responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining our company's databases and troubleshooting of databases.ResponsibilitiesProvide first-level Support...

  • Mysql Database And Restful Apis Developer

    3 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...

  • Database Administrator

    2 days 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...

  • Database Administrator

    4 weeks ago

    Lahore, Punjab, Pakistan Abroad Work Full time

    Database Administrator Vacancy in Lahore, PakistanWe are a reputable IT company seeking an experienced and detail-oriented Senior Database Administrator to join our team in Lahore.Responsibilities include:Ensuring the performance, integrity, and security of our company's databases.Collaborating with the development team to optimize database design and...

  • Database Administrator

    4 weeks ago

    Lahore, Punjab, Pakistan Burq, Inc. Full time

    About BurqBurq started with an ambitious mission: how can we turn the complex process of offering delivery into a simple turnkey solution. We started with building the largest network of delivery networks, partnering with some of the biggest delivery companies. We then made it extremely easy for businesses to plug into our network and start offering delivery...

  • Database Administrator

    3 weeks ago

    Lahore, Punjab, Pakistan Burq Full time

    About BurqBurq started with an ambitious mission: how can we turn the complex process of offering delivery into a simple turnkey solution.We started with building the largest network of delivery networks, partnering with some of the biggest delivery companies. We then made it extremely easy for businesses to plug into our network and start offering delivery...

  • Database Administrator

    3 weeks ago

    Lahore, Punjab, Pakistan I.T. Path Full time

    Get AI-powered advice on this job and more exclusive features.Direct message the job poster from I.T. PathJob Description:We are seeking an experienced and highly motivated SQL Server Database Administrator (DBA) to join our growing technology team. The ideal candidate will be responsible for the performance, integrity, security, and high availability of our...

  • Sr. Voip Engineer

    2 hours ago

    Lahore, Punjab, Pakistan Onsip Technologies Full time

    Sr. VoIP Engineer having proven experience in doing customized Asterisk projects. We work in a very comfortable and easy environment where you can have full ease of doing work. We believe in a work and life balance work environment.Job SpecificationGood Asterisk dial plan development experienceFamiliarity or experience with VOIP PBX technologies (Asterisk /...

  • Senior Database Administrator

    2 days ago

    Lahore, Punjab, Pakistan CureMD Full time

    Job Overview:As a Database Administrator, you'll be the backbone of our data operations, ensuring the seamless performance and growth of our databases. You'll proactively monitor system health, analyze data trends, and collaborate closely with development teams to pinpoint and resolve issues and boost performance. A key part of your role will involve...

  • Database Administrator

    2 days ago

    Lahore, Punjab, Pakistan Tandem Inc. Full time

    About BurqBurq started with an ambitious mission: to simplify the complex process of offering delivery through a turnkey solution.We built the largest network of delivery partners, making it easy for businesses to integrate and start offering delivery services. Currently, we power deliveries for some of the fastest-growing companies, from retailers to...