Database Administrator Tech Support

Agency Dept of Health and Human Services Division SEC OFFICE - INFO TECH - NC FAST Job Classification Title Applications Systems Analyst II (NS) Position Number 60038058 Grade DT09 About UsThe North Carolina Department of Health and Human Services (DHHS) is one of the largest, most complex agencies in the state, and has approximately 17,000 employees. It is responsible for ensuring the health, safety, and well-being of all North Carolinians, providing human service needs for special populations including individuals who are deaf, blind, developmentally disabled, and mentally ill, and helping poor North Carolinians achieve economic independence.Description of WorkThe Database Administrator position provides technical support for mainframe, middleware infrastructure, and distributed systems, with a focus on database administration and application support. The role includes maintaining and optimizing complex databases such as DB2, MS SQL, and Oracle, and supporting application teams with debugging, configuration, and performance tuning. This position also assists in administering the X/PTR report repository and provides CICS administration and problem-solving support.Work involves collaboration with internal teams and vendors to ensure system reliability, security, and performance. The position requires strong technical expertise across multiple platforms and participation in on-call and after-hours support as needed. Key Duties Include: - Provide technical support for mainframe, middleware, and distributed systems to ensure availability and performance of critical applications. - Analyze and resolve system and application issues, including abends, software bugs, and interoperability problems across platforms.- Support database design, implementation, and maintenance for DB2, MS SQL, and Oracle environments in development, testing, and production. - Evaluate and optimize complex SQL queries to improve software performance and reduce resource consumption. - Monitor system metrics such as CPU cycles, storage, and I/O utilization to proactively identify and address performance issues. - Administer the X/PTR report repository, including report and bundle definitions, index programs, and security configurations.- Assist application teams with CICS administration, debugging, and coordination with DIT personnel for issue resolution. - Participate in configuration and release management activities using tools such as Endevor to support software deployment. - Provide technical consultation during requirements and design sessions to guide system architecture and database planning. - Perform on-call and after-hours support to ensure successful execution of over 1,500 scheduled jobs daily. Knowledge Skills and Abilities/Management PreferencesSalary Grade Range: $78,467.00 - $117,701.00 Candidates now meet the minimum qualifications of a position if they meet the minimum education and experience listed on the vacancy announcement.The Knowledge, Skills, and Abilities (KSAs)/ Management Preferences are not required. Applicants who possess the following skills are preferred: Demonstrated experience supporting and maintaining enterprise-level databases such as DB2, MS SQL, or Oracle, including performance tuning, backup and recovery, and patch management. Proven ability to analyze and optimize complex SQL queries to improve system performance and reduce resource utilization in high-volume environments. Expert-level proficiency in administering mainframe environments, including CICS debugging, Endevor configuration management, and Z/OS system operations.Documented success managing X/PTR report repositories, including defining report bundles, maintaining index programs, and resolving user access issues. Demonstrated experience translating technical issues into clear, actionable guidance for non-technical stakeholders and collaborating across infrastructure and application teams. The Posting Will Close At 11:59 P.M. The Night BeforeThe End DateThis Position Is Funded In Part Through Federal FundsThis Position Has Possible Hybrid Option About the NC DHHS Information Technology Division: In collaboration with our partners, the North Carolina Department of Health and Human Services (DHHS) protects the health and safety of all North Carolinians and provides essential health and human services.The IT division (ITD) is one of the divisions that report to the Operational Excellence portfolio. The ITD division comprises four sections: Implementation and Operations, Strategy and Workforce, Enterprise Technology, and Vendor and Finance. ITD offers the following services but not limited to implementations, operations, project/portfolio management, infrastructure, consulting, business division liaison, digital transformation, IT strategy, enterprise technology, IT contract and vendor management, and data office services.Compensation andBenefits: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-bolthires 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 the website for State Benefits. Supplemental Contact Information:The North Carolina Department of Health and Human Services (DHHS) is an Equal Opportunity Employer that embraces an Employment First philosophy, which consists of complying with all federal laws, state laws, and Executive Orders.We are committed to reviewing requests for reasonable accommodation at any time during the hiring process or while on the job. For more information about DHHS: DHHS uses the Merit-Based Recruitment and Selection Plan to fill positions subject to the State Human Resources Act with the most qualified individuals. Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position. In accordance with the Governor’s Executive Order 303, our agency supports second-chance employment for individuals who were previously incarcerated or justice-involved.We invite all potential applicants to apply for positions for which they may be qualified. Application Process Be sure to complete the application in its entirety. Resumes will not be accepted in lieu of completing this application. Information should be provided in the appropriate areas, to include the following: Education, including high school and all degrees obtained, Work Experience, and Certificates & Licenses. It is critical to our screening and salary determination process that applications contain comprehensive candidate information.Answers to Supplemental Questions are not a substitute for providing all relevant information within the body of your application. To receive credit for the supplemental questions, you must provide supporting information within the "Work Experience" section of the application to support your answers. If multiple applications are submitted to an individual posting, only the most recent application received prior to the closing date will be accepted. Applications must be submitted by 11:59 PM on the closing date.Applicants may be subject to a criminal background check. All candidates selected for positions considered "Positions of Trust" will be subject to a criminal background check. 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. Upon the closing date, applications are "Under Review" and will be screened by Human Resources for qualified applicants.The hiring process may take several weeks. Degrees must be received from appropriately accredited institutions. Transcripts and degree evaluations may be uploaded with your application. The State of North Carolina/Office of State Human Resources uses the National Association of Credential Evaluation Services (NACES) as a referral resource for applicants who need to have their credentials certified as equivalent. For a list of organizations that perform this specialized service, please visit the NACES membership website at Degree/College Credit Verification Degrees must be received from appropriately accredited institutions.Transcripts, degree evaluations, and cover letters may be uploaded with your application. Veterans’ and National Guard Preference Applicants seeking Veteran's Preference must attach a DD-214 Member-4 Form (Certificate of Release or Discharge from Active Duty) to their applications. Applicants seeking National Guard Preference must attach an NGB 23A (RPAS), along with the state application, if they are a current member of the NC National Guard in good standing. Applicants who are former members of either the NC Army National Guard or the NC Air National Guard, with honorable discharge and six years of creditable service, must attach a copy of the DD 256 or NGB 22, along with the state application.ADA Accommodations Consistent with the Americans with Disabilities Act (ADA) and the Pregnant Workers Fairness Act (PWFA), DHHS is committed to the full inclusion of all qualified individuals. As part of this commitment, DHHS will ensure that people with disabilities, or known limitations covered by the PWFA, are provided with reasonable accommodation. If reasonable accommodation is needed to participate in the job application or interview process, please contact the person indicated below. CONTACT INFORMATION If there are any questions about this posting, please contact Talent Acquisition at [email protected] will not be accepted in lieu of completing this application. Minimum Education and Experience 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 years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details. Bachelor's degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and two years of experience in business application consulting or development OR Associate degree in computer science or an IT related field from an appropriately accredited institution and three years of experience in application consulting or development OR High School or General Educational Development (GED) diploma and six years of experience in business application consulting or development OR An equivalent combination of education and experience.EEO StatementThe State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices. Recruiter: Yvette Jones Email: [email protected] [email protected] North Carolina State Government is one of the state’s largest employers, with over 76,000 employees all working toward a common goal: a safer and stronger North Carolina.We are a large organization comprised of various agencies, offices, and universities, each providing important public services. Eligible state employees are entitled to comprehensive benefits, including a variety of leave options, professional development opportunities, insurance, and more. To learn more about the benefits of being a North Carolina state employee, visit the N.C. Office of State Human Resources' website. Permanent, temporary, and time-limited state government jobs can be found from the mountains to the coast.Find your next opportunity today! State Application Resources/Frequently Asked Questions Valuing Education and ExperienceThe State of North Carolina values the knowledge and experience of our jobseekers and current state employees. Approximately 91 percent of state job classifications allow experience to be substituted for education or do not require a post-secondary degree. Learn more about how you may qualify for a position through education or directly related experience, or a combination of both, with the Education and Experience Equivalency Guide.Introduce yourself to our recruiters and we'll get in touch if there's a role that seems like a good match. If you are already a state employee, please search for jobs by clicking here. Apply tot his job