Bachelor's degree in a relevant field or 4 additional years of relevant experience if the degree is in another field.
15+ years of overall IT experience.
10+ years of DBA experience with a strong focus on SQL Server.
8+ years of experience as a SQL Server DBA in production environments.
Proficiency in SQL Server 2016/2019/2022 and associated management tools.
Strong grasp of database recovery models with experience in disaster recovery procedures.
Responsibilities
Plan, develop, implement, and maintain the client's database environment.
Create and manage project plans and provide weekly status updates.
Develop operational and functional standards and procedures.
Intervene to resolve issues while collaborating with developers and end users.
Provide 24x7 support, including on-call responsibilities.
Work with minimum guidance, ensuring independence in task execution.
Benefits
100% remote work opportunity.
Support provided for obtaining necessary federal clearance.
Engagement in high-visibility and mission-critical projects.
Flexible scheduling considering client needs.
Full Job Description
Overview
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.
Responsibilities
Perform planning, development, implementation, maintenance and support client's 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 the client's 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.
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.
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.
