Sr + Mid SQL Server DBA

Top tier investment firm in the financial district of Boston.

There are 2 open positions, one is senior and one is mid level.

These are full time, permanent position. No sponsorship available. Must be local candidates.

Department Profile:

The Database Administration and architecture team is responsible for supporting and architecture of a global SQL environment. Responsibilities would encompass day-to-day administration, daily maintenance and optimization tasks and assisting developers in the creation of new databases. The team also provides support to all vendor and packaged applications which use SQL server as a backend.

Overview:

Reporting to the Database Manager, this Senior level DBA would assist in providing world class support and leadership to our developers, application support and business teams.

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. Also develop policies to restrict over-privileging and enforce it
- Provide second tier support on-call rotation to all mission critical production systems
- Develop custom scripts to automate various database management processes
- 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
- Assist in the migration of SQL Server 2000/2005 to SQL Server 2008
- Assist in the database release management process, be the “gate-keeper” and ensure only QUALITY code is released into production
- Help troubleshoot performance problems using a variety of methods (tracing, query optimization review, error logs, etc)
- 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

MANDATORY REQUIREMENTS
- An average of 6-8+ years total IT experience
- An average of 5-6+ years Database Administration
- Knowledge of the financial industry is preferred


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