(Geschlossen)Knowledge Builders, Inc.
HBITS-06-14010-Database Architect-Expert
- +4
- +4
- Albany, New York
- +4
- +4
- Albany, New York
Über
Expert Data Modeler working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.
Day-to-Day tasks:
• Interact with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and IT teams to determine and design application and system requirements.
• Design data infrastructure to extract and organize data for authorized individuals to access.
• Identify internal and external data sources, collaborating with business subject matter experts to determine their data storage and organizational needs and use the information to create and maintain data infrastructure.
• Participate in the entire Secure Software Development Life Cycle (SSDLC) including debugging and configuring solution.
• Identify, recommend and implement ODI/ELT and ETL process and architecture improvements.
• Design BigQuery DWH for Data Analytics
• Assist and verify design of solution and production of all design phase deliverables.
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture.
• Resolve difficult design and develop issues.
• Identify bugs when developers are not able to do so.
• Identify installation solutions for new databases
• Determine the requirements for new databases
• Design data model to support Self Service Reporting requirements
• Publish and/or present design reports
• Identifying areas for improvement in current systems
• Coordinate with business, vendor and IT team members to reach project milestones and deadlines
• Audit database regularly to maintain quality
• Create systems to keep data secure
• Design and document all components of approved application solutions including system integrations.
• Write clean, testable code using advanced analytical functions.
• Test and debug including but not limited to perform system testing and development of testing plans.
• Review and refactor code including but not limited to performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs.
• Deploy fully functional applications.
• Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment.
Mandatory Qualifications:
- Database Architect: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
- Expert: 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Requested Qualifications:
- 84 months experience working with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and ITS teams to determine and design data warehouse, application and system requirements.
- 84 months experience architecting, designing, documenting, and implementing data warehousing, enterprise application integration, and master data management.
- 84 months experience data modeling and designing normalized Data Warehouse environments for enterprise level applications; and, implementing those designs using Oracle Data Integrator (ODI) and Extract, Transform, Load technologies.
- 84 months experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language).
- 72 months experience performing database comparative analysis for designing new transactional databases and data warehouses, as well as improvements in existing transactional databases and data warehouses.
- 60 months experience in computation and presentation of data to solve business problems.
- 48 months experience implementing systematic Data Error/Recovery and Cleanup procedures.
- 48 months experience working in building DataLake, Data Mart, Data Model using ERWIN or any other tool for Self Service BI Reports.
Wünschenswerte Fähigkeiten
- SQL
- Data Modeling
- Data Warehousing
- Business Intelligence
Berufserfahrung
- Data Engineer
- Data Infrastructure
- Database Administrator
- Database Developer
Sprachkenntnisse
- English