[Hiring] Senior SQL DBA @A.C. Coy

Role Description

Tier One Technologies is seeking a Sr. SQL Database Administrator with national 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.

• Perform planning, development, implementation, maintenance and support client’s centralized organization for total support of the database environment.
• Execute national production applications on the client’s 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 the client’s management.
• Interact with other client organizations and individuals, such as developers and end users, 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 work varied schedules required by large, diverse and complex client production environment.
• Occasional travel may be required.
• Work independently or semi-independently with a minimum of guidance or direction.

Qualifications

• A degree from an accredited College/University in the applicable field of services is required; if the degree is not in the applicable field, then 4 additional years of related experience is required.
• 15+ years of overall IT experience.
• 10+ years of DBA experience.
• 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.

Requirements

• 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.
  • Familiarity 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.
• DevOps for SQL Server:
  • Familiar with CI/CD pipelines involving SQL deployments (e.g., Azure DevOps, GitLab, Octopus Deploy).
  • Experience with version control for database objects (e.g., Git + SQL Source Control).
  • Support for automated database deployments and schema changes.
  • Familiarity with Infrastructure as Code (IaC) concepts using PowerShell or ARM templates.
• Legacy SharePoint DBA Support:
  • Experience maintaining backend SQL databases for legacy SharePoint environments (2010/2013/2016).
  • Familiar with SharePoint content databases, service application databases, and search indexing structures.
  • Ability to support site migrations, database integrity checks, and performance tuning for SharePoint SQL backends.
  • Collaborate with SharePoint Admins on patching and upgrading activities.
• .NET Application Support on SQL Server:
  • Supported ASP.NET and .NET Core web applications with SQL Server backends.
  • Familiar with connection pooling, application-level query performance, and ORM frameworks like Entity Framework.
  • Ability to trace SQL calls from web apps and optimize database access patterns.
  • Worked with application developers to improve data access performance and scalability.
• General Requirements:
  • Strong documentation skills and adherence to ITSM/ITIL change control practices.
  • Basic PowerShell scripting experience for SQL and system task automation.
  • Must be effective communicator across DB, application, and infrastructure teams.
  • Demonstrate willingness to support on-call rotation and occasional after-hours work.
  • Work on high-visibility, or mission critical aspects of a given program, and perform all functional duties independently.
  • Oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job.
  • Excellent communication skills.
  • Must be able to obtain a Position of Public Trust Clearance.
  • Must be a US Citizen or have US Permanent Residence status (Green Card).
  • Must have resided in the US for the last 5 years and not have traveled outside the US for a combined total of 6 months or more in last 5 years.