Aaron Chester
Deer Park,WA
Summary
IT professional with a strong foundation in database administration and performance tuning. Proven track record in supporting development teams and optimizing database environments through effective query tuning and disaster recovery processes. Aiming to leverage extensive database knowledge in a data analytics role to drive actionable insights.
Overview
10
10
years of professional experience
Work History
Database Administrator
Expeditors International of Washington
04.2016 - 02.2022
- Maintained, built, and supported robust database environment with 8,000 databases globally, collaborating with other DBAs to uphold standards across all DBMS, facilitating support and ensuring consistency. Supported Customs group and collaborated with developers to implement best practices in creating database objects and troubleshooting errors. Query tuning for developers and making recommendations to improve performance. monitoring resource usage and tuning database resource usage. supporting databases in all development environments (prod,qa, and dev). created new database environments and migrated databases. Managed disaster recovery processes at DR facility for corporate offices in Seattle, conducting assessments and setups for application database recovery. This meant doing walkthroughs and assessing/setting up disaster recovery for application databases. helping teams create clustered environments for their databases to have high availability and disaster recovery.
- Administered database systems to ensure high availability and performance.
- Implemented security measures to protect sensitive information within databases.
- Developed and maintained data models for efficient data organization.
Database Engineer
Pluralsight
02.2022 - Current
- Maintained and supported production and development Postgres environments, applying SQL for troubleshooting production issues. My main job was supporting the developers through query tuning, refreshing databases to maintain updated environments for testing. Coordinated with data engineer to implement migrations and pull requests in Git for environment updates, ensuring seamless integration processes. A lot of my time was spent in Datadog monitoring our production database and if any queries were going haywire it was my responsibility to kill queries and work with developers to fix the problematic queries. Collaborated with engineering teams to migrate GitHub repositories to GitLab, enhancing version control and team collaboration. Involvement in DR exercises to stand up services and make sure our DR process is up to date just in case a disaster occurs. Supporting the snowflake team with code changes to make sure snowflake topics are readily available.
- Designed and implemented database solutions for various learning platforms.
- Maintained data integrity through regular audits and analysis processes.
- Collaborated with development teams to optimize database performance.
Education
Bachelor of Arts in Business Administration - Management Information Systems
Washington State University
Pullman, WA12-2015
Skills
- DB2
- Troubleshooting query performance (explain plans, db2advisor)
- Setup and maintaining DB2 HADR environments
- Installation and Upgrades
- Migration
- Weekly backups and archive logging
- Database partitioning setup
- SQL Server
- Performance tuning
- AlwaysOn High Availability
- Creating listener
- Performing failovers
- Rebuilding standbys
- Configure Read-Only Routing
- Comfortable creating T-SQL queries
- Daily backups with transaction log backups every 15 minutes
- OS
- DB2 databases in Solaris 10/11 and Redhat
- Comfortable navigating file systems
- Windows 2012, 2016, and 2019
- Windows Failover Cluster Manager to create AlwaysOn clusters
- SCOM
- Setting up AlwaysOn for SCOM backend
- Tuning alerts for monitoring
- Creating alerts for sql server errors (log backup failures, temp drive full)
- PostgreSQL
- Experience administering and making DDL changes
- Index Tuning
- Vacuuming
- Query Tuning
- Backup and restores
- Datadog
- Creating postgres alerts with datadog
- Installing APM for database monitoring
- Gitlab
- Creating pull requests and using Liquibase as a baseline for the PR to create additional database objects, create grants for users
- Claude
- Basic usage of claude code to make plans for tickets and get general ideas of what needs to be done for the ticket
Timeline
Database Engineer
Pluralsight
02.2022 - Current
Database Administrator
Expeditors International of Washington
04.2016 - 02.2022
Bachelor of Arts in Business Administration - Management Information Systems
Washington State University