IV&V Technical Engineer Consultant

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 Clemsons 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.

1. Proven DBA experience in supporting enterprise applications in Linux environments preferably windows and Linux.
2. Experience with Data Guard
3. Demonstrated success in supporting a development team implementing primarily web-based solutions using
4. Understanding of IT development and implementation projects.
5. Understanding of database scalability and operations.
6. Project planning experience including effort estimation on technical tasks and resource allocation.
7. Strong written and oral communications skills including the ability to give presentations to project management. Strong proficiency in English is required.
8. 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.
9. Willingness and ability to effectively engage with people and organizations on a continuous basis. SQL as the database.
10. 7 years experience as a SQL DBA
11. 5 years experience with SQL Server
12. 5 years experience with High Availability/Disaster Recover (HA/DR)
13. 3 years experience with TSQL
14. 3 years experience with PowerShell scripting
15. 7 years experience with performance tuning backup/recovery and security
16. Bachelors degree in a technical business or related field.

Desirable Skills:

1. Experience in data encryption and traffic encryption.
2. Medicaid Management Information System (MMIS) experience
3. Understanding of Oracle Enterprise Manager
4. Healthcare industry experience and/or experience managing PHI/PII data
5. Vendor management experience
6. Medicaid operations experience.
7. Public sector experience is a plus.
8. Masters degree is desirable.
9. SQLtraining/certification from a recognized source is beneficial.