Database administrator ii

Apply now

Location

onsite, Raleigh, NC, United States

Salary

$88k – $131k/yr

Commitment

Full Time

Level

Middle (2-4 years)

Required skills

Microsoft SQL ServerDatabase administrationPerformance tuningQuery optimizationSSISSSRST-SQLDatabase securityBackup and recoveryDisaster recoveryDatabase architectureScriptingAutomationTroubleshootingData migration

Job Description

About Us

The State Bureau of Investigation’s mission is to serve Sheriffs, Police Chiefs, and District Attorneys as well as State and Federal partners, by investigating crimes and providing technical assistance in order to increase public safety for the citizens of the state of North Carolina. The SBI does so by conducting criminal investigations of allegations in areas of jurisdiction including narcotics, arson, election laws, misuse of state property, environmental crimes, human trafficking, child sexual abuse in day care centers, and threats made against public officials. The SBI provides support to local agencies related to computer crime investigations, use of force investigations, deaths in custody, crime scenes, financial crimes, missing and endangered persons, public corruption, cold cases, K9, special response team, bomb squad, and air wing. The SBI serves as North Carolina's repository of information on criminal history records, fingerprint identification, expungements, sex offender registry, and concealed handgun permits. The SBI manages the North Carolina Information Sharing and Analysis Center (ISAAC), which is the fusion center for the state of North Carolina, as well as the Behavioral Threat Assessment Unit, which assesses and manages threats of mass violence.

Description of Work

The North Carolina State Bureau of Investigation (SBI) is searching for a highly skilled and innovative IT professional to serve as a Database Administrator II and play a critical role in supporting the agency's complex enterprise technology infrastructure.

Reporting to the Operating Systems Software Manager, this position is responsible for the administration, maintenance, and support of the SBI’s enterprise Microsoft SQL Server database environments. Responsibilities include ensuring database availability, performance, security, and integrity; monitoring operations; managing backup and recovery processes; and troubleshooting complex database issues. The position also provides technical expertise and leadership in database design, development, upgrades, migrations, and enterprise IT projects while collaborating with application developers, infrastructure teams, and IT management to support the agency's mission-critical systems and future technology needs.

Key responsibilities include but are not limited to:

  1. Enterprise Database Administration
    • Administer, maintain, and support the agency's enterprise Microsoft SQL Server database environments.
    • Ensure database availability, reliability, integrity, and operational performance.
    • Manage database instances, configurations, storage, and resource utilization.
  2. Database Performance Monitoring and Optimization
    • Monitor database performance using customized scripts, alerts, and diagnostic tools.
    • Analyze and optimize database queries, indexes, stored procedures, and execution plans.
    • Identify and resolve performance bottlenecks and recommend infrastructure improvements.
  3. Database Backup and Recovery
    • Monitor and validate scheduled database backups and transaction log backups.
    • Manage backup operations using Commvault and designated Data Domain storage.
    • Perform database restores and recovery operations and troubleshoot backup failures.
  4. Database Security and Access Management
    • Provision and maintain database user accounts, permissions, and access controls.
    • Implement database auditing and monitoring, including failed login activity.
    • Maintain database security and integrity in accordance with agency requirements.
  5. Database Design and Development
    • Participate in the design, development, and implementation of new SQL Server database systems.
    • Develop, maintain, and optimize database objects, scripts, stored procedures, and queries.
    • Collaborate with application developers and IT personnel to establish appropriate database architecture and integration solutions.
  6. Database Maintenance, Upgrades, and Migrations
    • Plan and perform database upgrades, migrations, and technology refresh initiatives.
    • Maintain and improve SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) packages.
    • Support application migrations, data conversions, and database compatibility requirements.
  7. Technical Support and Troubleshooting
    • Respond to database-related incidents, service requests, and change requests through established IT management processes.
    • Troubleshoot complex SQL Server issues and coordinate vendor support when necessary.
    • Provide technical assistance to application owners, IT teams, and agency personnel regarding database operations and data access.

Position/Physical Requirements:

  • Must be able to work Monday to Friday, 8:00AM - 5:00PM.
  • Must be a U.S. citizen due to security requirements for accessing SBI applications to which the person in this position must have access.
  • Once new employee is acclimated he or she will go into rotation for on call after hours.
  • Must reside within 1 hour of the SBI’s main campus at 3320 Garner Rd Raleigh, NC to support on-call responsibilities and emergency response needs.

Knowledge Skills and Abilities/Management Preferences

Salary Range: $87,617 - $131,426. Salary will be based on relevant qualifications, internal equity, and budgetary considerations for the advertised position.

IMPORTANT NOTE: This posting closes at 11:59:59 PM the night BEFORE the End Date listed.

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 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 Equivalent combination of education and experience.

Application Process

Please visit How Do I Get the Job for tips and guidelines on applying for State jobs. Be sure to complete the application in full. In order to receive qualifying credit for all your work history and credentials, applicants must complete their entire work history and education on the application. Workday allows you to populate your profile and applications with information automatically pulled from your resume or LinkedIn profile, but you must upload this information and ensure its accuracy. Resumes are not accepted in lieu of the application, and “See Resume” is not acceptable in application fields. Any information omitted from the actual application will not be considered for qualifying credit. It is OK to attach a resume, but make sure all pertinent information is listed on the application form. All applications must be submitted by 11:59 PM on the closing date.

Ready to join the team?

Apply now