Western Alliance Bank

SQL Database Administrator

Req No.
2017-3602
Western Alliance Bank
Category
Technology
Type
Regular Full Time
Phoenix

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

  • 5+ 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

 

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed