IT Data Warehouse Tech Specialist HYBRID
IT Data Warehouse Tech Specialist HYBRID
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Title: IT Data Warehouse Tech Specialist (HYBRID)
Location: Raleigh NC
Duration: 12 Months
Job Description:
The client IT Enterprise Level Data Warehouse Technical Specialist will provide advanced architect (lead technical expert) support and requires experience in systems development tools and techniques. This position requires excellent communication analytical and organization skills and the ability to translate business and technical ideas and issues into clear and concise language; excellent customer service skills; can contribute and work within a team environment; and can communicate effectively and professionally in verbal and written form with management and coworkers. Advanced knowledge of cloud (OCI AWS. Or Azure) database systems is required along with experience in modifying or developing complex interrelated applications and solutions. The role involves linking technical expertise with business research or instructional needs ranging from consulting services (software or hardware recommendations) to the development of integrated automated systems. Duties include client needs assessment as well as evaluating hardware availability and software requirements.
- This position will be responsible for various activities related to the design implementation and maintenance of complex Oracle and SQL Server databases.
- Experienced in supporting applications based on various platforms and technologies such as IBM Mainframe Sun Solaris (UNIX) Database platforms and tools (Oracle SQL Server DB2 MS Access) SAS DI Integration Unix shell script C/C SQL query writing Stored Procedures FTP Encryption/Decryption tools IIS Apache HTTPD Apache Tomcat TCP/IP Network Firewall VM Architecture SSL Certificate Tools Active Directory VPN Solaris VI Editor Curl X Windows Word Excel IE and Firefox.
- Experience with ETL structured system development methodologies data transfer and interface methodologies between mainframes and servers and distributed server environments in a statewide environment.
Skills:
Skill
Required/Desired
Amount
of Experience
Extensive experience with Database platforms and tools (Oracle SQL Server DB2)
Required
10
Years
Experience in deploying and managing databases on cloud platforms (OCI AWS or Azure) including cloudnative monitoring backup and recovery
Required
5
Years
Experience in integrating onprem and cloud databases using tools such as Oracle Data Integrator AWS DMS or Azure Data Factory
Required
5
Years
Experience with data cloud migration projects including expertise in planning execution and optimization of data pipelines and storage in cloud
Required
5
Years
Experience with supporting applications based on various platforms and technologies such as Sun Solaris (UNIX)
Required
10
Years
Experience with supporting applications based on Linux OS
Required
10
Years
Experience with supporting applications based on various platforms and technologies such as IBM Mainframe
Required
5
Years
Experience in migrating mainframebased data to modern relational databases such as Oracle or SQL Server
Required
5
Years
Experience in writing debugging and optimizing Unix Shell scripts to automate tasks and manage processes within Unixbased environment
Required
10
Years
Experience with C/C SQL query writing Stored Procedures FTP Encryption/Decryption tools
Required
10
Years
Extensive experience with ETL structured system development methodologies data transfer and interface methodologies
Required
10
Years
Experience with TCP/IP Network Firewall VM Architecture SSL Certificate Tools Active Directory
Required
5
Years
Able to work without assistance and able to manage high complexity work efforts.
Required
10
Years
Employment Type
Full Time
