SUMMARY

Hands-on Oracle Database Administrator with extensive experience in database design, database administration and data modeling in areas of Database Management with notable success in implementing enterprise solutions in Military, Federal Government and commercial environments.

SOFTWARE SKILLS

• Database Management Environments: Oracle RDMS 11g R2, 10.2.0.x, 9.2.0.x/8.1.7/v8.0.5/v7.3/v6 on Windows Server 2005/2008, HP-UX 11.1 , Sun Solaris 7,8,9 , IBM/AIX 5.2/5.3 , Linux Red Hat Linux 5
• Other DBMS experience SQL Server RDBMS 2000, 2005 , Oracle Middleware Software Deployments Oracle SOA and Oracle Fusion.
• Data modeling using Toad for Oracle RAC, Erwin/ERX relational data modeling , Oracle Enterprise Manager.
• Systems administration on Windows Server 2008, Sun-Solaris 8.0/9.0 and HP-UX 10/11
• Other Oracle Software includes: RAC 10g/11g , RMAN, Grid control for OEM 9i/10g/11g and Data Guard 10g .
• Software Development using PL/SQL, UNIX/Linux system administration using vi editor, WLST and Shell Script.
• Configuration Management Tools: CVS, PVCS Tracker 7.1 , Version Manager 7.1 .
• Other Business Application Products: Business Objects, Rational ClearCase, SharePoint, CITRIX Brio Intelligence, Visio 5.0 and SCT Banner 7.2.

PROFESSIONAL EXPERIENCE

Sr. Tactical Software Analyst

Confidential

• Currently supporting the NAVAIR E-2/C-2 Airborne Tactical Data System Program Office at Patuxent River NAS, Maryland.
• Primary responsibilities include, but not limited to, Weblogic Administration, maintaining Oracle Middleware/Fusion platform, Oracle SOA and supporting a fast-paced program office environment providing software analysis for team of Naval Engineers.
• Oracle Database Administrator responsible for using knowledge of computer science concepts and techniques, mathematics, and methods of statistical analysis to develop and apply automated solutions to engineering or scientific, data acquisition and management problems for the customer. Performing Linux system administration using vi editor, WLST and shell script.
• Received customer recognition for the use of mathematical, statistical, and scientific logic to identify conceptual or theoretical solutions to
• problems of automated data processing ADP hardware or software systems design and operations. Using CVS tool to maintain and track latest Oracle forms and reports updates.
• Analyzing and formulating architectural and functional specifications, interfaces, and data structures, researches applications for ADP hardware, software and operating systems. Other tasks include creating database links between production system to export/import data and to run scripted nightly backups.
• Other duties include writing, updating, and enhancing computer programs, PL/SQL scripts and databases, restoring and archival of datafiles, controlfiles, redo logs and tablespaces. Proficient in data recovery from full, incremental and hot backups.

Principal Database Administrator

Confidential

• Primarily responsible for daily Oracle 11g Advanced Replication of master-to-master database configuration, load balancing and
• maintenance. Recommended storage and space capacity for database growth and expansion.
• Determined root-cause analysis of complex Oracle 11g database performance issues between multiple remote UNIX OS servers.
• Monitored daily database performance related issues of large scale DLA installation that spans multiple locations across the U.S.
• Operated in CMMI Level 5 environment and provided weekly input and participation during group peer reviews required for quarterly
• Software Releases.
• Installed Oracle 11g Security Alert patches, and quarterly Critical Patch Updates to both production and test servers to remain compliant with government requirements.
• Applied new software release updates and database changes based on my recommendations to satisfy project requirements.
• Documented installation and operational procedures, and detailed solutions to resolve systemic alert log error messages.
• Provided technical support and managed production server issues on HP UNIX OS to support over 500 users nationwide.

Sr. Systems Analyst

Confidential

• Primarily responsible for BI data comparisons, data mapping/transformation and reconciliation of data gaps and anomalies identified among 3 companies for major database consolidation project.
• Developed business rules and transformation rules according to business user needs and requirements. Managed data extracted from old data warehouse into newly integrated metadata repositories.
• Created, designed and developed business user reports and data extracts for loading into downstream internal and external business users.
• Conducted in-depth systems analysis to assist data modelers with new database and table structure design and development.
• Analyzed, designed and supported different data structures in Microsoft Excel, SQL Server and Oracle PL/SQL as required.
• Completed gap analysis to examine, compare and reconcile reference data between multiple databases.

Sr. Oracle Database Administrator

Confidential

