Job Responsibilities:
Define data conversion, data quality, and data cleansing criteria for COTS vendors
Work with vendors to integrate COTS based solutions within DPH
Design, build, upgrade and patch highly available database solutions for mission critical applications
Perform database tuning as needed to optimize application performance
Troubleshoot database related outages as part of a larger team supporting other layers of the technology environment
Proven experience converting data from one database platform to another such as Oracle to MS SQL Server
Proven experience building and managing high scalable database solutions on cloud platforms
Guide the design, development, deployment and management highly reliable and scalable databases
Enforce company policies in areas of database design, security, change management, compliance documentation and separation of duties
Job Qualifications:
15+ years' experience building, maintaining, securing and backing up databases across multiple platforms such as Oracle and MS SQL Server.
3+ years' experience working with configuring database solutions in a cloud environment such as Microsoft Azure or AWS
15+ years' experience working with data cleansing, data conversions, data migrations
15+ years providing enterprise application and database operational support
10+ years application development experience with languages such as: Java, .NET, Json, Java Script, C#, etc.
10+ years building, integrating, or implementing COTS enterprise level database solutions for State Government agencies
5+ years implementing infrastructure architecture that supports enterprise applications
3+ years experience designing and implementing high availability systems
Required Skills:
Thinks strategically, understands the big picture but is also able to execute on tactical operational situations working with disparate databases
Solves complex problems and drives action across the organization
Clearly articulate integration issues with vendors working on COTS and/or custom applications with the ability to drive results and develop solutions
working with Server Engineers, preparing specifications for the database servers, monitoring and tuning the application databases, and establishing communication links across Database Management Systems
directs and controls activities relating to database management, planning, development, and security
Ability to work with multiple database products such as Oracle, MS SQL server, MySQL, Amazon RDS, Postgres etc.
Experience working with TOAD, Visual Studio, WebLogic, JBOSS, SQL, PL/SQL, .NET, C#, Java, XML, and SQL Developer
Education Required:
Bachelor Degree from an accredited University in computer science, or related field
Bachelor Degree