Principal I - Cloud Database Administrator

Western Alliance Bancorporation; Columbus (OH); On-site; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a Principal Engineer I specializing in Cloud Database Administration. This role involves leading the migration of SQL databases to Azure, ensuring compliance and security, and mentoring junior engineers. You will be at the forefront of database management, optimizing performance and scalability while collaborating with cross-functional teams. The position offers a competitive salary, comprehensive benefits, and the opportunity to enhance your business acumen in a dynamic environment. If you have a passion for technology and a drive for excellence, this is the perfect opportunity for you.

Benefits

Medical Insurance

Dental Insurance

401k Matching Program

Tuition Assistance

Employee Volunteer Program

Wellness Program

Ownership Stake in Company

Qualifications

• 10+ years of experience in database management and cloud technologies.
• Expertise in migrating SQL Server databases to Azure cloud platforms.
• Strong leadership and communication skills required.

Responsibilities

• Oversee the design, development, and maintenance of database systems.
• Lead the migration of databases to the Azure cloud environment.
• Collaborate with IT teams to ensure alignment with business objectives.

Skills

SQL DBA

Azure SQL Database

Database Migration

Troubleshooting

Leadership

Communication Skills

Education

Bachelor's degree in related field

Master's or MBA in related field

Tools

Azure Data Factory

Azure Data Lake

PowerBI

Ansible

Terraform

MongoDB

Job description

Job Title:

Principal I - Cloud Database Administrator

Location:

TX - Dallas/Irving

What you'll do:

As a Principal Engineer I you'll provide SME expertise in your respective domain as well as adjacent domains to ensure solutions are safe, secure, compliant and reliable. You'll identify development and support needs as well as take on large and complex design responsibilities supporting project tasks. You'll also engage with project and business sponsors refining requirements and objectives of targeted solutions. As a Principal Engineer I, you also facilitate dialogue and activities, and work to ensure team collaboration including teams outside of your domain. You'll develop effective presentations and narratives for IT audiences. In this role, you'll also develop the technical skills of one more junior engineers.

• Build the solution design of efforts that can be handed off to lower level engineers for execution assuring reuse of platforms where possible.
• Review technical plans developed by lower level engineers and analysts to assure quality designs prevail which can support the volumetrics of our business partners objectives.
• Build comprehensive measurement dashboards that give performance insight into key applications of the bank which can feed operational results of our business partners.
• Work independently or sometimes with architecture team counterparts to lay out the final documentation required for proper ongoing reference of the given solution, including physical and logical layouts with cross reference to use case models while enforcing standards, as well as assisting in the modification or buildout of procedures that support areas of operations across IT.
• Deliver high-quality work on time and under budget
• Oversee the design, development, implementation, and maintenance of database systems on prem and in the Azure cloud.
• Lead the migration to the Cloud from old VM based SQL Servers
• Monitor and optimize the performance, availability, security, and scalability of the database systems and applications.
• Troubleshoot and resolve complex database issues, such as data integrity, concurrency, backup and recovery, replication, and migration.
• Establish and enforce database standards, policies, procedures, and best practices for the cloud
• Collaborate with other IT teams, such as developers, architects, and engineers, to ensure alignment and integration of database solutions with business requirements and objectives.
• Stay updated on the latest trends and technologies in database management and cloud computing.
• Review of Business Application scripts for efficiency
• Implement automation where possible

What you'll need:

• 10+ years of related experience.
• Bachelor's degree in related field required; Masters or MBA in related field preferred.
• Strong SQL DBA experience in migrating SQL Server databases to the Azure cloud platform
• SME in Azure SQL Database, Azure SQL Managed Instance, Azure Data Factory, and Azure Data Lake
• Ability to trouble shoot issues end to end
• Previous leadership experience preferred.
• Ability to analyze specifications and design documents.
• Ability to create standard operating procedures (SOPs/MOPs).
• In office 4x per week (hours in the office can be flexible if needed)
• Advanced to expert knowledge of general Financial Services or Banking is preferred.
• Advanced to expert knowledge of applicable regulatory and legal compliance obligations, rules and regulations, industry standards and practices.
• Advanced to expert experience in leading cross-functional teams and managing multiple projects simultaneously with an established expertise in one or more key domains of the bank (Deposits, Loans, Operations or Reporting)with the ability to walk through top level process design.
• Capable of working with regulatory partners like the CFPB, OCC and FRB through audits and collaboration efforts as situations arise.
• Advanced to expert familiarity with the capability model across IT and the applications and infrastructures available for engagement in solutioning across the bank to develop results that leverage existing capabilities in addition to implementing new solutions when required. Experience in the design, enhancement and compliance to all governance frameworks across the IT organization to ensure proper compliance to published procedures and standards.
• Advanced speaking and writing communication skills.

Preferred:

• Oracle experience
• PowerBI, PowerShell, Bash
• Any automation experience, Ansible, Terraform
• Mongo DB
• Azure Certifications
• ITIL certifications
• SQL certifications

Benefits you'll love:
We offer all the important things you'd want - like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!

About the company:

Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company.

Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email [e-mail] or call 602-386-2488. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.

Western Alliance Bancorporation