SQL Database Administrator

The Csa
Pensacola, FL, United States
28 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Active Directory Backup Devices CompTIA Security+ Databases Data Centers Extract Transform Load (ETL) Data Mining Database Servers Microsoft SQL Server Windows Servers Performance Tuning Query Optimization
+6 more
Server Administration SQL Stored Procedures SQL Databases Transact-SQL Diagnostic Tools SC Clearance

Job description

ApplyJob TypeFull-timeDescriptionClient Solution Architects (CSA) is currently seeking a SQL Database Administrator to support a program onsite in Pensacola, FL. The SQL Server Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of critical SQL servers for the Navy corporate applications.For nearly 50 years, CSA has delivered integrated technology and operational support services to meet the defense and federal sector’s most complex enterprise needs. Working from operations centers and shipyards to training sites and program offices, CSA deploys experienced teams, innovative tools and proven processes to advance federal missions.How Your Role Will Make an Impact:Manages SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.Configures and maintains database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.Applies data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.Independently analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.Writes and optimizes T-SQL statements.Designs, develops, and maintains database objects such as stored procedures, functions, views, indexes, and triggers.Refines and automates regular processes, track issues, and document changes.Assists developers with complex query tuning and schema refinement.Performs scheduled maintenance and support release deployment activities.Shares technical expertise and provides technical mentorship and cross-training to other peers and team members.When performance issues arise, determines the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.Develops and executes profiler traces and other tools to find the most frequently run queries.RequirementsWhat You Will Need to Join Our Award-Winning Team:Clearance: Ability to obtain and maintain an active Secret Clearance.CompTIA Security + Certification or qualifying Bachelor’s degree.2+ years MS SQL Server Administration experience required.Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.Experience with backups, restores and recovery models.Experience working with Windows server, including Active Directory.Ability to multi-task and context-switch effectively between different activities and teams.SQL Server 2012/2014/2016Knowledge of HP, Sun, Dell, Intel Platforms.Excellent written and verbal communication.Ability to organize and plan work independently.What sets you apart:Active Secret Clearance.BS in IT related field and 5+ years of experience in the following: Design, install, monitor, and maintain SQL Server databases (2012, 2014, 2016).Data Extraction, Transformation, and Loading (ETL) experience.Backup and recovery experience.Performance tuning and optimization or resources experience.Experience performing SQL STIG checks, fix or mitigate any STIG findings, and maintain STIG compliance.Experience formulating policies, procedures, and standards relating to database management.Physical Requirements:While performing the duties of this job, the employee is regularly required to:Sit for extended periods of time and work at a computer workstationUse hands and fingers to operate keyboards, mice, and other input devicesCommunicate effectively, both verbally and in writingSpecific vision abilities required may include close vision, distance vision, depth perception, and the ability to adjustStand, walk, bend, or reach; Access equipment located in data centers, offices, or under desksLift and/or move equipment weighing up to 25 poundsReasonable accommodations may be made to enable individuals with disabilities to perform the essential functions, in accordance with the Americans with Disabilities Act (ADA).

Requirements

What You Will Need to Join Our Award-Winning Team:

  • Clearance: Ability to obtain and maintain an active Secret Clearance.
  • CompTIA Security + Certification or qualifying Bachelor’s degree.
  • 2+ years MS SQL Server Administration experience required.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Experience working with Windows server, including Active Directory.
  • Ability to multi-task and context-switch effectively between different activities and teams.
  • SQL Server 2012/2014/2016
  • Knowledge of HP, Sun, Dell, Intel Platforms.
  • Excellent written and verbal communication.
  • Ability to organize and plan work independently.

What sets you apart:

  • Active Secret Clearance.
  • BS in IT related field and 5+ years of experience in the following: Design, install, monitor, and maintain SQL Server databases (2012, 2014, 2016).
  • Data Extraction, Transformation, and Loading (ETL) experience.
  • Backup and recovery experience.
  • Performance tuning and optimization or resources experience.
  • Experience performing SQL STIG checks, fix or mitigate any STIG findings, and maintain STIG compliance.
  • Experience formulating policies, procedures, and standards relating to database management.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…