*Database Engineer*

*Lansing, MI - Hybrid Remote Role*

*$90,000-$100,000 Annually*

*Job Description:*

Provide technical guidance to the application development team, which includes designing, developing, and supporting complex applications. The resource will be involved in collaborating with the business area to ensure the technical design of the application meets the business requirements. The resource will provide technical guidance to the other developers in the department. The programmer will also participate in a variety of analytical assignments for the enhancement, integration, maintenance, and implementation of projects and preparing technology roadmap for the supported applications.

*Position Duties:*

• Support new and existing development projects with data and process modeling activities. Provide entity, logical and physical data models;

• Perform database design across multiple platforms;

• Provide technical guidance to the application development team.

• Collaborate with stakeholder to ensure application architecture is in alignment with business requirement

• Excellent knowledge in designing both logical and physical database model in Oracle and SQL server

• Experience tuning SQL queries, scripts and troubleshoots issues using SQL, PL/SQL scripts

• Hands on experience Integrating software components into a fully functional software system

• Experience developing, prototypes, mockup for users review and approval.

• Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirements

• Experience working on large agile projects.

• Fine-tune data model to achieve consistent performance

• Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.

*Requirements:*

8+ years designing and review of logical and physical data model in SQL and/or PL/SQL

6+ years of hands-on relational, dimensional, and/or analytic experience

6+ years of experience in writing SQL packages/functions/Triggers and and Mass data updates and deletes.

3 + year of experience in query optimization and performance tuning.

3+ years of experience in data conversion between multiple systems and experience in data transformation strategies.

Job Types: Contract, Full-time

Pay: $90,000.00 - $100,000.00 per year

Benefits:
* 401(k)
* 401(k) matching
* Dental insurance
* Flexible schedule
* Health insurance
* Paid time off
* Vision insurance
Schedule:
* 8 hour shift
* Monday to Friday



Ability to commute/relocate:
* Lansing, MI 48933: Reliably commute or planning to relocate before starting work (Required)


Work Location: Hybrid remote in Lansing, MI 48933