Performance Engineer - Remote - Az

Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. BCBSAZ 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.
This remote 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.
ESSENTIAL 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.
• Monitor and test SQL Server performance; prepare and deliver SQL Server performance statistics and reports.
• Support application development teams in the design and deployment of new applications and enhancements to existing applications.
• Monitor and create priority list(s) that are agreed to by management
• Ensure system connectivity of all SQL Server instances.
• Participate on small to medium scoped projects
• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.
• Perform instance and security audits, database recovery procedures, and other recovery processes in accordance with the company’s disaster recovery and business continuity strategies.
• Research, analyze, track and resolve basic production problems
• Collaborate in the integration of database servers into enterprise systems.

Level 2 - Performs job functions with moderate supervision and peer review

• Development of relational and multidimensional SQL database queries
• 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.
• Design, implementation and tuning of database schemas.
• Analytical knowledge necessary to generate reports based on available data and then make decisions based on reported data
• Advanced expertise in SQL Server services.
• Solid technical ability and problem solving skills
• Build synergy with a diverse team in an ever changing environment. (Applies to Level 3)
• Performs the research necessary to advise clients on SQL Server functionality and best practices
• Advises application development teams regarding the deployment of SQL Server artifacts.
• Perserverance in the face of resistance or setbacks.
• Ability to build lesson plans and deliver to team members
• Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints.
• Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
• Working technical knowledge of PowerShell.
• Development of time estimates and project schedules based on prioritization and business requirements.
• Design, development, maintenance and enhancement of database and business solutions, including enterprise-level databases, data-marts, and data warehouses
• Working technical knowledge of current software protocols and Internet standards to the extent that they apply to database administration.
• Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.
• Impeccable project management skills
• Ability to maintain confidentiality and privacy
• Advanced knowledge of computer operating systems
• Development of code for database access, modifications, and constructions including stored procedures.
• Advanced systems research and analysis expertise
• Facilitate and resolve customer requests and inquiries for all levels of management within the Corporation. (Applies to Level 2-3)
• Supports application development teams in best practices for job scheduling with ActiveBatch.
• Design and implementation of Extract, Transform, and Load (ETL) solutions including SSIS & DTS programming based on BCBSAZ SQL Server database design and implementation standards.
• Knowledge of business requirements development and user acceptance testing.
• Provide peer-level review and mentoring to levels 1 and 2
• Advises the application development teams in the following:
• Excellent database troubleshooting skills
• Intermediate PC proficiency
• Intermediate proficiency in spreadsheet, database, flow charting, and word processing software
• Effective interpersonal skills and ability to maintain positive working relationship with others.
• Formulation of hardware and software requirements.
• Systems research and analysis. Ability to write and present business documentation.
• 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.
• Collectively responsible for the uptime and health of the company’s database environments on a 24 x 7 basis.
• Advanced proficiency in spreadsheet, database, flow charting, and word processing software
• As requested by app development teams, collaborates with SQL Server architecture design and code reviews.
• 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.
• Ability to provide mentoring and peer review to team members
• Knowledge of data privacy practices and laws, including HIPAA regulations related to data security.
• Design of complex systems, including interfaces, data mapping and metadata.
• Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones
• Provides rotating on-call service (FTEs only).
• According 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.
• Evangelizes SQL Server’s functionality and best practices with application development teams and the SQL Server user community.
• The document database applications, server applications, and security policies/procedures, programs, systems, manuals, etc.
• 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.
• Knowledge of internal departments and operations
• SQL Server skills commensurate with the position’s level.
• Experience working with and managing third parties
• Perform all other duties as assigned