MySQL Database Administrator

Location

United States

Posted

77 days ago

Salary

0

Seniority

Mid Level

Job Description

MySQL Database Administrator

Fortified Data

Role Description Fortified Data is currently seeking a mid-level MySQL Database Administrator (DBA) who will play an integral role within the technical service delivery team. The MySQL DBA will be responsible for effectively designing, managing, and supporting MySQL database systems for clients. As the MySQL DBA, you will take ownership of ensuring the stability, reliability, predictability, availability, and performance of our clients' MySQL databases. Duties & Essential Job Functions - Manage priority of inbound support requests - Respond to client issues within targeted response times specified in SLA (service level agreement) - Resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues specific to MySQL - Communicate ticket status with team members and clients - Document in detail the resolution of each issue within our Ticket Management System - Enter time spent with clients in real-time - Be an escalation point during critical client events as part of a 24 x 7 team - Plan and perform the installation of MySQL Database application software, patches, and services packs - Proactive database monitoring and maintenance for MySQL databases - Ensure the integrity and security of client MySQL databases - Consolidate and tune MySQL databases for optimal performance - Perform backups and restores for MySQL databases - MySQL database performance monitoring, optimization, and tuning - Implement and support systems for high availability and disaster recovery for MySQL databases (e.g., replication, clustering, failover solutions) - Generate and maintain scripts to support MySQL DB creation, schemas, automate tasks, and related activities - Perform root cause analysis, document, and present findings to clients for MySQL-related issues - Update internal processes and support documentation related to MySQL databases - Mentor Junior DBAs in MySQL administration - Interest in Conducting Internal Lunch Learns specifically on MySQL topics - Interest in Publishing BLOGs and White Papers focused on MySQL technologies and best practices Qualifications - 3-5 years of MySQL Database Administration experience - MySQL versions 5.7, 8.0, and 8.4 (or later) - Advanced installation, configuration, and patching of MySQL database software - MySQL replication technologies including master-slave, group replication, and InnoDB Cluster - Backup and recovery strategies using tools such as mysqldump, Percona XtraBackup, or MySQL Enterprise Backup - High availability and disaster recovery implementation - Proficiency with MySQL Query Language (SQL) and query optimization - Performance tuning including query optimization, index design, and explain plan analysis - Understanding of InnoDB storage engine, buffer pool management, and locking mechanisms - Effective utilization of Performance Schema, MySQL Enterprise Monitor, or third-party monitoring tools (Prometheus, Grafana, Zabbix) - Implementation of MySQL security models including authentication, authorization, and encryption at rest and in transit - Understanding of ACID principles and transaction management - Intermediate knowledge of Linux and Windows Server operating systems - Basic understanding of network configurations, subnets, and firewalls Preferred Experience - 1+ years PostgreSQL administration experience including installation, configuration, and basic performance tuning - Python, Bash, or Shell scripting for database automation - Prior experience with a Managed Services Provider - Demonstrated experience with data extraction, manipulation, and ETL processes - Working knowledge of cloud-based database services (AWS RDS/Aurora, Google Cloud SQL, or Azure Database for MySQL) - Experience with containerized databases (Docker, Kubernetes) - MySQL automation and infrastructure-as-code tools (Ansible, Terraform) - MySQL Workbench, Zabbix, and advanced Performance Schema utilization - Experience with database migration tools and strategies - MySQL clustering solutions (InnoDB Cluster, Galera) - 1+ years Oracle or PostgreSQL database administration experience (bonus but not required) - 1+ years MS SQL Server database administration experience (bonus but not required) Required Attributes - Customer Service: Listens and responds effectively to customer questions; resolves customer problems to the customer’s satisfaction. - Ability to Multi-Task: Proven ability to manage multiple issues and/or projects successfully bringing them all to resolution in a timely manner. - Problem Solving: Anticipates problems, recognizes and accurately evaluates the signs of a problem and analyzes current procedures for possible improvements. - Detail Oriented: Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. - Automation / Tools: Proficient in use of all Microsoft Office software applications including Outlook, Word, PowerPoint, and Excel. Work Environment - We are a 100% remote company - Occasional travel possible

