Resume

Geoff Pasley - Senior Database Administrator

SQL Blog: www.sqlprofessional.org
Website: www.geoffpasley.com

DOWNLOAD PDF

 

Profile

  • Information Technology professional with over 8 years of experience as a production database administrator.
  • Experience with all versions of SQL server and MySQL 5.X.
  • Extensive experience with database administration, development, architecture, engineering, and reverse engineering.
  • Operations support for 24/7/365 globally available databases, systems, and applications.

 

Technical Skills

  • Databases:
    • Microsoft SQL: 2014/2012/2008-R2/2008/2005/2000/7
    • MySQL: 5.X
  • Native SQL Tools:
    • Reporting Services, Analysis Services, Profiler, Database Tuning Advisor, Performance Monitor
  • 3rd Party SQL Tools:
    • Quest Foglight and Spotlight, RedGate, CommVault, MySQL Workbench, Toad

 

Experience

Environmental System Research Institute (Esri), Redlands, CA

SENIOR Database Administrator

May 2011 – Current

Responsibilities include:
  • Provide priority level troubleshooting and problem resolution for issues both internal and external.
  • Coach and delegate work to other junior or mid-level database administrators.
  • Support a 27/7 environment, including several environments with an SLA of 99.95%
  • On call rotation for after-hours support, as well as escalation support for priority and high profile issues.
  • Design and implement High Availability and Disaster Recovery (HADR) for highly critical databases.
  • Maintain database performance and optimization enterprise wide.
  • Analyze and perform metrics on databases. Identify performance issues and implement changes to optimize performance.
  • Ensure successful database and transaction log backups are preformed for each instance based on the application’s requirements.
  • Work with vendors to setup proof-of-concepts, implementations, and full scale deployments of tools and applications that will be used throughout the enterprise.
  • Document database environment architecture as required.
  • Commonly access and handle confidential and sensitive information.

San Manuel Band of Mission Indians, Highland, CA

DATABASE ADMINISTRATOR

December 2006 – May 2011

Responsibilities include:
  • Monitor (on a daily basis) various Microsoft SQL databases for CommVault snap-shot success, standard SQL backup success, and transactions log backups. Health checks on all databases are a daily task.
  • Ensure Microsoft SQL mirroring is performing optimally and all transactions are recorded locally and at the designated disaster recovery site.
  • Perform database indexing on a weekly basis, due to high volume of I/O.
  • Archive historical data from MSSQL data stores and LUNS. Move historical data to remotely located SANs.
  • Design custom scripts to expedite database creation/maintenance. This includes, but not limited to: user audit reports, scripted table creations and data imports, database bulk inserts, and maintenance procedures.
  • Working directly with vendors to allow application integration with our environment between front-end users and back-end serves/databases.
  • General responsibilities include: Develop relational models and ERD diagrams, perform complex data analysis, create data dictionaries and database descriptions, and interact with various types of end-users (customers, team leads, managers, vendors etc.) to provide service and support for database implementation and maintenance. Keep the IT Director/Manager/Supervisor in touch with new technologies in database management, optimization and design.

 

Education

California State University, San Bernardino, CA
School of Computer Science and Engineering
Bachelor of Computer Science / Psychology
  • Dean’s List 3 Quarters
  • Computer Science GPA:
    Core: 3.413
    Option: 3.950
University of Redlands, Redlands, CA
School of Business
Masters of Business Administration (Accepted Candidate)