SQL Server DBA Lead (4 positions)

Atria Group LLC
Richardson, TX, United States
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$83,200.0 - $124,800.0
Working hours
Shift work

Tech stack

IBM DB2 Relational Databases Microsoft SQL Server MongoDB Oracle Databases Oracle (Applications) Performance Tuning Teradata SQL Database Performance

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. This will include execution activities on the SQL Server upgrade project, as well as backfilling for existing employees working on the SQL Server Upgrade Project.
  • 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.
  • Must be able to work with Active/Active Clusters and ideally have done conversions within environments that are clustered.
  • Uses tuning tools to improve database performance., 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.

Still TBD: Wednesday - Saturday nights from 7pm -7am.

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

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, 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. Internal FTE’s will be focused on the upgrade while this team will be a backfill for any other DBA duties performed off hours., 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 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., 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.

Requirements

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 the growth of the team. Communication skills are important; detail oriented with high sense of urgency., GC or USC. H1B only to be on our payroll as per client’s stipulation.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.smartrecruiters.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:01 min

Migrating existing applications from MongoDB to Postgres

Nikita Shamgunov Nikita Shamgunov · WWC 2024

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

1:21 min

Realizing the limitations of MongoDB for live statistics

Josip Stuhli Josip Stuhli · WWC 2023

2:48 min

Daily responsibilities and alignment practices for technical engineering leadership

Edoardo Dusi · LIVE

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

1:32 min

Updating stale duplicated subsets via specialized MongoDB change streams

Stanimira Vlaeva · JS Congress

Videos

See all

Related articles

See all