We provide IT Staff Augmentation Services!

Postgressql, Mysql, Oracle And Peoplesoft Dba And Product Developer Resume

Sandy, UT

SUMMARY:

  • Oracle Database Administrator / DB Architect / SQL / PL/SQL (17 years)
  • UNIX and Linux Administrator for Databases and Applications (17 years)
  • Oracle Forms / Oracle Financials and E - Business Suite DBA (8 years)
  • Data Warehouse Developer & Project Manager / SAP Data Services (4 years)
  • PostgesSQL Database Administrator & Developer / pSQL / PL/pgSQL (2 years)

TECHNICAL SKILLS:

Platforms: Red Hat Linux, SUSE Linux, Ubuntu, HP-UX, AIX, Sun/Solaris, PCs, KVMMS Windows thru Windows 7, MS SQL Server, VM Ware

Databases: Oracle 7 / 8 / 8i / 9i / 9i RAC / 10g / 11g, SQL Server, PostgreSql, MySql

Programming: SQL, PL/SQL, pSQL, PL/pgSQL, MySql, T-Sql, Shell script, AWK, ERD, ETL, HTMLApex, Oracle Forms and Reports, Java stored procedures in Oracle database

Applications:: Oracle Enterprise Manager, SQL Developer, Toad, Quest Spotlight, RMan, Replication, Data Guard, Oracle e-Business Suite 10.7 / 11i, Visio ERD, ERwin, SAP Business Objects Data Services / Data Integrator, ETL, Oracle Data Warehouse Builder, Crystal Reports, Business Objects 6 / XI, Ab Initio Data Warehouse ETL, Oracle Data Modeler (Designer), Oracle Forms/Reports 6i / 9i /10g, Workflow, Oracle 9iAS, Oracle WebLogic, Visio, Power Point, Adobe Dreamweaver, Photoshop, Word Perfect, Word, Excel, Access, YaST, KDE, Gnome, Excel Data Analysis, Graphic Design, SCRUM, Agile, Java DBA Support Programmer, PeopleSoft, Apex

Team and Management Skills: Extensive analytical, research, writing, mentoring, and presentation skills; Ph.D. in administration

EMPLOYMENT SUMMARY:

Confidential, Sandy, UT

PostgresSQL, MySQL, Oracle and PeopleSoft DBA and Product Developer

Responsibilities:

  • Created pSQL and PL/pgSQL election swing voter data calculation programs
  • Created SQL and PL/SQL election data swing voter data calculation programs
  • Converted Oracle databases to PostgresSQL databases
  • Set up and maintained PostgresSQL backup replication of election databases
  • Collected and formatted historical election data from five states for prototype election system
  • Submitted finished prototype to Washington D.C. interest groups for use in future elections
  • Installed and tested Ubuntu and RedHat Linux configurations compared to SUSE Linux
  • Used YaST, KDE, Gnome, KVM and command line to install Linux, patches and features
  • Designed Crystal Reports templates, forms, logos, graphs and data
  • Contract Oracle DBA and PeopleSoft DBA for Boise State University, Idaho
  • Contract conversion of SQL Server databases to MySql databases

Confidential Orem, UT

Senior Oracle DBA / SQL Server DBA, Oracle Financials DBA

Responsibilities:

  • Served as Oracle 10g and SQL Server 2005-8 DBA for natural health marketing company
  • Designed data warehouse using SAP Business Objects Data Services and PL/SQL
  • Evaluated, improved, modified and maintained existing PL/SQL data loading programs
  • Served as Project Director for design and implemented complex data warehouse
  • Designed, wrote and implemented complex retail sales data loading system using PL/SQL
  • Assist developers and report writers in SQL query development and tuning
  • Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
  • Maintained/supported Oracle Financials and application performance
  • Installed Business Object XI and provided support for Business Objects 6 and XI
  • Taught staff SQL and troubleshot and optimized Business Objects Universes
  • Linux and UNIX administration, backup, RMan, patching, security patching and scripting
  • Converted Oracle databases on HP to Linux and VM Ware

Confidential, Orem, UT / Murray, UT

Senior Oracle Warehouse DBA

Responsibilities:

  • Senior Oracle 10g Data Warehouse DBA for Confidential
  • Installed SUSE Linux and served as Linux System Administrator for Confidential (
  • Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
  • Converted Windows Oracle 8 databases to SUSE Linux Oracle 10g
  • Setup Data Guard replication between databases located in Utah and India for Confidential
  • Installed Business Object XI and support Business Objects 6 and XI for GE Money
  • Migrated data and databases from legacy systems to Oracle on HP
  • Linux and UNIX administration and scripting
  • Assist developers in SQL query development and tuning

Confidential, Redwood Shore, CA / Salt Lake City, UT

Senior Applications Database Administrator, Oracle Forms Developer / Support

Responsibilities:

  • Project Director for Oracle Forms and Apex in-house management system development
  • Senior Oracle Applications DBA on 10g and 11g instances on Solaris, HP-UX and Linux
  • Contract Oracle DBA and PeopleSoft DBA for Oracle client---Northern Arizona University
  • Implemented and trained staff for using this Oracle Forms Oracle Education management system
  • Supported Oracle Forms use in Oracle e-Business Suite for Oracle Education and clients
  • Manage Concurrent Managers and Forms/Reports Servers
  • Installation and Configuration Oracle Financials 11i and e-Business Suite
  • Cloned Oracle Financials and e-Business Suite for Oracle Education
  • Conducted frequent data loading to prepare production servers and backups
  • Apply Oracle software upgrades and patches using the Oracle ad* utilities
  • Apply UNIX, Linux, middleware and client upgrades and patches

Confidential, Murray, UT

Oracle DBA, AIX Administrator, Java DBA Support Programmer

Responsibilities:

  • Serve as DBA including maintaining Java stored procedures for programmers in database
  • Serve as sole Oracle DBA and AIX administrator for code development and testing
  • Test and advise Java developers of impact of Java code on database performance
  • Design Oracle databases to meet health information system needs
  • Backup and recovery of Oracle databases using RMAN and cold backups
  • Monitor Oracle servers, tuning, capacity and space management
  • Install, upgrade and patch databases and AIX servers

Hire Now