SUMMARY

• Oracle Database Administration Exposure: Experience administering Oracle 9i and 11gR2 instances on HP/UX, Oracle/Linux 6 platforms. Able to review, implement PL/SQL, DDL, DML code installations in support of database testing. Strong knowledge of database refresh / cloning methods. Strong Unix / Linux command line usage. Exposure to RMAN methods. Ability to create, manage objects, manage user schema's permissions and passwords. Able to monitor database performance, review / analyze Oracle logs. Strong understanding of RDBMS testing life cycle. Service oriented communicator, provides support for end users, developers, analysts.
• 6 year's experience using advanced SQL in enterprise level database environments: Transform large amounts of raw, complex data into meaningful information. Strong understanding of data warehousing concepts. Advanced SQL query writing inner and outer joins, sub queries, string functions, data type conversion . Logistics data analysis, financial data analysis, ad-hoc reporting, reconciliation, data modeling, custom database creation, ETL. Reconcile data from dissimilar sources. Able to juggle multiple projects, set priorities, and meet deadlines with spot on accuracy.
• Additional hands-on Oracle training see detail : Upgrades, Patching, Backup and Recovery methods, ASM, Performance tuning, Security, Troubleshooting, Real Application Clusters RAC
• Tools: Oracle, Unix, Linux, Red Hat, SQL Plus, SQL Developer, TOAD, Enterprise Manager, DBCA, Grid Control, VMWare, VirtualBox, Advanced Access and Excel formulas, pivot tables, v-lookups , SQL Server, SSRS, MySQL

EXPERIENCE

Confidential

• Administered Oracle 9i and 11g instances on HP/UX, Oracle Linux 6 platforms
• Utilized change management software to facilitate database changes
• Installed PL/SQL, DDL and DML scripts in SIT and UAT test instances using SQL Plus
• Supported developers in review and implementation of PL/SQL code installations
• Reviewed, edited PL/SQL procedures, packages, and triggers in support of developers
• Ensured cursors were closed within PL/SQL code blocks
• Ensured all dependent schema objects were backed up prior to installing code
• Identified, recompiled invalid objects after database code changes and installations
• Analyzed and updated object statistics using DBMS STATS packages
• Utilized cold backup methods to refresh test and development databases
• Utilized Vi, Unix shell scripting to edit backup trace control file used for cloning database
• Utilized dblink to copy objects between instances
• Performed daily DBA tasks such as verify Oracle processes, monitor alert logs
• Reviewed and cleaned out old log / trace files
• Reviewed daily back up logs for production and stand by databases
• Investigated / resolved RMAN backup errors, verified successful physical tape creation
• Optimized database performance by adding redo logs
• Stopped and restarted test instances
• Performed base install of Oracle/Linux 6 server software
• Configured Cygwin for use with Oracle Universal Installer GUI
• Installed Oracle 11gR2 instance, adjusted Linux kernel parameters as prompted by OUI
• Provided technical support of the RDBMS and managed passwords for end users
• Created new tables in production and test databases
• Utilized TOAD to interrogate slow database and SQL performance
• Participated in production turnover
• Communicated with developers and business analysts for clarification during the SDLC
• Utilized shell scripts to invoke processes in support of testing requirements
• Communicated with application server team to coordinate database vs application changes

Confidential

• Designed / implemented databases via Access and SQL Server Data Warehouse
• Conducted data modeling analysis in support of business requirements
• Utilized various schemas and views within the database and data warehouse
• Wrote SQL queries in order to analyze financial data
• Responsible for all manual updates to the data warehouse
• Loaded daily customer .csv invoice files to the accounting database
• Tested, reviewed, cleaned new customer files due to system upgrades as needed
• Reviewed, tested files and processes for new internal accounting system
• Developed creative and logical solutions to solve complex data challenges
• Implemented ETL solutions extraction/transformation/loading for manual processes
• Ensured data accuracy in support of management decision making and planning
• Compiled data used for budgeting, forecasting, reconciliation, month end reporting
• Transformed complex, raw data files from customer into meaningful reports
• Communicated with all levels of staff and clients to resolve technical issues
• Collaborated with customers to provide them data meeting their business requirements
• Provided ad-hoc reporting and analysis for internal and external customers
• Reconciled 3M per month in A/P inventory
• Exceeded shrinkage goals of less than .5

Confidential

• Analyzed logistics data in a SQL Server data warehouse
• Created / distributed field reports used for asset tracking and recovery
• Worked within a team to meet monthly deadlines and goals
• Improved shrinkage loss by 15k - 20k per month
• Performed asset recovery via phone and email
• Supported technicians and customers via phone in a large 24/7 call center
• Documented materials and labor data used for logistics and reporting

Confidential

• Tested the installation, functionality and GUI of mapping software
• Created, executed test plans and/or followed structured scripts
• Performed regression testing
• Posted materials and labor data in a large 24/7 call center