Database Administrator 2

TOMORROW HIRE•Richmond, VA

13h•Onsite

About The Position

We are seeking an experienced Database Administrator 2 to support its Microsoft SQL Server environment and assist with a major database migration initiative. This on-site contract opportunity is based in Richmond, Virginia, and requires a database professional with strong hands-on experience in production database administration, troubleshooting, backup and recovery, database security, system maintenance, and migration support. The Database Administrator 2 will support the migration of existing databases from a current hosted platform to a new hosted platform while providing day-to-day operational support for the organization's SQL environment. The role will assist with database migration activities, post-migration system validation, database administration, architecture, troubleshooting, backup and recovery, monitoring, updates, and break/fix incident response. The SQL environment operates on a dedicated high-performance hardware platform and includes SQL Server versions ranging from 2008 through 2019. The organization also maintains a small Oracle footprint; however, Microsoft SQL Server is the primary focus of this position. This resource will help maintain daily database operations while freeing the dedicated DBA to focus primarily on project and migration work, including the current initiative to transition from end-of-life database hardware to a new solution.

Requirements

Substantial hands-on experience supporting production database environments.
Capable of working independently and collaboratively on database administration, troubleshooting, security, backup/recovery, system maintenance, and migration activities.
5+ years of experience administering and managing production databases.
5+ years of basic through advanced troubleshooting experience.
5+ years of experience with database backup, recovery, and monitoring.
5+ years of experience communicating in a team environment with technical peers and customers.
5+ years of experience performing security assessments and reviews related to database administration and access.
5+ years of experience designing, configuring, deploying, troubleshooting, administering, and maintaining systems.
5+ years of experience ensuring project and workload documentation and processes are accurate, timely, and properly stored.
Considerable working experience with Microsoft SQL Server database administration.
Knowledge of moving or migrating databases between hosted platforms.
Experience with system validation following database migrations.
Working knowledge of backing up and restoring production databases.
Must be able to work 100% on-site at the designated Richmond, Virginia work location.
Must physically reside within the United States for the duration of the assignment in accordance with Commonwealth of Virginia security policies.
Must be legally authorized to work in the United States without employer sponsorship, now or in the future.

Nice To Haves

Experience administering or supporting Oracle databases is preferred due to the organization's small Oracle footprint.

Responsibilities

Administer and manage production database environments.
Provide day-to-day administration and operational support for Microsoft SQL Server environments.
Support SQL Server versions ranging from 2008 through 2019.
Perform basic through advanced troubleshooting of database and system issues.
Provide break/fix incident response for the SQL environment.
Perform database backup, recovery, restoration, and monitoring activities.
Support production database backup and restore operations as required.
Design, configure, deploy, troubleshoot, administer, and maintain database systems and related environments.
Assist with migrating existing databases from the current hosted platform to a new hosted platform.
Support database moves and migrations from end-of-life hardware to the new solution.
Perform system and database validation following migration activities.
Identify and troubleshoot database-related issues during and after migrations.
Support database updates, restores, and recovery activities when required.
Perform security assessments and reviews related to database administration and access.
Support appropriate database access controls and security practices within the production environment.
Assist with maintaining secure and reliable database operations.
Communicate effectively within a team environment, including with technical peers and customers.
Collaborate with the dedicated DBA and other stakeholders to support operational and project requirements.
Ensure project and workload documentation is accurate, completed on time, and stored appropriately.
Maintain clear documentation of relevant processes and database administration activities.
Maintain database availability and operational stability during ongoing migration and project activities.
Handle routine database administration and break/fix responsibilities to support the dedicated DBA's project workload.
Assist with the organization's small Oracle database footprint when applicable.