Inforeem Job Portal

SQL Database Administrator - DC

Location: Washington, DC
Date Posted: 02-14-2018
or
SQL Database Administrator
Washington DC

W2 Only !
Any Visa type okay

5 years experience

Install, configure and maintain Microsoft SQL Server 2008 R2 and SQL Server 2012 in Windows 2008 and Windows 2012 server
• Tune database configuration and parameters 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
• Assist 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 24001 processes
• Maintain highly available SQL Server databases using SQL Database Mirroring 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

Educational Qualifications and Experience:
• Education: Bachelor’s degree in Computer Science, IT, or STEM related fields
• Role Specific Experience: 5+ years of relevant experience as a DBA in MS SQL Server systems on Windows 2003 clustered platform
• Strong production experience in managing MS SQL Server clustered environment for mission critical systems
• Advanced experience in backup and recovery in SQL Server 2008 R2 and SQL Server 2012

Certification Requirements:
• MS SQL Server DBA 2008 certification is a plus

Required Skills/Abilities:
• Proficiency in installation and maintenance of SQL Server clusters for high availability
• Advanced knowledge of Windows Server 2008 and Window Server 2012 operating system environments
• Advanced understanding of underlying windows cluster technology

Desired Skills/Abilities (not required but a plus):
• SQL Server deployment in SharePoint environment
• Cloud deployment experience in Microsoft Azure

• Good technical documenting skills
• Level II - 5+ years of experience

this job portal is powered by CATS