Geoff Pasley - Senior Database Administrator
- 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.
- 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
Environmental System Research Institute (Esri), Redlands, CA
SENIOR Database Administrator
May 2011 – Current
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
December 2006 – May 2011
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.
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)