SQL Server Database Administrator

Top tier investment firm in the financial district of Boston.

This is a full time, permanent position.

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 Manager of Database and Architect, 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 30 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
- Spearhead the restructuring and management of the production level backup and restore processes
- Manage HA solutions such as MS Cluster Server, XOSoft, PolyServe, SQL Replication, etc
- Manage DR solutions such as Database Mirroring, Log Shipping, Double-Take GeoCluster, SQL Replication
- Assist in the development of a GDOC (Global Database Operations Center) where our systems will be continuously 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 24x7 support to all mission critical production level systems
- Develop custom scripts to automate various database management processes (e.g. programmatically searching for non-indexed tables)
- Leverage 3rd party tools (e.g. Red-Gate) 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 to SQL Server 2005 and/or 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)
- Assist in the build out of our SQL Server Analysis Services 2005 (SSAS) OLAP databases
- Provide development and production support for complex SSIS packages
- Architect and implement reports within SQL Server Reporting Services 2000/2005
- Define and maintain critical documentation including: Database Standards, Naming Conventions, Administrative Techniques, Troubleshooting Techniques, Processes, Rules and Regulations, Change Management, Best Practices, etc.

MANDATORY REQUIREMENTS
- An average of 5-6+ years total IT experience
- An average of 4-5+ years Database Administration (Includes Development, QA experience)
- An average of 1-2+ years Systems / Network / Application 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.