Senior MySQL Database Administrator

7 days ago

Faisalabad City Tehsil, Pakistan DGSOL- The Creative Marketing Agency Full time
Senior MySQL Database Administrator & Infrastructure ExpertSenior MySQL Database Administrator & Infrastructure Expert

2 weeks ago Be among the first 25 applicants

Direct message the job poster from DGSOL- The Creative Marketing Agency

Ai Automation | Digital Marketing Consultant | Search Engine Optimization (SEO) Manager | SEO Expert | Digital Marketing Expert | Social Media…

Project Overview:

We are building a large-scale SEO SaaS platform and seeking a highly experienced MySQL and infrastructure expert to help us:

Set up a 4-node MySQL Cluster (Group Replication or InnoDB Cluster) on Hetzner dedicated servers running Ubuntu 22.04.

Securely and efficiently import over 150 TB of compressed JSON data (.json.gz) from Google Cloud Storage into the MySQL cluster.

This is a remote, contract-based opportunity with strong potential for long-term DevOps/database support work, contingent upon performance.

Key Responsibilities:

Design and deploy a production-ready MySQL Cluster (preferably InnoDB Cluster or Group Replication) on 4 Ubuntu servers.

Set up secure, highly available networking with auto-failover and data redundancy across all nodes.

Optimize the MySQL setup for high-throughput JSON ingestion, including indexing, partitioning, and performance tuning to enhance overall efficiency.

Build a secure, resumable, and parallel data ingestion pipeline from Google Cloud Storage to MySQL.

Ensure full encryption of data in transit and at rest, utilizing SSH, firewalls, and properly configured MySQL user roles.

Implement logging, monitoring, and robust documentation of all steps and infrastructure to ensure comprehensive tracking and transparency.

Provide optional automation scripts (e.g., Ansible, Bash) or Infrastructure-as-Code (IaC) tools (e.g., Terraform) for reproducibility.

Test imports and validate data integrity and performance benchmarks.

Optional Tools: Python, Bash, Ansible, Terraform

Requirements:

Deep understanding of MySQL replication, high availability, and failover

Experience ingesting or transforming massive JSON datasets (50TB+)

Proficient in GCS CLI tools and cloud-to-server secure data transfer

Solid background in Linux system administration (Ubuntu preferred)

Strong grasp of security best practices: firewalls, SSH, MySQL roles, and backup strategies

Excellent skills in documentation, testing, and communication

Bonus Points For:

Experience with MySQL Router, ProxySQL, or Vitess

Familiarity with Percona XtraBackup or mysqlpump

Prior experience with Hetzner servers or bare-metal infrastructure

Location:

Remote (Global — must be highly responsive in your working hours)

Contract Type:

Part-time or full-time

Freelance / Contract

Long-term potential based on performance

Job Types: Part-time, Contract

Seniority level
  • Seniority levelMid-Senior level
Employment type
  • Employment typeFull-time
Job function
  • Job functionInformation Technology
  • IndustriesIT Services and IT Consulting

Referrals increase your chances of interviewing at DGSOL- The Creative Marketing Agency by 2x

Sign in to set job alerts for "Senior Database Administrator" roles.

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

  • Senior MySQL Database Administrator

    3 weeks ago

    Faisalabad City Tehsil, Pakistan DGSOL- The Creative Marketing Agency Full time

    Job descriptionProject Overview:We are building a large-scale SEO SaaS platform and seeking a highly experienced MySQL and infrastructure expert to help us:Set up a 4-node MySQL Cluster (Group Replication or InnoDB Cluster) on Hetzner dedicated servers running Ubuntu 22.04.Securely and efficiently import over 150 TB of compressed JSON data (.json.gz) from...

  • Expert Database Infrastructure Specialist

    6 days ago

    Faisalabad City Tehsil, Pakistan beBeeInfrastructure Full time 4,000,000 - 5,000,000

    Job Title:Database Infrastructure SpecialistWe seek an experienced MySQL and infrastructure professional to build a large-scale SEO platform.This role involves designing a production-ready MySQL Cluster on 4 servers, setting up secure networking with auto-failover, and optimizing the MySQL setup for high-throughput JSON ingestion.The successful candidate...

  • System Administrator

    4 weeks ago

    Faisalabad City Tehsil, Pakistan IT Y'ALL - Texas Computer Experts Full time

    Direct message the job poster from IT Y'ALL - Texas Computer ExpertsSystem Administrator - II @ IT Y'ALL | Network Security, Server AdministrationCompany DescriptionIT Y'ALL - Texas Computer Experts is a one-stop shop for all your IT needs with over 15 years of experience in the field. Our IT experts specialize in monitoring, networking, hardware, software,...

  • High-Impact Database Engineer

    2 weeks ago

    Hyderabad City Taluka, Pakistan beBeeDatabaseEngineer Full time $180,000 - $250,000

    Unlock your potential in a role that demands expertise, creativity, and innovation. As a key member of our database engineering team, you will be responsible for designing, building, and maintaining large-scale data storage and streaming platforms.This is an opportunity to work with cutting-edge technologies like MySQL, Clickhouse, Kafka, and Redis to...

  • Linux System Administrator

    3 weeks ago

    Faisalabad City Tehsil, Pakistan One Network Full time

    Direct message the job poster from One NetworkWe are in search of a "System Administrator" to join our esteemed team. The ideal candidate will bring a minimum of 3 years of proven experience, adeptly managing data center infrastructure and ensuring optimal system performance.Responsibilities:- Experience with Datacenter, Servers, RAID management, databases...

  • School Administrator

    1 week ago

    Faisalabad City Tehsil, Pakistan beBee Careers Full time $40,000 - $55,000

    School Administrator PositionThe School Administration Assistant plays a crucial role in ensuring the smooth operation of administrative functions. This position requires a highly hardworking candidate who is dedicated to the task provided on a day-to-day basis, requiring a blend of organizational skills, interpersonal abilities, and a deep understanding of...

  • NetApp/ Database Administrator

    4 weeks ago

    Hyderabad City Taluka, Pakistan HSBC Full time

    Some careers shine brighter than others.If you're looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.HSBC is one of the largest banking and...

  • Senior Executive Administrator

    4 days ago

    Faisalabad City Tehsil, Pakistan beBeeSupport Full time 4,000,000 - 8,000,000

    Key Support RoleThe ideal candidate will provide high-level support to senior executives. They should be highly organized and comfortable managing calendars and responding to emails on the executive's behalf.Scheduling meetings for executivesAiding in preparation for executive meetingsResponding to emails and document requests for executivesDrafting slides,...

  • Senior PHP Developer

    4 weeks ago

    Gujujranwala City Tehsil, Pakistan Xtecknow Full time

    bachelor's degree in computer science, software engineering, or a related fieldWe are seeking a highly skilled and experienced Senior PHP Developer to join our team at Xtecknow.As a Senior PHP Developer, you will be responsible for developing and maintaining web-based applications, working closely with our project management and development teams to ensure...

  • Senior Web Programmer

    3 days ago

    Faisalabad City Tehsil, Pakistan beBeeDeveloper Full time 6,000,000 - 8,000,000

    The role of a Laravel Developer is to design and develop high-quality websites using PHP.">Job ResponsibilitiesDevelop, test, and maintain complex web applications using Laravel.Collaborate with cross-functional teams to identify business needs and translate them into technical requirements.Design and implement scalable and efficient database...