We are looking for a Sr. SQL Server DBA (Min 8 yrs exp) (Candidate must live in VA)(REMOTE) (Webcam interviews ONLY)
POSITION DESCRIPTION
DIRECT CLIENT Position
Number of positions: 1
Length: 11 Months +
Work Address: Clifton Forge, VA 24422
Immediate interviews Webcam interviews ONLY
This position is REMOTE. Candidate must live in Virginia. Candidate must be willing to come to Clifton Forge, VA once every 60-90 days for staff meeting
Candidates must live in Virginia and be able to go to Clifton Forge, VA location to pick up laptop
Candidates must be willing to come to Clifton Forge, VA once every 60-90 days for staff meeting
Please note that Clifton, VA is NOT Clifton Forge, VA!
Microsoft Teams interviews only, must have Webcam for interview, NO exceptions
The Senior SQL Server DBA is expected to take on a full and proactive ownership of the SQL Servers in a virtual environment. This includes development, UAT and production. The DBA is expected to work closely with members of the operations team to provide support and troubleshooting.
Primary Responsibilities Include:
Plan and migrate SQL Server 2012 to SQL Server 2019
Maintain development, UAT and production environments
Monitor systems and proactively manage and maintain configurations to ensure performance, availability, and stability
Perform query optimization, performance tuning, using Performance Monitor, SQL Profiler, Query Store, and other related monitoring and troubleshooting tools
Develop/Perform backups, restores and disaster recovery plans
Ensure High Availability (HA) and Disaster Recovery (DR) for SQL Server
Document and implement changes to databases via proper Change Management methodology
Perform physical and logical database administration functions as required
Ensure integrity of all database components, e.g., Table definitions, structure definitions, statistic and indexes status etc.
Perform MS Service Pack patching procedures
Provide database assistance and problem support to application developers, business analysts, and quality assurance personnel
Required:
Minimum of 8 years of SQL Server database administration in a production environment
Minimum of 4 years of index tuning experience
Strong communication, decision making and interpersonal skills
Strong organizational and time management skill.
Able to work under pressure and take responsibility during situation management
SQL Server Reporting Services; SQL Server Integration Services
Troubleshooting SQL Server database issues
Ability to write complex T-SQL scripts
Technically enthusiastic and a willingness to learn attitude
Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required.
Skill Matrix
Experience with Business workflow processes
Required / Desired
Amount
of Experience
SQL Server database administration in a production environment
Required
8
Years
Index tuning experience
Required
4
Years
SQL Server Reporting Services
Required
4
Years
SQL Server Integration Services
Required
4
Years
Query Store
Highly desired
4
Years
Ability to write complex T-SQL scripts
Required
4
Years
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
Outsourcing/Offshoring
Referrals increase your chances of interviewing at Prohires by 2x