*Title: MySQL DBA* *Location: Atlanta, GA*
*Job Term: 6+ months * *Primary Skills:* · DBA, Networking, ODBC, Operating Systems, Perl, SQL, System design, Unix · Providing daily (24*7) operational support of EDS (Enterprise Data Services Dept) 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 reporting on all MySQL related issues for Windows. · Responsible for monitoring, DB 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. *Skills/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. *Job Responsibilities: * · 35% Monitor, maintain, and manage EDS production database environment including on call after hour support. · 15% Install, configure, create, and upgrade production MySQL databases. · 20% Resolve tickets: troubleshoot customer's problems and issues. · 5% Code and maintain production MySQL jobs. · 10%Provide MySQL resource/skills to multiple projects and product releases. · 10% Managing MySQL full database backup, archive log backup and data restore. · 5% Providing documentation both automated and manual. *Requirement:* · Training and/or experience required for this position · Clear understanding of networking concepts and server platforms. · MySQL certified preferred · Outstanding scripting and querying skills. · 3 - 5 years of experience with versions 4 and 5 · BA/BS MIS/CIS or equivalent experience at least 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. *Rohan Kumar* Pyramid Consulting, Inc. Phone: 770-255-3278 | Fax: 678.840.2109 Email: [email protected] USA | Canada | UK | India http://www.pyramidci.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
