Database Architect
Vacancy expired!
Position: Database Architect 3 (118473)Location: Jefferson City, MissouriType: ContractContract Period: 12+ monthsLocation/Interview: Onsite or hybrid preferred but will consider non-local candidates if highly qualified.Remote/WebEx interviews will be scheduled.Duration of the Contract: 12 months, with potential to extend. Job Description:Seeking a Database Architect who is expert in knowing ETL and SSIS package/job development, maintenance, and architecture for jobs/tasks communicating and working across multiple databases and environments, to re-architect and re-write some critical ETL processes that pull data from source applications, and feed all supporting applications and mandatory reporting needs - driven by federal requirements, state statutes, and departmental and organizational policies, understanding what database design issues exists, and how those can be corrected to best create modern, stable, reliable, and consistent data, data flows, and data processes, create documentation, diagrams, and data/process flows that explain the ETLs, review existing ETLs to identify concerns and mitigate risks in new ETLs/SSIS packages, collaborative and open to feedback and understanding of business needs. Requirements
- SQL Server 2019 (or greater) ETL/SSIS expert developer
- ETL flow documentation and flow-charting
- Architected transactional, yet multi-threaded/user, ETL solutions/jobs and flows of jobs
- Experience with moving SSIS packages out of the "msdb" and into the "SSISDB"
- Experience with SQL Server version upgrades