*Job Title: MySQL DBA * *Location: Washington, DC*
*Length: 6-12 Months+* *Must be Local to DC/MD/North VA* *OVERALL PURPOSE OF POSITION:* The purpose of this position is to perform and manage tasks related to the operation, support, administration, optimization, and maintenance of USAC owned databases and database tools. *ESSENTIAL DUTIES:* · The position’s essential duties include the following: · Support of production and non-production databases: · Correct issues reported in production system · Support routine and ad-hoc IT DBA requests · Update documentation, if required as part of correcting production issues · Implement and monitor daily and nightly database maintenance jobs · Monitor, diagnose, and respond to system failure and performance issues, taking appropriate measures to reduce system downtime and eliminate recurrence of the problem · Work with USAC technical staff, including network engineers and software developers, to analyse and improve system performance · Formulate and implement backup procedures for all company databases · Serve as technical support for any database related performance or access issue · Generate ad-hoc and routine reports and define metrics for database health and performance · Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of company databases. · Leading the team in providing technical support for any database-related performance or access issue · Perform or affect the performance of all database installations, patches, and planned upgrades. · Implement data models and database designs, data access and table maintenance codes. · Resolve database performance issues, database capacity issues, replication, and other database issues; · Perform database related development as dictated by departmental or project demands. · Design and perform data migrations and data transformations as required by application delivery teams or business customers. · Develop and maintain documentation, diagrams, and procedures and complies with company’s change management control process. · Ensure that all database designs adhere to industry best practices. · Work with application delivery teams during database design. · Possess substantial knowledge about application and database performance profiles of all databases under their management. · Represent the IT department in terms of database expertise in coordination with other departments. *TECHNICAL EXPERIENCE* · Type of Experience - MySQL Years of Experience · Provision MySQL instances, both in clustered and non-clustered configurations (7+ Years) · Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM (7+ Years) · Proficient in writing and optimizing SQL statements (7+ Years) · Experience with replication configuration in MySQL (5+ Years) · Managing MySQL User Accounts (7+ Years) · Backing Up, Copying, and Recovering MySQL Databases (7+ Years) · Tuning the MySQL Server (7+ Years) · Running Multiple MySQL Servers (7+ Years) · MySQL Database Maintenance and Repair (7+ Years) · Developing of SQL scripts for stored procedures and functions (5+ Years) · Experience with physical database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning etc (7+ Years) · Knowledge of de-facto standards and best practices in MySQL (7+ Years) · Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases · Linux/Unix platforms and Linux Shell scripting (5+ Years) · Display strong ability in troubleshooting complex issues (5+ Years) · Experience in performance tuning and load testing of database (7+ Years) · Knowledge of database security concepts (5+Years) · Experience with high availability database and application architectures (3+ Years) *NOTE: In addition, please list any desired experience.* · MySQL Certification · You have experience with NoSQL databases, such as Couchbase, MongoDB etc. · Demonstrated experience with Microsoft Reporting Services or other enterprise reporting tool. · Experience with clustered MySQL databases and high availability architectures. · SQL Server 2012 experience · Experience with agile software development such as SCRUM and XP · Experience with high availability database and application architectures · Experience with physical database characteristics such as table design, relationships · data partition, efficient indexes, storage allocation, capacity planning etc (5+ Years) · Display strong ability in troubleshooting complex issues (5+ Years) · Experience in performance tuning and load testing of database (5+ Years) · Knowledge of database security concepts (5+Years) *SPECIAL SKILLS:* · Analytical and problem solving skills · Developing and/or creating new or more effective ideas, approaches, etc. · Developing and executing short-range plans/decisions · Excellent interpersonal and communication skills · Ability to exercise sound judgment across a broad range of circumstances -- *Thanks & Regards* Tanya Syed | Sr. Executive Recruiter Sonoma Consulting, Inc. Office: 630-409-0400 Fax: 630-756-4181 Email: [email protected] Web: www.sonomaconsulting.net -- 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 https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
