We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

2.00/5 (Submit Your Rating)

San Antonio, TexaS

SUMMARY

  • Senior Oracle DBA for versions 12C, 11gr2, 11g, 10g, 9i, 8 and 7.3.3.4 production environments
  • Oracle Financials Cloud: 1Z0 - 1005 - Payables 2018 Implementation Essentials - English (ENU) Pearson VUE
  • Accenture Federal Services training - 3 OCI (Oracle Cloud Infrastructure) Training - Network, Infrastructure and Security
  • Oracle University RAC trained - St. Edward University Austin, Tex. - provided administrative support to production RAC environments.
  • Production SQL Server DBA for versions 2000,2005, 2008R2, 2012. 2016 associated products SSIS, SSRS and SSAS production support, also development and package creation via Microsoft Visual Studio and Visual Basic 2008, 2010
  • Over 10 years as Applications Oracle DBA - (EBS) Enterprise Business Suite version 10.7 NCA, 11.5.3, 11.5.5, 11.5.10, 12.1.3, 12.2 and a completed implementation of version 12.2 in January 2015. Experience has been based on the Insurance Industry, Tank Barge Industry, the Oil & Gas Industry, Tele-communication industry, Manufacturing (Toshiba and Wyman-Gordon)
  • Installation and configuration of GRID (OMS) Oracle Management System - (OEM) Oracle Enterprise Manager version 9, 10g, 11g 12.1.0.4, 12.2 and 13C.
  • Advanced KORN Shell Scripting to implement solutions via the CRONTAB scheduler along with BASH and C Shell.
  • Advanced Window Shell Scripting to implement solutions via Tidal and windows task scheduler.
  • Configured Development, Test and Regression environments on Linux, HP-UX, SUN, and Windows
  • Oracle DataGuard Standby Database solutions and implementation. Oracle DataGuard Active for reporting purposes. Utilizing the DB broker technique for log shipping at intervals
  • Veritas Cluster System (VCS) and Solaris Cluster packaging system
  • Toad Oracle, DB Artisan DBA, Toad for SQL Server, Spotlight for SQL Server
  • Oracle and SQL Developer performance tools installation, configuration and use to tune statements.
  • Oracle OBIEE 11.1.1.7 and 11.1.1.9. This includes all the OBIA configuration.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

Senior Oracle Database Administrator

Responsibilities:

  • Oracle EBusiness Applications DBA services, project work and technical support.
  • Oracle OBIEE and OBIA DBA Services, project work, patching, and technical support. DAC Informatica
  • OBIEE Analytics
  • Develop, maintain, perform, and test backup and recovery procedures.
  • Provide proactive performance monitoring, and capacity planning.
  • Administer and maintain security policies and procedures.
  • Perform installations, configurations, upgrades, and migrations.
  • Evaluate new trends and technologies and provide best practices and recommendations.
  • Assist team production support and off hour application deployments.
  • Creation of scripts to assist in automating deployment and administrative task.
  • Use networking, operating system, application tools to analyze and modify performance settings to improve operational performance.
  • Schedule and perform after hour software maintenance as required by customer needs.
  • Applications/tech stack/database upgrades, cloning, installations, patching, and performance tuning

Confidential, Austin, TX

Senior Oracle Database Administrator/ IT Supervisor

