Job Description :
This position has responsibility for a Department of Treasury database consolidation project. The project involves merging various databases and data sources into one usable database. This requires the knowledge of Microsoft Access, Microsoft SQL Server, Teradata and Oracle databases. The position is expected to analyze the various data sources and provide a single database solution. In addition, this position works with developers and others to support their ability to use the data to further the interests of the agency. This includes data cleanup, conversions, analyzing data from various sources, running scripts, and providing expertise in Structure Query Language (SQL), and extensible markup language (XML
Skill Required / Desired yrs of Exp
Expertise in creating, implementing and maintaining databases (Microsoft Access, Microsoft SQL Server, Teradata, Oracle) Required 5 yrs
Experience with requirements gathering, working with technical and non-technical staff. Required 5 yrs
Experience with product/platform migration Required 5 yrs
Looking for someone with experience with the entire process from setup, implementation, troubleshooting, and regular maintenance. Required 5 yrs
Windows server management experience Required 5 yrs
Income tax knowledge preferred, not required Desired
Holistic server management experience Required
Data cleanup, conversions, analyzing data from various sources, running scripts, and providing expertise in Structure Query Language (SQL), and extens Required 5 yrs
Automating manual processes - From Access to Oracle, Teradata, MySQL Required 5 yrs
Experience working with Cisco Tidal Enterprise Scheduler preferred Nice to have 2 yrs