Position Summary :
Title : DATABASE ENGINEER III - MYSQL / MARIADB
Duration : 6 Months - Long Term
Location : Washington, DC 20005
Hybrid Onsite : 3 days onsite per week from Day1
ESSENTIAL DUTIES :
The position's essential duties include the following :
- Support of production and non-production databases :
o Correct issues reported in production system
o Support routine and ad-hoc IT DBA requests
o Update documentation, if required as part of correcting production issues
o Implement and monitor daily and nightly database maintenance jobs
o Monitor, diagnose, and respond to system failure and performance issues, taking
o appropriate measures to reduce system downtime and eliminate recurrence of the problem
o Formulate and implement backup procedures for all company databases
o 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 performanceAdminister, 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 issuePerform 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 8 YearsUnderstanding of MySQL's underlying storage engines, such as InnoDB and MyISAM 8 YearsProficient in writing and optimizing SQL statements 8 YearsExperience with replication configuration in MySQL 6 YearsManaging MySQL User Accounts 7 YearsBacking Up, Copying, and Recovering MySQL Databases 7 YearsTuning the MySQL Server 7 YearsRunning Multiple MySQL Servers 7 YearsMySQL Database Maintenance and Repair 7 YearsDeveloping of SQL scripts for stored procedures and functions 5 YearsExperience with physical database characteristics such as table design, relationships, datapartition, efficient indexes, storage allocation, capacity planning etc. 7 YearsKnowledge of de-facto standards and best practices in MySQL 7 YearsKnowledge of limitations in MySQL and their workarounds in contrast to other popular relational databasesLinux / Unix platforms and Linux Shell scripting 5 YearsDisplay strong ability in troubleshooting complex issues 5 YearsExperience in performance tuning and load testing of database 7 YearsKnowledge of database security concepts 5 YearsExperience with high availability database and application architectures 3 YearsNOTE : In addition, this is desired experience.
MySQL CertificationYou 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.SQLServer 2012 experienceExperience with agile software development such as SCRUM and XPExperience with high availability database and application architecturesExperience with physical database characteristics such as table design, relationships data partition, efficient indexes, storage allocation, capacity planning etc. 5 YearsDisplay strong ability in troubleshooting complex issues 5 YearsExperience in performance tuning and load testing of database 5 YearsKnowledge of database security concepts 5 YearsSPECIAL SKILLS :
Analytical and problem-solving skillsDeveloping and / or creating new or more effective ideas, approaches, etc.Developing and executing short-range plans / decisionsExcellent interpersonal and communication skillsAbility to exercise sound judgment across a broad range of circumstancesMindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority / Gender / Disability / Religion / LGBTQI / Age / Veterans."
