Skip to Main Content

Job Title


MySQL DBA - C2H (Hybrid in PA or NJ)


Company : Atlantic Partners Corporation


Location : holmdel, NJ


Created : 2024-06-23


Job Type : Full Time


Job Description

Our client is actively seeking a passionate and driven Senior Database Engineer to provide operational support for their Database Systems, design and build database systems using automation in both data center and cloud platforms, including identifying build defects and create self-healing routines. Must have skills:10+ years of MySQL DBA experienceMySQL replication experienceSQL coding and tuning experienceShell scripting and automation experienceMySQL Enterprise Manager experienceAWSCloud Services experience: EC2, RDS, and AuroraCloud deployments experience: Jenkins, Bitbucket, TerraformHands-on, technically adept DBA, capable of performing required DB tasks experienceStrong troubleshootingperformance tuning skillsAbility to assess and improve SQL performanceUnderstanding of MySQL's underlying storage engines, such as InnoDB and MyISAMAbility to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.Profile server resource usage, optimize and tweak as necessaryExpert level MySQL RDBMS installationconfiguration, patching, troubleshooting, performance trackingtuning, back-uprecovery, remote monitoring skills with hands-on experience in -large and very dynamic environmentsStrong commitment to following SDLCChange-Management principlesSelf-starter and be able to perform work with minimal supervisory directionKnowledge of data quality, data management, and data testing strategies and practicesStrong communication skills, both oral and writtenStrong experience working with ticketing tools such as ServiceNow, Zenoss or any other monitoring tool, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool)Strong problem-solving and troubleshooting skillsKeen analytical and structured approach to problem solvingAbility to accommodate flexible work schedulesDesired skills: Ability to diagnose problems and triageresolve issues across various tiers (application, network, database, server, or storage tiers)Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniquesExperience in DB2 UDB, Oracle, Postgres, Microsoft SQL Server, MongoDB, andor Cassandra is plusExperience with configuration management tools: SCCM; Puppet; or Ansible.Development or enhancement of training and upskilling programsBachelor's Degree or similar required You will:Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changesPerform initial investigation andor troubleshooting of database and database system issues to resolve issue & determine root causeProcess all support requests within SLA by following procedural requirementsEscalate to vendors, where necessary, to ensure timely resolutionThoroughly document steps taken to resolve incidents and fulfil catalog requests within ServiceNow ticketsDevelop, document, and update standard operating procedures and knowledgebase articlesIdentify, address, and resolve repeating alert trends to improve stability and performanceSuggest defects and productinfrastructure enhancements to improve stability and automationParticipation in periodic skills enhancement sessions and training coursesBe a project lead, as well as a project participant for various activities: cloud migration, lifecycle management, application modernization, capacity planning, financial optimization, performance, and stability optimization, build and design state configuration automation, etc.