• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 6th Feb 2024

Remove/unsubscribe  |  Update your contact and subscribed mailing list(s)  |  Subscribe to mailing list(s) to receive requirements & resumes

From:
Priya Verma,
VYZE
priya@vyzeinc.com
Reply to:   priya@vyzeinc.com
 

Job Description -

Job Title: MySQL Database Engineer

Contract to hire 12 months

Duration: 12 month

Needs to be local within commutable distance, and a GC/USC

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
? Associate’s 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
? Bachelor’s degree in Computer Science or related field
? Certification directly related to computer programming