SQL Server Developer

Boston based investment management firm.

This is a full time, permanent position.


PRIMARY RESPONSIBILITIES
- 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)

MANDATORY REQUIREMENTS
- 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


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