Blue Cross Blue Shield of Arizona
DBA (Development Support) - Hybrid
Blue Cross Blue Shield of Arizona, Phoenix, Arizona, United States, 85003
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
Database administration responsibilities that are common to all DBAs in the team. In addition, under minimal supervision educates, advises and supports application development teams to assure compliance with BCBS AZ SQL Server standards. Evangelizes best practices for SQL Server, programming, performance tuning, data modeling, design, development, and documentation based on BCBSAZ corporate policies, industry best practices, and customer-based business requirements.
REQUIRED QUALIFICATIONS
Required Work Experience
Experience in database administration/development with SQL Server:
Level 1: 5 yearsLevel 2: 8 yearsLevel 3: 10 yearsExperience in advanced database administration/development with SQL Server
Level 1: 2 yearsLevel 2: 5 yearsLevel 3: 8 years5 years of Experience leading a SQL Server database administration/development team (Level 3)
Required Education
High-School Diploma or GED in general field of study (All Levels)Required Licenses
N/ARequired Certifications
N/APREFERRED QUALIFICATIONS
Preferred Work Experience
Experience in database administration/development with SQL Server:
Level 1: 5 yearsLevel 2: 8 yearsLevel 3: 10 yearsExperience in advanced database administration/development with SQL Server
Level 1: 2 yearsLevel 2: 5 yearsLevel 3: 8 years5 years of Experience leading a SQL Server database administration/development team (Level 3)
Preferred Education
Bachelor's degree in computer science, Information Systems, Business, or related field (All Levels)Preferred Licenses
N/APreferred Certifications
MCITP SQL Server 2005 Database Administration and DevelopmentMCITP SQL Server 2008 Database Administration and DevelopmentMCSE SQL Server 2012 Data PlatformESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES
Level 1 -
Performs job functions under general supervision or peer review
Collaborate with infrastructure staff to ensure smooth and reliable operation of SQL Server databases and services for fulfilling business objectives and processes.Work with executive team members, decision makers, and stakeholders to define business requirements and systems goals, and to identify and resolve business systems issues.Support application development teams in the design and deployment of new applications and enhancements to existing applications.Research, analyze, track and resolve basic production problemsPerform instance and security audits, database recovery procedures, and other recovery processes in accordance with the company's disaster recovery and business continuity strategies.Collaborate in the integration of database servers into enterprise systems.Ensure system connectivity of all SQL Server instances.Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.Monitor and test SQL Server performance; prepare and deliver SQL Server performance statistics and reports.Participate on small to medium scoped projectsMonitor and create priority list(s) that are agreed to by managementLevel 2 -
Performs job functions with moderate supervision and peer review
Advises the application development teams in the following:
design, development, maintenance and enhancement of database and business solutions, including enterprise-level databases, data-marts, and data warehousesdesign and implementation of Extract, Transform, and Load (ETL) solutions including SSIS & DTS programming based on BCBSAZ SQL Server database design and implementation standards.development of relational and multidimensional SQL database queriesaccording to the direction of BCSB AZ Enterprise Architects, Application Architects, and Database Administrators, ensuring that released code efficiently cleans and maintains databases by automated procedures to remove old data.development of code for database access, modifications, and constructions including stored procedures.the document database applications, server applications, and security policies/procedures, programs, systems, manuals, etc.
design, implementation and tuning of database schemas.design of complex systems, including interfaces, data mapping and metadata.formulation of hardware and software requirements.development of time estimates and project schedules based on prioritization and business requirements.Level 3-
Performs job functions with minimal supervision and peer review
Evangelizes SQL Server's functionality and best practices with application development teams and the SQL Server user community.Advises application development teams regarding the architecture of SQL Server services, including the Database Engine, Integration Services, Analysis Services, Reporting Services, Master Data Services, etc.As requested by app development teams, collaborates with SQL Server architecture design and code reviews.Collaborates with application development teams in discovery and resolution of application performance issues related to SQL Server, including indexing strategy, SSIS package optimization, SSRS report optimization, etc.Advises application development teams regarding the deployment of SQL Server artifacts.Supports application development teams in best practices for job scheduling with Active Batch.Discovers, documents, and prepares for transition to application development teams, legacy application processes which currently are considered to be owned by the Database Services team.Performs the research necessary to advise clients on SQL Server functionality and best practicesProvide peer-level review and mentoring to levels 1 and 2ALL LEVELS
Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.Collectively responsible for the uptime and health of the company's database environments on a 24 x 7 basis.Provides rotating on-call service (FTEs only).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.Perform all other duties as assigned
Our Commitment
AZ Blue does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected group.
Thank you for your interest in Blue Cross Blue Shield of Arizona. For more information on our company, see azblue.com. If interested in this position, please apply.
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
Database administration responsibilities that are common to all DBAs in the team. In addition, under minimal supervision educates, advises and supports application development teams to assure compliance with BCBS AZ SQL Server standards. Evangelizes best practices for SQL Server, programming, performance tuning, data modeling, design, development, and documentation based on BCBSAZ corporate policies, industry best practices, and customer-based business requirements.
REQUIRED QUALIFICATIONS
Required Work Experience
Experience in database administration/development with SQL Server:
Level 1: 5 yearsLevel 2: 8 yearsLevel 3: 10 yearsExperience in advanced database administration/development with SQL Server
Level 1: 2 yearsLevel 2: 5 yearsLevel 3: 8 years5 years of Experience leading a SQL Server database administration/development team (Level 3)
Required Education
High-School Diploma or GED in general field of study (All Levels)Required Licenses
N/ARequired Certifications
N/APREFERRED QUALIFICATIONS
Preferred Work Experience
Experience in database administration/development with SQL Server:
Level 1: 5 yearsLevel 2: 8 yearsLevel 3: 10 yearsExperience in advanced database administration/development with SQL Server
Level 1: 2 yearsLevel 2: 5 yearsLevel 3: 8 years5 years of Experience leading a SQL Server database administration/development team (Level 3)
Preferred Education
Bachelor's degree in computer science, Information Systems, Business, or related field (All Levels)Preferred Licenses
N/APreferred Certifications
MCITP SQL Server 2005 Database Administration and DevelopmentMCITP SQL Server 2008 Database Administration and DevelopmentMCSE SQL Server 2012 Data PlatformESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES
Level 1 -
Performs job functions under general supervision or peer review
Collaborate with infrastructure staff to ensure smooth and reliable operation of SQL Server databases and services for fulfilling business objectives and processes.Work with executive team members, decision makers, and stakeholders to define business requirements and systems goals, and to identify and resolve business systems issues.Support application development teams in the design and deployment of new applications and enhancements to existing applications.Research, analyze, track and resolve basic production problemsPerform instance and security audits, database recovery procedures, and other recovery processes in accordance with the company's disaster recovery and business continuity strategies.Collaborate in the integration of database servers into enterprise systems.Ensure system connectivity of all SQL Server instances.Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.Monitor and test SQL Server performance; prepare and deliver SQL Server performance statistics and reports.Participate on small to medium scoped projectsMonitor and create priority list(s) that are agreed to by managementLevel 2 -
Performs job functions with moderate supervision and peer review
Advises the application development teams in the following:
design, development, maintenance and enhancement of database and business solutions, including enterprise-level databases, data-marts, and data warehousesdesign and implementation of Extract, Transform, and Load (ETL) solutions including SSIS & DTS programming based on BCBSAZ SQL Server database design and implementation standards.development of relational and multidimensional SQL database queriesaccording to the direction of BCSB AZ Enterprise Architects, Application Architects, and Database Administrators, ensuring that released code efficiently cleans and maintains databases by automated procedures to remove old data.development of code for database access, modifications, and constructions including stored procedures.the document database applications, server applications, and security policies/procedures, programs, systems, manuals, etc.
design, implementation and tuning of database schemas.design of complex systems, including interfaces, data mapping and metadata.formulation of hardware and software requirements.development of time estimates and project schedules based on prioritization and business requirements.Level 3-
Performs job functions with minimal supervision and peer review
Evangelizes SQL Server's functionality and best practices with application development teams and the SQL Server user community.Advises application development teams regarding the architecture of SQL Server services, including the Database Engine, Integration Services, Analysis Services, Reporting Services, Master Data Services, etc.As requested by app development teams, collaborates with SQL Server architecture design and code reviews.Collaborates with application development teams in discovery and resolution of application performance issues related to SQL Server, including indexing strategy, SSIS package optimization, SSRS report optimization, etc.Advises application development teams regarding the deployment of SQL Server artifacts.Supports application development teams in best practices for job scheduling with Active Batch.Discovers, documents, and prepares for transition to application development teams, legacy application processes which currently are considered to be owned by the Database Services team.Performs the research necessary to advise clients on SQL Server functionality and best practicesProvide peer-level review and mentoring to levels 1 and 2ALL LEVELS
Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.Collectively responsible for the uptime and health of the company's database environments on a 24 x 7 basis.Provides rotating on-call service (FTEs only).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.Perform all other duties as assigned
Our Commitment
AZ Blue does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected group.
Thank you for your interest in Blue Cross Blue Shield of Arizona. For more information on our company, see azblue.com. If interested in this position, please apply.