Database Administrator

Job Title: Database Administrator DATABASE ADMINISTRATOR sought by City of Hope National Medical Center in Irwindale, CA ABOUT CITY OF HOPE: City of Hope, an innovative biomedical research, treatment and educational institution with over 4000 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 20 leading cancer centers that develops and institutes standards of care for cancer treatment. POSITION SUMMARY & KEY RESPONSIBILITIES: Duties: Responsible for the advanced design of Microsoft database installations including servers, databases, storage, and disaster recovery. Design and implement High Availability (HA) and Disaster Recovery (DR) architecture of large Microsoft SQL Server environments (more than 100 servers). Lead 24/7 support of database monitoring, maintenance and troubleshooting work including process enhancement of database backup and recovery methodology, server patching, and security updates. Plan and implement database migration/upgrade between different Microsoft SQL Server versions and perform validations. Design and setup data syndication using Microsoft transaction, snapshot and merge replication to bring desperate data sources into data warehouse. Maintain Microsoft SQL Server database performance by calculating optimum value of database parameters, implementing new releases, completing maintenance requirements, evaluating computer operating systems, and hardware resource consumptions. Design and oversee an enterprise level database security policy. Create SQL server logins, users and roles. Design and implement physical, logical and conceptual database model. Create database tables, constraints, procedures, triggers, and other database objects. Design and develop complicated SSIS and DTS packages for data integration and migration. Requirements: Bachelor's degree or equivalent in Computer Science, Computer Applications or a related field, plus Six (6) years of experience as a Database Administrator, Software Engineer or related occupation, including working on database replication (snapshot, transactional and merge), automate backup restore/refresh procedure, and SSRS reports and dashboards; working on software tools and environment including Oracle and MySQL; SQL server instance and database performance tuning and optimization using SQL Server Profiler, extended events, performance counter, SQL Audit, SQL Trace, and performance monitor (perfmon) for trace performance counters; experience in database capacity plan and storage management; designing and implementing SQL server, database security standard and policy, and database audit; implementing physical, logical, and conceptual database modeling; designing, development, and deployment experience in SSIS Package and SSAS Cubes; managing MySQL database engine on Window and Linux environments; architecting, designing and implementing High Availability (HA) and Disaster Recovery (DR) solutions of large Microsoft SQL Server environments; and installing, configuring, monitoring and troubleshooting Windows Cluster (colocation), SQL Cluster, Always on Availability Group, Availability Group Listener, Log Shipping, and Mirroring. 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. ? Department: Information Technology - provided by Dice
Architecture, Backup and Recovery, Biomedical, Database, Data Warehouse, Development, Disaster Recovery, Hardware, Linux, Management, Modeling, MySQL, mysql, Oracle, Research, Scientific, Security, Software Engineer, SQL, SQL Server, Windows

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Database Administrator for Digital Strategy
San Francisco, CA Dignity Health
Database Administrator Stf / VFA-125 / Lemoore...
Lemoore, CA Lockheed Martin Corporation
Database Administrator - SQL Database Technolo...
Norwalk, CA FactSet Research Systems Inc.
Telecommute Enterprise PostgreSQL Database Adm...
Los Angeles, CA Idexcel
MySQL Database Administrator
Pleasanton, CA Workday, Inc.
Financial Applications/Database Administrator
Morgan Hill, CA Kelly IT