Database Architect

 Database Architect 

Description:
* 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 solutions.
* Identify, recommend and implement ODI/ELT and ETL process and architecture improvements.
* 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
* 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.