We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

2.00/5 (Submit Your Rating)

Houston, TX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

  • Installation and configuration of Dbvisit standby on Primary and standby database Servers
  • Oracle Database Enterprise Edition downgrade to Standard Edition
  • Working with third party Vendors with regards to new database deployments ensuring proper standards are adhered to and Database Version Control maintained.
  • Provisioning databases for the Development team.
  • Data scrubbing and masking of production data for dev and test environments

Confidential,

Senior Oracle DBA

Responsibilities:

  • Setup Active Data guard Between Head Office Data Centre and Disaster Recovery site.
  • Implemented Partitioning strategy to improve response time of queries.
  • Migrated Databases to Exadata and Supercluster Environments from Non - Engineered system environments.
  • Performed Data Backups to Disk and ZFS Storage.
  • Implemented and configured Oracle GoldenGate for data replication to ensure Zero downtime.
  • Lead a Team of six DBA’s ensuring coverage 24/7.
  • Provided Mentoring to team members.
  • Maintained and Cloned Oracle EBS Version 12.2
  • Implemented data archiving and auditing methods based on Sarbines Oxley (SOX) act regarding data retention using audit logs, partitioning, Heat Map and other Information Life Cycle (ILM) strategies.
  • Acted as Subject Matter expert on issues concerning Oracle to other DBA’s, Developers and Exco
  • Implemented Data masking on sensitive data using 12c Redaction policies on the Core Banking database.
  • Performed Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory utilization and Performance Tuning of Data Core banking database.

Confidential

Database Consultant

Responsibilities:

  • Supported and improve the database performance of Confidential by repartitioning the databases
  • Provided product support by engaging improvement team to perform upgrades, as needed.
  • Engaged in Storage capacity planning and space management for production servers.
  • Installation of Application server for the Confidential environment through Development, Test, Uat to Production.
  • Implemented and administered a central user repository using Oracle Internet Directory (OID) for the SOA infrastructure preventing the need to add AD lightweight service for each new application deployed on Fusion Middleware.
  • Advised Management on database management strategies and best practices.
  • Migrated the Facts d Confidential base to a new M9000 environment while ensuring that Oracle best practises are adhered to.
  • Helped TSS developers with issues with PL/SQL coding.
  • Performed the role of the Oracle go to person for TSS dept.
  • Liaised with vendors regarding issues with server purchase and advised Management on d Confidential base management strategies and best practices.
  • Provided 24/7 on call support for the production databases.
  • Configured and set up Disaster Recovery Site using Oracle Data Guard.

Confidential

Senior planning Engineer/ Architect

Responsibilities:

  • Prepared Project Planning and Scheduling Procedures.
  • Prepared Project CTR’s C Confidential logue.
  • Prepared and maintained Project Schedule with resource allocation and levelling using Primavera 5.0 for Engineering and Construction and Microsoft Project.
  • Prepared and Updated Project Bar Charts and S-Curves.
  • Project control and monitoring.
  • Project reporting with analysis on project performance with emphasis on project target dates.
  • Prepared Project forecast and recovery Plans when appropriate in line with project delivery dates.
  • Established Work Breakdown Structure (WBS) to facilitate the creation of Cost Breakdown Structure (CBS).
  • Prepared and maintained planned and actual man-hours / cost expenditures using S-Curves.
  • Measured Value of Work Done (VOWD) against Time-Phased Budget on monthly basis.
  • Ensured that the planning and scheduling documents such as, master schedule, progress reports, “S” Confidential . are prepared properly and in accordance with contractual time schedules.
  • Introduced and reengineered strategic business processes using Oracle BPM

Confidential

ORACLE DBA

Responsibilities:

  • Working on client site for Confidential, an oil and gas producing company as lead DBA.
  • Carried out configuration of oracle database servers for Confidential databases.
  • Installed and migrated Oracle version 9.2.0.1 to 9.2.0.5 to conform to Confidential HCM 8.8 .
  • Data base administration and performance tuning on multiple instances of Confidential databases using Oracle and Confidential native tools.
  • Managed data conversion and uploading using SQL * LOADER, TOAD, EXCEL.
  • Cloned data bases Confidential various environments using D Confidential MOVER, DBCA and IMP/EXP
  • Rebuilt and created tables and indexes using APPLICATION DESIGNER
  • Installed and migrated Confidential and database patches Confidential environment
  • Work in conjunction with Basis dba team to analyzing space problem of tables, administration method and using the SAPDBA/BRTools utility provided by SAP.

