Lansing, MI, USA
14 hours ago
Infrastructure Solutions Architect
Job Seekers, Please send resumes to resumes@hireitpeople.com

Position Summary:

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 leadership to the application development team Develop software design documents and work with stakeholders for review and approval. 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 preparing technology roadmap for supported applications 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.

Skill Descriptions:

12+ years designing and review of logical and physical data model in SQL and/or PL/SQL 10+ years of hands-on relational, dimensional, and/or analytic experience 10+ years of experience in writing SQL packages/functions/Triggers andand Mass data updates and deletes. 8 + year of experience in query optimization and performance tuning. 5+years of experience in data conversion between multiple systems and experience in data transformation strategies.

Experience required: 12-15 Years

Confirm your E-mail: Send Email