Etl Developer Resume
2.00/5 (Submit Your Rating)
Objective
To obtain a position utilizing my experience in administration, development, standards and compliance that will allow me to take my career to the next level.
Experience
Confidential,DBA Jan 09 – Present
- Provide level 2 and 3 On-Call for Oracle DB, MySql, SQL DB, and Oracle App Servers
- Provide administration, support and security for FEMA’s ELA, a LAMP stack with full redundancy in a geographically relocated data center
- Managing offsite contract dba support group
- Provide tuning support for sql and pl/sql support to development groups
- Monitoring and testing Oracle, SQL server and MySql backups
- Implemented production and Data Guard configurations of oracle 11g on Unix and Red Hat
- Rebuilding / Refreshing Dev and QA Databases from Production
- Performing QA and Production database code releases
- Developed SOX and PCI audit reports
- Administering software licenses and support renewal
Security
- Responsible for maintaining and enforcing all PCI and SOX related requirements including internal and external vulnerability scanning and assessment, writing and implementing policies, firewall configuration reviews, primary contact for external QSA and PCI certified penetration testers, ect..
- Responsible for daily, weekly, monthly and quarterly auditing and log review for systems including Tripwire, Qradar, Firewall Blocking, AV, Patch audits, Password audits
- Manage, schedule and implement plan for a global security audit leveraging outside consultants
Project Management
- Planned, Scheduled and organized effort to migrate all applications from Wichita datacenter to an Atlanta data center Las Vegas DR data Center. Systems included Oracle, Solaris 10, MySql, Apache, Microsoft Servers, Fax Servers ect…
- Planned, Scheduled and organized effort to migrate from Server 2003 / Microsoft Dynamics 9 to Server 2008 / Microsoft Dynamics 10
Production Control
- Manage/implement jobs in Control-M, Cron, Windows Scheduler, Oracle Scheduler and Oracle Jobs
- Provide 24/7 support on rotation for credit authorization system
- Approve or Deny system changes as part of change control board
- Administer, install and upgrade Control-M instances
- Sent to Prague, CZ to consult during install of Control-M instance in datacenter
Confidential,ETL Developer Mar 07– Dec 08
- Developing ETL processes using Data Stage 7 and Oracle in a Sun Solaris environment
- Designing and tuning Oracle/SQL using TOAD.
- Designing scripts to audit, balance and control production processes.
- Supporting day to day data warehouse and system operations.
Confidential, System Analyst May 05 – Mar 07
- Defining technical requirements from business users.
- Developing JCL programs which leverage SORT-D and SAS to pre-process and provision data to remote AIX servers.
- Developed ETL processes using Informatica Powercenter and DB2 implemented in an AIX environment.
- Developed and tuned DB2 SQL using Command Center.
- Building and modifying data models using ER/Studio and VBA scripting
Confidential, Student Work Program Jan 03 – May 05
- Microsoft desktop support
- Implementing web updates
- Computer lab support technician
- Provide reporting from university DB2 system on graduation census
Education
Bachelors of Science in Information Systems
Training Courses
- SANS: SEC401 Security Essentials Bootcamp Style
- Oracle: 11g Administration Workshop II revision 2
- DBA University: Oracle DBA
- Oracle: 10g Administration Workshop revision 2