Position: Sr. Database Developer
Location: Boston, MA Area
Up to $100K DOE + Bonus
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

Position Responsibilities - Summary:
The Data Technologies team is responsible for supporting and architecture of
a global SQL environment. Responsibilities would encompass day-to-day
administration, daily maintenance, optimization tasks and assisting
application developers. The team also provides support to all vendor and
packaged applications that use SQL Server as a backend.

Reporting to the Manager of IT Data Technologies, this senior level
Developer would assist in providing world-class support and leadership to
application support and business teams.

Position Responsibilities - Detailed:
- 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
- Understanding of the database development lifecycle, including
database creation, table design, etc.
- Familiar with ETL tools, primarily with SSIS 2005 however
Informatica, DTS, Ab Initio is a plus
- Experience supporting the development and deployment of complex
SSIS packages
- Experience with architecting and implementing reports within SQL
Server Reporting Services 2000/2005 / 2008
- Understanding of Front-End Applications and Middle-Tier Systems
(.NET, COM+, etc)
- Experience with VLDB’s - 100+ GB databases, hundreds of DB’s in a
highly transactional environment
- Expertise with query performance analysis, improvements and
troubleshooting performance degradation
- Familiar with the new facets of SQL Server 2005 / 2008 (e.g.
table partitioning, mirroring, full-text management, indexed views, security
management, etc)
- Experience with resolving complex blocking and deadlocking issues
and automated ways of doing so
- Experience with security as it pertains to databases
(permissions, users, roles, policies, etc)
- Experience writing comprehensive and descriptive documentation
- Solid grasp of primarily T-SQL, however experience in .NET
(C#/VB) will not be discounted
- 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
- Assist in the migration of SQL Server 2000 to SQL Server 2005 and
SQL Server 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, etc
- Enforce our database standards, best practices, methodologies,
processes and procedures, 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
- Research new technologies to enhance performance, heighten
security, ensure uptime, automate common/redundant administrative duties
- Define and maintain critical documentation including: Database
Standards, Naming Conventions, Administrative Techniques, Troubleshooting
Techniques, Processes, Rules and Regulations, Change Management, Best
Practices, etc.
- Knowledgeable about operating systems (e.g. Windows 2003 and
2008)

Required Skills and Competencies:
- An average of 10+ years total IT experience
- An average of 8-10+ years SQL  Development experience
- Knowledge of the financial industry is preferred

Candidate Characteristics:
- Impeccable verbal and written communication skills
- Highly ambitious individuals with the desire to go above and
beyond
- Detail-oriented with very strong organizational skills
- Ability to work effectively and efficiently with little or no
supervision
- Strategic, structured, and focused thinker who has strong
analytical and problem solving skills
- Highly motivated, positive and passionate about the work they do
- Extremely strong interpersonal skills
- Strong accountability and results orientation
- Highly professional demeanor with well rounded business acumen
- Ability to work and quickly react in a fast paced environment
- Ability to effectively translate technical jargon into business
terms during face to face customer interactions
- Ability to make powerful split second decisions
- Ability to perform self and team project management (prior
technical leadership roles)
- Ability to scope projects, create project plans, and manage
deliverables & deadlines
- Ability to productively multi-task

Contact Information:
Gary Wright - President - Wright Associates
Phone - (508) 761-6354
Email - replywrightassociates AT verizon DOT net
Website -www.wrightassociates.org