Photography |  Biography | Resume | Home

Kelley Rianna Prebil
EDUCATION Boston University, Metropolitan College, Boston, Massachusetts
Master of Science in Computer Information Systems, May 2009
San Francisco State University, College of Science and Engineering, San Francisco, California
Bachelor of Science in Physics with a minor in Mathematics, May 2005
Cornell University, College of Architecture, Art, and Planning, Ithaca, New York
Bachelor of Fine Arts in Photography, May 1999
SKILLS Systems: Windows; Macintosh; UNIX (Red Hat, Solaris, Mandrake)
Computer Languages: SQL, T-SQL, C#, Java, XML, HTML
Software: Microsoft Visual Studio .NET, Microsoft SQL Server Tools, Microsoft Visual Studio 6.0, Microsoft Office Suite, SQL Server Reporting Services, SQL Server Integration Services, Subversion, RedGate SQL Backup, Idera SQL Diagnostics Manager, Microsoft Visio
Databases: SQL Server 2000/2005/2008 R2/2012/2014, MySQL, Oracle
Database Design Skills: Data Modeling, Data Analysis, 1st/2nd/3rd/4th Normal Forms, Data Integrity, ER Diagrams, Logical Schema/Design, Physical Schema/Design, DBLC, Joins
Languages: Knowledgeable in Spanish and Japanese
EXPERIENCE SENIOR DATABASE ADMINISTRATOR
Information Technology, California Academy of Sciences
San Francisco, California
(January 2017 - Present)
SENIOR DATABASE ADMINISTRATOR
Pure IP
San Francisco, California
(July 2016 - January 2017)
·Designed and completed data archiving for large data sets over 6 months old
·Setup and maintained SQL Server Agent jobs, merge replication, archiving, and backup and recovery strategies
·Proactively monitor database server health
·Ensured data consistency, security, and integrity across all systems
·Identified and resolved database performance issues, database capacity issues, and other distributed data issues
·Assisted developers and business power users in query requests and enhancements
·Optimized stored procedures and provide suggestions for additional indexes
·Authored database dictionaries and process documentation
·Communicated with employees at all levels and areas
SENIOR APPLICATION DATABASE ADMINISTRATOR
IT Operations, Prosper Marketplace
San Francisco, California
(January 2016 - July 2016)
·Migrated database security to AD groups instead of individual logins to streamline and maintain secure database access for Engineering and BI teams
·Administered several 24x7x365 high traffic production database clusters across multiple data centers
·Responsible for extensive SQL Server monitoring, troubleshooting, tuning, high-availability strategies
·Maintained SQL Server Agent jobs, transactional replication, log shipping, archiving, and backup and recovery strategies
·Ensured data consistency, security, and integrity across all systems
·Identified and resolved database performance issues, database capacity issues, and other distributed data issues
·Configured and maintained AlwaysOn for data redundancy and reporting purposes
·Reviewed DML and DDL scripts submitted by software developers during the SDLC
·Assisted developers and business power users in query requests and enhancements
·Optimized stored procedures and provide suggestions for additional indexes
·Installed, configured, upgraded, migrated, and tested SQL Server databases
·Maintained, modified, and troubleshooted SSIS packages
·Authored database dictionaries and process documentation
·Communicated with employees at all levels and areas
·Participated in 24x7x365 on-call pager rotation schedule
SENIOR DATABASE ADMINISTRATOR
Information Services, SCI Solutions
Campbell, California
(October 2014 - December 2015)
·Administered several medical client production databases across multiple platforms in accordance with HIPAA standards
·Automated and optimized several processes including database refreshes from production to staging environments, data imports, back office billing data load and reports, and non-standard application settings reports
·Troubleshooted vendor and in-house production database server performance issues
·Led and authored the purchase proposal for Ideral SQL Diagnostic Manager
·Identified and resolved database performance issues, database capacity issues, and other distributed data issues
·Coordinated with Network Administrator and Software Engineers to ensure data security, integrity, and availability
·Administered SQL Server jobs and proactively monitored & optimized data replication/ETL processes
·Investigated and resolved any query/database performance issues and assisted developers and business power users in query requests and enhancements
DATABASE ADMINISTRATOR
Information Systems, Panda Restaurant Group
Rosemead, California
(June 2013 - October 2014)
·Administered several VLDB 24x7x365 high traffic production database clusters across multiple platforms
·Executed and enforced operational and administrative tasks with a focus on maintaining the stability of the data stream between AS400, SQL Server, and Netezza
·Troubleshooted and resolved vendor and in-house applications data and performance issues
·Maintained and monitored database backup and restore processes including ensuring sensitive data security
·Coordinated with the Network Administrators & Developers to ensure data security, integrity, and availability
·Performed database performance analysis and optimization
·Communicated and maintained SQL Server concepts and best practices
·Planned, designed, and implemented the database capacity, physical and logical modeling, and security practices for every phase of major .NET application development
·Administered SQL Server jobs and proactively monitored & optimized data replication/ETL processes
·Reviewed the design and deployment of data objects from development/staging to production
·Investigated and resolved any query/database performance issues and assisted developers and business power users in query requests and enhancements
·Optimized stored procedures and provide suggestions for additional indexes
·Installed, configured, upgraded, migrated, and tested SQL Server databases
·Developed and maintained SSIS packages
·Communicated with and trained employees at all levels and areas
DATABASE ADMINISTRATOR
Applied Underwriters
Foster City, California
(September 2012 - June 2013)
·Designed, maintained and ensured high availability of VLDB 24x7x365 production database clusters
·Responsible for extensive SQL server monitoring, troubleshooting, tuning, high-availability strategies
·Developed and implemented replication, mirroring, archiving, and backup and recovery strategies
·Provided high-level database support and guidance to existing systems and those in development
·Ensured data consistency and integrity across all systems
·Planned hardware requirements and storage capacity for production servers for scalable database growth
·Proactively monitored the production database and optimized it for better performance
·Resolved locking conflicts and resource utilization issues
·Administer, maintain, develop and recommend policies & procedures for ensuring the security and integrity of the company’s databases
·Managed & created database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.)
·Implement production SQL Server database objects, models and database designs
·Identified and resolved database performance issues, database capacity issues, and other distributed data issues
DATABASE ADMINISTRATOR
Product Development, Coupons Inc.
Mountain View, California
(July 2009 - August 2012)
·Administer several VLDB 24x7x365 high traffic production database clusters
·Provide hardware and software support for production and development database environments
·Troubleshoot production database performance issues
·Maintain transactional replication for production, development, and QA environments
·Create Windows batch programs for configuring database servers on VMWare clones including setting up linked servers and transactional replication
·Create data imports methods from various file types including XML, CSV, and TXT files
·Reloaded multiple servers in QA and development environments on a recurring basis
·Optimize stored procedures and provide suggestions (if necessary) for additional indexes
·Review DML and DDL scripts submitted by software developers during the SDLC
·Produce stored procedures supporting requested recurring reports for internal and external usage
DATABASE ADMINISTRATOR
Applications Support Group, Gensler
San Francisco, California
(October 2005 - June 2009)
·Communicated with and train employees at all levels and areas
·Managed SQL Server security, growth, backups, performance, monitoring, troubleshooting, log shipping, and task scheduling
·Designed database disaster recovery plan
·Identified, troubleshooted, and resolved real-time SQL Server server, database, and data issues
·Created, monitored, and troubleshooted SQL Server agent jobs for data transfer and manipulation
·Installed, configured, upgraded, migrated, and tested SQL Server databases and dependent applications
·Designed, developed, and supported custom reports in SQl Server Reporting Services and Actuate
·Designed, developed, and supported DTS and SSIS packages
·Perform database queries to assist all business development teams
·Implemented, customized, and supported legacy and new in-house and third party systems including CRM, Accounting, Finance, and Human Resources systems
·Wrote .NET/C# applications embedded in third-party software and stand-alone applications
·Designed and supported SQL Server data warehouses
TEACHING ASSISTANT
Department of Physics, San Francisco State University
San Francisco, California
(January 2005 - May 2005)
·Prepared and lectured on concepts of electricity, magnetism, radiation, optics, quantum physics, and atomic physics to non-science majors on a weekly basis
·Collaborated with professor on session material
·Individually tutored students
WEB PROGRAMMER INTERN
International Americas, MySales, Sun Microsystems
Menlo Park, California
(June 2003 - March 2004)
·Helped streamline group's online community and communications
·Wrote JSP applications to generate metric reports from MySQL database
·Wrote SQL queries and designed database schema for MySQL database
RESEARCH ASSISTANT
Psychophysiology Lab, NASA Ames Research Center
Moffett Field, California
(September 2002-June 2003)
·Analyzed and reduced Real-time data from experiments
·Created graphical representation of data
·Assisted in preparation of Powerpoint Presentations for research results
ADMINISTRATIVE ASSISTANT II
Department of Surgery, UCSF General Hospital
San Francisco, California
(July 2001-December 2001)
WEB PRODUCER
Learning Solutions and Development, DigitalThink
San Francisco, California
(July 2000-February 2001)
WEB DESIGNER
Zappos.com
San Francisco, California
(April 2000-June 2000)
SLIDE TECHNICIAN
The New Lab
San Francisco, California
(November 1999-April 2000)
SENIOR PHOTOGRAPHER
Prestige Portraits
San Carlos, California
(June 1999-November 1999)
LAB ASSISTANT
Department of Biochemistry, Cornell University
Ithaca, New York
(June 1996-May 1999)
DARKROOM MONITOR
Department of Art, Cornell University
Ithaca, New York
(August 1997-June 1998)
COMMUNITY LEADERSHIP OBSERVER, Catalina Channel Swimming Federation (2014 - present)
STEWARDSHIP DIRECTOR, Western Cave Conservancy (2012 - present)
WEBMASTER, Western Cave Conservancy (2005 - present)
TRUSTEE, Crystal Sequoia Cave, Sequoia National Park (2007 - present)
WEBMASTER, San Francisco Bay Chapter of the National Speleological Society (2002 - 2015)
ADVISORY BOARD MEMBER, Western Cave Conservancy (2008 - 2012)
IT COMMITTEE CHAIR, National Speleological Society (2003 - 2005)
WEBMASTER, 2003 National Speleological Society Convention (2002 - 2003)
NEWSLETTER EDITOR, San Francisco Bay Chapter of the National Speleological Society (2002 - 2003)
AFFILIATIONS Catalina Channel Swimming Federation
Santa Barbara Channel Swimming Association
U.S. Masters Swimming
South End Rowing Club
SheSpoke Cycling
Cornell Native American Alumni Association
Cornell Alumni Admissions Ambassador Network
National Speleological Society
Cave Research Foundation
Western Cave Conservancy
American Motorcyclist Association