Senior SQL Database Administrator

Senior SQL Database Administrator

  Not Disclosed

  Columbia, SC (100% Remote)

  12.0 Months

  Not Disclosed

  Not Disclosed

  Government - State

  $-4/hour - $1/hour

Job Description

Client is seeking a Senior Microsoft SQL professional with the knowledge and experience along with comparable communication and interpersonal skills to enable success on this high-visibility project.

DAILY DUTIES / RESPONSIBILITIES:
The Senior SQL DBA is responsible for working closely with both the project development team (scrum/sprint teams) and with the client 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 the 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, and other client.
Analyze performance data, recommend courses of action and implement best solutions to achieve optimum performance.
Participate in a 24x7 on-call support rotation.
Other duties as assigned.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
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.
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.
Willingness and ability to effectively engage with people and organizations on a continuous basis.

7+ years experience 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 SKILLS (RANK IN ORDER OF IMPORTANCE):
Understanding of Oracle Enterprise Manager
Healthcare industry experience and/or experience managing PHI/PII data
Experience in data encryption and traffic encryption.
Vendor management experience.
Medicaid Management Information System (MMIS) experience
Medicaid operations experience.
Public sector experience is a plus.

REQUIRED EDUCATION:
Bachelor’s degree in a technical, business, or related field. Master’s degree is desirable.

REQUIRED CERTIFICATIONS:

None required. SQL training/certification from a recognized source is beneficial.

Notes:

Role is 100% remote

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