Database Engineer
Milwaukee, Wi, Us
As a member of the data services team, I was responsible for researching, architecting, building, and automating the deployment of our DBMS technologies. I was also responsible for setting direction of our environment as far as best practices, release levels, automation, self-service, etc.MySQL:Designed, built, and deployed NM's first AWS cloud platform which supports our client website Proficient in Ansible automationHighly Skilled in native MySQL replication technologies (Master-Master, Master-Slave, XtraDB Cluster. binlog, and GTID)Ensured 99.999% availability in productionKnowledgeable on how to make changes while maintaining availability of the systemExperience in MySQL 5.6, Ansible, Satellite, ELK stack, Zabbix, Docker.AWS:Experience in RDS, Route53, EC2, EBS, Lambda, SNS, CloudWatch, AWS CLI.DB2 LUW:Worked closely with our capacity and unix teams to increase the realized capacity on P7 frames.I am a key player in editing, authoring and implementing many korn shell scripts which has taken advantage of our auto-ticketing functionality to detect problems before they become outagesGo-to person for investigating and resolving high priority incidents and problems.Brought in, built automation, and deployed Flyway for automating and versioning schema changes to our database environmentImplemented and tuned DB2 BLU to one of our warehouse databases to increase response times for end usersSkilled in supporting IBM Websphere and BPM backend databases.Performance tuned many systems to results never achieved by the application(s) previously; including Warehouses, Marts and OLTP.Well-versed with IBM's Infosphere Data Replication (IIDR) tool to replicate data from our data center to the cloudExperience in v9.1,9.7,10.1,10.5(BLU) as well as AIX.SQL Server:Limited experience in SQL Server 2008 R2 and 2012 and Windows 2003, 2008, and 2012.Other:Experience with Github, Liquibase, Flyway, Zabbix, PagerDuty, Agile Development, Automation