Job Requirements

  • 3-5 years of MySQL Database Administration experience
  • MySQL versions 5.7, 8.0, and 8.4 (or later)
  • Advanced installation, configuration, and patching of MySQL database software
  • MySQL replication technologies including master-slave, group replication, and InnoDB Cluster
  • Backup and recovery strategies using tools such as mysqldump, Percona XtraBackup, or MySQL Enterprise Backup
  • High availability and disaster recovery implementation
  • Proficiency with MySQL Query Language (SQL) and query optimization
  • Performance tuning including query optimization, index design, and explain plan analysis
  • Understanding of InnoDB storage engine, buffer pool management, and locking mechanisms
  • Effective utilization of Performance Schema, MySQL Enterprise Monitor, or third-party monitoring tools (Prometheus, Grafana, Zabbix)
  • Implementation of MySQL security models including authentication, authorization, and encryption at rest and in transit
  • Understanding of ACID principles and transaction management
  • Intermediate knowledge of Linux and Windows Server operating systems
  • Basic understanding of network configurations, subnets, and firewalls
  • Preferred Experience
  • 1+ years PostgreSQL administration experience including installation, configuration, and basic performance tuning
  • Python, Bash, or Shell scripting for database automation
  • Prior experience with a Managed Services Provider
  • Demonstrated experience with data extraction, manipulation, and ETL processes
  • Working knowledge of cloud-based database services (AWS RDS/Aurora, Google Cloud SQL, or Azure Database for MySQL)
  • Experience with containerized databases (Docker, Kubernetes)
  • MySQL automation and infrastructure-as-code tools (Ansible, Terraform)
  • MySQL Workbench, Zabbix, and advanced Performance Schema utilization
  • Experience with database migration tools and strategies
  • MySQL clustering solutions (InnoDB Cluster, Galera)
  • 1+ years Oracle or PostgreSQL database administration experience (bonus but not required)
  • 1+ years MS SQL Server database administration experience (bonus but not required)
  • Required Attributes
  • Customer Service: Listens and responds effectively to customer questions; resolves customer problems to the customer’s satisfaction.
  • Ability to Multi-Task: Proven ability to manage multiple issues and/or projects successfully bringing them all to resolution in a timely manner.
  • Problem Solving: Anticipates problems, recognizes and accurately evaluates the signs of a problem and analyzes current procedures for possible improvements.
  • Detail Oriented: Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small.
  • Automation / Tools: Proficient in use of all Microsoft Office software applications including Outlook, Word, PowerPoint, and Excel.
  • Work Environment
  • We are a 100% remote company
  • Occasional travel possible

Related Categories

Related Job Pages

More Database Administrator Jobs

ePATHUSA, Inc. logo

Senior Database Administrator

ePATHUSA, Inc.

ePATHUSA - eInnovation Delivered!

OtherRemoteTeam 11-50Since 2005H1B No Sponsor

• Collaborate with other ADABAS administrators at MDHS to support MACWIS and other applications supported by MDHS.

United States
$62 - $66 / hour
Job Closed
bswift logo

Senior Cloud DBA

bswift

Helping companies be ready for all their benefits needs, today and tomorrow.

OtherRemoteTeam 1,001-5,000H1B No Sponsor

