SQL Server DBA Job in Washington, DC

Applied: No

Date Posted: Wednesday, May 17th, 2017
Job Location: Washington, DC
Pay Rate: Market
Employment Type: Contract
Job Duration: Over 1 year
Required Skills: SQL Server DBA Job in Washington, DC

Job Description:

SQL Server DBA Job in Washington, DC. This is a long term contract with a global organization in downtown DC with an amazing atmosphere. The contract is extendable yearly. Apply today!

Description:
This position will provide MS SQL Server Database Administration for key applications supported by ITSWR MS SQL Database Administration Tasks (General Description):
· Install, configure and maintain Microsoft SQL Server 2008/R2 and 2012 in Windows 2008 and Windows 2012 server environment.
· Tune database configuration for optimal system performance.
· Ensure proper setting of system memory and system parameters in consultation with windows administrators
· Strong production experience in managing MS SQL Server clustered environment for mission critical systems
· Create and maintain application databases with optimal data file and log file sizes
· Aid developers in detecting performance problems including analysis of SQL, Transact-SQL, OLEDB and ODBC connections.
· Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments.
· Provide backup and restore functions for MS SQL Server databases
· Develop and maintain DBA scripts supporting the database function using Windows Power Shell scripts
· Periodically refresh development and test databases using copy of production system
· Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary
· Manage the setup of MS SQL Server databases at Business Continuity site
· Configure and manage the database systems as per security guidelines and industry best practices such as SOX, HIPAA, and PCI
· Follow ITIL process in the system administration and need to be familiar with ISO 20000 and ISO 27000 processes
· Maintain highly available SQL Server databases using SQL Database Mirroring Technology and SQL Always-On Technology.
· Maintain highly secure SQL Server databases using SQL Transparent Data Encryption, SQL Line Encryption, and enhanced SQL Server Auditing features
· Strong backup and recovery experience in SQL Server 2008/R2 & SQL 2012
· SQL Server deployment in SharePoint environment is a big plus
· Cloud deployment experience in Microsoft Azure is a big plus

Specific Requirements
· 7 years relevant experience as a DBA in MS SQL Server systems on Windows 2008 clustered platform
· MS SQL Server DBA 2008 certification is a plus
· Proficient in installing and maintain SQL Server clusters for high availability.
· Strong knowledge of Windows Server 2008 and Window Server 2012 operating system environments
· Manage MS SQL Server clusters with good understanding of underlying windows cluster technology
· Tune database configuration for optimal system performance.
· Ensure proper setting of system memory and system parameters in consultation with windows administrators
· Tune database parameters for optimal system performance.

Online Application×
First Name: *
Last Name: *
Email Address: *

Cover Letter *

Resume (300 KB max) *

Application Submitted
Click OK to close this message box
OK
Unexpected Error
An unexpected error occurred while processing your request. Please, try again later or contact us for technical assistance.
Click OK to close this message box
OK
Progress Indicator