Database Administrator / Engineer

This position is open for only local to Utah - W2 Only

Mode of work : Hybrid

Location : West Jordan, Utah

The State of Utah Department of Government Operations, Division of Technology Services (DTS) seeks an experienced Engineer to support the Board of Pardons & Parole and the Utah Department of Corrections.DTS is looking for an experienced Engineer working on SQL databases hosted on Windows and Linux servers with a strong focus on database migration, re-platforming, and adoption of cloud computing services.

The ideal candidate will lead our transition from Informix to a more modern, mainstream database management system; PostgreSQL hosted on AWS cloud services to enhance our data processing capabilities and support future scalability and performance needs.

The chosen candidate will also provide interim database maintenance, support, and administration supporting various applications while cross-training in-house support staff to assume those duties and responsibilities long term.

This role is crucial for ensuring that the State of Utah remains competitive and capable of meeting the demands of our customers with efficient, reliable, and scalable database solutions.

Primary Duties & Responsibilities

• Develop and implement a comprehensive database migration strategy from Informix to a more modernized and scalable database system.
• Conduct thorough assessments of current database structures, data volumes, and system integrations.
• Design and manage database schemas ensuring they meet functional requirements and performance goals.
• Leadthe migration process, including data cleansing, migration scripting, data validation, and post-migration testing.
• Collaborate with IT teams to ensure smooth integration with other enterprise applications.
• Monitor system performance post-migration and optimize as needed to meet performance targets and provide ongoing maintenance, support, database integrity, troubleshooting, performance assessments, and enhancements in database services.
• Develop and enforce best practices for database management, security measures, and disaster recovery plans.
• Document all processes related to database migration and routine maintenance as well as documentation of existing database systems.
• Leaddatabase designs and development for applications based on user requirements and specifications provided by Business or Technical Leads.
• Build, migrate, and maintain databases for on-premise and cloud services systems.
• Assist the Technical Project Leads in addressing technical issues.
• Submit all test and production turnovers to Project Technical Lead to be installed.
• Provide data modeling support to development projects, as needed.
• Assist application developers with complex query development and tuning.
• Create database tables, indexes, constraints, stored procedures, and other database components and functions.
• Prepare, deliver, install, and upgrade software databases into development, quality assurance, and production environments.
• Design, implement, and enforce strong security structures and mechanisms for databases.
• Create and update data schematics and dictionary structures to document and describe system databases, interfaces, and security.
• Design, create, install, and manage automated databases, data reports and chronological report runs.
• Perform data validation to test the integrity of data, database relationships, calculations, references, and data reports.
• Participate in the development of system database standards and development processes.
• Interact with and support project leaders and teams, business analysts, and users in analysis, design, and testing processes on projects.
• Coordinate with System Administrators on database installations, upgrades, releases, problem solutions, and technical architecture changes.
• Accommodate work that needs to be performed both during and after business hours.
• Other tasks as assigned.

Typical Qualifications