Role Description The Senior Database Administrator will support, elevate, and modernize bswift’s data platforms. This role blends deep Microsoft SQL Server expertise with cloud‑native architecture, automation, and engineering practices on AWS. You will own the reliability, performance, security, and evolution of our database ecosystem while driving modernization initiatives toward scalable, automated, cloud‑native architectures. This is a hands‑on, high‑impact role partnering closely with Engineering, DevOps, Analytics, and Security teams to deliver resilient and cost‑efficient data solutions. Responsibilities - Cloud & Platform Architecture and Strategy - Design, implement, and operate scalable cloud‑native data platforms on AWS, including RDS SQL Server, MySQL, Aurora PostgreSQL, DynamoDB, and OpenSearch. - Automate infrastructure and database operations using Infrastructure as Code (Terraform, CloudFormation) and scripting (PowerShell, SQL Agent) to reduce manual processes and improve reliability. - Database Administration & Operations - Own day‑to‑day administration of SQL Server 2019+ environments, ensuring performance, availability, scalability, and security. - Architect and maintain high availability and disaster recovery solutions, including multi‑AZ designs, replication, automated backups, point‑in‑time recovery, and failover testing. - Perform core DBA activities including backups, environment refreshes, data de‑identification, disaster recovery readiness, index maintenance, and statistics management. - Proactively tune and optimize database performance through query analysis, indexing strategies, execution plan review, and monitoring. - Participate in on‑call rotation via PagerDuty and respond to production database alerts and incidents. - Modernization & Data Engineering Enablement - Provide database expertise to support cloud‑native data pipelines, ensuring efficient SQL performance, sound schema design, and high data quality. - Modernize and optimize database platforms by implementing ELT/ETL workflows and scalable ingestion strategies. - Define and enforce standards for observability, security, and compliance, including encryption, RBAC, auditing, data masking, monitoring, and alerting. - Reliability, Security & Cost Optimization - Ensure platform reliability through proactive monitoring, alerting, capacity planning, and performance baselining. - Optimize cloud costs through lifecycle management, storage tiering, archival strategies, and rightsizing database resources. - Partner with Security, DevOps, and Engineering teams to implement least‑privilege access and secure data handling practices. - Technical Leadership - Act as a technical leader and trusted advisor on database and data platform decisions. - Document architecture, standards, and best practices; mentor teams and review implementations. - Own database platforms end‑to‑end, from design and implementation through operations and continuous improvement. Qualifications - Minimum of 8 years of senior‑level experience administering Microsoft SQL Server in enterprise environments. - Proven experience with Always On, clustering, replication, and high availability/disaster recovery architectures. - Hands‑on experience with AWS database services, including RDS MySQL, Aurora PostgreSQL, and DynamoDB. - Proficiency with observability and performance tools such as Idera, Redgate, CloudWatch, AppDynamics, Performance Insights, SQL Profiler, and Extended Events. - Experience participating in on‑call rotations and managing critical production incidents. - Demonstrated experience supporting highly available data platforms with strong SLAs and uptime requirements. - Experience with ELT/ETL pipelines, CDC patterns, and analytics‑focused data architectures. - Hands‑on experience with automation and Infrastructure as Code tools (Terraform, CloudFormation, PowerShell). - Experience leading or supporting cloud migrations and modernization of legacy database platforms. - Strong collaboration skills and ability to work effectively in fast‑moving, distributed team environments. Requirements - Familiarity with NoSQL databases, caching technologies, or event‑driven architectures. - Experience with AWS services such as Bedrock, OpenSearch, Glue, and Lambda. - Experience working in regulated industries such as healthcare, insurance, or financial services. Benefits - Comprehensive Health Benefits: Access to health, dental, and vision plans to support your wellness and that of your family. - Competitive Compensation: A compensation package that recognizes your skills, experience, and contributions, including performance-based incentives for most roles. - Remote first, Office friendly environment! - Retirement Savings Plans: Options to help you plan for a secure financial future with employer-sponsored retirement savings programs. - Professional Development: Opportunities for career growth, including training and access to resources to support your career progression. - Supportive Culture: A work environment that encourages collaboration, open communication, and creative problem-solving, where your voice and ideas are valued. - Employee Wellbeing Initiatives: Programs focused on mental health, financial planning, and wellness resources to help you thrive inside and outside of work. - Make an Impact: At bswift, your work directly contributes to transforming how organizations approach benefits administration and client engagement.

United States
$140K - $150K / year
Job Closed

