Senior Oracle Dba Resume
Washington, DC
SUMMARY:
18 years’ experience designing, developing and implementing solutions using Oracle Technologies. Oracle Certified Professional Developer, DBA and Architect with in-depth knowledge of SQL, PL/SQL, Oracle RAC, Data Guard, RMAN, Oracle Discoverer, Oracle Designer, Oracle Data Warehouse, Crystal Reports, Business Objects, Oracle Advanced Security, Oracle APEX, Oracle 9i 10g, 11i,Unix, Windows 2003, IBM AIX5. Expert in using, OEM, RMAN, SQL LOADER, TOAD, VM Ware, MS Project, VISIO, ER-WIN, Unix Shell Scripting. Developer having experience in Full Life-Cycle Software Development. Expertise in Training/Courseware Development. Subject Matter Expert in developing and implementing systems security policy, guidelines, and procedures for systems processing multiple applications that require differing and conflicting security controls. Experience working with very large databases (over 3 TB).
Lead Oracle DBA/SME, provide database performance, architecture, business intelligence, and management consulting in support of various projects. Write and present training seminars to project managers and development staff to accelerate new technology integration. Examine current business functions and suggest strategies for technology development that streamline operations and automate data processes. Compose Proof of Concept presentations and suggest integration solutions
EDUCATION:
M. B. A. Finance
M. S. Finance
B. B. A. International Business
SKILLS PROFILE:
Hardware:IBM-AIX, SUN Solaris, COMPAQ/HP, TOSHIBA, VM-Ware, Pentium PCs
Operating Systems: Windows NT/XP/Vista/7, HP9000, Redhat Linux.
Software Tools: OracleDeveloper, Oracle Designer, Oracle Discoverer, Oracle Enterprise Manager, Oracle Data Guard, Oracle RAC, Oracle APEX, RMAN, ER-Win, ETL, Business Objects, Oracle Data-Mart, Toad, MS Office, MS Project, MS Visio, Momentum, Visual Studio, VSS, Clear Quest, Share Point, EntelliTrack by Micropact.
Languages: SQL, PL/SQL, Unix Shell Script
RDBMS: Oracle 11g/10g, SQL Server,My SQL.
PROFESSIONAL EXPERIENCE:
4/2006 to Present Confidential,MD, Senior Oracle DBA/Data Architect/Project Manager/SME
Data Architectresponsible for migrating/transforming an application in Non-Relational Database (MUMPS) to Oracle 11g for Veterans Administration. Installed and configured Oracle APEX 4.1. Created “Apartment Rental” application. Set up several Redhat Linux 6.2 (64 Bit) on VM-Ware Workstation 8 to create Oracle 11g environments for development, test and training. Installed several Oracle Dataguard Instances on Oracle 10204 and 11202 for DOJ on IBM-AIX platform. Work with application developers to ensure data integrity on Primary and Logical Standby Databases. Performance monitoring and Tuning of all databases using Oracle Grid Control and AWR Reports. Redesigned the Database. Created roles, privileges, functions to control access for the Momentum (CGI) application. Created Workgroup mode and Enterprise mode environments for Business objects. Created and modified BO Universe, Classes and Objects, Fact Tables and Aggregate Tables as and when requested by end users. Reviewed final software installation and system plans for additional security risks not identified during proposal stages and recommended work process changes and general design and programming techniques to alleviate potential security problems. Investigated security incidents for cause and the most effective corrective actions. Monitored and evaluated changes that effect systems security. Installed two node Oracle RAC. Created proof of concept for an Oracle Data Warehouse. Created programs using UNIX shell scripting to automate processes. Set up Oracle Golden Gate and demonstrated proof of concept for senior managers and government officials. Senior Oracle DBA responsible for MHS LEARN database for Tri-Care, US Military Health Care System. Migrated over 2 Million user accounts from a previous system to Oracle 10g Database using HIPAA guidelines. Maintain the Database in Production Development and Testing Environments. Coordinating with DBAs and managing servers in Unix VIA VPN and windows environment. Apply Security Patches (CPU Patches) and Upgrade patches to Oracle Databases and Application Servers. Upgraded Oracle Database from 9.2.0.8 to 10.2.0.3 10 to 11202 Upgraded Oracle Application Server from 9.2.0.3 to 10.1.2.0 to 11.2.1 Set up a 2 Node Oracle RAC. Expertise in OEM, RMAN, and TOAD. Supervising 3 DBA’s and 4 Developers. Planned, scheduled, coordinated and monitored the Database downtimes and ensured 24/7 availability. Advised management on setting goals and targets. Supervised project planning using Ms. Project to ensure meeting deadlines. Trained personnel. Made presentations to senior management and government officials. Conducted special security studies, analyses, surveys and reviews of IT systems to assure that appropriate levels of safeguards exist to protect against perceived threats. Planed and directed the development of security criteria and guidelines for users of IT systems.
2/2005 to 3/2006 Confidential, VA Project Manager
Keyview Systems Manager responsible for maintaining US Army’s Personnel Database for creating reports. Roles and responsibilities include; plan, direct, and co-ordinate a cross-functional team activities to manage and implement project and interrelated programs from contract/proposal initiation to final operational stage using MS Project. Leading a Data Warehouse project to redesign an existing antiquated system. Established risk-management procedures and ensured that risk-management techniques are applied to all new or modified computer applications. Continually evaluate current system security posture, monitors activities, and assesses the security awareness knowledge of staff as it relates to assigned areas of responsibility. Determined, monitored, and reviewed all project economics to include costs, operational budgets, staffing requirements, sub-contractors, resources, and risk. Identified and assembled the appropriate blend of resources to meet project/program needs and requirements, including sub-contractor selection. Planed, scheduled, monitored and reported on activities related to the project. Lead the project team in determining client requirements and translating requirements into operational plans. Maintain awareness of emerging technologies and project management techniques. Designed a system that creates and sends out reports without human intervention and help save thousands of man hours. Redesigned an Oracle Datawarehouse and improved response time. Supervise 7 developers and 3 DBAs. Managed 2 subcontracting companies. Implemented Track-It to track Help Desk calls and improved response time. Hired and trained personnel.
9/2004 to 1/2005 Confidential, Washington, DC Oracle DBA/Senior Consultant
Oracle DBA responsible for 7 Servers and 3 environments, namely Production, Development and Testing. Managed Oracle 9i migrating to Oracle 10g. Technical expert in using OEM, RMAN and TOAD to perform migration, backup and restoration of databases. Created Data Model using ER-WIN. Loading and transporting data using SQL Loader. Support application developers. Expert on creating new environment for the next release of the application. Supervised 4 DBAs and 6 developers. Facilitated status review meetings among project team members and clients. Worked with senior management on project proposals, bids, contracts, estimates, and schedules using MS Project. Proposed and developed add-on program opportunities. Mentored and trained the customer and vendor in project management methods, procedures, and activities. Controlled project requirements, scope, and change management issues. Coached and counseled members of cross-functional teams to accomplish project goals, to meet established schedules, and resolve technical/operational issues. Established appropriate metrics for measuring key program criteria. Managed setting up of Oracle Data Guard Environment.
6/2004 to 7/2004 Confidential,Fairfax, VA Oracle DBA/Senior Consultant
Lead DBA/Developer responsible for monitoring production, development and testing Oracle Databases on 15 servers. Performing backup and recovery using RMAN. Create instances and migrate data on new instances. Migrating, upgrading and cloning databases. Development of detailed design for the next release. Used MS Project to support and monitor several application developers for the National Guard. Determined and installed appropriate automated systems for management of projects. Facilitated the creation of communication plans, ensuring that appropriate information is exchanged among key stakeholders. Identified and recommended contingency measures.
1/2003 to 4/2004 Confidential,Washington, DC Oracle Database Administrator
DBA on Integrated Clinical Database (ICDB) for Walter Reed Army Medical Center having thousands of concurrent users. Managing 15 on line databases. Create programs, functions, packages, libraries and triggers in PL/SQL. Create automated reports on daily, weekly and monthly monitoring of the databases. Perform Export/Import. Install Oracle 9i Application server and maintain 3 Web Servers. Manage Database using Oracle Enterprise Manager (OEM) and Tools for Oracle Application Development (TOAD) and MS Project. Perform backup and recovery using Recovery Manager (RMAN). Data Loading using SQL LOADER. Version upgrades on Oracle. Perform version upgrades on ICDB. Provide management support to 10 developers and programmers using MS Project. Created automated reports using UTL file. Maintain a development environment in compliance with HIPPA.
6/2001-12/2002 Confidential, Gaithersburg, MD DBA/Software Developer
Hands on consultant Project Manager and DBA responsible for a team of software developers. Full lifecycle application development utilizing oracle tools. Developed statement of work for projects and monitored projects using MS Project. Evaluated competing proposals from several vendors. Performed Requirements Analysis, Data Modeling, Logical Database Design, Design reviews and Physical Database design. Reviewed deliverables from subcontractors relating to software applications .
4/2000 to 11/2001Confidential, Rockville, MD Programmer Analyst IV
Project Manager and Oracle DBA responsible for creating test procedures and unit tests for Weapons Direction System (WDS) project. Imported data into tables for MCPS project.
11/1996 to 03/2000 Confidential,Washington, DC Sr. Programmer
Microsoft Access, Excel Programmer using Visual Basic For Applications. Created Loan Adjustment Program. This Program calculated interest payment adjustment based upon credit ratings and several other factors. Maintained Oracle 8i Database on Windows platform. Created users assigned roles and privileges, maintained tablespaces and monitored space. Projected space requirements for the next quarter.
11/1992 to 10/1996 Confidential,Riverdale, MD Financial Analyst/Programmer
Created weekly, monthly, quarterly and annual financial reports in MS. Excel for the project at NASA. Redesigned and reorganized several reports to display relevant information. Created first program using Ms. Access and SQL Language to keep Employee information for Human Resources department. Program allowed the Project manager to get information on employees and the projects.
04/1992 to 10/1992 International Commercial Collections, New Orleans, LA Production Manager
Financial Analyst analyzing data of failed Banks and Savings and Loans companies. Prepared detailed reports using Lotus 123 and Ms. Excel showing the misappropriation of funds for the prosecutors. Responsible for a team of 15 analysts.
08/1989 to 03/1992 Confidential,New Orleans, LA Management Associate
Rotated in all departments of the 1200 Rooms hotel to understand the business. Worked with the assistant controller on preparing and maintaining financial reports. Created 30-60-90 accounts receivable reports using Lotus 123. Created manpower reports using Lotus 123 for up coming banquets. Worked with General Manager on special projects. Created financial report in MS. Excel for a new deli style restaurant.
CONTINUING EDUCATION:
Oracle Certified Associate Oracle Certified Professional Gaithersburg, MD 2003
Project Management USDA Graduate School Washington, DC 2001
Local Area Network Concepts USDA Graduate School Washington, DC 1999
Windows NT 4 Server Administration USDA Graduate School Washington, DC 1999
Crystal Reports 6.0 Aalpha Systems Gaithersburg, MD 1998