Salary: $54,974.00 - $101,712.00 Annually
Location : Richland County, SC
Job Type: FTE - Full-Time
Job Number: 164443/61006667/DPH
Agency: DHEC-CO/COS
Opening Date: 04/29/2024
Closing Date: 5/13/2024 11:59 PM Eastern
Class Code:: AM43
Position Number:: 61006667 (164443)
Normal Work Schedule:: Monday - Friday (8:30 - 5:00)
Pay Band: Band 7
Hiring Range - Min.: $54,974.00
Hiring Range - Max.: $78,343.00
Opening Date: 04/29/2024
EEO Statement: Equal Opportunity Employer
Agency Specific Application Procedures:: If you meet the requirements of the position and would like to be considered, you must submit a state application online. Please complete the state application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position. The quality of the application presented (completeness and accuracy as well as grammar and spelling) will be considered prior to the offer of an interview. A criminal records check will be conducted prior to an offer of employment. Applications will be accepted until 11:59 p.m. on the stated closing date.
Veteran Preference Statement: South Carolina is making our Veterans a priority for employment in state agencies and institutions.
Job Responsibilities
Careers at DHEC: Work that makes a difference!
Embracing Service, Inspiring Innovation, Promoting Teamwork, Pursuing Excellence, and Advancing Equity
Under limited supervision, work in a leadership role to oversee the design, development, implementation, monitoring, backup, and disaster recovery of agency relational database systems of moderate to advanced complexity across platforms and computing environments to ensure availability, data integrity and credibility. To support agency initiatives and security policies with a primary focus on IBM DB2 and Microsoft SQL Server Databases.

• Install, test, upgrade, administer, and monitor agency databases and related software to ensure integrity, availability, backup, and disaster recovery of those systems. To include data processes, workflow, reporting, policies, business terms, and rules to ensure identification of relationships across applications, ensure business rule validation, detect data out of established standards, and data quality to ensure data credibility. Promotes strategic initiative to improve the agency's overall operations.
  
• Coordinates and assists in the planning, development, amendment, optimization, normalization, and implementation of database schedma to meet system(s) requirement throughout the development life cycle. Assist developers and information technology staff as necessary. Develop, document, and administer database operating and security procedures.
  
• Gathers, analyzes, and normalize relevant information related to operations to identify poor database performance. Troubleshoot database systems and discern any resulting hardware and/or software issues. Make recommendations and take appropriate actions to improve database performance.
  
• Directs the preparation of project reports for management and customers. Assesses project progress and is held accountable for results. Provide appropriate administrative documentation/project communication. Support the IT Service Center by responding to database related service calls.

Minimum and Additional Requirements
State Minimum Requirements: A high school diploma and work experience in systems development and maintenance, technical support, or the support of database management systems. A bachelor's degree in a related field may be substituted for the required experience.
Institutions of Higher Learning must be recognized by the Council for Higher Education Accreditation.
Agency Additional Requirements: Knowledge of computer hardware and a wide range of software including operating systems (Microsoft Server and AIX). Ability to plan, evaluate, design, normalize, optimize, maintain, monitor, and manager agency relational databases (Microsoft SQL, IBM DB2, Oracle). Must use industry best practices for disaster recovery and business continuity. Ability to establish and maintain working relationships with uses, technical staff, management and vendors. Ability to communicate effectively both orally and in writing. Ability to work independently in establishing priorities and responding to agency needs.
Applicants indicating college credit or degree(s) on the application may upload an unofficial copy of the transcript as an attachment to the application. Please note that the agency will require an official, certified copy of the transcript or diploma prior to hiring.
Preferred Qualifications

• Leadership skills
• Ability to multi-task
• Good Team Member
• Excellent troubleshooting capabilities

Additional Comments

DRIVING RECORD: If this position requires the applicant to possess a valid driver's license to operate a state vehicle or personal vehicle, any applicant being considered in the final stages of selection for the position will be required to provide a certified copy of a 10-year driving record.
EEO: SC DHEC is an equal employment opportunity/affirmative action employing agency. We are committed to a diverse workforce. SC DHEC does not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, age (40 or older), disability or genetic information.
The South Carolina Department of Health and Environmental Control offers an exceptional benefits package for FTE positions that includes: •Health, Dental, Vision, Long Term Disability, and Life Insurance for Employee, Spouse, and
Children
•15 days annual (vacation) leave per year
•15 days sick leave per year
•13 paid holidays
•State Retirement Plan and Deferred Compensation Programs
• REMOTE WORK: The option to work partially remote is available after six (6) months of employment
T his position is part of the South Carolina Department of Health and Environmental Control's Office of Information Technology (OIT). The work performed supports DHEC's mission to improve the quality of life for all South Carolinians by protecting and promoting the health of the public and the environment. Effective July 1, 2024, this position will transfer to the South Carolina Department of Public Health created by Senate Bill 399 which provides for the creation of the Department of Public Health to assume the public health-related functions of DHEC.
Benefits for State Employees
The state of South Carolina offers eligible employees generous benefits, including health and dental insurance; retirement and savings plan options; and paid vacation and sick leave. Plus, work-life balance programs such as telecommuting and flexible work schedules are available to employees of some state agencies.

Insurance Benefits
Eligible employees may enroll in health insurance, which includes prescription coverage and wellness benefits. Other available insurance benefits include dental, vision, term life insurance, long term disability and flexible spending accounts for health and child care expenses.

Retirement Benefits
State employees are also offered retirement plan options, including defined benefit and defined contribution plans. Additionally, eligible employees may elect to participate in the South Carolina Deferred Compensation Program, which is a voluntary, supplemental retirement savings plan offering 401(k) and 457 plan options.

Workplace Benefits
State employees may also be eligible for other benefits, including tuition assistance; holiday, annual and sick leave; and discounts on purchases, travel and more.

Note: The benefits above are available to most state employees, with the exception of those in temporary positions. Employees in temporary grant and time-limited positions may be eligible for all, some or none of these benefits as benefits are associated with each position type. For these positions, contact the hiring agency to determine what benefits may be available.
01

Supplemental questions are considered part of your official application. Any misrepresentation will result in your disqualification from employment. Please complete the state application to include all current and previous work history and education. A resume will not be accepted or reviewed to determine if an applicant has met the qualifications for the position. I have read and acknowledge the above statement.

• Yes
• No

02

Applicants indicating college credit or degree(s) on the application may upload an unofficial copy of the transcript as an attachment to the application. Please note that the agency will require an official, certified copy of the transcript or diploma prior to hiring. I have read and acknowledge the above statement.

• Yes
• No

03

Are you a current or prior DHEC employee?

• Yes
• No

04

Are you willing to accept a salary within the agency's hiring range of $54,974 - $78,343?

• Yes
• No

05

Do you have at least a high school diploma or higher and work experience in systems development and maintenance, technical support, or the support of database management systems?

• Yes
• No

06

Do you have experience in the IBM DB2 database?

• Yes
• No

07

If you answered "YES" to the Question #5, please briefly describe your DB2 experience to include the latest version you worked on.
08

Do you have SQL server experience?

• Yes
• No

09

If you answered yes to the previous question, please briefly describe your SQL experience?
Required Question