Job Title: SQL DBA (41615-THAIAR-IOM-E-ARI)

Location: Washington, DC

Duration: 6+ months

Emp. Type: W2 / 1099

 

REQUIRED SKILLS:
-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.
-Strong backup and recovery experience in SQL Server 2008/R2 & SQL 2012

NICE TO HAVE SKILLS:
-SQL Server deployment in SharePoint environment is a big plus
-Cloud deployment experience in Microsoft Azure is a big plus

RESPONSIBILITIES:
-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

 

 

 

 

 

 

To Apply, Please click here: APPLY NOW