• Planned, installed, configured and maintained all Oracle 10g and 11g database production systems for clustering, replication and
• database recovery. Completed installation of all quarterly Oracle IAVA Critical Security Patch updates.
• Resolved database issues on performance, disk capacity, replication and load balancing with Oracle Grid console management and OEM. Monitored daily database and user activity on the network server and troubleshooted any issues.
• Provided technical expertise in the definition, data modeling and database design and creation of the new Oracle 11g database environment on Linux Red Hat OS. Designed central instance failovers and active clusters for databases with SQL Server and Oracle.
• Performed routine audits of production database and installed Oracle STIGs on network servers using DISA mandated policies standards.
• Developed new database standards and controls, procedures and documentation for the Naval Explosives Ordnance Technical Division. Consolidated all production, development and staging network platforms.
• Completed the update and definition of technical standards related to Oracle database resources for the clients Standard Operating Procedures.

Data Management Analyst

Confidential

• Responsible for oversight and completion of Portfolios of Service Catalogs for Portfolio Management Division.
• Responsible for database management of system facilities and data capabilities including the operation and tuning of Oracle 10g databases.
• Maintained database dictionaries, monitored standards and procedures and integration of systems through database design for entire CIO/G6 division. Provided input and guidance to less experienced staff.
• Completed in depth analysis and design activities associated with the development and maintenance of the database. Created and maintained logical data models and worked with key stakeholders in the identification and resolution of production related performance issues.
• Performed Analysis of existing Joint Command portfolio catalogs and identified additional DoD Certified Service Providers.

Oracle DBA

Confidential

• Completed RDBMS design and implementation issues including data modeling, schema design, indexing and advanced SQL queries.
• Developed database schemas, views and stored procedures using Oracle PL/SQL and Toad for Oracle 9.7.2.
• Worked as part of a full development team on tasks within the development lifecycle design, development, unit assembly testing, maintenance and documentation .
• Created SQL scripts to design and maintain SQL Server Databases using MS SQL Server Management Studio. Developed new tables for transaction processing.
• Completed the technical review/evaluation of various application systems, generating team work plans, and configuration management through documentation uploaded to SharePoint.

Sr. Systems Analyst

Confidential

• Worked with key stakeholders and team members to understand the US Census Bureau and the FDCA projects economic, geographic and demographic data and its functionality.
• Implemented and designed required database objects. Identified innovative ways to reduce costs by streamlining processes and consolidation of tasks. Coded, tested Oracle 10g SQL scripts and fixed code defects in complex 3 tier application.
• Eliminated redundant tasks.
• Reached out to major stakeholders to anticipate expectations by solving problems effectively and making client issues a priority.
• Implemented fixes throughout all testing phases Unit, Assembly, and Production . Act as intermediary from the various other teams to the Data Sync and HHC Applications/Architecture teams.
• Completed Peer Reviews of Unit Test plans to ensure Accenture's compliance with CMMI Level 4 requirements.

Confidential

Analytics Reporting

• Reviewed and prepared functional specifications and detailed technical designs for software solutions based on help desk tickets, user enhancement requests and functional requirements using Business Objects and SharePoint.
• Performed various data analysis to generate and maintain Business Objects reports based upon client needs.
• Developed ETL scripts and testing/validating imported data into data warehouse.
• Delivered key SLA Reports on a daily, bi-weekly, and monthly basis. Developed data load validation scripts.
• Established procedures and process improvements for efficient reporting and error tracking.
• Responsible for providing weekly status updates to appropriate managers to maintain customer issues as a priority.

Department of Commerce

Confidential

• Designed, coded and tested program modules to meet customer design specifications for Oracle 10g Web Migration project at
• Department of Commerce.
• Maintained, tuned and updated applications in order to improve performance and enhance Oracle 10g Forms and Reports.
• Ran analysis and conversion scripts executed, verified and documented Forms and Reports to ensure that Oracle 10g environment meets technical standards.
• Created Developers Web Migration Standards Guide to promote coding consistency of Oracle Reports and Forms.
• Provided technical support to other team members to ensure 100 completion of deliverables with a high quality product.
• Removed Kumaran code from Oracle 10g forms, performed unit testing and conducted peer reviews of Oracle Forms and Reports.

Sr. HRIS Manager

Confidential

• Instrumental in developing and implementing SCT Banner Data Warehouse campus-wide for major software release upgrade.
• Worked in collaboration with multiple internal departments and IT Unit to migrate existing HR/Payroll forms and reports to Oracle 10g and Banner 7.2.
• Worked in collaboration with Information Technology unit to migrate existing HR/Payroll programs to Oracle 10g. Created test plans and test schedules for new INB upgrade.
• Updated Banner 6.2 forms and reports Improved internal support of HR/Payroll website design and maintenance by reducing response time to user requests.
• Redefined HR personnel job roles and responsibilities to maintain strict confidentiality and discretion for user access.
• Established and facilitated Data Cleansing Committee to address Banner data integrity issues. Reduced data integrity issues over 80 .
• Set user roles/access and established new HR Data Security policies to ensure best practices were used throughout the University.
• Other duties included managing HR/Payroll technical specifications for Banner reports/scripts and reviewing all requests before submission to IT Unit.

