SQL Server Database

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

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)

• Good comm skills are a big priority
• Duration: 6+ Months
• Candidate must have excellent verbal and written communication skills.

•

Interview Information:

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