Senior DBA - SQL Server and Snowflake

Qualifications
Bachelor's Degree or equivalent
Minimum 7 years of IT experience
Minimum 5 years experience in database design, administration, programming, and support of at least one industry standard database platform
Advanced knowledge and experience with Database and Query Performance optimization for large data volume
Experience with SQL Server and Snowflake required
Knowledge and hands-on experience with Data Warehousing and Reporting techniques and tools
Benefits
Starting base salary: $101,231 - $172,355 per year
Exact compensation may vary based on skills, experience, and location
This job is eligible for bonus and/or commissions
At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues
Responsibilities
The Senior Database Administrator is a member of the Database Administration team and is responsible for all functions associated with the physical implementation, operation, and maintenance of database environments
Plans, coordinates, administers, and maintains databases
Responsibilities include: planning, documentation, operations, security, and contingency planning
Ensures database recovery, maintenance, and capacity for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management
Analyzes, tests, evaluates, and implements physical database performance and capacity and tunes the system for efficient performance
Provides technical guidance and assistance in the development and implementation of database systems
Provides a high degree of coordination between colleagues, technical staff, and applications developers to ensure effective data management and meets business objectives
Plan, physical design and implement databases including capacity planning, data archival and backups per established CNB database standards
Manage the existing enterprise databases maintenance tasks including backups, performance tuning, schema changes etc
Creates, develops, and reviews the physical model created from the logical model
Ensures that the physical design and database structures comply with CNB standards and conventions
Audits and quality controls database permissions to ensure accurate and appropriate use of data
Designs, develops, maintains, and executes scripts
Monitors execution of the loads and resolves operational or other technical issues when necessary
Monitor system growth and perform resource and capacity planning for databases
Patches databases as per patching guidelines
Participates in all DR exercises and ensures all related documentation is up to date
Works closely with infrastructure team to help design infrastructure requirements for the databases to ensure high database resilience in production and recoverability in a DR environment
Recommends and establishes standards, guidelines, and procedures for all aspects of physical database design and maintenance
Administers and controls activities related to database planning and operations
Establishes procedures and standards pertaining to data management, security, maintenance, utilization, and backup/recovery
Identifies and eliminates manual processes by utilizing available tools to automate, for example creation of databases and patching
Works closely with information security to ensure all databases conform to TSS standards
All other appropriate duties as required
Job description
SENIOR DATABASE ADMINISTRATOR

WHAT IS THE OPPORTUNITY?

The Senior Database Administrator is a member of the Database Administration team and is responsible for all functions associated with the physical implementation, operation, and maintenance of database environments. Plans, coordinates, administers, and maintains databases. Responsibilities include: planning, documentation, operations, security, and contingency planning. Ensures database recovery, maintenance, and capacity for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management. Analyzes, tests, evaluates, and implements physical database performance and capacity and tunes the system for efficient performance. Provides technical guidance and assistance in the development and implementation of database systems. Provides a high degree of coordination between colleagues, technical staff, and applications developers to ensure effective data management and meets business objectives.

What You Will Do
• Plan, physical design and implement databases including capacity planning, data archival and backups per established CNB database standards.
• Manage the existing enterprise databases maintenance tasks including backups, performance tuning, schema changes etc.
• Creates, develops, and reviews the physical model created from the logical model.
• Ensures that the physical design and database structures comply with CNB standards and conventions.
• Audits and quality controls database permissions to ensure accurate and appropriate use of data.
• Designs, develops, maintains, and executes scripts.
• Monitors execution of the loads and resolves operational or other technical issues when necessary.
• Monitor system growth and perform resource and capacity planning for databases.
• Patches databases as per patching guidelines
• Participates in all DR exercises and ensures all related documentation is up to date
• Works closely with infrastructure team to help design infrastructure requirements for the databases to ensure high database resilience in production and recoverability in a DR environment.
• Recommends and establishes standards, guidelines, and procedures for all aspects of physical database design and maintenance.
• Administers and controls activities related to database planning and operations.
• Establishes procedures and standards pertaining to data management, security, maintenance, utilization, and backup/recovery.
• Identifies and eliminates manual processes by utilizing available tools to automate, for example creation of databases and patching
• Works closely with information security to ensure all databases conform to TSS standards.
• All other appropriate duties as required.

Must-Have*
• Bachelor's Degree or equivalent
• Minimum 7 years of IT experience
• Minimum 5 years experience in database design, administration, programming, and support of at least one industry standard database platform

Skills And Knowledge
• Advanced knowledge and experience with Database and Query Performance optimization for large data volume
• Experience with SQL Server and Snowflake required.
• Experience with Azure Managed SQL preferred.
• Knowledge and hands-on experience with Data Warehousing and Reporting techniques and tools

Compensation

Starting base salary: $101,231 - $172,355 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
• To be considered for this position you must meet at least these basic qualifications The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

Benefits and Perks

At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our Benefits and Perks.

About City National

City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $+2.03 billion in assets as of April 30, 2024. Founded in 1+54, City National provides personalized banking, investment and trust services in select markets including Los Angeles, Orange County, San Diego, the San Francisco Bay Area, New York City, Nashville, Atlanta, Delaware, Las Vegas, Washington D.C. and Miami.* In addition, the company and its investment affiliates manage or administer $+6.83 billion in client investment assets. City National is dedicated to strengthening communities, and in 2023 alone, the company made more than $11 million in charitable contributions to nonprofits that support the communities it serves.
• City National Bank does business in Miami and the state of Florida as CN Bank.

For more information about City National, visit cnb.com.

EQUAL OPPORTUNITY EMPLOYER REASONABLE ACCOMMODATION

City National Bank is an equal opportunity employer committed to promoting and maintaining a diverse, equitable and inclusive working environment where differences are valued and encouraged. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by the laws or regulations in the locations where we operate or in our Code of Conduct. READ MORE

If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation for any part of the employment process. Please contact us via email or leave a message at (213) 673-+13+. These contact methods are dedicated to applicants whose disability prevents them from successfully applying online. Only messages left for this purpose will be returned. Responses may take up to two business days. Read more