Tom Chisholm Email & Phone Number

Portland, Or, Us

Minneapolis, Minnesota, Us

Arlington, Virginia, Us

Vernon Hills, Il, Us

Wisconsin Rapids, Wi, Us

Part of an international team responsible for multi-year project migrating Renaissance applications from DC to AWS. Heavy emphasis on data engineering and data delivery. Agile shop.Regular duties: Tier 1,2,3 support for Linux and Windows nodesOverseeing code deployments to Production Source management (including GitFlow)Environment management (dev, pre-staging, performance, staging)Monitoring and troubleshooting DB issues (RDS, Mongo, DynamoDB, Redshift, Postgres, Aurora)Developing and deploying Terraform for application and infrastructure changesAlfresco management for all environmentsWork with international contracting teams in several different time zonesParticipation in on-call rotation.Build and release management duties, including PR management, assistance to developers, repo templating, BOM management Projects: Ground-up build-out of an AWS-resident CI/CD pipeline. Tooling includes Bash, Python, AWSCLI, Terraform, Docker, Ansible and JenkinsCo-designed and developed Data CI/CD pipeline. Tooling: Jenkins, Docker, Ansible, Liquibase, AWSCI, Postgres, SQL Server, MySQL, git, and RDS. Features include: build-on-commit, unit-testing, static analysis, linting, performance testing, and centralized build database for monitoring changesets from development to production deploymentConverting monolith application to Terraform-backed Docker microservices (Windows and Linux). Tooling: Jenkins, Docker, git, AWSCLI, ECS, ECR, .NET Core 2.0Designed and implemented a per-zone diagnostic hub for microservices, lambdas and databases. Tooling: Docker, C#Designed database development methodology and tooling, leveraging AWS RDS snaphotsSelected implemented and maintain performance monitoring tool for RDS instances (pganalyze), including Production instances.

Chicago, Il, Us

Part of a small team dedicated to automating client installations and monitoring of all RDBMs. Duties include: Tier 2 and 3 database support for 27 discrete production environments. Tier 1 and 2 Linux administration. Nagios administration. Puppet development and administration. Server build-out and monitoring. Extensive Powershell and Puppet automation.

(Contract) Ground-floor work on designing AWS VPC, building image templates for developers, and work on CD/CI pipeline. Tools used: EC2, S3, RDS, VPC, OpsWorks, MongoDB, SQL Server, .NET/Open Source Stack.

Lake Oswego, Oregon, Us

Database and Infrastructure responsibility for a 24x7 IT production environment supporting real-time payment processing systems. Environment spans 5 datacenters, over multiple geographical locations. Included is management and oversight of all IT Infrastructure, Database Operations, Data Layer Architecture and Data Delivery. Note: All duties from previous role as DBA Manager continued in this role.• Management and oversight of all datacenter infrastructure server and SAN systems. Includes: -Multiple VMWare farms for production and back-office systems -All SAN and NAS storage, enterprise-wide -All physical machines, including HA database clusters -Datacenter build-out and management• Ensured customer SLA and up-time requirements were met • Introduced and hosted the daily company-wide Standup—an operations-focused open meeting concentrated on solving current issues, operational challenges, current IT projects, and upcoming code deployments. Typical attendance ranged from 30 to 40 participants, with all groups represented--from developers to business owners.• Merged and integrated storage and DBA teams to improve transactional performance through coordinated vertical tuning and monitoring. Increased efficiency of snapclones by creating collaborative engagement between SAN engineers and DBAs• Implemented IT workflow tool (Trello) for planning, tracking, and visibility of Infrastructure and DBA projects• Daily management of two separate teams, with two technical leads (including staff in Atlanta, GA and Dundalk, Ireland)

Lake Oswego, Oregon, Us

Responsible for the overall management, security, robustness, stability and policies governing the global 24/7 production database services. Manage team in addition to serving as an individual contributor. No external or internal SLA infractions in 3 ½ years.• Ownership of all data servers in Production, UAT, QA and Development environments, in one local and three remote datacenters. Included HA clusters, standalones, virtual and physical• Provided services and SLAs to internal business owners. Includes: Finance, Marketing, Engineering, DevOps, Risk Management, Security and QA• Designed and built-out HA data layer in three separate remote production sites• Designed and implemented data layer for enterprise-wide Disaster Recovery solution between remote production sites• Successfully migrated all production databases from standalones to clusters over a period of eight months• Implemented virtual SQL Servers for back office support databases• Significantly reduced resource consumption on production data servers through methodical and routine performance tuning of database code; designed and built-out production performance testing lab; worked closely with Engineering and QA to implement enhanced database code• Conducted code reviews and onsite SQL training for developers. Established official SQL Coding Guidelines and Best Practices documents for SSIS development• Extensive implementation of EqualLogic and NetApp snapclone technology for data delivery to business groups within the corporation.• Designed, developed, and deployed a data warehouse to support marketing efforts

Lake Oswego, Oregon, Us

• Performed functional and performance testing for production database code drops; responsible for testing of all fraud detection code• Participated in monthly production maintenances and after-hours code deployments; worked closely with production DBAs to verify functionality and performance of post-deployment code • Reduced total testing time for code drops by introducing database snapshots as an integrated part of QA testing.• Researched, tested and oversaw production data server upgrades and database migration from SQL Server 2000-2005. • Designed and executed test plans against three separate storage vendors using SQLIO and Iometer; built database to capture, aggregate and analyze test data; presented test results to management to guide purchase decisions.• Regular collaboration with remote development and QA teams• Conducted root cause analysis for production database incidents and problems.• Synched company databases across Development, Integration, and QA environments• Provided performance tuning feedback to developers. Extensive use of JMeter, Fitnesse, SQLQueryStress and custom load-testing scripts• Installed first cluster in QA environment; assisted with installation of first production cluster; wrote documents on Windows and SQL Clustering still in use in production

• Responsible for daily, weekly and monthly maintenance cycles on 8 database servers, 50+ databases. Includes off-site backups, transactional backups, replication, log file maintenance, and index maintenance.• Designed and developed a publish-on-demand import system utilizing File Transport Protocol, SQL Server DTS and integration with Google Maps API. Application allowed graphical representation of client retail outlets based on address/zip lookup.• Optimized clients’ databases through SQL query optimization, normalizing data structures, indexing, and routine profiling• Created import ETL processes that import, process and distribute client records in a timely, accurate and secure manner. Export ETL processes created for client sales affiliates, distribution centers, offline database reporting and other ERP systems.• Gathered business requirement reports and use cases for physical/logical data modeling. Designed and developed OLTP databases for online e-commerce clients. • Designed and developed data structures for CRM, invoicing, and data warehousing modules.• Integrated online merchant payment services (Cybercash, Verified by Visa) with web application and databases.