Senior DBA - SQL Server and Snowflake - City National Bank
Los Angeles, CA
About the Job
*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](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf).
ABOUT CITY NATIONAL
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $92.03 billion in assets as of April 30, 2024. Founded in 1954, 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 $96.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](https://www.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](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/1/159726e0-aeb1-4058-9052-d7a2d69626b8.pdf)
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](mailto:TalentAcquisition@cnb.com) or leave a message at (213) 673-9139. 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.
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](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf).
ABOUT CITY NATIONAL
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $92.03 billion in assets as of April 30, 2024. Founded in 1954, 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 $96.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](https://www.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](https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/1/159726e0-aeb1-4058-9052-d7a2d69626b8.pdf)
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](mailto:TalentAcquisition@cnb.com) or leave a message at (213) 673-9139. 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.
Source : City National Bank