Mindlance
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."
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."