Senior SQL DBA – North of Denver, CO
Responsibilities:
- Responsible for installation, configuration, customization, maintenance and performance tuning of associated server based products including SSIS, SSAS and SSRS.
- Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
- Perform database optimization, administration and maintenance (partitioning tables, partitioning indexes, indexing, normalization, synchronization, job monitoring, etc).
- Establish best practices for T-SQL scripting and encouraging development teams to follow these practices via mentorship and training.
- Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
- Establish and enforce database change management standards including pushes from development to QA, on to production, etc;
- Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
- Proactively stay current with latest technologies and industry best practices associated to the position and responsibilities.
- Assist in the design, finalization and execution of a new multi-tier MS Business Intelligence environment(s).
- Provide development and production support to troubleshoot day-to-day database or related application issues.
- Participate in code reviews , ensuring solutions perform smoothly/optimally and follow best practices.
- Develop processes for system monitoring, storage management, backup and recovery.
- Work with development teams to design/implement marketing database solutions.
- Develop, implement and verify database backup and disaster recovery strategies.
- Maintain physical database models inherent to client specific instances.
Required Skills/Background:
- Strong PROVEN skills/experience in optimization, database sizing, capacity planning, back up, recovery, and automation of database related processes and alerts
- 5+ years of experience as a MS SQL Server Database Administrator managing (at a minimum) SQL - Server 2005 and SQL Server 2008 databases.
- 3+ years of experience managing tools in the MS Business Intelligence Stack (i.e. SSIS, SSAS, SSRS)
- Experience with data warehousing, data integration, data import and relational data modeling
- Knowledge of/experience with SAN technologies and I/O optimization techniques a plus
- BA or BS degree in CS, IT and/or equivalent experience required.
- Expert knowledge of T-SQL, stored procedures and triggers
- Excellent analytic and problem solving skills
- Knowledge of Windows Server 2003/2008
US CITIZENS AND/OR GREEN CARD HOLDERS ONLY CAN BE CONSIDERED FOR THIS POSITION. NO EXCEPTIONS AND NO THIRD PARTY AGENCIES.
Should you be interested in the above-listed position, please email a clean copy of your resume (Word format preferred) to jackie@sorcesolutions.com along with 3-5 available times for a telephone prescreening (30 minutes maximum). In order to ensure a response within 48 hours, please be sure to include the position title in the subject line of your response message.
Should you not be interested the above listed position but know of someone who may be - please feel free to forward this message and please let us know who referred you to ensure the referral program is paid as planned. For other positions, check out our website listings at www.sorcesolutions.com.
If you are looking for a new position and have not sent us an updated resume within the last 6 months - please do so. Having the most up to date information will allow us the opportunity to match you to new/approved positions as soon as they open!
Jacqueline M. Sorce
Owner/President - Sorce Solutions, Inc.
Sign up for our mailing list and receive the latest job notifications at http://www.sorcesolutions.com/subscription.html