Confidential

APPS DBA

Responsibilities:

  • Installation, administration and configuration of Oracle Applications version 10.5.9 on a linux 2.1 ES server
  • Installation and configuration of Oracle interconnect Confidential two Oracle version 9.2.0.5 d Confidential bases for a data stream application server.
  • D Confidential base monitoring using Watchdog, Enterprise Manager and Sql scripts.
  • Administration and configuration of Oracle Collaboration Suite.
  • Performance tuning of Oracle version 9.2.0.5 d Confidential bases including using explain plan and tablespace re-organization.
  • Backup and recovery of the oracle 9.2.0.5 d Confidential bases using Confidential .
  • Cloned production databases periodically to refresh the development environment.
  • Administered and upgraded Oracle 8i version 8.1.7 to version 9.2.0.5.
  • Linux system administration tasks.
  • Designed and tested Disaster recovery methods.

Confidential

APPS DBA

Responsibilities:

  • Patching of the Self-service web applications servers
  • Performance tuning of Oracle Portal ( Confidential server) using DAD trace, Confidential and explain plan
  • Installation and configuration of Oracle 9iAS on a Linux 2.1 ES server
  • Clone of the HR and payroll system
  • Database refresh of the council tax system
  • Upgrade of the Oracle CRM application from 11.5.7 to 11.5.9
  • Upgrade of Oracle Financials application from 11.0.3 to 11.5.9
  • Ensuring that the apps tier and the database tier are properly backed up and maintain the backup procedure

Confidential

DBA

Responsibilities:

  • Daily maintenance of over 130 Oracle databases using various tools including Enterprise manager, Big brother, scripts etc.
  • Installation and maintenance of Oracle 9i version 9.0.1 on a Linux Red Hat platform
  • Installation of Oracle 8i version 8.1.7 and upgrade of Oracle 7.3.4 to 8.1.7 on a dg-Unix platform, NT4/2000.
  • Installation of Oracle8i version 8.1.7 and upgrade of Oracle 7.3.4 to 8.1.7 on an OpenVMS Platform.
  • Mentoring of a junior DBA and skills transfer.
  • Maintenance of the Oracle data warehouse using enterprise manager and Oracle warehouse builder.
  • Creation of Oracle databases for the different departments across the
  • SAP Client copy (local, remote, export/import), creation of clients, deleting clientsSap (SAP GUI)

Confidential,

APPS DBA

Responsibilities:

  • Installation, upgrades and build of Oracle 8.1.6 databases for the investment and private banking group.
  • Performance tuning of all Oracle databases.
  • Daily monitoring of the databases and space issues
  • Implemented database synchronisation using Export utility, PL/SQL and SQL loader
  • Review of current backup procedures
  • Tablespace reorganisation.
  • Installation of Oracle applications version 11i using Rapid Install.
  • Operating system UNIX and NT4
  • Refreshed and cloned 11i production environment with adclone utility.
  • Extensive documentation of various task performed.

Confidential

APPS DBA

Responsibilities:

  • Working on client site for Confidential, an Internet banking solution for the Confidential private bank.
  • Installation of Oracle 8i version 8.1.6 on Development, Integration, Acceptance and Production environments on UNIX/NT.
  • Provide support for the development and infrastructure teams.
  • Daily monitoring of the databases using scripts, Enterprise manager and third party tools.
  • Migration of data into the Oracle databases.
  • Implementation of a backup and recovery strategy using Confidential .
  • Ensuring smooth running of all databases on a 24 /7 basis.
  • Installation and maintenance of Oracle applications version 11i
  • Writing Oracle Module Technical design using Oracle’s Application Implementation Methodology (AIM).
  • Patch administration and system administration task

Confidential

DBA

Responsibilities:

  • Installation and configuration of Oracle 8i version 8.1.6 and 8.1.5 on Confidential -UX v11 and windows NT 4.0
  • Daily monitoring of the SAP Oracle database using scripts, Enterprise manager and SAPGUI.
  • Database creation, user set-up, configuration of pearl DBI, JDBC thin and oci drivers
  • Writing of shell scripts and PL/SQL procedures for the monitoring and housekeeping of over 70 databases.
  • Implementation of a backup strategy for new databases created and the review of existing backup Strategy.
  • Unix system administration
  • Review and implementation of disaster recovery procedures

We'd love your feedback!