| MySQL Database Engineer!! Hybrid Role || 100% Interview || at Remote, Remote, USA |
| Email: [email protected] |
| From: Anuj, Vyze inc [email protected] Reply to: [email protected] Job Description - MySQL Database Engineer Contract to hire 12 months MySQL is key and they will train on MariaDB. Position Summary The MariaDB Database Engineer (DBE) needs a thorough understanding of relational database theory and practice, along with in-depth knowledge of data systems and database methodology, design and modeling. This individual must be analytical and adept at problem solving, can strategically design and implement production databases, and provide support for specific applications. This DBE focuses on both the logical and physical aspects of the database and application data contained within. They are responsible for developing, implementing, documenting and overseeing database policies and procedures to ensure the integrity of data. The Database Engineer will also monitor and ensure system performance issues do not arise due to database related issues. The DBE is a person who can bridge the gaps and communicate on both a technical level and a business level with the other portions of IT. They must be able to partner with the infrastructure teams, the application development teams and the information management teams. Accountabilities/Responsibilities Database Architecture, Design and Implementation The DBE is responsible for the architecture, design and implementation of database systems and components in support of information management goals. This includes the database and data life cycle. It includes understanding and applying the science and art of data modeling practiced via modern methods, tools and interfaces. The DBE is involved in gathering business requirements, logical modeling, physical modeling, implementing the model and maintaining the model. The DBE is responsible for best practices of constraints, referential integrity, and triggers. A thorough understanding of disaster recovery strategies for stand-alone and clustered environments is also necessary. Data Availability, Control, Governance and Integrity The DBE, in partnership with the data owner, is responsible for the accessibility, availability and integrity of the database and data. The DBE is responsible for defining and implementing the appropriate strategy and methods to maintain control and governance of the database and the data, as defined and mandated by the owner. This includes understanding and accounting for all the potential data access interfaces and methods, and ensuring proper security, permissions, and auditing measures are in place. A critical success factor is identifying, understanding and reconciling the associated business and technical requirements for data and information management. Data Centric Application Design and Programming The DBE is responsible for ensuring proper and adequate data centric techniques are used in the design, development and implementation of applications. This includes taking advantage of built in database management system features and functions such as constraints, functions and triggers. The DBE is responsible for understanding and applying the science and art of coding and implementing SQL (DDL, DML and PSM) via modern methods, tools and interfaces. Leading, guiding and reviewing data centric application development is a fundamental task. As appropriate, the DBE is also involved in all aspects of maintaining, modernizing and enhancing existing database applications that are based on DDS, high level language record level access and other non-SQL interfaces. Database Performance and Scalability The DBE is responsible for identifying, understanding, reconciling and meeting the data serving performance and scalability requirements. This includes applying the best practices of indexing, work management and set at-a-time SQL requests. The DBE is responsible for understanding and applying the science and art of monitoring, analyzing and tuning data access and data processing via modern methods, tools and interfaces. The DBE is involved in planning, sizing and configuring database systems to meet business and technical requirements. This should include the set up and use of prototypes, proofs of concept, proofs of technology and realistic benchmarks. The DBE must be able to perform server maintenance and provide support for the various applications using MariaDB throughout the organization Competencies for Success 1. Analytical and critical thinking 2. Complex problem solving 3. Collaboration and communication 4. Planning and organizing 5. Presentation skills 6. A constant learner and embraces continual improvement 7. Proficient with database administration and good technical acumen 8. Expertise with SQL (DDL, complex views, constraints, etc.) 9. Knows the Data Qualifications/Experience Minimum Qualifications Greater than 3 years related professional experience Associates degree in Computer Science or related field Similar work experience, technical skills or relevant certification may be considered in place of bachelor's degree; must maintain awareness of changing technology At least 2 years experience with MariaDB; or equivalent experience with MySQL Red Hat Enterprise Linux (RHEL) Desired Qualifications Bachelors degree in Computer Science or related field Certification directly related to computer programming Keywords: information technology |
| [email protected] View all |
| Thu Feb 08 21:27:00 UTC 2024 |