Database Administrator at City National Bank (Los Angeles, CA)
Sorry, this job was removed at 9:02 p.m. (CST) on Monday, June 26, 2023
By clicking Apply Now you agree to share your profile information with the hiring company.
Employer Provided Salary: $92,114-$156,880 Annually
Salary data is provided by the employer. Please note this is not a guarantee of compensation.
DATABASE ADMINISTRATOR
WHAT IS THE OPPORTUNITY?
The Database Administrator is a member of the Database Administrator 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.
Technology and Innovation Division
As a member of City National's Technology & Innovation group, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our technology teams.
As a member of City National's Technology & Innovation group, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our technology teams.
WHAT WILL YOU DO?
- Plan, physical design and implement databases including capacity planning, data archival and backups per established CNB database standards. 20%
- Manage the existing enterprise databases maintenance tasks including backups, performance tuning, schema changes etc. 15%
- 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. 20%
- 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 5%
- Participates in all DR exercises and ensures all related documentatiion is up to date. 10%
- 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 20%
- All other appropriate duties as required. 10%
WHAT DO YOU NEED TO SUCCEED
Must-Have*
- Bachelor's Degree
- Minimum 6 years of IT experience
- Minimum 4 years’ experience in database design, administration, programming, and support of at least one industry standard database platform.
- Minimum 3 year experience with SQL tuning
- Minimum 2 year experience in implementing and managing High Availability (HA) options and Disaster Recovery
Skills and Knowledge
- Experience managing PeopleSoft related databases is a
- Working knowledge of Wintel and/or Unix
- Working knowledge of programming and scripting tools such as Unix Shell, Powershell etc.
- Working knowledge of enterprise storage solutions"
- Working knowledge of database modeling, programming, data loading and query tools.
- Significant experience in the design of data extract, transformation, and data loading facilities.
- Thorough knowledge of multi-dimensional and relational database models and extensive experience in data warehouse logical and physical database design, data modeling, schema design, and data files.
- Hands- on experience on OEM, RAC and Oracle GRID.
- RMAN and Export experience for large DW DB recovery.
- Strong experience on Oracle Recovery Manager – Archiving, Oracle Recovery with Archiving, Oracle Export and Import Utilities Programming skills in scripting languages, experience with major database/data warehouses such as Red Brick, SGL Server, or Oracle.
- Experience with UNIX, LINUX and Windows servers .
- Experience with modeling tools such as Erwin and reporting/query tools such as Brio or Business Objects.
- WebLogic admin experience highly desirable.
- Excellent verbal and written communication skills, analytical skills, and a detailed knowledge of database concepts, structures, and data flow processes.
- Working knowledge of NT and/or UNIX.
- Strong programming skills.
Compensation
Starting base salary: $92,114 - $156,880 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.
INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT
City National Bank is an equal opportunity employer committed to diversity and inclusion. 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 law.
City National Bank is an equal opportunity employer committed to diversity and inclusion. 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 law.
ABOUT CITY NATIONAL
We start with a basic premise: Business is personal. Since day one we've always gone further than the competition to help our clients, colleagues and community flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues to drive phenomenal growth today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies.
See More
