Senior SQL Server Database Administrator in Ridgecrest, CA at DCS

Date Posted: 5/21/2020

Job Snapshot

Job Description

DCS Corp. is looking for an experienced Senior SQL Server DBA to join the F/A-18 & EA-18G Integrated Product Team (IPT).

Essential Job Functions:

Collaborate with software developers, system operators, administrators and other IT staff members to support software development projects and the IPT’s IT infrastructure.

Support infrastructure projects and processes.

Develop advanced SQL scripts for data extraction from SQL Server databases.

Create data structuring/mapping, the process of defining data types and the connections between them.

Maintain responsibility for completion and accuracy of work products.

Create and manage multiple databases and assist in capacity planning and requirement gathering.

Monitor, maintain database systems and troubleshoot problems that may arise.

Maintain data integrity and security (manage roles and permissions of database users).

Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.

Develop strategies and implement solutions for managing back-ups, restoration and replication.

Create and manage constraints and indexes.

Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.

Manage production, QA and development database environments.

Create detailed documentation including diagrams of database infrastructure.

Learn relevant business processes and understand the data flow, criticality and dependencies.

Coordinate and communicate with all the stakeholders (internal teams and clients) effectively.

Set up and maintain database infrastructure for the organization’s Business Intelligence (BI) needs.

Required Skills:

Due to the sensitivity of customer related requirements, U.S. Citizenship is required.

High school diploma/GED plus 20 years of experience, or Associate's-level (AA/AS/Technical school) plus 14 years of experience, or a Bachelor degree in an IT field with 12 years of experience, or equivalent and relevant certifications.

Obtain and maintain a Security Clearance for the duration of employment.

A minimum of 7 years of experience with Database Administration, specifically working with Microsoft SQL Server (MS SQL Server).

Experience with Microsoft infrastructures, MS SQL Server (2014/2017), agile software development (Scrum/SAFe).

Ability to build and maintain the MS SQL Server database infrastructure.

Experience with database installation and configuration, backup management and disaster recovery.

Able to assist developers to configure database instances, code deployment, and user access management.

Practical experience in managing internal and external Microsoft SQL Server database security.

Experience with Always-On Availability Groups, Replication, Log Shipping, and Database Mirroring, High Availability, Business Continuity, and Clustering, database optimization.

Knowledge of SQL Service Broker.

Up-to-date on the latest industry trends; able to articulate trends and potential clearly and confidently.

Good interpersonal skills and communication with all levels of management.

Able to multitask, prioritize, and manage time efficiently.

Desired Skills:

Knowledge of and experience with Federal security regulations, standards, DoD STIGS and processes including FISMA, FIPS, NIST, and FedRAMP.

Microsoft Certifications: Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Expert (MCSE), Microsoft Technology Associate (MTA): Database Fundamentals SQL Certification, Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development Certification, Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration Certification.

T-SQL, PS, SSIS, SSRS highly preferred.

CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs