Sr. Data Engineer - ConsultNet

Sr. Data Engineer
Salt Lake City, UT
Long-term Contract: $70-$100 per hour

Our client is in search of a to join their team on a long-term contract. Our client 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.

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 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.
• 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 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.

• 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.

Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.