Role Overview
Tier One Technologies is seeking a Sr. SQL Database Administrator with national production environments experience to support our US Government client. This is a 100% remote position.
What You Will Do
Perform planning, development, implementation, maintenance and support client's centralized organization for total support of the database environment. Develop and maintain project plans, develop standards and procedures, and perform other duties in support of the organization's mission.
Why It Might Be a Fit
Must have 15+ years of overall IT experience, 10+ years of DBA experience, and 8+ years of experience as a SQL Server DBA in production environments. Proficiency in SQL Server 2016/2019/2022, experience with backup and restore strategies, and strong understanding of database recovery models and point-in-time recovery.
Requirements
- Degree from an accredited College/University in the applicable field of services
- 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
- Experience with backup and restore strategies
- 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
- 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
Benefits
- 100% remote position
- Opportunity to work with a US Government client
- Position of Public Trust Clearance
- US Citizenship or US Permanent Residence status (Green Card)
- Residency in the US for the last 5 years
