THIS IS A REPOST. PREVIOUS APPLICANT DO NOT NEED TO REAPPLY TO BE CONSIDERED FOR THIS POSITION.
The Database Administrator will function as a Database Administrator, Web Developer, and Programmer for the MIS Department at Caswell Developmental Center.Job responsibilities include the following:
* The position will develop custom n-tier applications systems using programming languages such as ASP.NET, VB.NET, C#.NET, HTML5, AJAX, JavaScript, JQuery, and/or PHP, where applicable. These applications may be WAN or LAN-based and will require the understanding and use of relational databases. Methods of data retrieval will include the use of HL7, ODBC and other similar protocols.
* Strong knowledge in database theory and design, SQL syntax, views, stored procedures, and user-defined functions.
* Triggers and SQL Server Agent jobs maintenance is required.
* The employee will design and administer databases including triggers and stored procedures. These applications must be secure and provide encryption of patient data, role-based access, as well as audit logging. Reports and queries will be developed to generate information from data residing on local databases and WAN databases using tools such as SSIS and SSRS. Some applications will require import or conversion of legacy and/or current data from existing disparate systems.
* Database applications will be maintained by this employee including the systematic analysis of data integrity.
* This employee will also meet with subject matter experts to develop requirements for new or upgraded applications.
Work Location: MIS Department
Work Hours: Monday-Friday
About the Department of Health and Human Services / Caswell Developmental Center:
The NC Department of Health and Human Services (DHHS) is one of the largest, most complex agencies in the state, with approximately 18,000 employees. In collaboration with its partners, it is responsible for ensuring the health, safety and well-being of all North Carolinians.
Caswell Developmental Center, serving as North Carolina's Eastern Region resource center, provides specialized residential, programmatic, and support services for individuals with developmental disabilities. The individuals we serve are at the heart of our facility. Our team is critical to the mission of the facility. We strive to create an environment in which every team member contributes to the overall success of the Center to positively impact the lives of those around them and the individuals we service. If you are looking to make a difference and seeking a rewarding career, we encourage you to consider this opportunity. Please click on the following link https://vimeo.com/185000006 to experience how Caring is Contagious at Caswell Developmental Center.
To receive credit for all your work history and credentials, you must list the information on the application form. Any information listed under the text resume section or on an attachment will not be considered for qualifying credit. Qualified candidates must document on the application that they clearly possess all the following:'
The following competencies must be documented in your job duties on your application and demonstrated in your employment history on your application. Generic job duties will not be considered. Job duties should include the knowledge, skills and abilities listed below (if applicable). "See resume" is not acceptable.
* Demonstrated ability to develop in Microsoft .NET using Visual Studio.
* Demonstrated ability to develop SQL Server database objects.
* Demonstrated experience with HL7 messaging engines and interfaces.
* Demonstrated web development experiences using HTML5/Responsive Design, JavaScript, JQuery, ASP.NET, VB.NET.
* Demonstrated ability to comprehend, analyze and interpret organizational and procedural problems.
* Demonstrated experience ensuring privacy and security of patient data.
* Demonstrated experience with problem identification and integration of technical skills to address and solve issues.
* Demonstrated experience reading third party software technical documentation and applying that documentation to effectively configure and design add-on solutions to third party software.
* Demonstrated experience itemizing and organizing tasks in a logical manner, tracking progress, and reporting problems and progress to management as requeste
Management Preferences:
Minimum of 5 years' experience programming in .NET (VB, C#), relational database (SQL Server, PostgreSQL), and web development (HTML5, JavaScript, JQuery).
Some state job postings say you can qualify by an equivalent combination of education and experience. If that language appears below, then you may qualify through EITHER years of education OR a combination of both. See oshr.nc.gov/experience-guide for details.
Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or
Associate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or
High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or
an equivalent combination of education and experience.
Degrees must be from an appropriately accredited college or university.
The North Carolina Department of Health and Human Services is an Equal Opportunity Employer. Positions in the Division of State Operated Healthcare Facilities shall be subject to pre-employment drug testing and criminal record background checks. Also, the use of tobacco products of any kind including vapor products are prohibited from our campuses. All employees are required to adhere to the facility's Vaccination Policy.
The DHHS Division of Human Resources (DHR) follows the State Human Resources Employment of Relatives Policy. Applicants who have relatives or people living in the same household, will not be considered for job vacancies in the DHR at those locations. For a complete definition of immediate family member, please see the State Human Resources Workforce Planning, Recruitment and Selection Policy, Section 2, Page 38.
Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account. You will either receive a call to schedule an interview or an email notifying you when the job has been filled.
For technical issues with your applications, please call the NEOGOV Help Line at 855-524-5627. Applicants will be communicated with, via email only, for updates on the status of their application. If there are any questions about this posting other than your application status, please contact HR at (252) 208-4293.
Compensation & Benefits:
The State of North Carolina offers excellent comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high-quality, low-cost benefits on a pre-tax basis). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees. Visit website for State Benefits