Database Architect

Job Title: Database Architect Client Company: FEi Systems CMS Zip Code: 21046 City: Columbia State: MD

W2 Only During COVID it’s REMOTE

Required Skills: At the architecture level has

SQL Server ETL SSIS, SSRS, SSAS OLAP and OLTP

Database Architect

Job Description: The Database Architect will be responsible for evaluating the current data structure, and architecture for the Long Term Services & Supports (LTSS) system, provide Technical Director a strategy for a to-be data landscape in compliance with database architecture standards and best practices, and will assist BI Lead to implement LTSS state of art BI and report solution implementation. On a regular basis the Database Architect will provide guidance to fellow team members on capturing and fine-tuning low performing areas of existing databases. Report solution implementations include generating datawarehouse design and structuring a high performing ETL process with little to no user-end experience interruptions.

Role and Responsibilities

• Determines database structural requirements by analyzing client operations, applications, and programming; reviewing client objectives; evaluating current systems; • Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, back-up, and recovery specifications. • Provide archiving structure and strategies on an as-needed basis. • Collaborate with analysts, developers and architects to capture meaningful data definitions, build data models, and document results throughout the project life cycles • Responsible for existing database architecture and future database implementations • Responsible for target data design including the OLTP design and OLAP design, source to target mappings, data migration, and metadata modeling • Functions as a liaison with clients and operations. • Analyzes clients' existing systems and business models • Understands software development lifecycle • Translates client requirements into highly specified project briefs • Identifies options for potential solutions and assesses them for both technical and business suitability

Qualifications

• Bachelor's Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience. • 8-10 years of directly related computer systems analysis and/or programming experience. • 5+ years' hands-on technical experience as Database Architect. • Experience constructing complex ETL processes from scratch. • Strong experience with ETL tools such as SSIS. • Datawarehouse design, implementation, and life cycle maintenance. • Strong SQL Server skills with versions including SQL Server 2017+ • Strong Conceptual, Logical and Physical data modeling skills • Strong Rational, Dimensional and Object modeling experience and skills • Strong SQL and Data Analysis skills. • Strong Metadata management. Strong understanding of Extract-Transform-Load (ETL) processes and complexities. • Strong experience with multiple database formats (e.g., SQL Server, PostgreSQL). • Strong understanding of database security principles • Strong understanding of Software Development Lifecycles (process, methodologies and best practices) with a strong analytical/technical background within a multi-tier system. • Experience in Healthcare industry business practices and data. • Strong customer and business focus with presentation skills.

Thanks & Regards,

Mohan Kumar B | Technical Recruiter | Wave Solutions Inc. | 1444 N. Farnsworth Ave, Suite 302, Aurora, IL - 60505 | Email: kumar@wavsols.com Direct #: 630-566-9398| Fax: 630-566-9398 Main #:6305669398, EXT: 108 Website: www.wavsols.com LinkedIn: https://www.linkedin.com/in/mohan-kumar-bangaru-b424467b/