Database Administrator II

State of North Carolina•Wake County, NC
•Onsite

About The Position

The North Carolina State Bureau of Investigation is hiring a Database Administrator II to administer, maintain, and support its enterprise Microsoft SQL Server database environments. Reporting to the Operating Systems Software Manager, the role helps ensure database availability, performance, security, reliability, and integrity. It monitors database operations, manages backup and recovery processes, and troubleshoots complex database issues. The position provides technical expertise and leadership for database design, development, upgrades, migrations, and enterprise IT projects. It works with application developers, infrastructure teams, IT management, application owners, and agency personnel to support mission-critical systems and future technology needs. The role is full-time, 40 hours per week, with a stated Monday-to-Friday schedule of 8:00 a.m. to 5:00 p.m.; after acclimation, the employee joins an after-hours on-call rotation. The employee must reside within one hour of the SBI’s main campus in Raleigh and must be a U.S. citizen to access the relevant SBI applications.

Requirements

  • Meet the minimum education and experience requirement through one of the stated pathways: a bachelor’s degree in computer science, an IT-related field, or a related curriculum from an appropriately accredited institution plus three years of progressive experience in programming and applications analysis, including integrated database system design and maintenance; an associate degree in one of those fields plus four years of such experience; a high school diploma or GED plus seven years of relevant experience; or an equivalent combination of education and experience.
  • Be a U.S. citizen because of security requirements for access to SBI applications.
  • Reside within one hour of the SBI’s main campus at 3320 Garner Road, Raleigh, North Carolina, to support on-call responsibilities and emergency response needs.
  • Work Monday through Friday, 8:00 a.m. to 5:00 p.m., and join the after-hours on-call rotation after acclimation.
  • Successfully complete the comprehensive background investigation, including a pre-employment polygraph, credit and arrest checks, reference and employment verification, education verification, medical examination, urinalysis drug screening, and fingerprint submission.

Nice To Haves

  • Extensive hands-on experience administering and supporting enterprise Microsoft SQL Server environments, including SQL Server Enterprise, database architecture, performance tuning, indexing, and query optimization.
  • Advanced experience with SSIS, SSRS, T-SQL programming, stored procedures, and database scripting and automation.
  • Demonstrated experience managing enterprise database backup, recovery, disaster recovery, and high-availability operations, including troubleshooting complex database failures and performance issues.
  • Experience planning and executing enterprise database upgrades, migrations, data conversions, and modernization projects while maintaining application compatibility and minimizing operational disruptions.

Responsibilities

  • Administer, maintain, and support enterprise Microsoft SQL Server database environments.
  • Ensure database availability, reliability, integrity, and operational performance; manage instances, configurations, storage, and resource utilization.
  • Monitor database performance using customized scripts, alerts, and diagnostic tools; analyze and optimize queries, indexes, stored procedures, and execution plans; identify bottlenecks and recommend infrastructure improvements.
  • Monitor and validate scheduled database and transaction log backups; manage backups using Commvault and designated Data Domain storage; perform restores and recovery operations and troubleshoot backup failures.
  • Provision and maintain database accounts, permissions, and access controls; implement auditing and monitoring, including failed-login activity; maintain security and integrity according to agency requirements.
  • Participate in designing, developing, and implementing SQL Server database systems; develop, maintain, and optimize database objects, scripts, stored procedures, and queries.
  • Collaborate with application developers and IT personnel to establish database architecture and integration solutions.
  • Plan and perform database upgrades, migrations, and technology refresh initiatives; maintain and improve SSIS and SSRS packages; support application migrations, data conversions, and database compatibility requirements.
  • Respond to database 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 concerning database operations and data access.
  • Participate in an after-hours on-call rotation after becoming acclimated to the position.

Benefits

  • Benefits are offered; specific benefits are not detailed.
  • Eligibility for the Public Service Loan Forgiveness Program as a state employee.
  • Paid parental leave for birth, adoption, and foster care is referenced as a state-supported policy.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service