SQL Developer with SSIS

Hireteq Solutions Inc.; Irving (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

A database solutions company in Texas is seeking a Database Developer with strong experience in AWS Data Lakes and SQL Server. The role requires at least 7-10 years of experience in database development, focusing on data conversion, integration, and synchronization. The ideal candidate will have skills in SQL programming, CDC, and be highly proficient with SQL Server products. This position may require relocation or commuting to Irving, TX.

Qualifications

• Minimum of 7-10 years of experience in database development, data conversion, integration, and synchronization.
• Solid experience with AWS Data Lakes and SQL Server products.
• Familiarity with Oracle for additional advantage.

Responsibilities

• Develops and maintains database applications focusing on data conversion and integration.
• Creates scripts for data maintenance or bug fixes.
• Collaborates with departments and vendors on technical issues.
• Responsible for administrative maintenance of relational database systems.

Skills

AWS Data Lakes

SQL Integration

Stored Procedures

T-SQL

CDC

Data Analysis

SSIS

Power BI

Education

High School Diploma or GED equivalency

Tools

SQL Server

Oracle

Job description

Location: Irving, TX - Need candidates who can relocate or commute to Irving (Dallas area)

Duration: 4 months with possible extension

Note: AWS Data Lake experience is must

Job Summary

Develops and maintains database applications. Focuses on data conversion and data integration supporting back-end processes, including developing, maintaining, and troubleshooting CDC, inter-environment, and inter-vendor RDBMS synchronization, SSIS, and data analysis. Creates scripts for data maintenance or bug fixes. Reviews, analyzes, and documents data and workflow processes. Creates and builds processes for creating mock data matching application required structures for repeatable test environments. Collaborates and communicates with other departments and outside vendors on technical issues. Assists with administrative maintenance of relational databases, including backup/recovery, schedule jobs, problem diagnosis and performance tuning. Implements data models and database designs. Assists in the resolution of database capacity issues, replication, and other distributed data issues.

Must have

Solid exp on AWS Data Lakes, SQL Integration, Reporting SQL Service - Store Procedures, SQL Programming, CDC

Minimum Qualifications

Education Level: High School Diploma or GED equivalency

Experience: Minimum of 7-10 years of experience in database development, including data conversion, integration, and synchronization.

Oracle and MSSQL replication, Database Table Management, Stored Procedures, Documentation, Database Administration, Tuning, Research, Data Analysis, and Application Troubleshooting. T-SQL, Power BI, CDC, SSIS, SSRS, SQL 2008/2012/2014/2016 and above, Attunity, Oracle 10g.

Please note that we need someone with extensive experience in Microsoft SQL SERVER and its products.

Require AWS Data Lakes experience and Oracle experience is good to have.

Essential Functions

Management reserves the right to add, modify, change, or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the essential functions of the job.

• Creates scripts and packages for data integration, synchronization, data maintenance, CDC, or bug fixes.
• Develops and maintains efficient, accurate, and secure database applications.
• Analyzes, defines, and documents system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.
• Provides technical consulting and responds to error reports, application performance issues, problems, or questions. Solves complex problems and takes a broad perspective to identify solutions. Leads projects and provides guidance to functional teams as needed.
• Responsible for administrative maintenance of relational database systems. Applies understanding of relational database concepts and query languages to design required summary or aggregation tables to support analysis.
• Writes and maintains functional and technical specifications. Interprets internal or external issues and recommends solutions/best practices.
• Performs other job-related duties as assigned.