SQL/Server Database Administrator

The Database Administrator IV leads discussions and mentors application and database development staff with database design, automation, and validation of data load routines involving application databases. In addition, The Database Administrator IV also provides team leadership, establishes technical standards for the database team, and works closely with the management team to continuously refine the KHS project management and agile development methodology, procedures, and policies to promote efficiency and productivity.

Essential Functions:

Provide strong technical direction and guidance, project management skills using the Project Management Institute (PMI) methodology, and related abilities to facilitate, execute, and accomplish corporate and maintenance project deliverables
Provide technical leadership for all Database development and operations aspects, lead technical teams using the Agile methodology for incremental product delivery, independently perform Scrum Master duties, and promote Agile best practices for continuous improvement
Facilitate and lead collaborative cross-functional workgroups to resolve complex problems in real-time and reduce or mitigate operational interruptions
Mentor and provide leadership to junior team members

Required skills/experience:

More than 7 years in the role of SQL/Server DBA in an enterprise environment
Recent experience in data modeling using tools like Erwin
Experience with ETL for data transformation and integration
Advanced level of creating complex SQL Queries
Expertise in working with different types of data (JSON/XML/HL7/etc.) and heterogeneous data sources from web/cloud-based solutions to Data Lakes or warehouses
Experience with routine or special database software upgrades, maintenance, security audits, and patches
Experience with data and database backup and recovery, system performance, monitoring, and security
Strong experience with MS BI Stack - SSIS, SSRS, PowerBI

Nice to have skills:

SQL/DBA experience supporting QNXT / experience with QNXT data models
Strong Health Plan background
SQL/Server DBA certification