What are the responsibilities and job description for the Senior DBA - SQL Server and Snowflake position at City National Bank?
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 $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.
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-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.
Salary : $101,231 - $172,355
