What are the responsibilities and job description for the Sr. Data Engineer position at ConsultNet, LLC?
Job Details
Sr. Data Engineer
Salt Lake City, UT
Long-term Contract: $75-$100 per hour
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.
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 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.
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.
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 .
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.
Salt Lake City, UT
Long-term Contract: $75-$100 per hour
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.
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 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.
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.
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 .
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $75 - $100
