Description
Job Description:
Dynamic fortune 500 organization is looking for a top notch Database Engineer to add to their team.
* Providing daily (24*7) operational support of EDS production database environment including on call after hour support.
* Responsible for production MySQL database installation, configuration and administration.
* Providing troubleshooting skill for customer's problems and resolving of issues and related reporting on all MySQL issues for Windows.
* Responsible for monitoring, Database tuning and maintenance activities
* Managing MySQL objects including tables, indexes, views etc.
* Managing MySQL full database backup and data restore.
* Performing database user audits and accounts management.
* Implementing HA and disaster recovery solution to reduce unplanned downtime.
* Providing documentation both automated and manual procedures and processes.
EXPERIENCE:
* Deep experienced on MySQL installation/configuration, management and troubleshooting.
* Experience working in large enterprise database environments with multiple databases with SAN storage.
* Hands on experience on coding, troubleshooting and performance tuning SQL and complicated reporting.
* Excellent programming using Shell Scripts (sh, bash, and ksh) and Perl.
* Able to prioritize and execute tasks in a high-pressure environment
* Knowledge of reporting and query tools and practices.
* Working knowledge of MySQL versions 4 and version5.
* Being able to perform operating system level i/o, cpu, memory and disk troubleshooting and performance tuning tasks using iostat, vmstat, and other tools.
* Experience using OEM to monitor and troubleshoot system, cpu, memory, disk, and performance issues.
* Maintaining user security.
* A motivated team-player and fast learner.
* Ability to effectively communicate both written and verbally to peers and management.
* Ability to work under pressure and in high stress situations.
Requirements:
- Clear understanding of networking concepts and server platforms.
- MySQL certified preferred
- Outstanding Scripting and querying skills.
- 3 - 5 years of experience with MySQL versions 4 and 5
- 8 years experience as a DBA role.
- 4 years enterprise level production databases support.
- 2 years' experience utilizing NetBackup backup.
- 2 years enterprise database development experience.
- Knowledgeable of enterprise level applications.
Excellent written and verbal skills