Data Engineer
Posted on :
23-08-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Position: Senior Data Engineer
Client: State of Utah
Department: UDC
Location: 8523 S Redwood Rd West Jordan Utah 84088
Position ID: 133609
Projected Duration: 1 year from projected start date (with possible extension)
Tentative interview dates: August 22nd and 23rd
Remote or onsite: Hybrid 80% in the office and then moving to 60% in office and 40% remote after the first 30 to 60 days.
DRUG TESTING REQUIRED
Local or nonlocal: Local
Scoring:
Technical Expertise 40%
Past Experience 40%
Cost 20%
Job Description:
Sr. Database Engineer Are you a Database Engineer looking for a great career doing important work that makes an impact 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 replatforming 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 crosstraining inhouse 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.
Lead the migration process including data cleansing migration scripting data validation and postmigration testing.
Collaborate with IT teams to ensure smooth integration with other enterprise applications.
Monitor system performance postmigration 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.
Lead database designs and development for applications based on user requirements and specifications provided by Business or Technical Leads.
Build migrate and maintain databases for onpremise 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
Proven experience as a Database Administrator with specific experience in data migration projects.
Extensive knowledge of database design documentation and coding.
Knowledge of the development and management of computer system databases and data warehouses.
Knowledge and/or experience with mainstream SQL databases.
Strong analytical research and organizational skills with impeccable attention to detail.
Understanding and experience with cloud services.
System administration skills are desired.
Knowledge of CI/CD Pipelines.
Good understanding of database version control.
Ability to test and troubleshoot software using appropriate methodologies and techniques.
Excellent written/verbal communication interpersonal and organizational skills required.
Understand the principles theories and practices of computer science.
Deal with people in a manner that shows sensitivity tact and professionalism
automated databases,data,database administration,software testing,database,database version control,maintenance,system administration,ci/cd pipelines,written/verbal communication,system performance monitoring,database maintenance,postgresql,security structures,interpersonal skills,data modeling,database management best practices,it teams collaboration,computer science principles,database migration,sql databases,cloud computing services
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
