Database Administrator 2

Database Administrator 2

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.

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.

Candidates must have substantial hands-on experience supporting production database environments and must be capable of working independently and collaboratively on database administration, troubleshooting, security, backup/recovery, system maintenance, and migration activities.