Senior Oracle Database/application Engineer Resume
Mclean, VA
OBJECTIVE
Seeking contract opportunities as an Oracle Database Administrator, PL/SQL programmer or Unix System Administrator
TECHNICAL SKILLS
Hardware: M5000, SuperCluster, Sun (E25K, F15K, E10K, 6500, 4500, 3500, 480, 450, 240, Ultra10, Ultra5), HP 9000 (K570, K420, D380, D370, D280, B132), Prime Power.
Operating Systems: Solaris, HP/UX, Linux, AIX, SunOS, Windows.
Software: Oracle, PeopleSoft, Oracle Data Integrator, Informatica, Informix, Visual Basic, C, ASP, Cognos, DB2, udb, Sybase, Access, ERwin, Ingres, SQL Developer, Designer 2000, SoftBench, Remedy, EMC’s EDM and Networker, Tivoli Storage Manager, Veritas File System, Cluster and Netbackup, OmniBack, Real Application Cluster, Warehouse Builder, Streams, Oracle Application Server, Toad, and Dreamweaver.
PROFESSIONAL EXPERIENCE
Confidential, McLean, VA
Responsibilities:
Senior Oracle Database/Application Engineer responsible for database conversions from police departments and sheriff’s offices to Confidential ’s LInX (Legal Information Exchange) system. Customize packages to maximize the data that can be entered from individual agencies into the production system which runs Oracle 11.2.0.3. Utilize SQL Developer, Toad, and OEM to make sure the PL/SQL code is functional and optimized for efficiency. Work with testing teams to work out issues between the agencies and the production database. Documented procedures to convert specific database types to LInX.
Confidential, Washington, DC
Responsibilities:
Senior Oracle Database Administrator/Solaris Administrator responsible for administration of DOJ’s library applications. Run Ex Libris Voyager for VACT application with Oracle 11.2.0.3 database on RHEL 6.5. Run Ex Libris Voyager for VCAT application with Oracle 11.2.0.3 database on Solaris 10. Currently migrating VCAT to RHEL 6.5. Designed, implemented and tested the Disaster Recovery Plan. The solution included shell scripts automating the RMAN backup through Tivoli’s Storage Manager Tivoli Data Protection. Successfully restored both systems at the COOP site.
Confidential, Washington, DC
Responsibilities:
Senior Oracle Database/Application Administrator responsible for database, web and application servers for the National Finance Center's Insight application. Database servers are Oracle SPARC Enterprise M5000 Servers running Solaris 10 with Oracle 11.2.0.3. Provide 24 by 7 administration of the 4 TB data warehouse production instance. Installed OBIEE and Oracle Data Integrator. Provide technical documentation including standard operating procedures for administrators and developers as well as release documentation including installation, migration, and refresh instructions. Monitored the running instances in development, test, build, pre - production and production environments through OEM. Perform patching and upgrades for all Oracle products. Utilized RDA, AWR, ADDM and ASH reports to troubleshoot performance issues. Utilized SQL Developer, Toad, SQL Plus, explain plans, tkprof, SQL trace to help debug application issues within ODI and tune SQL queries. Developed shell scripts for administration tasks, database monitoring and batch operations utilizing cron.
Confidential, Washington, DC
Responsibilities:
Senior Oracle Database Administrator/Linux System Administrator responsible for supporting production, development, and testing environments for this PeopleSoft Human Capital Management implementation with Oracle 11g on RHEL 5.5 on SuperCluster hardware. Production environment utilizes Oracle RAC, Data Guard, and ASM. Monitored development environment with Oracle Grid 11g while QA and production environments are monitored by Oracle 12c. Backups scheduled using RMAN through Enterprise Manager. Documented processes and procedures to aid administrators and developers. Initial launch for 400 users resulted in only 3 trouble tickets the entire first week.
Confidential, Washington, DC
Responsibilities:
Senior Oracle Database Administrator/UNIX System Administrator supporting the development effort on new messaging systems running Oracle 11g on Solaris 10 and Windows 2008. Responsible for 24 by 7 operation of the current production messaging systems in both Secret and Top Secret environments. Built and maintained both the Test and QA environments. Developed and documented requirements for the new system. Implemented Data Guard solution for data availability, data protection, and disaster recovery. Documented policies, procedures, and guidelines for operation of the system, monitoring, and troubleshooting in the event of an error. Served as Informatica resource with Informatica 8.6 in migrating a legacy messaging system to SQL Server. Responsible for analyzing requirements, design and development of source to target mappings using Informatica Power Center Designer, Informatica Workflow Manger, and Informatica Workflow Monitor. Optimized Informatica code for better performance. Defined mapping parameters and variables and session parameters needed for business requirements. Strong knowledge of data warehouse and dimensional data modeling, star schema/ snowflake modeling, and fact and dimension tables.
Confidential, Rosslyn, VA
Responsibilities:
Senior Oracle Database Administrator responsible for production releases of the largest biometric database in the world. Responsible for database administration of Development, Testing, and QA instances. Wrote several procedures for performance tuning team on Oracle 9i on Solaris 10, as well as many shell scripts. Reviewed database for performance issues and presented possible solutions.
Confidential, New Carrollton, MD
Responsibilities:
Senior Oracle Database Administrator/Unix System Administrator/Informatica Administrator responsible for supporting 25 Informix to Oracle and migration projects running Oracle 9i/10g on Solaris 10. Responsible for installing Informatica 8.1.1 on Windows 2003. Created folders using Informatica Repository Manager. Responsible for creating users and roles using Informatica Administration console. Maintained upgrades and patches for Informatica. Utilized Informatica 8.1.1 to migrate the data. Implemented security requirements and assured their incorporation in the migrated applications. Guided the team in migration process (Folder copy method) by moving the code from one environment to another.
Confidential, Kearneysville, WV
Responsibilities:
Senior Oracle Database Administrator responsible for performance tuning of Coast Guard application being ported from Oracle 8i to 10g. Implemented and tested proposed solutions including partitioning tables and indexes. Saw significant gains in the sandbox indicating that improved performance could be achieved on the 10g platform in production with minimal changes to the application.
Confidential, Washington, DC
Responsibilities:
Senior Oracle Database Administrator/Informatica performing data migration for the Confidential ’s blood collection system running on Sun’s E25K machines with Oracle 10g database on Solaris 10. Developed and installed database system architecture with 10gR2 that employs Real Application Clusters (RAC) in conjunction with Veritas Storage Foundation for Oracle to support BEA Weblogic application server cluster. Used Oracle Streams for data capture. Documented and executed qualified procedures to create Real Application Cluster (10.2) installations for the production site in Chicago. Collected data from multiple online transaction systems and created a data warehouse. Consolidated data from 40 regional databases plus mobile devices into a one consolidated national database for blood collection. Responsible for development of source to target mappings using Informatica Power Center Designer. Used different types of transformations including connected and unconnected lookup transformations, router, filter, aggregator, expression and update strategy transformations for large volumes of data. Created workflows and sessions using Informatica workflow manager and monitored the workflow run and statistic properties with Informatica Workflow Monitor. Tuned Informatica ETL code. Used version control provided by Informatica on each and every object used.
Confidential, Lorton, VA
Responsibilities:
Senior Oracle Database Administrator/Solaris System Administrator for the (120s, 240s, and 480s) running Solaris 9. Responsible for the Joint CERT Database (JCD), Joint Threat Incident Database (JTID), and DOD CERT Incident Database (DCID). Created canned business intelligence reports with Cognos. Investigating move to Solaris 10. Created failover solution utilizing Sun Cluster. Developed and implemented disaster recovery plan and procedures.
Confidential, Centreville, VA
Responsibilities:
Working on technical solution/proposal for creating Telework centers.
Confidential, Pentagon City, VA
Responsibilities:
Senior Oracle Database Administrator/UNIX System Administrator responsible for supporting 268 Oracle development/quality assurance/production 8.1.7 instances running on Windows 2000 and 2003. Responsible for migrating Oracle 8 instances to 9i and 10g. Responsible for getting all production instances on HP-UX 11.11 platform. Achieved increased performance, reliability and availability by moving 68 production instances to UNIX. Loaded Oracle Application Server 9iAS, then 10gAS. Worked with Single Sign-On and Oracle Internet Directory for future implementation. Worked with developers to get development applications into production quickly and efficiently. Worked directly with COGNOS developers working on Business Intelligence Reporting. Utilized Informatica 8.1 to create a data warehouse trial that could be utilized by various enforcement agencies.
Confidential, Martinsburg, WV
Responsibilities:
Senior Oracle Database Administrator/UNIX System Administrator responsible for supporting 168 Oracle and Informix development/migration projects on 8 Sun E10K/F15K machines supporting 5-8 domains each. Responsible for administering Oracle 8.0.5, 8.1.6, 8.1.7 and 9i, as well as Informix 7.30, 7.3.1, 9.20 and 9.21 running Solaris 2.6 and 2.8. Ran EMC’s dbtuner to assist developers in tuning their code for better performance. Worked with Oracle product and features including replication, Oracle9 iAS (1.0.2). Implemented partitioning to increase performance. Assisted in the backup process by writing scripts to automate the exports and working with EMC to implement EDM and the use of Business Continuance Volumes to obtain hot backups. Used Oracle Enterprise Manager and Informix Service Administrator to assist in managing databases. Served as the Peoplesoft Administrator for two key IRS trials to see if the product would meet their long-term objectives. Loaded and administered Peoplesoft’s Human Resources 7.5 and Financials 8SP1 on Oracle 9i on Sun E10K machines. Applied database and application patches including Peoplesoft Tools upgrade. Worked on the two largest applications at the IRS, Electronic Fraud Detection and Automated Under Reporter. Worked with Informatica Power Center 6.0 to migrate the data. Responsible for upgrading Power Center to 6.2.1.
Confidential, Centreville, VA
Responsibilities:
UNIX System Architect responsible for researching Linux and recommending the most robust version along with alternate processes and procedures to development organization that would reduce costs and improve productivity. Recommended SuSE over Red Hat Linux for reliability, security, availability and customer support.
Confidential, Herndon, VA
Responsibilities:
Senior UNIX System Administrator/Architect responsible for supporting 50 IMCI internal HP and Sun machines. Responsible for building a web hosting data center for Winstar Communications which included 23 Sun machines including 4 E450s, 420, 12 220s and 6 Netra 105s. Installation included EMC Symmetrix, Veritas Cluster, Volume Manager, and Netbackup plus Inter Mail. Set up DNS and NIS+ for name service and security. Trained UNIX Administrators. Assisted in Disaster Recovery Plan including backing up Oracle databases and use of Ignite-UX and Jump Start.
Confidential, Herndon, VA
Responsibilities:
UNIX System Architect/Administrator responsible for supporting AT&T during the port of their Customer Account and Data Management (CADM) System to a Sun platform. The system included
5 E10Ks, 2 6500s, 2 5500s and 2 3500s. Ported scripts for the systems, databases and applications. Assisted Oracle DBAs in analyzing transfer options for a 1 TB database.
Confidential, Washington, DC
Responsibilities:
Peoplesoft Administrator for this turn-key system implementation at Confidential . Responsible for installation and administration of PeopleSoft’s Student Administration module and HRMS on a Sun E450 (development) and an E4500 (production) running Solaris 2.6. Planned and coordinated the installation of the hardware, operating system, database (Oracle 8.0.5.0), compilers (C++ and COBOL), and assorted software packages including Tuxedo, and the Peoplesoft application. Responsible for upgrades, performance tuning, change management, backup/recovery and trouble shooting. Utilized SQL, SQR, PeopleTools, PeopleCode, DataMover and Crystal Reports to accomplish tasks. Wrote shell scripts to monitor system performance and document current configurations. Created and implemented disaster recovery for the Center for Planning and Information Technology at Confidential .
Confidential, New York, NY
Responsibilities:
Technical Project Manager/UTS Specialist responsible for porting a Mortgage Brokering application used by 20 prestigious clients in the daily buying and selling of mortgages throughout the country.
The application resided on Amdahl’s 5995 running UTS 2.1.7 and was ported to the new Amdahl Millennium running UTS 4.3.2. The same source code tree was required to compile and run under SunOS, UTS 2.1.7, and UTS 4.3.2. Completed the hardware upgrade/operating system upgrade/application porting on time and under the $4.2 million budget.
Confidential
Responsibilities:
Teach Linux Administration, Network Security and Auditing in Linux environments at ITT Tech. Previously taught Relational Database Theory, Oracle Database Administration, Unix Users, Solaris System Administration and Advanced Solaris Administration at NOVA and George Mason.
Confidential, Manassas, VA
Responsibilities:
Financial services representative teaching people how to become financially independent and how to protect their assets. Hold securities licenses 6 and 63, as well as 26 allowing me to manage other representatives.