SQL Server DBA Lead (4 positions)

1. LEAD experience - Must be a leader, will be a supervisor over 4 jr/mid DBAs.

2. TSQL - to build stored procedures

Job Description:

We are in need of a team to provide off-hour support for a large portion of its SQL Server and Oracle database environment. This Lead SQL Server DBA is being brought in to supervise the off-hour support team but still needs to be hands-on. Estimated 60/40 split of leadership to hands-on.

Responsibilities will include:

• Serve as single onsite POC for management team, as well as for 1st level escalations from off-hour support team.
• Will aid in status updates and reporting to management team.
• Provide nightly DBA duties as assigned by management for SQL Server environment, including execution activities on the SQL Server upgrade project.
• Work with application owners and app developers on production support issues, releases to production from development, etc.
• Application troubleshooting and support as it pertains to performance tuning.
• Assist with the SQL Server Upgrade from 2008 -2012, but will not be solely dedicated to the project.
• Must be able to work with Active/Active Clusters and ideally have experience with conversions within clustered environments.
• Use tuning tools to improve database performance.

Additional Information:

This lead will work 1st shift hours while being trained in the first month. Once the off-hour support team has been established, the Lead will move into 3rd shift hours.

Schedule: Wednesday - Saturday nights from 7pm -7am.

This is a production environment, so actual system conversions are done on nights/weekends. Extensive production issue resolution will need to be handled.

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

Fast-paced environment with intense deadlines; will have on-call and production support on weekends/off hours.

Interview Information:

Phone Screen (2/20)

In-person with team. F2F.

Business Challenge:
Client is moving to a 24/7 support model for RMAS in support of the SQL Server upgrade initiative. 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 FTEs will focus on the upgrade while this team will backfill any other DBA duties performed off hours.

EVP:
The opportunity to work for one of the top 5 Healthcare insurance companies in the US and potentially grow into a management role within one of the largest SQL Server environments in DFW. Ability to support a 1000+ SQL Server DB environment and be part of a SQL Server Upgrade; opportunity to gain more advanced knowledge of performance tuning within an enterprise MS environment. Long-term opportunity and the start of a new practice.

Non-Technical Skills:
This person must be a leader, a problem solver with good analytical skills. Someone who is committed to building out this team and taking control of its growth. Communication skills are important; detail-oriented with a high sense of urgency.

Why is the position open?:
Client 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.

Technical Environment:
SQL Server 2005, 2008, 2012

GC or USC. H1B only to be on our payroll as per client's stipulation.

All your information will be kept confidential according to EEO guidelines.