Title: Engineer Location: Plano United States Hybrid Job Description: Akkodis is seeking an Engineer for a Contract with a client in Plano, TX(Hybrid). Candidates must have strong expertise in SQL Server administration to manage performance, availability, and security across critical production systems. Rate Range: $54/hour to $56/hour; The rate may be negotiable based on experience, education, geographic location, and other factors. Engineer job responsibilities include: - Oversees SQL Server database administration including configuration, maintenance, and optimization across production environments. - Manages system health monitoring, performance tuning, and real‑time issue resolution to ensure high availability and reliability. - Implements backup strategies, restore procedures, and DR/HA configurations to maintain data integrity and business continuity. - Supports developers with query tuning, schema refinement, and performance troubleshooting. - Refines automated processes, tracks recurring issues, and maintains detailed documentation of system changes. - Performs scheduled maintenance, releases deployments, and provides 24×7 support for mission‑critical systems. Required Qualifications: - Bachelor's degree in computer science, Information Technology, or a related technical discipline. - 10+ years of experience in SQL Server database administration and performance optimization. - Strong proficiency in SQL Server performance tuning, high availability/disaster recovery, and real‑time issue resolution. - Demonstrated expertise in backups, restores, automation, and supporting critical 24×7 production database environments. If you are interested in this role, then please click APPLY NOW. For other opportunities available at Akkodis, or any questions, feel free to contact me at Vikas.Tomar@akkodisgroup.com. Pay Details: $54.00 to $56.00 per hour Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Equal Opportunity Employer/Veterans/Disabled Military connected talent encouraged to apply The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable: - The California Fair Chance Act - Los Angeles City Fair Chance Ordinance - Los Angeles County Fair Chance Ordinance for Employers - San Francisco Fair Chance Ordinance Massachusetts Candidates Only: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Texas
BNY logo

Senior Vice President, Database Engineer

BNY

A global financial services company overseeing more than $50T in assets — managing it, moving it and keeping it safe.

OtherRemoteTeam 10,001+H1B Sponsor

The Bank of New York Mellon seeks Senior Vice President, Database Engineer in New York, NY, to consult with internal business groups to provide high-level application software development services or technical support. Evaluate compliance with the organization's technology standards. Actively participate in code reviews. Integrate software components into a fully functional software system. Apply security and privacy principles. Work with internal business groups on implementation opportunities, challenges, and requirements of various applications. Analyze information and provide recommendations to address and resolve business issues for a specific business group. Consult with IT management and technical staff regarding use of emerging technologies and associated services. Participate in defining corporate implementation and integration strategies of new technologies. Use learning tools such as Pluralsight to complete both recommended and aspirational targets set in personal development plans. Stay abreast of emerging technologies. Advocate for innovative, creative technology solutions. Mentor junior level engineers. Remote work may be permitted within a commutable distance from the worksite. REQUIREMENTS: Bachelor’s degree, or foreign equivalent, in Computer Science, Computer Engineering, or a related field, and nine (9) years of progressively responsible experience in the job offered or in a related IT occupation. Nine (9) years of progressively responsible experience must include: Performing all phases of development lifecycle, from gathering requirements, analysis, design, coding, testing, implementing, maintaining, and supporting application software; Architecting application system with complex business logic and data using ETL, Mongodb, SQL, API, XML, JSON, HTML, and S3 data; Handling data feed from different data sources, performing transformations, and loading the data into various targets using ETL Pentaho, Data Stage, and Spark tools; Writing business logic using NoSQL, and MongoDB database aggregation pipelines; Participating in defining corporate implementation and integration strategies of new technologies; and Developing CICD pipeline utilizing Jenkin and GitLab. Qualified applicants please apply online at https://bnymellon.eightfold.ai/careers and utilize reference code #72748. Please indicate “referral source – advertisement – WEB.” BNY assesses market data to ensure a competitive compensation package for our employees. The base salary/range for this position is expected to be $189,592.00 - $189,592.00 per year at the commencement of employment. Base salary if hired will be determined on an individualized basis, including as to experience and market location, and is only part of the BNY total compensation package, which, depending on the position, may also include commission earnings, discretionary bonuses, short and long-term incentive packages, and Company-sponsored benefit programs. This position is at-will, and the Company reserves the right to modify the base salary (as well as any other discretionary payment or compensation) at any time, including for reasons related to individual performance, change in geographic location, Company or individual department/team performance, and market factors. BNY is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals with Disabilities/Protected Veterans

United States
$189.6K / year