Salary: $84,353.00 - $126,529.00 Annually Location : Lenoir County, NC Job Type: Permanent Full-Time Job Number: 24-15113 Department: Dept of Health and Human Services Division: SEC OFFICE - INFO TECH Opening Date: 12/06/2024 Closing Date: 5/21/2025 5:00 PM Eastern Job Class Title: Database Administrator II Position Number: 60052424 Section: Caswell Developmental Center Salary Grade: DT10 Description of Work 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 to experience how Caring is Contagious at Caswell Developmental Center. Knowledge, Skills and Abilities / Competencies 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). Minimum Education and Experience Requirements 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. Supplemental and Contact Information 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-###-####. 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) ###-####. 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 NOTE: For temporary, contract or other supplemental staffing appointments: There are no paid leave, retirement or other benefits associated with these appointment types. For permanent and time-limited appointments:Eligible employees have benefits that include employee health insurance options, standard and supplemental retirement plans, NC Flex (a variety of high-quality, low-cost benefits on a pre-tax basis), and paid vacation, sick, and community service leave, to name a few. Paid parental leave is available for eligible employees. Some benefits require 30 + hours work/week for participation. 01 DHHS 20 Where did you learn about DHHS or this opportunity?
- NC Jobs
- Employee Referral
- Conference / Career Fair
- Email campaign
- Professional Association or Industry-specific job board
- Indeed
- LinkedIn
- NC Nursing Board email
- Google
- Other General Job Boards
- Other Search Engines
- Other Social Media
- Internet Advertisement
- TV / Radio
02 Please give additional detail where you learned of DHHS or this opportunity. (e.g., APA Annual Meeting in NYC in May 2018, Facebook, Doximity, NC Substance Abuse Professional Practice Board, etc.) Required Question
