SQL Server Database

Job Description:

HCSC is in need of a team to provide off-hour support for a large portion of its SQL Server and Oracle database environment. These Jr DBA's are being brought in to provide off-hour support for a SQL Server upgrade project as well as a Retail IT project.

Responsibilities will include but not be limited to the following:

Performing upgrades on databases (SQL Server 2008-2012)

Executing backups, refreshes and restores to existing production environments

Executing scripts and monitoring production releases

Representing DBA group during application and/or technology releases; this sometimes entails multi-hour conference calls where the DBA will execute change orders at some point in the call

Will aid in status updates and reporting to Lead DBA and HCSC management team.

Provide other nightly DBA duties as assigned by HCSC management for SQL Server environment.

Working with application owners, as well as app developers on production support issues, releases to production from development, etc..

Application troubleshooting and support as it pertains to performance tuning

Brought in to help with the SQL Server Upgrade from 2008 -2012, but will not be solely dedicated to the project.

Additional Information:

This is a huge opportunity for a Jr level resource, striving to become a DBA, to gain a tremendous amount of experience in one of the largest and most complex SQL Server (and overall IT) environments in the Dallas market. We are looking for resources who are passionate about doing whatever it takes to support the team and overall success of the project. The years of experience are far less important than the candidate's desire to grow professionally as well as technically. The 1-3 years experience is a benchmark; we are willing to look at all levels of candidates, provided they meet the overall criteria laid out in the requirement.

The current scope of work includes the SQL Server environment, but eventually the other RDBMS platforms could come into play (DB2, Oracle, Teradata, Mongo etc.) so any experience with multiple RDBMS would be a plus.

Work Environment:

Very fast paced, intense deadlines from time to time; will have on-call and production support on weekend/off hours

Who is the Internal/External Customer:

http://rws.allegisgroup.com/RWS/images/callout_question.gif

customers will be application owners internal to BCBS

Impact to the Internal/External Customer:

http://rws.allegisgroup.com/RWS/images/callout_question.gif

Production environment, SLA's are in place for uptime on apps and databases, some if not most of the apps being down, cost BCBS revenue

Business Challenge:

HCSC is moving to a 24/7 support model for RMAS in support of the SQL Server upgrade initiative and there is a need for a team to provide off-hour support for a large portion of its SQL Server and Oracle database environment. Internal FTE's will be focused on the upgrade while this team will be a backfill for any other DBA duties performed off hours.

EVP:

http://rws.allegisgroup.com/RWS/images/callout_question.gif

The opportunity to work for one of the top 5 Healthcare insurance companys in the US and potentially grow within one of the largest SQL Server enviornments in DFW. Ability to support a 1000+ SQL Server DB environment and be apart of a SQL Server Upgrade; opportunity to gain more advanced knowledge of performance tuning etc, within an enterprise MS environment. Long Term opportunity and the start of a new practice.

Non-Technical Skills:

A problem solver with good analytical skills. Someone who is committed to supporting this team and a passion to grow professionally and technically. Communication skills are important; detail oriented with high sense of urgency.

Why is position open?:

Need Additional resource for - 24/7 support model for RMAS in support of the SQL Server upgrade initiative and there is a need for a team to provide off-hour support for a large portion of its SQL Server and Oracle database environment.

Project Stage/Lifecycle Info:

Full Lifecycle

Technical Environment:

SQL Server 2005, 2008, 2012

1. 1-3 years of SQL Server Database experience - As a DBA

2. Tier 1/Tier 2 Database Support

3. Ability to work off-hour shift (TBD: 7pm - 7am or 1pm - 10pm: Wed - Saturday)

1. Good comm skills are a big priority
2. Duration: 6+ Months

3. Candidate must have excellent verbal and written communication skills.

4. Interview Information:

• In person interview/IOI Abby Loftus
• Meet with Melissa Cornwell