Job Overview
We are seeking an experienced Database Engineer who excels in designing and supporting intricate applications. As a key member of our application development team, you will work in conjunction with various business stakeholders to ensure our applications effectively meet their needs while providing invaluable support and mentorship to our developers.
Key Responsibilities
- Lead new and ongoing development projects through data and process modeling tasks.
- Develop and manage entity, logical, and physical data models.
- Execute database design across diverse platforms.
- Offer technical direction and mentorship to the application development team.
- Collaborate with stakeholders to ensure that application architecture aligns with business requirements.
- Construct logical and physical database models utilizing Oracle and SQL Server.
- Optimize SQL queries and resolve issues using SQL and PL/SQL scripts.
- Integrate software components to form a fully functioning software system.
- Create prototypes and mockups for user evaluation and approval.
- Develop flowcharts, screen layouts, and documentation to ensure system requirements are met.
- Contribute to large agile projects.
- Refine data models to ensure consistent performance.
- Manage metadata effectively and utilize data modeling tools such as Erwin and ER Studio.
Required Skills
- Over 8 years of experience in designing and reviewing logical and physical data models in SQL and/or PL/SQL.
- More than 6 years of practical experience with relational, dimensional, and/or analytic databases.
- 6+ years of experience in drafting SQL packages/functions/triggers and executing mass data updates and deletes.
- 3+ years dedicated to query optimization and performance tuning.
- 3+ years of expertise in data conversion across multiple systems and implementing data transformation strategies.
Qualifications
- A minimum of 8 years of applicable experience in application development and database management is essential.
- A Bachelor's degree in Computer Science, Information Technology, or a related discipline is preferred.
Career Growth Opportunities
Joining our organization presents an outstanding opportunity for professional advancement within a dynamic team-oriented environment. You will have the chance to enhance your skills in data modeling and application architecture while making significant contributions to high-impact projects.
Company Culture And Values
We pride ourselves on fostering an inclusive and collaborative culture that values diversity and promotes professional growth. Our commitment to employee development ensures that you will thrive in a supportive atmosphere.
Networking And Professional Opportunities
As part of our esteemed organization, you will gain access to valuable networking opportunities and collaborative projects, aiding in your professional development and visibility in the industry.
Compensation And Benefits
- Salary: \(90,000.00 - \)100,000.00 per year.
- 401(k) with matching.
- Dental insurance.
- Flexible schedule.
- Health insurance.
- Paid time off.
- Vision insurance.
Schedule
- 8-hour shift, Monday to Friday.
Location:
- Lansing, MI 48933: Candidates should reliably commute or plan to relocate prior to starting work.
Work Arrangement
Employment Type: Full-Time