Job Title: SQL Server/Azure Database Administrator Location: Richmond, VA Duration: 11+ Months Interview: In Person Only Must be able to work on site 3 days a week initially
Job Description: The Client is seeking a senior SQL Server database / Azure database administrator to join the Oracle/SQL Server Database Administration Team in the Enterprise Data Management section. The selected candidate will administrator and support SQL Server databases throughout the agency.
The selected candidate has:
- Expertise working as a SQL Server DBA
- Expertise working with SQL clustering, mirroring and high availability
- Experience working with large SQL databases
- Expertise in writing Transact SQL
- Experience tuning Oracle and/or SQL Server databases
- Expertise in installing, upgrading, patching and migrating SQL Server databases
- Experience working on Windows environment
- Experience working with SSIS, SSAS, & SSRS
- Experience working with Azure Cloud
The selected candidate will:
- Monitor databases to maintain/ensure database uptime and availability.
- Troubleshoot application/database issues related to connectivity, access, security and etc.
- Tune long running SQL
- Review & refine existing database tasks and processes to better align with agency/group priorities.
- Leverage & utilize O/S scripting utilities in support of database maintenance/diagnosis/support.
- Review the existing database implementation and propose, execute, and/or direct necessary changes.
- Perform SQL Server installations (2012, 2014, 2016 w/ failover clustering).
- Support SQL Server databases (administration, support, tuning).
- Knowledgeable of data modeling principals
Be expected to
- Rely on experience and judgment to plan and accomplish goals.
- Independently perform a variety of complicated tasks.
- Work with a team of Oracle & SQL Server DBAs.
- Communicate clearly and effectively, both speaking and in writing.
Qualifications:
- At least 5 years of experience w/ SQL Server database experience
- At least 2 years of Azure experience
- Bachelor's Degree in Computer Science, Information Systems or other applicable and/or equivalent skills, knowledge and/or work history
- Demonstrated experience in communicating effectively using standard requirements and design artifacts
Desired knowledge of and experience with the following technologies:
Required/Desired Skills:
- SQL Server Database Management
- SQL Server Tuning
- Experience working with SSIS,SSRS & SSAS
- Coding & debugging Transact SQL
- Expertise in installing, upgrading, patching and migrating SQL Server databases
- DB Administration on Azure Cloud