Sr. SQL Server DBA - Investment Management - Boston, MA Area - Outstanding Package

From: Gary W.
Sent on: Friday, January 13, 2012 4:31 PM
Please feel free to refer this position to your associates – Referrals
appreciated.

Position Title – WRCGSSSDBA012012

Sr. SQL Server DBA – Investment Management - Boston, MA Area – Outstanding
Package

Excellent Base + Bonus + Ret + Comprehensive Benefits - Excellent total
package

Local Candidates Only – No Sponsorship

Company

Mid-Sized, successful, and growing Boston based global investment management
company – Great Company – Lots of Upside – Excellent Compensation Package –
Bonus – Retirement – Comprehensive Benefits

Looking for the Best of the Best.

Position Summary:

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 that use SQL server as a backend.

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 build out 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. 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
·         Research new technologies to enhance performance, heighten
security, ensure uptime, automate common/redundant administrative duties
·         Assist in the re-architecting of the organization’s Share Point
Site.

Required Skills and Competencies:

·         An average of 6-8+ years total IT experience
·         An average of 5-6+ years SQL Server Database Administration in a
complex, global, 24x7, mission critical environment
·         Knowledge of the Investment Management Industry is required
·         Ability/experience/s­kills to meet the majority of all of the
responsibilities listed above

Contact Information – (Resumes in Word format please)

Gary Wright - President – Wright Associates

Phone - (508)[masked]

Email  - [address removed] - WEB Site –
www.wrightassociates­.org

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy