Previous Job
Previous
IT Data Warehouse Tech Specialist
Ref No.: 18-23565
Location: Raleigh, North Carolina
Job Title: IT Data Warehouse Tech Specialist
Duration: 03 Months
Location: Raleigh, NC


Job 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 distributed operating systems is preferred. Requires experience with modification or development of complex inter-related applications/solutions. Solutions link technical knowledge with business, research and/or instructional solutions and may range from consulting services (software or hardware recommendations) to developing 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 Sybase and SQL Server databases. Experienced in supporting applications based on various platforms and technologies such as IBM Mainframe, Windows Server, Sun Solaris (UNIX), JAVA, Database platforms and tools (SQL Server, Oracle, Sybase ASIQ, Sybase ASE, DB2, MS Access, Cache Database), SAS Coding, SAS DI Integration, SAP Business Objects 4.0 or 4.1, SAP Business Objects Web Intelligence, Unix shell script, Visual Basic, C/C++, SQL query writing, Stored Procedures, DB Visualizer, FTP, WSFTP, Encryption/Decryption tools, IIS, Apache HTTPD, Apache Tomcat, TCP/IP, Network, Firewall, VM Architecture, SSL Certificate Tools, Active Directory, Eclipse, Bourne Shell, VPN Solaris, VI Editor, Curl, X Windows, ASP Classic, Word, Excel, Excel VBA, 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.
 
Skill Required / Desired Amount of Experience
Experience with maintenance, modification or development of complex inter-related applications/solutions. Required 10 Years
Experience with supporting applications based on various platforms and technologies such as IBM Mainframe. Required 10 Years
Experience with supporting applications based on various platforms and technologies such as Windows Server Required 10 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 various platforms and technologies such as JAVA Required 10 Years
Extensive experience with Database platforms and tools (SQL Server, Oracle, Sybase ASIQ, Sybase ASE, DB2, MS Access, Cache Database) Required 10 Years
Experience in SAP Business Objects 4.0-4.1, SAP Business Objects Web Intelligence (installation, migration, upgrade, support), Unix Shell script Required 10 Years
Experience with Visual Basic, C/C++, SQL query writing, Stored Procedures, DB Visualizer, FTP, WSFTP, Encryption/Decryption tools Required 10 Years
Experience with IIS, Apache HTTPD, Apache Tomcat, TCP/IP, Network, Firewall, VM Architecture, SSL Certificate Tools, Active Directory Required 10 Years
Extensive experience with ETL, structured system development methodologies, data transfer and interface methodologies Required 10 Years
Experience with SAS Coding and SAS DI Integration to support ETL developers Required 06 Years
Able to work without assistance and able to manage high complexity work efforts. Required 10 Years
State Government architecture experience Required 10 Years