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.