Senior Oracle Database Administrator Resume Profile
Washington D, C
OBJECTIVE
Searching for a contract position as an Oracle Database Administrator or Unix System Administrator
- SKILLS SUMMARY
- Hardware: 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 2008, 7, XP, and 2003.
- Software: Oracle, PeopleSoft, Toad, Dreamweaver, Informatica, Informix, Visual Basic, C, ASP, Cognos, DB2, udb, Sybase, Access, ERwin, Ingres, Developer 2000, Designer 2000, SoftBench, Remedy, EMC's EDM and Networker, Veritas File System, Cluster and Netbackup, OmniBack, TCP/IP, Real Application Cluster, Warehouse Builder, Streams, and Oracle Application Server.
PROFESSIONAL EXPERIENCE
Confidential
Senior Consultant specializing in Oracle
PROJECTS
Confidential
Senior Oracle Database Administrator/Solaris Administrator responsible for administration of DOJ's library applications Voyager running on Oracle 10g on Solaris 9 and VCAT running on Oracle 11g and Solaris 10. Responsible for completion of the Disaster Recovery Plan. The solution included shell scripts automating the RMAN backup through Tivoli's Storage Manager Tivoli Data Protection. Successfully restored this system at the COOP site. Migrated Voyager to Oracle 11g on RHEL 6.5.
Confidential
Senior Oracle Database Administrator/Linux System Administrator responsible for supporting production, development, and testing environments for this PeopleSoft HCM 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 went smoothly and resulted in only 3 trouble tickets the first week.
Confidential
Senior Oracle Database Administrator/UNIX System Administrator
- responsible for supporting 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. Responsible for builds to Test and QA environments. Developed and documented requirements for the new system. Implemented Data Guard solution for data availability, data protection, and disaster recovery. Responsible for documenting policies, procedures, and guidelines for operation of the system, monitoring, and troubleshooting in the event of an error.
- Senior Informatica Resource Utilized 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. Responsible for optimizing Informatica code for better performance. Responsible for defining 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. Thorough understanding of Kimball and Inmon methodologies. Utilizing Remedy for our trouble ticketing system.
Confidential
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. Investigated database for performance issues and presented possible solutions.
Confidential
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
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
Senior Oracle Database Administrator/Informatica performing data migration for the American Red Cross's blood collection system running on Sun's E25K machines with Solaris 10 and Oracle 10g. 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. Worked with collecting data from multiple online transaction systems and created a data warehouse. Attempted to consolidate 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. Responsible for creating workflows and sessions using Informatica workflow manager and monitored the workflow run and statistic properties with Informatica Workflow Monitor. Responsible for Performance tuning of Informatica ETL code. Used version control provided by Informatica on each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
Confidential
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
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
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 Replication, Oracle9 iAS 1.0.2 with Apache, and Partitioning. 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
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
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
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
Peoplesoft Administrator for this turn-key system implementation at Catholic University. 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. Experience with SQL, SQR, PeopleTools, PeopleCode, DataMover and Crystal Reports. Wrote shell scripts to monitor system performance and document current configurations. Created and implemented disaster Confidential Senior UNIX System Administrator responsible for performance tuning/capacity planning on two K570s, a K200 and 4 H Series machines running HP-UX/9.0.0/9.0.4/10.20 running Oracle 7.1.4/7.3.2.2. Recommended changes which resulted in raising the successful number of calls per call center seat from 5.5 to 9.5 per hour. Established plans for Y2K compliance, improved security, Oracle migration and application migration. Replaced Linux Red Hat/Gauntlet firewall with HP/Checkpoint solution.
Confidential
Lead UNIX System Architect/Administrator responsible for integrating 100 UNIX machines into a new 8.5 million mission critical data center used for supplying branded application outsourcing services. Responsible for bringing up new UNIX machines for production. Utilized Ignite-UX to speed the process by allowing machines to be loaded with baseline configurations at the push of a button. Used Mirror/UX to mirror all system disks to enhance availability. Responsible for security measures to eliminate unauthorized users. Responsible for loading Tivoli agents on all production machines so that they could be monitored constantly. Created scripts to ascertain configuration, performance and stability of each UNIX machine through an NFS mounted script. Responsible for implementing DNS throughout the enterprise. Worked with Security to implement PIX, Gauntlet and Check Point firewalls. Utilized MC/Service Guard for availability. Turned data center operational in 5 weeks.
Confidential
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 resides on Amdahl's 5995 running UTS 2.1.7 and must be 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
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.
Confidential
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.