SQL Database Administrator

Fort Worth, TX

Company Name :IBA Infotech LLC

Type : Contract

Primary Skills : SQL Databases, Oracle DBA, Mongo DBA.

Location : Fort Worth

CTC : DOE

Job Description:

 

The Staff DBA will work hand-in-hand with business analysts, developers, Windows, storage and network engineers to ensure optimal solution, availability, performance and support of Database platforms and Data integration solutions amongst disparate systems. This role will act as a hands-on subject matter expert within the team.

What you’ll do:

The Staff DBA role is responsible for designing and supporting standardized, enterprise-class IT solutions. This individual will be responsible for facilitating, supporting and designing the evolution of infrastructure (principally Microsoft SQL Server in coordination with Windows Server, storage and network). Additional duties may include consulting with application architects on all strategic deployments, generating architectural design documents, generating SSIS packages and SSRS reports and BI platform, and presenting design concepts and solutions to internal customers. Ability to identify process improvements as well as reduce complexity and systemic availability issues is a must.

Candidate must have 5+ years’ experience in designing, deploying and supporting high availability Microsoft SQL Server solutions on the Windows Server platform. Excellent communication, negotiation and interpersonal skills are a requirement.

What you have:

  • Minimum 5 years of MS SQL DBA experience.
  • Production Support experience with excellent communication/written communication skills.
  • Must possess the ability to handle tasks and function in a fast-paced, demanding, high growth environment, and be customer-service oriented
  • Ability to interface with customers (internal & external) and strong interpersonal skills
  • Strong organizational skills
  • Ability to understand new technologies quickly
  • Ability to work flexible hours as required and participates in on-call rotation.

Experienced or Exposure in the following:

  • MS SQL 2005, 2008, 2008 R2, SQL 2012, SQL 2016, SQL 2017 Enterprise and Standard (32-bit and 64-bit)
  • Configuration of SSIS and SSRS.
  • Work experience on SSIS and SSRS to create and deploys dtsx packages and Reports.
  • Work experience with SSAS
  • TSQL and stored procedure development experience
  • Installation and configuration of SQL Databases on Windows 2008 and Windows 2012 Standard and Enterprise Editions.
  • Database upgrade, Patching & Refresh
  • SQL tuning, Data conversion / Migration, Supporting Development, Test and Production System.
  • Database maintenance, Database backup and recovery
  • Setup and constantly improve maintenance, operational and monitoring processes
  • Export/Import Replication, Maintaining back up jobs, Creating Linked Server Objects
  • Experience in Database Mirroring, log shipping and DR procedures
  • Experience in SQL transactional Replication
  • Supporting MS SQL databases in Microsoft clustered environments
  • SQL 2012 Availability groups is a plus.
  • Experience in SQL Sentry / Idera DM is plus.
  • Oracle DBA experience is a plus.
  • Mongo DBA experience is a plus.