Responsibilities:

  • Primary Duties of the Senior Oracle DBA - secondary duties of the IT Supervisor. IT Supervision encompassed managing 3 additional individuals in a support team. A beginner DBA, Senior Network engineer and a Desktop support individual. Provided yearly employee assessments, merit raise suggestion, approved holiday, and vacation schedules. Trained employees and was a reference point for all IT work.
  • Performed Oracle OEM 11g and 12C (Cloud Based) Oracle Enterprise Manager installations and migrations from version 10gr2.
  • Managed outsource location (OnRamp - Austin). Removed all old HP blades and replaced with new generation G9 HP blades. Added new EMC VNX 5200 storage for the Oracle environment.
  • Migrated old legacy data from Sybase to Oracle for use with a new application. Installed redundant routers, additional memory and redesigned the layout of the infrastructure for failover capabilities.
  • Providing configuration, upgrades and patching support for Oracle utilizing best practices guidelines. Oracle duties. Installations, RMAN recovery, Tuning, Data movement, Disaster Recovery and EMC disk configuration for Oracle. Migration of KORN shell scripting to windows scripting to remove the need for the utilization of the MKS Tool Kit Software on all Windows servers.
  • Introduced Standard Operating procedures to the team. Maintained a central storage repository via VPN for all documents pertaining to the infrastructure.
  • Revised all prior foundation database init.ora parameters to increase performance and ensure failover. Tuned and troubleshooted old database environment and carried all revisions over to a pristine environment. Utilizing ADDM, ASH and AWR reports including SQL profiling.
  • 24/7 database monitoring perform backups and ensured high availability.
  • Worked on Oracle versions 11r2 upgrades/migrations and apply new quarterly security patching.
  • Performed the installation of new OEM 12.1.0.6 agents and the removal of all 10g agents for new 12C Oracle Enterprise Manager.
  • Responsible for filling in for day-to-day operations as part of the DBA group, pager duty, weekend on calls for employees taking holiday leave.
  • Client software installation/maintenance - SQL Developer, TOAD, Oracle Enterprise manager (java based) desktop, Oracle client software and Dell (Quest) optimization tool.
  • Job scheduling via Windows job task scheduler, internal database jobs and OEM.
  • Knowledge of all aspects of the Oracle environment on the Windows 2008 and 2012 O/S platform architectures.
  • Maintained the backup environment for the Oracle database platforms, which included creating backup scripts, testing, scheduling production backups and doing regular backup checks by recovering from prior backups.
  • Interfaced with management on various issues and presented to the state of Texas a status monthly.
  • Installed and maintained 2016 MS SQL Server for data migration.

Confidential, Houston, TX

Senior Oracle EBS Database Administrator