Oracle Developer

Confidential

• Responsible for code changes to existing Oracle 6i Forms and Reports. Created and maintained Oracle database schemas and optimized database tables. Maintained existing Forms and Reports on Windows application server.
• Completed code changes to existing stored procedures, triggers and functions. Coded PL SQL procedures and triggers, created
• database links, schema accounts, views, tables, primary and foreign keys.
• Set up central reporting area for users to report system change requests for system defects and enhancements.
• Completed daily server administration of AS400 servers and Windows 2000 application servers. Checked system logs and services, allocated disk space and updated the application servers with Microsoft critical updates. Installed Oracle patch releases as needed.
• Ran nightly scheduled backups on Sun Solaris Production and Test servers using DAT tape devices and Veritas software.

Oracle DBA/UNIX Admin

Confidential

• Responsible for onsite support at the Pentagon OUSDC to maintain production systems, monitoring, analyzing, and optimizing database performance, and data capacity planning.
• Performed routine scheduled backups on HP servers using DAT tape devices and Brightstor / ArcServe.
• System administration on UNIX HP UX 11.11 DB servers, checked system logs, assigned user ids and passwords, allocated and tracked disk space, and maintained DISA security standards.
• In charge of the daily monitoring of Windows application servers, checked event logs, system services, and trouble-shooted hardware and operating system issues.
• Coordinated with developers for specific applications and databases on the servers, identified and ordered needed supplies, hardware, software and accessories.
• Performed hardware and software upgrades, completed full exports and imports of Oracle databases between Test and Production servers. Developed migration plans to convert from Oracle 9i to Oracle 10g and assigned daily tasks to junior Oracle DBA.

SAP Technical Architect

Confidential

• Evaluated customer hardware sizing requests using SAP Online Quick sizer tool, and configured SAP application components on Unisys ES7000 Enterprise Servers.
• Configured database and application servers for Development, Test, Training and Production environments.
• Set up IP addresses using Server Sentinel and labeling fibre cable as part of hot staging installations.
• Installed Windows 2000 Advanced Server Operating System onto mainframe servers used by customers.
• Upgraded and installed SAP with subsequent patches and 3rd party software.
• Recommended vendor hardware options and media requirements for Tape Backup and Disaster Recovery solutions.

Oracle DBA/Team Lead

Confidential

• Successfully completed data migration effort from Oracle 7.3.2 to Oracle 8.1.7 for the U.S. Army Logistics Integration Agency.
• Rewrote sql code, and developed Oracle database schema. Used database optimization to improve overall system performance.
• Performed DBA tasks such as: installation and configuration of Oracle8i configured Net8 created and managed database instances, table spaces, users, tables, views, database constraints, and synonyms.
• Completed enhancements to applications using Oracle 6i Reports, Oracle 6i Forms and Oracle Discoverer.
• Designed complex stored procedures and database triggers using PL/SQL.
• Served as technical liaison with Unisys staff in New Cumberland, PA to support client requirements via video teleconference.
• Participated in monthly status meetings and prepared PowerPoint presentation updates.

Database Management / Requirements Analysis

Confidential

• Derived Functional Requirements from Government RFPs and created Requirements Registers from Statements of Work.
• Reviewed existing client database applications to develop database in Access 97 for Department of Transportation DOT and identified interface problems.
• Developed advanced SQL queries to import data from multiple sources in Access. Consolidated data into one manageable database from site survey information gathered by engineers from several off-site locations.

Integrated Test Coordinator

Confidential

• Established a comprehensive knowledge base of routine and mission-critical systems for Cluster 2 within the A/EX/IRM organization.
• Collaborated with the Y2K Program Office to ensure proper configuration of the simulated environment for end-to-end testing of internal State Department business processes.
• Monitored the installation of equipment installed in test environment and verified system components to make sure the infrastructure of the test lab is identical to production.
• Coordinated customer tasks as well as Unisys employees to ensure proper implementation of test schedules and execution of test scripts for Year 2000 certification.
• Used Visio 5.0 to document business process diagrams according to pre-defined test scenarios for end-to-end testing.
• Defined project timelines and milestones using MS Project and assessed resources for personnel, equipment, and, facilities.