What are the responsibilities and job description for the Database Administrator position at South Carolina Department of Commerce?
Job Responsibilities
Welcome to South Carolina. The new headquarters of American innovation.
The South Carolina Department of Commerce (S.C. Commerce) is committed to maintaining the state’s long-term competitiveness while building a modern economy — one that is diverse, supporting businesses at every phase of their lifecycle, while allowing people to live and work where they love.
As one of 22 cabinet agencies, S.C. Commerce is the state’s lead economic development agency. Its mission is to create economic opportunities to increase choices for all South Carolinians, which it does by supporting new and existing businesses and partnerships that fuel emerging industries such as life sciences, headquarters, and advanced energy. To drive the state’s advanced energy potential and global impact, S.C. Commerce helped organize the SC Nexus for Advanced Resilient Energy (SC NEXUS), designated as one of 31 federal Technology and Innovation Hubs in 2023. A national leader in foreign direct investment, South Carolina extends its international reach with representation in Europe and Asia, ensuring the state remains a top, global business destination from launch to legacy.
Job Purpose:
This position supports the development, maintenance, and integrity of the agency’s enterprise databases and data management systems. The role ensures the accuracy, completeness, and usability of data through effective data integrity processes, metrics, and reporting.
Job Responsibilities:
Skill in the development, implementation, and administration of low to moderately complex database systems through effective analysis, planning, modeling, schema design, and normalization. Skill in developing SQL queries, views, joins, relationships, indexes, constraints, transactions; in performing database CRUD (Create, Read, Update, Delete) operations. Skill in data validation, integrity checking, escaping, quoting, and encoding. Functional knowledge of data security and protection techniques including data classification, user/group management, access controls, authentication, authorization, backups, business continuity, and disaster recovery procedures. Ability to utilize basic data warehouse tools for reporting, visualization, and data extraction. Skill in the use and management of the operating system, storage, and network technologies supporting the database environment. Proficient in the use of CLI utilities and scripting maintenance, management, and automation. Ability to communicate clearly and effectively to technical and nontechnical audiences verbally, through presentations, and through the preparation of documentation and reports. Ability to establish positive working relationships with others.
Minimum And Additional Requirements
A high school diploma and work experience in systems development and maintenance, technical support, or the support of databased management systems. A bachelor’s degree in a related field may substitute for the required experience.
Must possess a valid driver’s license.
Preferred Qualifications
Experience with database administration, data integrity, and data dictionaries. CRM program experience and experience in economic development.
Additional Comments
The South Carolina Department of Commerce offers an exceptional benefit package for full-time and temporary grant positions that include:
Welcome to South Carolina. The new headquarters of American innovation.
The South Carolina Department of Commerce (S.C. Commerce) is committed to maintaining the state’s long-term competitiveness while building a modern economy — one that is diverse, supporting businesses at every phase of their lifecycle, while allowing people to live and work where they love.
As one of 22 cabinet agencies, S.C. Commerce is the state’s lead economic development agency. Its mission is to create economic opportunities to increase choices for all South Carolinians, which it does by supporting new and existing businesses and partnerships that fuel emerging industries such as life sciences, headquarters, and advanced energy. To drive the state’s advanced energy potential and global impact, S.C. Commerce helped organize the SC Nexus for Advanced Resilient Energy (SC NEXUS), designated as one of 31 federal Technology and Innovation Hubs in 2023. A national leader in foreign direct investment, South Carolina extends its international reach with representation in Europe and Asia, ensuring the state remains a top, global business destination from launch to legacy.
Job Purpose:
This position supports the development, maintenance, and integrity of the agency’s enterprise databases and data management systems. The role ensures the accuracy, completeness, and usability of data through effective data integrity processes, metrics, and reporting.
Job Responsibilities:
- Build and operate a robust data integrity process to include metrics, reporting, audits and improvement proposals for division and agency leadership.
- Build and maintain a set of metadata for enterprise databases including data definitions and data lineage in a single location. Create and generate custom reports, views, and fact sheets; maintain Power BI and CRM goal tracking.
- Assist in the implementation of data designs and architecture.
- Troubleshoots data issues and develop solutions or recommendations for corrective action. Assists with data policy and strategic recommendations. Train agency employees on CRM data integrity protocols and basics to new and existing employees.
Skill in the development, implementation, and administration of low to moderately complex database systems through effective analysis, planning, modeling, schema design, and normalization. Skill in developing SQL queries, views, joins, relationships, indexes, constraints, transactions; in performing database CRUD (Create, Read, Update, Delete) operations. Skill in data validation, integrity checking, escaping, quoting, and encoding. Functional knowledge of data security and protection techniques including data classification, user/group management, access controls, authentication, authorization, backups, business continuity, and disaster recovery procedures. Ability to utilize basic data warehouse tools for reporting, visualization, and data extraction. Skill in the use and management of the operating system, storage, and network technologies supporting the database environment. Proficient in the use of CLI utilities and scripting maintenance, management, and automation. Ability to communicate clearly and effectively to technical and nontechnical audiences verbally, through presentations, and through the preparation of documentation and reports. Ability to establish positive working relationships with others.
Minimum And Additional Requirements
A high school diploma and work experience in systems development and maintenance, technical support, or the support of databased management systems. A bachelor’s degree in a related field may substitute for the required experience.
Must possess a valid driver’s license.
Preferred Qualifications
Experience with database administration, data integrity, and data dictionaries. CRM program experience and experience in economic development.
Additional Comments
The South Carolina Department of Commerce offers an exceptional benefit package for full-time and temporary grant positions that include:
- Health, Dental, Vision, Long Term Disability, and Life Insurance for Employee, Spouse and Children.
- 15 days annual (vacation) leave per year.
- 15 days of sick leave per year.
- 13 paid holidays.
- State Retirement Pension and 401K Plans
- Deferred Compensation Programs
- Paid Parental Leave