Responsibilities:

  • 6-8 years of experience as an Oracle Applications DBA Experienced on E-Business suite
  • 6-8 years’ experience supporting and maintaining (including code migrationsPerformance tuning and patching) Oracle EBS application R12 components (PortalOID, OBIEE, OBIA, J2EE, Oracle Forms) enterprise multi-tiered UNIX environment Including the use of RAC and standby databases
  • Responsible for database monitoring, troubleshooting, performance tuning, high-
  • Availability strategies in a 24x7 Production environment
  • Installing, configuring, upgrading, patching, securing, maintaining, and troubleshooting
  • Oracle EBS application R12 and patching procedures
  • Assist in ongoing EBS project to convert all business units, groups & companies from
  • Legacy ERP systems to Oracle EBS
  • Develop and implement replication, archiving and backup and recovery strategies (DR
  • Failover testing capabilities)
  • Assists and leads with data operations, monitoring, backup, recovery, cloning and
  • Security
  • Performs and leads activities related to the promotion and migration of software and
  • Components through pre-production to production environments
  • Mentors and transfers knowledge of technologies and processes to team members
  • Maintain the integrity of the database and application environments.
  • Ability to collaborate, build and maintain relationships with technical groups
  • Lead complex support issues and problem analysis.
  • Administer, maintain, develop and recommend policies and procedures. Ensuring the
  • Security and integrity of the company's Oracle databases and application systems
  • Oracle Database management
  • WebLogic 10.3.5 and 10.3.6
  • SOA (Service Oriented Architecture)
  • E Business Suite applications - BOM, SCM, AP, GL, AR
  • PL/SQL
  • SQL and SQL plus
  • Unix (Sun Solaris)
  • Microsoft Project 2010
  • Exadata x5-2 machines, Supercluster and Exalytics in-memory machines.
  • Disaster recovery experience both mirroring and Oracle standbys
  • Work both independently and as a member of a team to make system critical decisions
  • And communicate effectively both verbally and in writing.
  • Senior SQL Server DBA duties and responsibilities.
  • JIRA Agile software utilizations for project control
  • Crucial Conversation management training for employee PMP reporting
  • Project management and time keeping
  • SQL Server DBA support

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

  • Responsible for production, development, and regression databases for client EOG Resources. Includes over 1000 employees. Total number of Oracle database 249 and 149 SQL Server database under different flavors 2008, 2005 and 2000.
  • Red-Hat Linux 2.6.1.8 configuration of Oracle 10204 Databases for all Divisions
  • Finder support for Tyler, Denver, Midland and Fort Worth Divisions
  • Utilized the Track-it ticket system for help desk requests plus a Exdesk DBA Ticketing system - average 200+ tickets weekly.
  • Migrations of SQL server database from version 2000 to 2005 to 2008
  • IDEAS trouble shooting, performance support and upgrades for Trinidad and United Kingdom
  • Utilization of Oracle Support Meta-link to troubleshoot issues.
  • Configuration of Heterogeneous Database connections - Oracle to SQL Server
  • Microsoft SQL Server 2000 Log Shipping setup and configuration for failover recovery
  • Oracle Data Guard configuration and setup - Standby failover recovery
  • Versed in Oracle 11g, 10g and 9i setup and configuration.
  • SQL Server 2005 Best Practices operational and administrative tasks
  • Utilized the Franklin Covey time management system.
  • Fluent in Enterprise Manager Grid Control - Version 10g and 11g - web based.
  • Fluent Oracle Enterprise Manager 10g and 9i at the desktop level
  • Fluent in the DBMS STATS and DBMS UTILITY (old Analyze version)
  • Fluent RMAN backups, database registry, crosscheck, and recovery of archive logs
  • Fluent in the application of Oracle Critical patches and Oracle home creation
  • Utilized Oracle 11g Administration 11.2.0.1, 11.1.0.7
  • Utilized Oracle 10g Administration 10.2.0.3, 10.2.0.4 and 10.2.0.5
  • Utilized Oracle 9i Administration 9.2.0.1 thru 9.2.0.7
  • On-track to take Oracle Certified Professional All-in-One exams 1Z0-051, 1Z0-052 and 1Z0-053.
  • Provided subject matter expertise on Microsoft SQL Server 2008 configuration and standby creation via mirroring technology.
  • Proficient in all aspects of Database Administration including installation, configuration, backup, and recovery, and troubleshooting database issues.
  • Tools utilized - SQL*Plus, Oracle Enterprise Manager, TOAD, SQL Expert, Exceed and MS Visual Source Safe or VSS
  • Provided subject matter expertise on Oracle functionalities/technologies such as Materialized Views, Standby Databases, Active DataGuard, RAC, partitioning and RMAN.
  • Utilized Move/Refresh databases/data as necessary using export/import utilities for both Oracle and SQL Server
  • Utilized +ASM volumes for the installation of new Oracle Databases versions 10g and 11g.
  • Assisted in supporting the server and network infrastructure including hardware setup and configuration.
  • Oracle RAC installation and maintenance. Cardinality of 3 on the RAC setup per project.
  • Change control attendance and implementation for changes to production.

Confidential, Peabody, MA

Senior Oracle Technical Manager

Responsibilities:

  • Completion of newly designed Oracle 11i / Oracle implementation of Payroll/HRMS and Oracle Financial modules
  • Provided subject matter expertise in Oracle 11i architecture for Liberty Mutual Insurance Company project based in Portsmouth, New Hampshire.
  • First implementation of the 11i payroll/HRMS modules within the United States. Beta site for applying patches and tune various performance issues. Fluent in Oracle adpatch for applications and the utilization of Vertex for financial module. Versed in the Application TOP (APPL TOP) and Oracle iAS (Application Server).

Confidential, Houston, TX

Senior Principal Consultant

Responsibilities:

  • Provided subject matter expertise in Oracle 10.7 and 11 Architecture for Nextel, Bellsouth, Bellcore, Level (3) and the Alcatel project.
  • Completed 8 months of support at Nextel in database and middle tier network computing architecture (NCA).
  • Skilled in the Oracle application server techniques
  • Win NT Server configuration
  • HP/UX and Sun administration
  • DBA technical expertise
  • Shell Recognition award for Contributions toward Research.
  • Digital Achievement series certification as an “Advanced VAX & VMS System Manager”
  • AIX Systems Administrator Certification
  • HP/UX Systems Administrator Certification
  • Masters Oracle Database Administration 8.1.7
  • Oracle 11g RAC Administration
  • SQL Server 2000, 2005 and 2008 Certification
  • Oracle 9i Wizard certification
  • 6 AFS awards for contributions to project work and meeting required government deadline.

We'd love your feedback!