SQL Server DBA

Two positions, one is a Full Time permanent position and the otehr is an open ended contract
Downtown Boston location


Overview:
Reporting to the Database Manager, the Senior DBA would be aligned with a development and business division and act as the liaison, providing superior database support, direction and solutions for new and ongoing initiatives. Areas of support/solutions include implementing best practices, performance tuning, problem resolution, environment buildout and database maintenance. The Senior DBA will also be an integral part of the DBA team responsible for project delivery, and contribute to the future vision of the department.

Primary Responsibilities
· Manage a production environment consisting of 300+ databases, and 50+ production SQL Server’s, most of which are read-intensive databases with a large data load cycle while some are OLTP-based mission critical trading systems

· Manage HA and DR solutions including MS Cluster Server, Database Mirroring, Log Shipping and SQL Replication

· Assist in the development of a GDOC (Global Database Operations Center) where our systems will be monitored via 3rd party products, in-house scripts and a operational dashboard

· Manage the database security models, both in-house developed as well as Windows Auth (AD) based security.

· Leverage 3rd party tools (e.g. Red-Gate, Idera) or in-house developed tools to troubleshoot

· Safeguard our production systems by implementing the right security policies as well as managing the MS service pack/hotfix deployment process

· Resolve blocking and deadlocking issues, high CPU / memory, analyze job timeouts, ETL loader performance problems.

· Manage database maintenance jobs to ensure optimal performance and data availability.

· Define and enforce database standards, best practices, methodologies, processes and procedures

· Assist in the build out of our SQL Server Analysis Services 2005/2008 (SSAS) OLAP databases

· Provide development and production support for complex SSIS packages

· Architect and implement reports within SSRS 2005/2008

· Research new technologies to enhance performance, heighten security, ensure uptime, automate common/redundant administrative duties


Mandatory Requirements
· An average of 5-6+ years Database Administration

· Knowledge of the financial industry is preferred

· Experience with managing and implementing High Availability (HA) solutions for SQL Server 2005/2008

· Experience with managing and implementing DR solutions for SQL Server 2005/2008 (e.g. DB Mirroring, SAN replication, etc)

· Database monitoring software (e.g. Idera, HP Openview, SiteScope, etc) and advanced monitoring techniques

· Experience with VLDB’s - 100+ GB databases, hundreds of DB’s in a highly transactional environment

· Well versed in query performance analysis, improvements and troubleshooting performance degradation

· Experience with resolving complex blocking and deadlocking issues and automated ways of doing so

· Strong knowledge of SQL Server internals and performance tuning methodologies

· Experience with security as it pertains to databases (permissions, users, roles, policies, etc)

· Experience writing comprehensive and descriptive documentation

· Understanding of the database development lifecycle, including database creation, table design, etc.

· Familiar with ETL tools and processes, primarily with SSIS 2005/2008, Informatica, DTS

· Experience supporting the development and deployment of complex SSIS packages

· Experience with architecting and implementing reports within SQL Server Reporting Services 2005/2008

· Experience in the management of OLAP databases, most specifically with SSAS 2005/2008

· Solid grasp of primarily T-SQL


Please contact Albert Barsoumian with qualified resumes via email at albert@collabstaff.com or via phone at 508-872-7402