TECHNICAL SKILLS

Training: PostgreSQL Advanced Database Administration2016

Oracle Database 11g: Administration Workshop I2010

Oracle Database 11g: Administration Workshop II2010

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 22011 grid clusterware, ASM, RAC

Sybase 15: Performance and Tuning Configuring Adaptive Server2011 locks, monitoring, caches, partitioning, tuning, parallelism

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

PostgresQL DBA / Developer

Responsibilities:

• Wrote functions and triggers in plpgsql with json inputs and returns
• Made extensive use of foreign servers and tables to pull data from other sources
• Created an encrypted instance on RDS using a snapshot of the database
• Wrote bash scripts, applied DDL, tuned queries, wrote complex queries, upgraded postgresql databases
• Created CircleCI and pgTap tests for deployment and regression testing

Confidential, Chicago, IL

PostgreSQL DBA / Developer

Responsibilities:

• Created pg dump backups and tested restores using pg restore
• Created Pentaho ETL jobs and transformations and scheduled them via cron
• Wrote linux bash shell scripts to do database performance monitoring
• Created RDS and EC2 databases on AWS, changed configuration parameters and upgraded them as needed
• Performed a MySQL - to-PostgreSQL conversion by rewriting the stored procedures as postgresql functions

Confidential, Rosemont, IL

Pentaho Developer

Responsibilities:

• Worked on migrating data from Oracle 10.1 to PostgreSQL 9.2 for magazine and newspaper circulation data using Pentaho
• Decommissioned Oracle Warehouse Builder from an application using it so that they no longer had to pay for the licensing
• Set up PostgreSQL Streaming Replication on Red Hat Linux as proof of concept
• Tuned PostgreSQL database for their new OLTP application

Confidential, Chicago, IL

Pentaho Developer

Responsibilities:

• Built a Data Mart to be used for reporting using Pentaho Kettle and PostgreSQL 9.4 on Centos Linux.
• Obtained data from an oltp source, cleansed, and loaded into the fact and dimension tables along with data from Twitter, Facebook, Google Analytics, Yahoo

Confidential, Rolling Meadows, IL

PostgreSQL Developer

Responsibilities:

• Wrote a potgresql upgrade script to upgrade circuit board making software from any version to the latest one
• Helped to convert C code into postgresql functions to allow for faster processing of circuit board analytical data

Confidential, Bannockburn, IL

Oracle Developer

Responsibilities:

• Tuned an application written almost entirely using dynamic DDL that was performing poorly
• Used the DBA and V$ views to analyze resource-intensive queries and applying or recommending changes to them
• Reduced run time of the application and allowed it to be scalable by rewriting sql, introducing indexes where needed, and using bind variables to reuse sql

Confidential, Schaumburg, IL

PostgreSQL DBA / Developer

Responsibilities:

• Worked with the PostgreSQL database for the first time, mainly as a developer using PSQL and PGAdmin on CentOS
• Wrote database functions and migrated code between environments including production
• Partitioned many database tables by date or date dimension by writing a shell script to add and drop from triggers
• Migrated data between databases to refresh them and obfuscated data used by offshore developers
• Created reports on cell phone tower data for the client using postgresql functions

Confidential, Elk Grove, IL

Database Consultant

Responsibilities:

• Learned new skills working, for the first time, with Sybase SQLAnywhere, SQLite, Powershell, SQLServer 2008 R2, Hyper-V, VMWare, Sybase PowerDesigner
• Trialed and installed BackupAssist to backup up our Hyper-V VM's
• Created Oracle and SQLServer databases and custom installation scripts. Debugged Oracle problems at client sites
• Created and maintained data models and data dictionaries

Confidential, Chicago, IL

Oracle Application DBA

Responsibilities:

• Worked with development staff as an operational DBA on 10g and 11g RAC instances, providing both application and individual sql tuning using tracing/tkprof, SQL Access and SQL Tuning Advisors
• Environment was Red Hat linux and used SQLDeveloper and EM DBConsole for daily work
• Wrote bash scripts for database auditing, database and os space usage collection, and database monitoring
• Analyzed and approved oracle stored procedures, triggers, functions, and wrote my own for database-related tasks
• Opened, updated, and monitored Oracle MySupport tickets

Confidential, Chicago, IL

Sybase Application DBA

Responsibilities:

• Used sybase 15 monitoring tables, recommended and implemented tuning changes. DBArtisan
• Assisted non-oracle staff with implementing a new application using oracle 10g. Toad, SQLDeveloper, OEM

Confidential, Chicago, IL

Sybase Application DBA

Responsibilities:

• Used sysmon outputs and data dictionary queries to determine what improvements could be made to the database. Used showplans and statistics to recommend changes to the stored procedures that consumed the most resources, determined by monitoring of the database. Transact-SQL, korn shell scripting.
• Created initial sybase-to-oracle migration script and plan using SQL Developer for proof-of-concept
• Researched slow-running procedures and recommended changes to improve response time

Confidential, Deerfield, IL

Oracle developer

Responsibilities:

• Primary developer for the web apps team, writing complex sql, triggers, procedures and packages
• Administered schemas of the applications, migrating database and linux objects through their full life cycle
• Refreshed database environments as needed using export and import
• Loaded staging tables using external tables and SQL*Loader
• The primary development tools were SQLDeveloper, SSH, and ERwin