Senior SQL DBA MMIS experience (MUST)

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Project Development
Microsoft Windows
People Skills
Management Information Systems
Microsoft SQL Server
Data Modeling
Database
Database Administration
Encryption
Project Planning
Microsoft
Oracle
Performance Tuning
Presentations
Project Management
English
High Availability
IDMS
Leadership
Linux
MMIS
Application Development
Application Support
Backup
Collaboration
Scripting
Data Migration
Medicaid
Recovery
Resource Allocation
SQL
Scalability
Scrum
Software Development
Software Estimation
Sprint
Transact-SQL
Windows PowerShell

Job Details

Senior SQL DBA MMIS experience (MUST)

Type: Contract

Duration: 12+ months

Work Location: Columbia South Carolina - hybrid

Candidate location: Candidate must be a CURRENT SC resident. No relocation allowed.

Interview Process: 1 round, virtual

Travel: Onsite travel for meetings as needed, 25% of the year (project dependent)

The Senior SQL DBA role has four major attributes: software development leadership, project management skills, people skills, and domain knowledge in enterprise class multi-tier web-based application development projects. Candidates must display excellence in all areas.

Key Skills Must show on resume explained in each job used.

7+ years as a SQL DBA

5+ years experience with SQL Server

5+ years experience with High Availability/Disaster Recover (HA/DR)

3+ years experience with TSQL

3+ years experience with PowerShell scripting

7+ years experience with performance tuning, backup/recovery, and security

Preferred

Experience in data encryption and traffic encryption.

Medicaid Management Information System (MMIS) experience

The Senior SQL DBA is responsible for working closely with both the project development team (scrum/sprint teams) and with the Oracle Database Administrators as well as IDMS DBAs to provide DBA support for numerous application and infrastructure databases.

Duties include:

  • Advising development and product teams on best approaches for required data model extensions and/or changes.
  • Hands-on SQL development and application support in ways that are consistent with Microsoft best practices.
  • Collaboration with Client s Oracle and IDMS database administration team to maintain test, staging, production databases and the development of operations procedures for database management.
  • Developing and executing a data migration plan as needed to accommodate data transfers from existing data stores.
  • Coordinating with outside entities, including vendors for other systems/services, providers, professional associations.
  • Analyze performance data, recommend courses of action and implement best solutions to achieve optimum performance.
  • Participate in a 24x7 on-call support rotation.Proven DBA experience in supporting enterprise applications in Linux environments, preferably windows and Linux.
  • Experience with Data Guard
  • Demonstrated success in supporting a development team implementing primarily web-based solutions using SQL as the database.
  • Understanding of IT development and implementation projects.
  • Understanding of database scalability and operations.
  • Project planning experience, including effort estimation on technical tasks and resource allocation.
  • Strong written and oral communications skills, including the ability to give presentations to project management. Strong proficiency in English is required.
  • Impeccable integrity. This project will have very high visibility and will impact significant expenditures of public funds. Candidates must be confident with their abilities to make correct decisions and the courage to speak out when necessary.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.