You are viewing a preview of this job. Log in or register to view more details about this job.

Database Administrator

NC Department of Commerce
Email

Description of Work

 

 


 

 


Unleash your potential and make an impact! The Department of Commerce, Division of Workforce Solutions is currently accepting applications for the Database Administrator located in Raleigh.

 


****** Recruitment Range $78,467 to $107,893 ***     
Salary Grade DT09

 

 

The Division of Workforce Solutions is currently working a Hybrid (onsite/offsite) Teleworking schedule.

 


The North Carolina Department of Commerce is the state's lead agency for economic, community, and workforce development.  The Department works with local, regional, national and international organizations to fulfill its mission to improve the economic well-being and quality of life for all North Carolinians.  The mission of the North Carolina Division of Workforce Solutions (DWS) is to develop North Carolina's workforce talent, help individuals advance their career opportunities, and meet business workforce needs by connecting talent to jobs. The DWS is responsible for administering federal workforce programs that help individuals gain skills and find employment, and help businesses find the workforce they need to be successful. Across the state, there are 80+ career centers which support individuals finding work and pursuing education and training and connect businesses with the well-trained, diverse talent they need. The centers are customer-centric, designed to meet the needs of customers, individuals and businesses.

The Information Technology (IT) section is responsible for all information Technology needs of the Division.  This includes creating new applications/solutions and maintaining existing applications/solutions necessary to collect and report all data to USDOL and other partners.  IT section works with State Department of Information Technology (DIT) DIT to provide all computer and software services to staff.

The primary purpose of the Database Administrator (DBA) is The DBA will be responsible for all aspects of the DWS Development, Test, and Production Database Environments and Windows Servers with an emphasis on Always On High Availability.  The position is also responsible for a multitude of SQL Server Integration Services packages and jobs, as well as installation, configuration, & patching of databases, database design, data modeling, data loading and extraction and stress testing database applications, database monitoring, database performance tuning, database backup and recovery, change control deliveries, resource management & capacity planning, batch job management, database security, trouble shooting, and problem resolution. The environment is currently on-premise but the position will also be involved with future cloud based initiatives.  The position will manage database access using the principal of least privilege and provide daily SCRUM reports and work using AGILE methodologies to produce agency-wide, mission critical solutions.   

Incentives of NC State Employment 
We value our employees and offer a wide variety of competitive and family-friendly benefits. Benefits to include:

  • 12 Annual Paid Holidays
  • North Carolina State Health Plan administered by Aetna
  • Supplemental Benefits including Flexible Spending Accounts, Accident Insurance, Cancer & Specified Disease, Critical Illness, Dental and Vision
  • NC State Retirement (TSERS)
  • WeSave Employee Discounts

Learn more about new hire resources, safety, health, and wellness information, leave options, employee discounts and more by selecting the benefits link. 

Please Note: It is critical to our screening and salary determination process that applications contain comprehensive information. Information should be provided in the appropriate areas to include the beginning and ending dates of jobs worked, education with the date graduated, all work experience, and certificates/licenses.  Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position. 

 

Knowledge, Skills and Abilities / Competencies

The Knowledge, Skills and Abilities listed below, along with the Minimum Education and Experience Requirements, are REQUIRED to qualify for this position.  We will not review resumes in lieu of Experience and Education listed on the application (additional statement below).  Click these links for additional information: Introduction to the Job Application and Addressing Knowledge, Skills and Abilities. The successful candidate will document on the application that they possess ALL of the following:  
 

Demonstrated technical expertise in SQL Server databases, SSIS, administration, clustering, mirroring, high-availability configurations, and their underlying operating systems and the associated hosting infrastructure.

Demonstrated technical expertise in windows and operating systems and their associated hosting infrastructures.

Demonstrated ability to evaluate third party/off-the-shelf tools and technologies, collaborate with solution architects, and lead teams in providing effective database solutions.

Experience in migrating, deploying, supporting, and maintaining databases.

People skills to work collectively with application Developers, systems administrators, and DB team lead to resolve problems and to design solutions to complex systems and application database requirements.

Ability to perform database sizing requirements, system needs, and capacity plans for new solutions.

Ability to develop and implement complex database solutions to enhance application performance and business solutions.

Ability to develop product roadmaps and always ensure compliance.

Ability to prepare summaries with the supporting documentation to senior management for seeking approvals and decisions. 

 

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 years of directly related experience, OR a combination of both. See oshr.nc.gov/experience-guide for detail. 

Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and one year of 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 two years of 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 five years of experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.

**INCLUDE ALL RELEVANT EDUCATION ON THE FORMAL APPLICATION. If a degree has not been completed, credit can be given for coursework if a transcript is attached to the application.**