Job Overview
We are seeking an accomplished Database Engineer with extensive experience in designing and supporting complex applications. As a vital member of our innovative application development team, you will engage closely with business stakeholders to ensure our applications fulfill their requirements while guiding and mentoring our developers. Your role will encompass a variety of responsibilities, including enhancing, integrating, maintaining, and implementing projects, alongside developing comprehensive technology roadmaps.
Key Responsibilities
- Provide support for both new and ongoing development projects through effective data and process modeling activities.
- Design and manage entity, logical, and physical data models across diverse platforms.
- Offer technical guidance and mentorship to the application development team, fostering growth and excellence.
- Collaborate with stakeholders to ensure application architecture aligns with business objectives and 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 various software components into a cohesive and fully functional software system.
- Create prototypes and mockups for user evaluation and approval.
- Develop detailed flowcharts, screen layouts, and documentation to capture logical system requirements.
- Engage in large agile projects, ensuring successful execution and delivery.
- Refine data models to achieve optimal performance and efficiency.
- Manage metadata and employ data modeling tools such as Erwin or ER Studio.
Required Skills
- Over 8 years of experience in designing and reviewing logical and physical data models in SQL and/or PL/SQL.
- At least 6 years of hands-on experience with relational, dimensional, and/or analytic databases.
- Minimum of 6 years of expertise in writing SQL packages, functions, triggers, and executing mass data updates and deletions.
- At least 3 years of experience in query optimization and performance tuning.
- A minimum of 3 years of experience in data conversion between multiple systems and implementing data transformation strategies.
Qualifications
- A bachelor's degree in Computer Science, Engineering, or a related field is required.
- A minimum of 8 years of relevant experience in software development and database management.
Career Growth Opportunities
Joining our esteemed organization provides an exceptional platform for professional development and career advancement. You’ll have access to a network of industry professionals and opportunities to enhance your skill set in a supportive and innovative environment.
Company Culture And Values
We pride ourselves on fostering a collaborative and dynamic workplace, emphasizing integrity, excellence, and teamwork. Our commitment to diversity and inclusion ensures that every voice is heard and valued, aligning with our mission to achieve excellence in application development.
Compensation And Benefits
- Salary: \(90,000.00 - \)100,000.00 per year
- Comprehensive 401(k) plan with matching
- Dental and vision insurance
- Flexible scheduling options
- Health insurance coverage
- Paid time off
Location:
- Lansing, MI 48933: Candidates should be able to reliably commute or plan to relocate before commencing work.
Work Arrangement
- Hybrid remote work options available.
Employment Type: Full-Time