Roles / Responsibilities :
The Senior SQL DBA is responsible for working closely with both the project development team (scrum / sprint teams) and with the Clemson 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 SQLdevelopment and application support in ways that are consistent with Microsfot best practices.
- Collaboration with Clemson'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 State agencies.
- 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.
Mandatory Skills :
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 GuardDemonstrated success in supporting a development team implementing primarily web-based solutions usingUnderstanding 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. SQL as the database.7+ years' experience as a SQL DBA5+ years' experience with SQL Server5+ years' experience with High Availability / Disaster Recover (HA / DR)3+ years' experience with TSQL3+ years' experience with PowerShell scripting7+ years' experience with performance tuning, backup / recovery, and securityBachelor's degree in a technical, business, or related field.Desirable Skills :
Experience in data encryption and traffic encryption.Medicaid Management Information System (MMIS) experienceUnderstanding of Oracle Enterprise ManagerHealthcare industry experience and / or experience managing PHI / PII dataVendor management experienceMedicaid operations experience.Public sector experience is a plus.Master's degree is desirable.SQLtraining / certification from a recognized source is beneficial.