Company:
PRI Technology
Location: New York County
Closing Date: 10/08/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Job Description: Job Title: MySQL DBA
Location: Bethlehem, PA or Holmdel, NJ. Local candidates preferred. The Database Service is scheduled to work Monday through Friday 8:00 AM ET till 5:00 PM ET. Today we are working 3-days remote and 2-days in the office. We operate on a 24x7x365 using an on-call rotation which the candidate will be a part of.
Must have skills:
" 10+ years of MySQL DBA experience
" MySQL replication experience
" SQL coding and tuning experience
" Shell scripting and automation experience
" MySQL Enterprise Manager experience
" AWS/Cloud Services experience: EC2, RDS, and Aurora
" Cloud deployments experience: Jenkins, Bitbucket, Terraform
" Hands-on, technically adept DBA, capable of performing required DB tasks experience
" Strong troubleshooting/performance tuning skills
" Ability to assess and improve SQL performance
" Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM
" Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
" Profile server resource usage, optimize and tweak as necessary
" Expert level MySQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments
" Strong commitment to following SDLC/Change-Management principles
" Self-starter and be able to perform work with minimal supervisory direction
" Knowledge of data quality, data management, and data testing strategies and practices
" Strong communication skills, both oral and written
" Strong 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 skills
" Keen analytical and structured approach to problem solving
" Ability to accommodate flexible work schedules
Desired skills:
" Ability to diagnose problems and triage/resolve 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 techniques
" Experience in DB2 UDB, Oracle, Postgres, Microsoft SQL Server, MongoDB, and/or Cassandra is plus
" Experience with configuration management tools: SCCM; Puppet; or Ansible.
" Development or enhancement of training and upskilling programs
" Bachelor's Degree or similar required
You will:
" Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes
" Perform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root cause
" Process all support requests within SLA by following procedural requirements
" Escalate to vendors, where necessary, to ensure timely resolution
" Thoroughly document steps taken to resolve incidents and fulfil catalog requests within ServiceNow tickets
" Develop, document, and update standard operating procedures and knowledgebase articles
" Identify, address, and resolve repeating alert trends to improve stability and performance
" Suggest defects and product/infrastructure enhancements to improve stability and automation
" Participation in periodic skills enhancement sessions and training courses
" Be 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.
Location: Bethlehem, PA or Holmdel, NJ. Local candidates preferred. The Database Service is scheduled to work Monday through Friday 8:00 AM ET till 5:00 PM ET. Today we are working 3-days remote and 2-days in the office. We operate on a 24x7x365 using an on-call rotation which the candidate will be a part of.
Must have skills:
" 10+ years of MySQL DBA experience
" MySQL replication experience
" SQL coding and tuning experience
" Shell scripting and automation experience
" MySQL Enterprise Manager experience
" AWS/Cloud Services experience: EC2, RDS, and Aurora
" Cloud deployments experience: Jenkins, Bitbucket, Terraform
" Hands-on, technically adept DBA, capable of performing required DB tasks experience
" Strong troubleshooting/performance tuning skills
" Ability to assess and improve SQL performance
" Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM
" Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
" Profile server resource usage, optimize and tweak as necessary
" Expert level MySQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments
" Strong commitment to following SDLC/Change-Management principles
" Self-starter and be able to perform work with minimal supervisory direction
" Knowledge of data quality, data management, and data testing strategies and practices
" Strong communication skills, both oral and written
" Strong 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 skills
" Keen analytical and structured approach to problem solving
" Ability to accommodate flexible work schedules
Desired skills:
" Ability to diagnose problems and triage/resolve 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 techniques
" Experience in DB2 UDB, Oracle, Postgres, Microsoft SQL Server, MongoDB, and/or Cassandra is plus
" Experience with configuration management tools: SCCM; Puppet; or Ansible.
" Development or enhancement of training and upskilling programs
" Bachelor's Degree or similar required
You will:
" Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes
" Perform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root cause
" Process all support requests within SLA by following procedural requirements
" Escalate to vendors, where necessary, to ensure timely resolution
" Thoroughly document steps taken to resolve incidents and fulfil catalog requests within ServiceNow tickets
" Develop, document, and update standard operating procedures and knowledgebase articles
" Identify, address, and resolve repeating alert trends to improve stability and performance
" Suggest defects and product/infrastructure enhancements to improve stability and automation
" Participation in periodic skills enhancement sessions and training courses
" Be 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.
Share this job
Useful Links