Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Truck Driver Position Occupational Therapist 0 0 PR Digital Marketing Intern Delivery Driver Paid Healthy Trial Participant Paid Clinical Trial Participant Paid Research Participant BairesWash Incorpora Personal Para Software Developer Bread Baker Dental Receptionist-Full Time Driller Delivery Driver Carpenter Bud Tender Hiring Mortgage Agents and Brokers Marketing Assistant Amazon Picker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Immediate Amazon Order Packer Seasonal Full-Time Warehouse Team Member Amazon Picker Amazon Warehouse Associate Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Picker Amazon Warehouse Associate - Immediate Amazon Picker Full-Time Warehouse Team Member Amazon Picker Amazon Picker Amazon Warehouse Worker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Free Amazon Warehouse Worker Amazon Warehouse Worker Amazon Warehouse Associate Amazon Order Packer Amazon Warehouse Associate - Free Seasonal Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Warehouse Worker Full-Time Warehouse Team Member Amazon Warehouse Worker Newest Jobs
Companies
Yelp ContactMonkey CareGuide Clearbanc Sterling-Turner Exact Media Aerotek Two Sigma Aecom Peel Regional Police AsteroidX Akira Jane Street Borrowell Insight Global WeWork Shopify First Convenience Bank American Income Life Doordash Amazon Flex Square Microsoft AT&T Instacart Clickworker Vector Marketing Scotiabank Creative Circle Hatchways Walgreens UnitedHealth Group Recovhub LowCostWebDesignFirm.com Desjardins CI&T mappedin 51talk Top Hat Checkout 51 Paylocity Mobeewave TD Bank The Youth Connection Hootsuite SnapTravel ScribbleLive autoTRADER.ca GoParkr Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Database Administrator At City of Hope

Location: Irwindale, California

Job Description

About City of Hope

City of Hope, an innovative biomedical research, treatment and educational institution with over 6000 employees, is dedicated to the prevention and cure of cancer and other life-threatening diseases and guided by a compassionate, patient-centered philosophy.


Founded in 1913 and headquartered in Duarte, California, City of Hope is a remarkable non-profit institution, where compassion and advanced care go hand-in-hand with excellence in clinical and scientific research. City of Hope is a National Cancer Institute designated Comprehensive Cancer Center and a founding member of the National Comprehensive Cancer Network, an alliance of the nation’s leading cancer centers that develops and institutes standards of care for cancer treatment.


Position Summary:

Assist in the design, implementation, and maintenance of Relational database applications, including application-specific databases implemented in Oracle, SqlServer, PostgresSQL, mysql, nosql.

Deep knowledge of best practices in database design, including entity-relational and dimensional modeling, data and metadata management, and data extraction, transformation, and loading (ETL).

Ability to create and expand databases, but with an eye toward long-term performance, extensibility, maintainability (e.g., partitioning).

Expert knowledge of indexes, sequences, stored procedures, triggers, and other non-table database objects.

Knowledge of front-end tools for accessing back-end databases (e.g., Quest Toad, Oracle SQL Developer, AquaFold Aqua Data Studio, etc.)


Key Responsibilities include:


  • Generates database servers. Creates individual databases, schemas, segments, tables and logins.

  • Designs and works closely with application developers and software engineers to build highly scalable enterprise level, database applications.

  • Builds interfaces using websevices, database views to integrate other database into a centralized and query-able data environment.

  • Monitors the database environment to ensure systems are performing efficiently.

  • Responsible for performance tuning.

  • Reorganizes databases, if necessary, to improve performance.

  • Makes recommendations regarding the purchase of additional hardware to improve performance.

  • Writes and maintains indexes, sequences, stored procedures, and triggers.

  • Proactively monitors database space utilization.

  • Adjusts size of databases as necessary.

  • When appropriate, makes recommendations to purchase additional storage.

  • Reviews daily error logs and takes corrective action as necessary.

  • Monitor and review database consistency checks.

  • Participate in establishing and testing procedures for disaster recovery.

  • Establish database and transaction log backups.

  • Monitor the backup logs and perform restores as necessary.

  • Keeps abreast of the latest in database technology.

  • Makes appropriate recommendations regarding the purchase of new tuning, monitoring and documentation tools.

  • Attend database-related conferences.

  • Work with third-party vendors on database installation and upgrades

  • Work in an Agile and responsive software engineering environment

  • Monitor Unix disk utilization.

  • Format and partition fixed disk and RAID arrays for use by Unix and Oracle.

  • Build shell scripts for routing maintenance tasks.

  • Create cron jobs and review Unix message logs.



Basic education, experience and skills required for consideration:


  • Bachelor’s degree in computer science, data-science, or other closely related field.
  • Experience may substitute for minimum education requirements
  • 4-6 years of experience in the field of database design, implementation, planning, tuning, and monitoring of database systems supporting internally or vendor designed and built systems.
  • Having worked as part of a software engineering team building enterprise level software applications is highly desirable.

Required Courses/Training:
SqlServer, Oracle, PostgresSQL, mysql, nosql, Unix, windows.

Preferred Courses/Training:

Windows NT, Word, Excel, MS Project

Preferred education experience and skills:
Knowledge of front-end tools for accessing back-end databases (e.g., Quest Toad, Oracle SQL Developer, AquaFold Aqua Data Studio, etc.).
Experience with database monitoring and performance tools.
Knowledge of Unix scripting tools (AWK, Perl, SED).
Ability to format and partition Unix disks and arrays.
Working knowledge of Microsoft SQL Server, Sybase, and Informix a plus.
Experience with Oracle’s WebCenter platform and Fusion middleware platform a plus.
Software: Oracle, Solaris, monitoring tools, performance analysis tools.

City of Hope is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, or status as a qualified individual with disability.