Senior Oracle Database Administrator Resume
Boston, MA
SUMMARY:
- An Oracle Database Administrator of sixteen years with extensive experience in analyzing, planning, developing, testing and maintaining Oracle databases and an in - depth knowledge in formal system, analysis, design, procedures and database development methodologies.
- I possess experience lending itself to several industries, some of which include pharmaceutical firms, manufacturing, aerospace and engineering, entertainment, finance, and the United States military.
- I have worked on multiple platforms including Solaris, HP-UX, Linux, Irix, and SCO.
- Versions of Oracle I have worked with range from 7, 8, 8i, 9i, 10g, and 11g, and 12c. Experience configuring RAC for Oracle versions 10g through 12c.
- Re-certified as of 5/2013 with the US Department of Defense for secret clearance eligibility.
- RDBMS and Related software (16 years of experience): Oracle 7, 8, 8i, 9i, 10g, 11g, and 12c.
- Oracle Enterprise Manager, Oracle Data Mart, Cognos, PeopleSoft, Erwin, Brio, Veritas HA Clustering, Netbackup, Autosys, Retek Retail Inventory System, Unitech, Kana Retail Reporting System, Visual Manufacturing ERP Suite, Oracle Call Interface Release 7/ 8/8i, 9i,10g, 11g, SQL*Loader, Oracle Import/Export, all Oracle utilities, Embarcadero DB Artisan, BMC Patrol for Oracle, Oracle Enterprise Manager, Interleaf, Lotus Notes,, SAS, BMC DB-Import
TECHNICAL SKILLS:
Middleware: ODBC, JDBC, JDK, Tomcat, Apache
Operating Systems: (16 years’ experience) UNIX (Sun E4500, Ultra-10 (Solaris 7, 8, 9), HP-UX 0 10.20/11.0 , SCO, Irix, Windows NT 4.0/2000, Redhat Linux Advanced Server, DEC VAX & VMS
Networking Protocols: TCP/IP, SQL*NET, Net*8, TNSNAMES, Oracle Net Services, OID
Languages: SQL, PL/SQL versions 1/2/8/8i, Shell Scripting in Ksh, Csh, and Bsh, Perl
Hardware: HP, Sun, Various NT platforms, Windows platforms, IBM Mainframe, StorageTek, Dec-Alpha, VAX, Compaq, Dell
SPECIALIZATIONS:
- Oracle Database Administration Database Design & Implementation
- Oracle Parallel Server
- DataGuard/Oracle Standby Database
- Real Application Clusters (RAC)
- MySQL
- Korn Shell Programming
- Oracle Distributed Technology PL/SQL Programming
- Oracle Database Tuning Application Tuning
- Oracle Networking Application Design and Development
- Oracle Snapshot, Multimaster Replication
WORK HISTORY:
Confidential, Boston, MA
Senior Oracle Database Administrator
Responsibilities:
- Project manager and Oracle DBA functioning in the development of offerings and professional services; manages activities of global database support teams.
- Develop SOPs in tandem with practice heads, managers, sales staff, and strategic partners.
- Provides expertise in strategically implemented infrastructure and applications deployments and aligns with technology concepts in marketplace, supporting migration/consolidation initiatives with Linux, Unix, Windows, Oracle Virtualization, and database appliances.
- Performance tuning, database creation, patching for 10g, 11gR2, and 12c Oracle databases. Also administers MySQL, PostGres, and Vertica Analytics.
MySQL DBA/Architect
Confidential
Responsibilities:
- Designed and reviewed data models, database schemas, and SQL/queries, both relational and non-relational, for our servers and web applications.
- Identified and fixed DB related performance bottlenecks.
- Tuned performance to ensure our servers and applications are highly scalable.
- Developed and tested enhancements for improving performance, scalability, reliability.
- Resolved system problems and customer issues under very tight service level agreement.
- Created data architecture standards and implemented best practices.
Confidential, Wayne, PA
Oracle DBAResponsibilities:
- Responsible for design, site structure (information architecture), and daily maintenance of a global website and many of it’s localized sites.
- XHTML & CSS coding, image editing, basic SEO and analytics reporting.
- Editing and preparation of videos for the web.
- Architecting and implementation of MySQL metadata archives for photographic catalogs.
Confidential, San Francisco, CA
Oracle DBAResponsibilities:
- Planning, design, implementation, and ongoing maintenance of complete web site for retail and fulfillment center B2B web portal for vendors.
- Design with standards compliant code with emphasis on browser compatibility, accessibility, and search engine optimization
- Audio and video editing for the web
Confidential, St. Louis, MO
Oracle DBAResponsibilities:
- Supported PeropleSoft migration in a functional role in Oracle 10g and 11gR2.
- Architected notification systems in Unix shell environment with Perl in HP-UX, Sun, and Windows environments.
- Supported HR and finance systems migrations for Oracle on HP-UX, Solaris, and Windows.
- Maintained RMAN, FRA for over 100 databases.
- Applied Oracle RDBMS, security, and PeopleSoft patches during migration.
- Assisted with construction of new RAC environments on Linux.
- Performance tuning of the physical and logical database components and SQL queries.
Confidential
Oracle DBAResponsibilities:
- Working for Confidential as a Senior Oracle DBA in charge of project oversight and all technical aspects of Oracle Database administration including performance tuning, space management, capacity planning, and implementation of database solutions such as Cognos, RAC 11gR2 on ASM, RMAN scripting, grid instsallation and configuration, shell scripting, Oracle HTTP server configuration, and oversight/critique of logical/physical database design.
- Developed, planned and executed storage and HA solutions for: Videotron Cable Television / Telecommunications in Montreal, CIGNA Data Center (Installation and configuration of Data Deduplication product Data Domain), and maintenance/performance tuning of RAC 11gR2 on AIX), Windsor CT, Videotron (RAC installation, configuration, and maintenance on AIX), Montreal Canada, Beacon Mutual Assurance Company, and Baystate Health of Illinois.
- Researched, analyzed, and implemented replication, DR, and HA schemes, conducting meetings, and interacting with personnel that resulted in decreased time in transit for deploying solutions and responsible for reduced TCO. Frequently worked on Oracle Fusion Middleware/EBS/Retail products.
Confidential, Philadelphia, Pa
Oracle DBA
Responsibilities:
- Installation/maintenance tasks included latest versions of Oracle and MySQL for Redhat OS and windows server environments.
- Conducted monthly security audits, verified registered mail documents and receipts and daily reports.
- Installation of network patches, diagnosing network layer problems in Oracle
- Writing shell scripts for backup and recovery/data transport routines
- Modification and management of CRM databases
- Installation of Oracle patches, shell scripting, UNIX kernel tuning, monitoring20 oracle databases.
Confidential
Oracle DBA
Responsibilities:
- Installation/maintenance tasks included latest versions of Oracle for Solaris OS and windows server environments
- Installation of network patches, diagnosing network layer problems in Oracle
- Writing shell scripts for backup and recovery/data transport routines
- Using Grid technology to maintain distributed environments
- Installation of Solaris OS, and Windows Server, and network administration tasks
- Installation of Oracle patches, shell scripting, Unix kernel tuning, monitoring
Confidential, Akron, OH
Oracle DBA/PeopleSoft Administrator
Responsibilities:
- Design development of production, development and QA database systems.
- Platforms: AIX and Sun OS
- Backups managed through BMC SQL Backtrack 6.5. Administration and performance tuning of Oracle RAC instances on AIX, v.10g.
- Maintained EMC storage environment, SAN storage, HA (High availability) systems, and RAC
- Using Enterprise manager and OMS/Grid technologies to maintain Oracle environment.
- Worked in tandem with Network and System Administrators in the maintenance of distributed Linux/Unix environments/installed Oracle security patches regularly, shell scripting, Unix kernel tuning, monitoring
Confidential, Philadelphia, PA
Oracle Consultant
Responsibilities:
- Performs design development and implementation of HR databases using Oracle and RedHat AS
- Created RMAN backups for 9i and 10g databases running on Solaris and Linux.
- Periodic performance tuning tasks, including jobs for computing statistics on tables.
- Created shell scripts for data loading and backups routines
- Maintained storage environment and failover capabilities/ RAC instances
- Maintained SAN environment using Sun and Hitachi hardware
- Installed and maintained Solaris and Linux OS, and subsequent networking protocols as applicable to Oracle environments
- Created QA, test, and production instances of Oracle regularly
- Maintained PeopleSoft environment, installed application patches regularly, shell scripting, Unix kernel tuning, monitoring
- PeopleSoft patch management.
- PeopleSoft release management
Confidential, Newark, NJ
Oracle DBA
Responsibilities:
- Reorganized primary database assets, to make OFA (Optimal Flexible Architecture) compliant.
- Managed MySQL based CRM.
- Created RMAN backups for 10g databases running on Redhat AS 4.0 and Windows 2003 Server
- Performed installation of Redhat AS 4.0 servers. Scripted cron jobs for space monitoring and data loads
- Migrated from Oracle 10g on Windows to Oracle 10g on Linux. Performed OS updates and Oracle server upgrades, Unix kernel tuning and shell scripting, monitoring
- Maintained SAN storage arrays and RAC, Oracle standby server
Confidential, Lenexa, KS
Oracle Consultant
Responsibilities:
- Performed and oversaw the installation of RAC on Oracle 10g/Solaris
- Reviewed functional specifications of Oracle data environment,
- Migrated of databases from 10g stand-alone instances of Oracle to 10g RAC instances, utilizing ASM management, using Hitachi disks and Sun V440s
- Utilized Grid Control tools to perform a variety of diagnostic work, including I/O contention, CPU usage, and explain plans. Shell scripting and RMAN scripting., performance tuning, shell scripting, Unix kernel tuning, monitoring
Confidential, Newark, NJ
Oracle DBA
Responsibilities:
- Performed routine database administration tasks including desigining, building and tuning Oracle 8i and 9i databases. Also maintained an existing group of Oracle 7 databases and migrated them to Oracle 9i
- Rewrote existing shell scrits to include more efficient code
- Scripted a nightly ETL 'data push' program which exported and imported data from servers in the USA to Beijing, China and worked with personnel on two continents to ensure data consistency
- Performed performance tuning and SQL tuning for an international shipping/bill of lading application, shell scripting
- Worked with Oracle on Dell, Sun, and HP hardware, EMC storage
- Maintained clustered environments
- Unix kernel tuning and shell scripting, monitoring
Confidential, Beavercreek, OH
Oracle DBAResponsibilities:
- Migrated 16 databases (Test, Development, QA, and staging environments for adaptation to production) from Tandem to Oracle on Unix
- Migrated Oracle databases from Windows server to Solaris 9 and Redhat AS Linux server
- Created, tuned new databases, including Oracle 9i RAC environment for mission critical systems
- Configured RMAN scripts, and OMS Server. Performance tuning, backup and recovery, DDL generation
- Designed backup and recovery strategies for existing and new environments
- Configured shell scripts for RMAN. Wrote RMAN scripts for hot backups, as well as export scripts. Assisted in defining hardware and RAID requirements for new and existing Oracle environments
- Configured OEM Grid control Must know Data Guard on Redhat AS. Also configured clustering services for RAC on 10g. Utilized OEM to perform diagnostics and to control grid management, monitoring