Donan Consulting
Database Engineer MySQL/MariaDB (senior)
Donan Consulting, Washington, District of Columbia, us, 20022
Overview
The overall purpose of this position is to perform and manage tasks related to the operation, support, administration, optimization, and maintenance of client owned databases and database tools. Responsibilities 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 client technical staff, including network engineers and software developers, to analyze 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. Lead 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 comply with the companys 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.
Qualifications and Experience
Experience: MySQL 8+ years of experience in provisioning MySQL instances, both in clustered and non-clustered configurations. 8+ years of experience in understanding MySQLs underlying storage engines, such as InnoDB and MyISAM. 8+ years of experience in proficient in writing and optimizing SQL statements. 6+ years of experience in replication configuration in MySQL. 7+ years of experience in managing MySQL User Accounts. 7+ years of experience in backing up, copying, and recovering MySQL databases. 7+ years of experience in tuning the MySQL Server. 7+ years of experience in running multiple MySQL servers. 7+ years of experience in MySQL database maintenance and repair. 5+ years of experience in developing SQL scripts for stored procedures and functions. 7+ years of experience in experience with physical database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning, etc. 7+ years of experience in knowledge of de-facto standards and best practices in MySQL. 5+ years of experience in knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases. 7+ years of experience in Linux/Unix platforms and Linux Shell scripting. 5+ years of experience in displaying strong ability in troubleshooting complex issues. 3+ years of experience in performance tuning and load testing of database. 5+ years of experience in knowledge of database security concepts. 3+ years of experience in high availability database and application architectures.
Note
Note: In addition, this is the desired experience. 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. Display strong ability in troubleshooting complex issues. Experience in performance tuning and load testing of database. Knowledge of database security concepts.
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.
#J-18808-Ljbffr
The overall purpose of this position is to perform and manage tasks related to the operation, support, administration, optimization, and maintenance of client owned databases and database tools. Responsibilities 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 client technical staff, including network engineers and software developers, to analyze 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. Lead 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 comply with the companys 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.
Qualifications and Experience
Experience: MySQL 8+ years of experience in provisioning MySQL instances, both in clustered and non-clustered configurations. 8+ years of experience in understanding MySQLs underlying storage engines, such as InnoDB and MyISAM. 8+ years of experience in proficient in writing and optimizing SQL statements. 6+ years of experience in replication configuration in MySQL. 7+ years of experience in managing MySQL User Accounts. 7+ years of experience in backing up, copying, and recovering MySQL databases. 7+ years of experience in tuning the MySQL Server. 7+ years of experience in running multiple MySQL servers. 7+ years of experience in MySQL database maintenance and repair. 5+ years of experience in developing SQL scripts for stored procedures and functions. 7+ years of experience in experience with physical database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning, etc. 7+ years of experience in knowledge of de-facto standards and best practices in MySQL. 5+ years of experience in knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases. 7+ years of experience in Linux/Unix platforms and Linux Shell scripting. 5+ years of experience in displaying strong ability in troubleshooting complex issues. 3+ years of experience in performance tuning and load testing of database. 5+ years of experience in knowledge of database security concepts. 3+ years of experience in high availability database and application architectures.
Note
Note: In addition, this is the desired experience. 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. Display strong ability in troubleshooting complex issues. Experience in performance tuning and load testing of database. Knowledge of database security concepts.
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.
#J-18808-Ljbffr