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