At a Glance
- Tasks: Manage and support Microsoft SQL Server databases while assisting with a major migration project.
- Company: Join a dynamic team in Richmond, VA, focused on innovative database solutions.
- Benefits: Competitive pay rate of $45 – $65 per hour with a 6-month contract.
- Other info: 100% on-site role; local candidates preferred for this exciting opportunity.
- Why this job: Gain hands-on experience in database administration and migration in a collaborative environment.
- Qualifications: 5+ years of experience in database management and troubleshooting required.
The predicted salary is between 65 - 65 £ per hour.
- Pay Rate : $45 – $65 per hour
- Industry Category : Information Technology
- Overview
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.
Candidates must physically reside within the United States for the duration of the assignment and must be able to work 100% on-site at the provided Richmond, Virginia work location.
Candidates will be required to confirm their current city and state and their ability to meet the on-site requirement.
Job Description
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
- Database Administration & Technical Support
- 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.
- Database Migration & Validation
- 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.
- Security & Access Administration
- 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.
- Collaboration & Documentation
- 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.
- Operational Support
- 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.
Requirements
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.
- Minimum Qualifications
- 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.
- Preferred Qualifications
- Experience administering or supporting Oracle databases is preferred due to the organization's small Oracle footprint.
Compensation
- This is a 1099 Contract role.
- Pay Rate: $45 – $65 per hour.
- Schedule
- Assignment Duration: 6 months
- Work Arrangement: 100% on-site
- Candidates must be available to work at the designated Richmond, Virginia worksite.
- Work Location
- Richmond, VA
- This position is 100% on-site.
- Local candidates are strongly encouraged.
- Candidates must confirm that they are able to work on-site at the provided location for the duration of the assignment.
- #J-18808-Ljbffr
Database Administrator 2 in Richmond employer: TOMORROW HIRE
As a Database Administrator 2 in Richmond, VA, you will join a dynamic team dedicated to supporting a major database migration initiative within a collaborative and innovative work culture. The company offers competitive pay rates, opportunities for professional growth, and a commitment to maintaining a secure and efficient SQL environment, making it an excellent employer for those seeking meaningful and rewarding employment in the IT sector.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator 2 in Richmond
✨Get Social in the Data World
Join online communities like Stack Overflow or Reddit's r/Database to connect with others in database management. Share your insights and ask questions to get noticed by industry insiders who might know of temporary roles!
✨Showcase Your Skills
Create a small project using the database software you’re familiar with—maybe something fun like a personal book or music database. Having a project to demonstrate will make you stand out to companies like TOMORROW HIRE when they see your hands-on approach!
✨Utilise Temporary Staffing Agencies
Many temp positions in database management are filled through staffing agencies. Get in touch with agencies that focus on tech roles, and let them know you're on the lookout for short-term opportunities. They can be a great bridge to finding your next gig.
✨Direct Applications are Key!
Don’t shy away from applying directly to TOMORROW HIRE through our website. Temporary roles often get posted without fanfare, so check back frequently, and don’t hesitate to reach out if you see a position that fits your skills!
We think you need these skills to ace Database Administrator 2 in Richmond
Some tips for your application 🫡
Highlight Your Technical Skills:In the world of database management, it’s essential to showcase your technical skills upfront. Make sure your CV includes relevant programming languages, database systems you’ve worked with, and any data modelling tools you’re familiar with. We want to see how your skills align with the needs of TOMORROW HIRE.
Document Your Projects:If you have completed any database projects, don’t forget to mention them! Include specific examples that demonstrate your problem-solving abilities and your experience with data migration or optimisation. Having a portfolio or a section on your CV detailing these projects can really set you apart in a temporary role.
Express Your Flexibility:Since this is a temporary position, it’s key to highlight your adaptability in your cover letter. Let us know that you’re ready to jump into different tasks and tackle challenges as they arise at TOMORROW HIRE. This shows that you’re not just looking for another job, but you’re excited about contributing to our team.
Keep it Concise:For a temporary role like this, keep your application concise and focused. Use bullet points to list your relevant experience and skills, making it easier for us to absorb the info quickly. Your aim should be to grab attention without overwhelming us with unnecessary details. And remember, submit your application through our website!
How to prepare for a job interview at TOMORROW HIRE
✨Get Hands-On with Tools
In database management, it’s crucial to be familiar with the tools of the trade like SQL, NoSQL, or even data visualisation software. Make sure you’ve got some practical examples ready to discuss how you’ve used these tools, and maybe even try to whip up a sample database to share in a discussion. This shows you're not just theory, but can get stuck in.
✨Brush Up on Technical Questions
Expect some technical questions that dive deep into your problem-solving skills. Be prepared to tackle scenarios where you might need to optimise a database query or explain data normalisation. This is a key area for database management roles, and demonstrating your understanding here can set you apart from other candidates.
✨Show Your Flexibility and Adaptability
Since this is a temporary role, showcasing your flexibility is key. Be ready to discuss past experiences where you quickly adapted to new systems or tasks. Emphasise your eagerness to hit the ground running and how easily you can familiarise yourself with the company’s database systems. Companies love a candidate who can dive right in without unnecessary handholding!
✨Pitching Yourself and Your Availability
In a temporary role, your availability is crucial. Be upfront about your schedule and how you can commit to the temporary demands of the job. Plus, don’t forget to express your keen interest in learning and contributing to TOMORROW HIRE—they’ll appreciate your enthusiasm for both the role and their team!
