SQL Database Administrator

Client Solution Architects; Pensacola (FL); On-site; USD 90,000 - 120,000; Full time

Job summary

Client Solution Architects is seeking a SQL Database Administrator to support a program onsite in Pensacola, FL. The role focuses on implementing, configuring, maintaining, and optimizing SQL servers critical to Navy corporate applications.

You will manage databases across lifecycle stages, tune performance, implement data models, and mentor peers while ensuring security and reliability. Strong communication and security clearance are required.

Qualifications

• 2+ years MS SQL Server Administration experience.
• Ability to obtain and maintain an active Secret Clearance.
• Experience with Performance Tuning and Optimization (PTO) using native tools.
• Experience with backups, restores and recovery models.
• Experience with Windows server environments and Active Directory.
• Excellent written and verbal communication.

Responsibilities

• Manages SQL Server databases through development to production environments.
• Configures and maintains database servers, monitors health, performance, security.
• Applies data modeling techniques for integration and performance.
• Analyzes, resolves issues in real time, end-to-end.
• Writes and optimizes T-SQL statements.
• Designs and maintains stored procedures, functions, views, indexes, and triggers.
• Automates regular processes, tracks issues, and documents changes.
• Assists developers with query tuning and schema refinement.
• Performs scheduled maintenance and release deployments.
• Mentors peers and shares technical expertise.
• Improves performance via hardware, server changes, or index/query changes.
• Develops profiler traces to identify frequently run queries.

Skills

MS SQL Server Administration

Performance Tuning

T-SQL

Query Optimization

Backup & Recovery

Windows Server

Active Directory

Communication

Secret Clearance

Education

Bachelor's degree

BS in IT related field

Tools

SQL Server 2012/2014/2016

Active Directory

Job description

Description

Client 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.

Job Type

Full-time

Description

Client 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.

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.

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 workstation
• Use hands and fingers to operate keyboards, mice, and other input devices
• Communicate effectively, both verbally and in writing
• Specific vision abilities required may include close vision, distance vision, depth perception, and the ability to adjust
• Stand, walk, bend, or reach; Access equipment located in data centers, offices, or under desks
• Lift and/or move equipment weighing up to 25 pounds

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions, in accordance with the Americans with Disabilities Act (ADA).