SQL Database Administrator Senior

Western Alliance Bancorporation   •  

Phoenix, AZ

Industry: Finance & Insurance

  •  

11 - 15 years

Posted 58 days ago

This job is no longer available.

Overview

The Database Administrator (DBA) is responsible for the overall management and maintenance of information databases used to operate IT applications and systems. The DBA will partner with application teams and infrastructure operations to ensure that database performance is not hindered and performance standards adhere to service level agreements set with the enterprise.

Responsibilities

  • Partners with development teams to design data management and governance protocols, manage the information lifecycle, and design infrastructure and data integration controls
  • Understands business strategy and cascades business intelligence needs to the database level
  • Designs, configures, implements, and administers all databases for the respective parties involved
  • Develops and maintains complex models and logical database designs
  • Identifies and resolves all issues related to database systems to ensure that systems are online and without service interruption
  • Builds and manages the database disaster recovery backup and high availability plan if necessary
  • Develops new and enhances existing standards, processes and procedures, and guidelines for database environments using industry experiences, best practices research, and business needs
  • Analyzes and reports the performance of database operations against the key database performance metrics
  • Meets performance standards in accordance to service level agreements set by the company


Qualifications

  • 10+ years of experience working as an applications database administrator on MS SQL Server 2008 or better
  • Bachelor's in computer science or related field degree desired
  • Microsoft SQL Certification is a plus
  • Proficient with Microsoft SQL Server (MS Access , SAS or Oracle BI is an additional plus)
  • In-depth knowledge of Stored Procedures and SQL Query Manager
  • Experience using SSIS/SSRS/SSAS
  • Experience with using ETL processes
  • Experience with automating DBA tasks, database tuning and capacity planning
  • Experience with data modeling and schema design
  • Proficient in data warehouses including schemas, facts and dimensions
  • Experience with SQL reporting systems, data cubes and dashboards is a plus
  • Able to find root causes of problems and quickly determines efficient solutions
  • Strong logical and analytical thinker