Sr. SQL Server DBA - Hybrid

Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. AZ Blue offers a variety of health insurance products and services to meet the diverse needs of individuals, families, and small and large businesses as well as providing information and tools to help individuals make better health decisions.

We are hiring for a future start date of 1/1/2025.

This position is hybrid within the state of AZ only.

This hybrid work opportunity requires residency, and work to be performed, within the State of Arizona.

PURPOSE OF THE JOB

Under minimal supervision provides the necessary technical expertise to coordinate, maintain and support databases utilizing Microsoft's SQL Server, database utilities, software products and major subsystems as packaged with purchased applications. The duties include performance tuning, monitoring, database capacity and utilization planning, server application security, archiving, planning and monitoring of backups, disaster recovery, and documentation based on BCBSAZ corporate policies, industry best practices, and customer-based business requirements. The Database Administrator is responsible for the efficient and effective management of the corporation's electronic data on enterprise databases. The position will ensure highly available, stable, secure and recoverable databases in a 24/7 environment.
REQUIRED QUALIFICATIONS

Required Work Experience

Experience in database Administration with SQL

Server

Level 1: 5 years
Level 2: 8 years
Level 3: 10 years
Experience in advanced database administration with SQL

Level 1: 2 years
Level 2: 5 years
Level 3: 8 years
Experience leading a SQL Server database administration team

Level 3: 5 years
Required Education

High-School Diploma or GED in general field of study (All Levels)
Required Licenses

N/A
Required Certifications

PREFERRED QUALIFICATIONS

Preferred Work Experience

Experience in information technology or computer systems, including experience with networked software and operating systems

Experience in planning, design, development, and implementation of software systems, applications and related products

Experience in project management

Supervisory or lead experience

Preferred Education

Bachelor's degree in computer science, Information Systems, Business, or related field (All Levels)
Preferred Licenses

Preferred Certifications

MCITP SQL Server 2005 Database Administration and Development
MCITP SQL Server 2008 Database Administration and Development
MCSE SQL Server 2012 Data Platform
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES

Level 1 -

Performs job functions under general supervision or peer review
Collaborate with the Database Services team and infrastructure staff to ensure smooth and reliable operation of SQL Server databases and services for fulfilling business objectives and processes.
Collaborate in responding to urgent alerts and Production incidents.
Promote SQL Server artifacts through the several database environments as requested by application development teams, and in general attend to client requests as assigned.
Participate in the promotion of SQL Server best practices
Contribute to the team's knowledge base with useful information such as adopted standards, procedure documentation, problem resolution advice, etc.
Install and configure SQL Server instances according to standards defined by the team and upgrade the SQL Server instances as required.
Manage, monitor, maintain and optimize SQL Server instances as assigned.
Support Enterprise database clustering, mirroring, replication among other SQL Server technologies.
Manage scheduled database maintenance jobs.
Implement and manage SQL Server security to provide appropriate levels of access to users throughout the company.
Level 2 -

Performs job functions with moderate supervision and peer review

Perform cost-benefit and return on investment analyses for proposed systems involving SQL Server databases and services to aid management in making implementation decisions.
Conduct research on software and systems products to justify recommendations and to support purchasing efforts.
Gauge the effectiveness and efficiency of existing SQL Server instances; develop and implement strategies for improving or further leveraging these instances.
Propose and create database design models, specifications, diagrams, and charts to provide direction to infrastructure and application development teams.
Participate or lead database-related projects
Draft programs, time estimates and project schedules based on prioritization and business requirements
Participate and/or lead large- or complex-technical projects
Act as primary operational contact for internal and external customers when needed / in the absence of manager or team lead.
Level 3 -

Performs job functions with minimal supervision

Responsible for overall technical direction of the Database Services team, including the coordination for the definition of standards for SQL Server administration.
Serve as point of escalation for technical issues that team members need assistance with.
Assist the Server Services Manager in distributing work to the Database Services team and the scheduling of tasks required of the team by client departments.
Assist the manager in providing budgetary forecasting of equipment, software, service, and license needs for the technology team
Responsible for capacity planning of database-related Infrastructure systems assigned to this department
Help maintains a Disaster Recovery / IT Contingency plan for BCBSAZ database-related computer equipment and software
Responsible for modifications or updates to the production environment assigned to this department
Responsible for problem management and resolution of Infrastructure systems assigned to this department
Responsible for providing visible leadership for the department within the Information Technology division
Partners with other team leaders to identify points of leverage, integration, and resource sharing opportunities
Responsible for conducting weekly functional team meetings
Responsible for providing weekly team status reporting to management including capacity metrics, performance metrics, ticket information, project information, issues, and potential areas of concern
Interact and negotiate with vendors, outsourcers, and contractors to secure system-related products and services.
Provide peer-level review and mentoring to levels 1 and 2
Lead, develop and mentor staff by providing opportunities for growth through delegation, training, and assignment to various project teams

ALL LEVELS

Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.
The position requires a full-time work schedule. Full-time is defined as working at least 40 hours per week, plus any additional hours as requested or as needed to meet business requirements.
Collectively responsible for the uptime and health of the company's database environments on a 24 x 7 basis. Provides rotating on.