drjobs DHHS IT Data Warehouse Tech Specialist

DHHS IT Data Warehouse Tech Specialist

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Raleigh, NC - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

NC DHHS requires the services of an experienced Data Warehouse Technical Specialist to support a Departmental Data Warehouse.

The NC DHHS 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.



Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExtensive experience with Database platforms and tools (Oracle SQL Server DB2)Required10YearsExperience in deploying and managing databases on cloud platforms (OCI AWS or Azure) including cloudnative monitoring backup and recoveryRequired5YearsExperience in integrating onprem and cloud databases using tools such as Oracle Data Integrator AWS DMS or Azure Data FactoryRequired5YearsExperience with data cloud migration projects including expertise in planning execution and optimization of data pipelines and storage in cloudRequired5YearsExperience with supporting applications based on various platforms and technologies such as Sun Solaris (UNIX)Required10YearsExperience with supporting applications based on Linux OS Required10YearsExperience with supporting applications based on various platforms and technologies such as IBM MainframeRequired5YearsExperience in migrating mainframebased data to modern relational databases such as Oracle or SQL ServerRequired5YearsExperience in writing debugging and optimizing Unix Shell scripts to automate tasks and manage processes within Unixbased environmentRequired10YearsExperience with C/C SQL query writing Stored Procedures FTP Encryption/Decryption toolsRequired10YearsExtensive experience with ETL structured system development methodologies data transfer and interface methodologies Required10YearsExperience with TCP/IP Network Firewall VM Architecture SSL Certificate Tools Active DirectoryRequired5YearsAble to work without assistance and able to manage high complexity work efforts.Required10Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirementQuestion2Please list candidates email address HERE that will be used when submitting ERTR.Question3Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.Question4Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirementQuestion5Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirementQuestion6Candidates submitted above the rate of $$$ may not be considered. Do you accept this requirementQuestion7Hybrid schedule will be remote with occasional onsite.

Employment Type

Full Time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.