Database Engineer III

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 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 8+ Years

• Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM 8+ Years

• Proficient in writing and optimizing SQL statements 8+ Years

• Experience with replication configuration in MySQL 6+ 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, datapartition, 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, this is 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.

• SQLServer 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

"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."