Database Engineer (MYSQL)

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