IT Data Warehouse Tech Specialist - Hybrid

Title: IT Data Warehouse Tech Specialist - Hybrid

Mandatory skills:

Database platforms, tools, Oracle, SQL Server, DB2,
cloud platforms, OCI, AWS, Azure, cloud-native monitoring, backup, recovery,
cloud databases, Oracle Data Integrator, DMS, Azure Data Factory,
cloud migration projects, planning, execution, optimization, data pipelines,
Sun Solaris, UNIX,
Linux OS,
IBM Mainframe, MS Access,
mainframe-based data, modern relational databases, database systems,
writing, debugging, optimizing Unix Shell scripts, SAS DI Integration,
C, C++, SQL query writing, Stored Procedures, FTP, Encryption, Decryption tools,
ETL, structured system development methodologies, data transfer, interface methodologies,
TCP/IP, Network, Firewall, VM Architecture, SSL Certificate Tools, Active Directory,
systems development tools, systems development techniques,
customer service, integrated, automated systems

Description:

The 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 co-workers. 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.

Required / Desired 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 cloud-native monitoring, backup, and recovery - Required - 5 Years
Experience in integrating on-prem 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 mainframe-based 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 Unix-based 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

VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.

Contact Details :

VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008