Database Architect

Company: Prolim Infosystems Pvt Ltd.
Location: Lansing
Posted on: December 4, 2019

Job Description:

Overview PROLIM (**************) is currently seeking Database Architect for Location Lansing, MI for one of the top Client. Overview: The Client is beginning its modernization efforts to replace its primary business application, OBase. This effort will require analysis of both the content and structure of the underlying Oracle database containing 600+ tables, modeling and design of a new Oracle or MS SQL Server database, and migration of existing data to the new database. Job Description: Support the modernization effort from a data perspective by working closely with both business and technical teams Perform current state data model assessments/target data models and gap analysis Analyze legacy database, including both data content and structure to derive necessary information Define and analyze data requirements needed to support business processes Counsel with Subject Matter Experts on specific topics in order to accurately capture existing business rules/principles Establish data modeling naming standards, abbreviations, guidelines and best practices Develop and maintain conceptual, physical and logical data models Drive the data model review process and solicit user's feedback Propose new database architecture, support data migration from an existing Legacy system to a new structure Years of Experience: 12 or more years of experience in the Information Technology field. Required Skills: Experience supporting a business from the data perspective with a strong business understanding Experience building and validating data models Experience using data modeling tools Expert understanding of relational databases and proficiency in writing queries (SQL and PL/SQL) Expert understanding of database design tradeoffs, impacts on user expectations and performance levels Experience in defining and enforcing data standards, procedures, and guidelines to ensure data integrity, dependability, quality and usability Experience developing and publishing data architecture standards/guidelines governing data services, data security and privacy, and data integration Strong knowledge of data governance standards Ability to develop data migration strategies for moving, duplicating, retiring data from legacy systems to new applications Proven ability to establish a high level of trust and confidence in both the business and IT communities Strong teamwork and interpersonal skills at all levels Proven influencing skills, strong collaboration, and mentoring capabilities Ability to communicate effectively to all levels of the organization in a proactive, contextually appropriate manner Strong organizational skills Proven track record of achieving results in challenging environments Experience in Agile/Scrum development environment Skill Matrix Extensive experience in the Information Technology field as a developer, application architect, or database architect. Effective communication and collaboration skills working with business and technology partners Experience with relational databases including Oracle and Microsoft SQL Server Experience in data analysis, modeling, and database design Experience in data modeling; including conceptual, logical and physical Proffered : Hands-on experience with data modelling tools Experience with Agile/Scrum development environments Apply online for immediate consideration, please send your updated resume and contact info via email ************************ About PROLIM Corporation: PROLIM is a leading provider of end-to-end IT, PLM and Engineering Services and Solutions for Global 1000 companies. Prolim understand business as much as technology, and help our customers improve their profitability and efficiency by providing high value technology consulting, staffing, and project management outsourcing services. PROLIM's IT and PLM consulting offerings include; Advisory, PLM Software/Services, Program Management, Solution Architecture Training/Staffing, Cloud Solutions, Servers/Networking, Infrastructure, ERP Practices and QA Services. Engineering services include Data Translation, CAD/CAM/CAE, Process & Product Engineering, Prototyping, and Testing/Validation within a wide range of markets and industries.

Keywords: Prolim Infosystems Pvt Ltd., Lansing , Database Architect, IT / Software / Systems , Lansing, Michigan