SQL DBA (Remote) at A.C. Coy

Washington, District of Columbia, United States -

Full Time

Start Date

Immediate

Expiry Date

09 Jan, 26

Salary

0.0

Posted On

11 Oct, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server DBA, T-SQL, SSMS, Backup and Restore, Disaster Recovery, High Availability, Performance Tuning, Database Design, Documentation, Communication Skills, Always On Availability Groups, SQL Monitoring, Index Tuning, Execution Plans, Storage Capacity Planning, Database Lifecycle Management

Industry

Information Technology & Services

Description

Overview Tier One Technologies is seeking a SQL Database Administrator with production environments experience to support our US Government client. This is going to be a 100% remote position. SELECTED CANDIDATES WITHOUT REQUIRED CLEARANCE WILL BE SUBJECT TO A FEDERAL GOVERNMENT BACKGROUND INVESTIGATION TO RECEIVE IT. Responsibilities Perform planning, development, implementation, maintenance and support client’ centralized organization for total support of the database environment. This includes executing national production applications on the Client' large, complex and widely distributed Microsoft NT operating system environment and Local Area Network (LAN) infrastructure throughout the United States. Develop and maintain the project plans in accordance with Client’s standards. Weekly status reporting will be required. Develop standards and procedures, both operational and functional. Perform other duties in support of the organization’s mission as directed by FCSC/DSS management. Interact with other client organizations and individuals, such as developers and end users, in order to understand applications and resolve problems. Support different shifts to enable 24x7 support; may be required to carry a pager and be on call and be required to work varied schedules required by large, diverse and complex client production environment. Travel may be required. Qualifications Bachelor’s Degree in Computer Science or associated discipline preferred 8+ years of experience as a SQL Server DBA in production environments. Proficiency in SQL Server 2016/2019/2022 (T-SQL, SSMS, Agent Jobs, Maintenance Plans). Experience with backup and restore strategies, including full, differential, and transaction log backups. Strong understanding of database recovery models and point-in-time recovery. Ability to create and maintain database documentation and operational runbooks Disaster Recovery & High Availability: Hands-on experience with Always On Availability Groups and/or SQL Server Failover Clustering Knowledge of Log Shipping and Database Mirroring Familiarity with backup encryption and offsite retention strategies Participated in and supported DR drills and contingency planning SQL Monitoring & Performance Tuning: Skilled in performance troubleshooting using SQL Profiler, Extended Events, and DMVs Ability to identify and resolve deadlocks, blocking, and slow-running queries Experience tuning indexes, reviewing execution plans, and maintaining stats Familiar with SQL monitoring tools (e.g., Redgate, SolarWinds DPA, Sentry One) Architecture & Design: Understanding of normalized and denormalized schema design Experience with table partitioning, filegroups, and database file I/O planning Participated in storage capacity planning and database lifecycle management Supports scalability and performance through smart database design decisions Willingness to support an on-call rotation and occasional after-hours work. Excellent communication skills. Must be able to obtain a Position of Public Trust Clearance. All candidates must be a US Citizen or have permanent residence status (Green Card). Candidate must have lived in the United States for the past 5 years. Cannot have more than 6 months travel outside the United States within the last 5 years. Military Service excluded.

Responsibilities

The SQL DBA will perform planning, development, implementation, maintenance, and support for the database environment. This includes executing national production applications and interacting with other client organizations to resolve problems.