Database Administrator II

State of North Carolina

North Carolina

On-site

USD 88,000 - 131,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

North Carolina State Bureau of Investigation (SBI) seeks a Database Administrator II to maintain enterprise SQL Server databases, ensure performance, security, and integrity. The role involves backup/recovery operations, security controls, and collaboration with developers and IT teams on migrations and upgrades.

You will monitor and tune database performance, manage access, and contribute to high-availability initiatives, SSIS/SSRS development, and enterprise IT projects within SBI.

Qualifications

  • Experience administering enterprise Microsoft SQL Server environments.
  • Proficiency with SSIS, SSRS, T-SQL, and automation.
  • Experience with backup, recovery, DR, high availability.

Responsibilities

  • 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.
  • Monitor database performance using customized scripts and diagnostic tools.
  • Analyze and optimize queries, indexes, and execution plans.
  • Plan and perform database upgrades, migrations, and technology refresh initiatives.
  • Maintain SSIS/SSRS packages and data migrations.
  • Provide technical assistance to application owners and IT teams.

Skills

SQL Server
SSIS/SSRS
T-SQL
Backup & Recovery
Security auditing

Education

Bachelor's degree in computer science or IT-related field
Associate degree in computer science or IT-related field
High School diploma or GED

Tools

Commvault
Data Domain
SSMS

Job description

AgencyState Bureau of InvestigationDivisionInformation , Support ServicesJob Classification TitleDatabase Administrator II (NS)Position Number60011116GradeDT10About UsThe 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 WorkThe 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 PreferencesSalary Range: $87,617 - $131,426Salary will be based on relevant qualifications, internal equity, and budgetary considerations for the advertised position.*THIS IS AN ANTICIPATED VACANCY*IMPORTANT NOTE: This posting closes at 11:59:59 PM the night BEFORE the End Date listed.The Minimum Education and Experience (E&E) is REQUIRED to qualify for this position. Management also prefers: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 SQL Server Integration Services (SSIS), SQL Server Reporting Services (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.This is a full-time position (40 hours per week) with Benefits .Selected candidates will undergo and must successfully complete a comprehensive background investigation which includes: pre-employment polygraph examination; credit and arrest checks; interviews with associates, personal and business references; verification interviews of employers; verification of education achievement; medical examination; urinalysis drug screening; submission of fingerprints.Minimum Education and ExperienceSome 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;ORAssociate 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;ORHigh 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;OREquivalent combination of education and experience.The North Carolina State Bureau of Investigation (SBI) selects applicants for employment based on required education and experience and job-related knowledge, skills, and abilities without regard to race, religion, color, national origin, sex, pregnancy, gender identity or expression, sexual orientation, age (40 or older), disability, National Guard or veteran status, genetic information, political affiliation, or political influence.We are an Employment First state, ensuring that people with disabilities have equal opportunities to succeed in the state government workplace. SBI supports pay equity for women, establish paid parental leave for birth, adoption, and foster care, and implement fair chance policies. Join a team that welcomes, values, respects and supports all members of our work community.Application ProcessPlease 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.Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account. Upon the closing date, applications will be screened by Human Resources for the qualified applicants. The hiring process may take several weeks.Degree/College Credit VerificationDegrees must be received from appropriately accredited institutions. Transcripts and degree evaluations may be uploaded with your application. If applicants earned college credit hours but did not complete a degree program, they must attach an unofficial transcript to each application to receive credit for this education.If you earned a foreign degree, you must attach your official evaluation for U.S. equivalency to your application to receive credit for your degree as foreign degrees require an official evaluation for U.S. equivalency. If you do not attach, Human Resources cannot verify your degree equivalency to give you credit for salary qualification purposes. There are several organizations that perform this specialized service listed on the National Association of Credential Evaluation Services (NACES) website: https://www.naces.org/members .If you have student loans, becoming a state employee includes eligibility for the Public Service Loan Forgiveness Program. Visit www.studentaid.gov to learn more.Certified PositionsApplicants applying for positions certified through the North Carolina Department of Justice - Criminal Justice Education and Training Standards Division can find specific certification requirements here .Per North Carolina General Statute 143B-1209.54 , applicants hired into a position certified as a criminal justice officer or justice officer are required to electronically submit fingerprints to the NC State Bureau of Investigation for a state and national criminal history record check and enrollment in the Federal Bureau of Investigation's Next Generation Identification (NGI) System and Criminal Justice Record of Arrest and Prosecution Background (Rap Back) Service . This is in addition to submitting fingerprints during the application process.Veteran’s and National Guard PreferenceApplicants seeking Veteran’s Preference must attach a DD Form 214, Certificate of Release or Discharge from Active Duty, along with the state application.Applicants seeking National Guard Preference must attach an NGB 23A (RPAS), along with the state application if they are a current member of the NC National Guard in good standing.Applicants who are former member of either the NC Army National Guard or the NC Air National Guard, with honorable discharge and six years of creditable service must attach a copy of the DD 256 or NGB 22, along with the state application.ADA AccommodationsConsistent with the Americans with Disabilities Act (ADA) and the Pregnant Workers Fairness Act (PWFA), SBI is committed to the full inclusion of all qualified individuals. As part of this commitment, SBI will ensure that persons with disabilities, or known limitations covered by the PWFA, are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, please contact the person indicated below.Employment EligibilityIt is the policy of the State of North Carolina and NC SBI that all employees provide proof of employment eligibility (immigration and naturalization) on the first day of employment. We participate in E-Verify (Employment Eligibility Verification System).CONTACT INFORMATION:N.C. State Bureau of InvestigationHuman Resources3320 Garner RoadRaleigh, NC 27610Recruitment@ncsbi.govEEO StatementT he State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.Recruiter:Sharon Massey SasserRecruiter Email:Recruitment@ncsbi.gov
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Fixed Asset and Inventory Specialist
Fixed Asset and Inventory Specialist

State of North Carolina - State Bureau of Investigation • North Carolina

On-site
USD 43,000 - 65,000
Housekeeper
Housekeeper

State of North Carolina • North Carolina

On-site
USD 31,000 - 47,000
Director of the Domestic Violence Monitoring Program
Director of the Domestic Violence Monitoring Program

Ncsbi • North Carolina

On-site
USD 70,000 - 110,000
Accountant I
Accountant I

State Bureau of Investigation • North Carolina

On-site
USD 50,000 - 67,000
Fixed Asset and Inventory Specialist
Fixed Asset and Inventory Specialist

State Bureau of Investigation • Raleigh (NC)

On-site
USD 43,000 - 65,000
Benefits
Director of the Domestic Violence Monitoring Program
Director of the Domestic Violence Monitoring Program

State Bureau of Investigation • Raleigh (NC)

On-site
USD 70,000 - 110,000
Data Applications Systems Analyst II
Data Applications Systems Analyst II

State of North Carolina - Justice • North Carolina

On-site
USD 82,000 - 122,000
Health insurance
12 paid holidays
Retirement benefits
User Support Technician I - (Scotland CI)
User Support Technician I - (Scotland CI)

North-Carolina-Department-of-Correction • North Carolina

On-site
USD 57,000 - 85,000
Health Insurance
Retirement Plans
Paid Vacation
Administrative Specialist
Administrative Specialist

State of North Carolina - Justice • North Carolina

On-site
USD 39,000 - 48,000
Health insurance
Paid holidays
Vacation and sick leave
+1
Diagnostic Services Specialist
Diagnostic Services Specialist

Adult Correction • Raleigh (NC)

On-site
USD 48,000 - 83,000
Health insurance
Retirement plans
Paid leave