James Tyranski Jr.
Linux Engineer / MySQL / PostgreSQL DBA
Woodstock, IL 60098
***@********.***
EXPERIENCE
Cullerton Group — DBA / Architect
February 2020 - April 2020 - SPR / Shoprunner
Responsibilities:
Evaluate existing database a layout, suggest improvements
Benchmark and migrate MySQL 5.6 to Amazon Aurora
Create solution for maintaining key large tables
Create solution for tables with foreign indexes and work with developers to make changes
Close collaboration with engineering on schema additions and updates utilizing Liquibase
Data migration while upgrading database versions
Writing database stored procedures for large table maintenance
Monitor and manage database indexes for optimal performance
Configure and impliment proxySQL using Docker
Jobba Trade Technologies, Inc. — Systems Engineer
June 2010 - February 2020
Responsibilities:
Design and administer application database. Optimize for OLAP and OLPT.
Develop database backup strategies, data extraction, and custom reporting.
Architect and administer Rackspace, Google Cloud, and Amazon Web Service accounts to provide secure and optimized applications.
Plan, configure, deploy, and secure linux cloud servers, load balancers, database instances.
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Data migration while upgrading database versions
Used New Relic, AWS CloudWatch, and Google Stackdriver monitoring tools to monitor traffic and increase performance.
Streamlined code deployment process and communication procedures with customers.
Developed automation and deployment utilities using Github and Mercurial
Write and maintain code using Python, PHP, Javascript, and SQL Achievements:
Communicate directly with customers, operations, and development teams
Planned and implemented entire cloud infrastructure from Rackspace dedicated servers to a complete cloud solution, allowing for improved performance and better managed development platform.
Used my knowledge of open source tools to help reduce infrastructure costs, while maintaining performance.
Created and managed development policies and procedures for growing development team
SKILLS
9+ years Administrating
Linux Operating systems.
Installation, configuration,
maintenance using CLI.
Can install software from
packages or from
compiling.
Development and scripting
using PHP, Javascript, SQL,
Python, and Bash.
Experience with AWS,
Google Cloud Platform,
and Rackspace cloud
technologies. Provision
and manage cloud
Infrastructure, including
server config, database,
load balancing, and
managing cloud file
containers.
Experience with database
administration - Amazon
Aurora, PostgreSQL,
MySQL, and MariaDB.
James Tyranski Jr. Page 2
continued
EDUCATION
Currently working on AWS Certified Solutions Architect - Associate Level certification
William Rainey Harper College — Computer Science
August 1989 - June 1992
Crystal Lake Central High School — Graduated
August 1985 - June 1989