DIRECT client req
Title: Data Architect/Modeller
Location: Annapolis, MD
Duration: 6 months+ possibility to hire
The Database Architect and Data Modeler will also design and architect database solutions for housing and protecting data as well as data warehouse solution and business intelligence reporting capabilities. The Database Architect and Data Modeler maintains and evolves core Platform databases by determining structural requirements, creating and maintaining documentation, developing and implementing holistic database solutions, acting as SME on platform architecture to advise derivative projects on normalized/optimized extensions. This role is the overall Database and Data Architect and Modeler for a long-term programs supporting platform development and associated applications. As a Database Architect and Modeler Provide Solution Development and Integration for agile teams, including requirements backlog management, DevOPS, database design, database tuning for software development, testing, ETL data migration, and support during release deployment. Assist with the client's data management strategies and management processes. Conceptual, logical, and physical data modeling for relational databases and advise on future tech-stack roadmap at enterprise level. Perform project tasks independently, and may direct the efforts of others. Participate in or lead the development of client deliverable content. Anticipate client needs and formulate solutions to client issues. Review deliverables for accuracy and quality. Qualifications require experience with designing, implementing, and tuning relational databases (e.g., Oracle, SQL Server, PostgreSQL) Experience with NoSQL databases (e.g., Cassandra, MongoDB). Preferred Agile experience. Experience designing and tuning data warehouses Cloud computing (AWS, Azure) Experience collaborating with clients to translate business needs.
Determines database structural requirements by analyzing operations, applications, and programming; reviewing objectives; evaluating current systems; augmentation based on client requirements. Maintains core system optimization and normalization
Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications, replication, fault-tolerance, etc.
Installs database systems; develops flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
Prepares users by conducting training.
Provides database support by coding utilities, responding to user questions, and resolving problems.
Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
Accomplishes information systems and organization mission by completing related results as needed.
Leads, coordinates and manages artifacts pertaining to Data Modeling, ER Diagrams and documentation, standards definitions and enforcement, ETL and Database loading
Development and design of database stored procedures and triggers, etc
Expertise and certification with Oracle, SQL Server, PostGreSQL, NoSQL and other databases
Cloud computing and Big Data and data streaming solutions such as Hadoop and others
10+ years of experience with Oracle database driven solutions with progressive experience from DBA/Developer to Architect
5+ years of Oracle Database Architecture experience including data structures, data dictionary, database schemas ; Strong PL/SQL and ETL skills
5+ years of data architecture and data modeling tools and techniques including conceptual, logical and physical data models & schemas. Experience with ER Diagrams & Entity-Relationship Model (ERM), Semantic data modeling and/or Bachman Diagrams
Experience with industry standard data modeling tools such as ERwin, Sparx, PowerDesigner or Embarcadero
Experience with Oracle 12c and other databases required
Thanks & Regards
Team Lead - Talent Acquisition
AN INC 500|5000 COMPANY
31313, Northwestern Hwy, Suite 219, Farmington Hills, MI - 48334
Direct: 248-537-9036 | Off: 248-865-0300 x 101 | Fax: 248-865-0058