We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Over 14 years of exerience in database design, development and administration. Implemented and maintained complex enterprise applications for Federal Agencies, such as Department of the Navy, DHS, Bureau of Engraving and Printing. Solid expertise in the following areas:
  • RAC database installation and configuration, database upgrade, security patches application (CPU) deployments, RAC database administration, Oracle Enterprise Manager HA Cloud Control 12c and 13c.
  • Oracle advanced technologies include, ASM (Automatic Storage Managent), Real Application Clusters (RAC), Oracle Enterprise manager High Availability 13c, and Data Guard for the purpose of business continuity, load balancing and system scalability, performance tuning and backup and recovery (RMAN)
  • Oracle E - Business Suite applications database administration including database patching and cloning.
  • Experience in WebLogic Sever single node and Cluster patching, upgrade and administration.

EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

  • Mr. Kadji is a senior member in Operations and Maintenance (O&M) team, responsible for supporting terabytes Oracle database version 11.4.0.2, and then on 12c after upgrade, Oracle Enterprise Manager 12c and 13c.
  • Install and configure Oracle Enterprise Edition 12c on RAC servers with Linux Red Hat version 7 and created Container databases and Pluggable databases in 2 and 3 nodes RAC (Real Application Cluster) platform for development, test and production databases.
  • Lead the Migration of the database from 11.2.0.4 to Oracle database 12c and applied all the required security patches in the RAC environments.
  • Constantly refresh development pluggable databases from production or Staging environment.
  • Install Enterprise Manager 13c Cloud Control on RAC databases and configure OMS High Availability.
  • Create and configure OEM Monitoring Templates for different environment (Development, staging and Production);
  • Create Metric Extensions and deploy to different Monitoring templates.
  • Support front end applications including Oracle E-business Suite R11 and R12, Oracle Golden Gate, ODI, Informatica, OBIEE, WebLogic and IBM Maximo.
  • Experience administrating multiple stand-alone and Oracle E-Business Suite databases; including routine administrative activities such as installing, pre and post-clone activities, cloning, Oracle database upgrade, backup/restore, and Database, Informatica and Apps tier patching.
  • Troubleshoot and resolve database, OBIEE, Weblogic, informatica and Oracle e-Business Suite related issues.
  • Coordinate with MCS to support and manage enterprise-wide Oracle E-business suites environments for the production, development and test environments instances.
  • Lead the upgrade of WebLogic single node and cluster servers from 10.3.2 to 10.3.6 of different environments and apply Quarterly security patches.
  • Perform and monitor backup of database instances and perform database recovery when necessary.

Technical Environment: Windows 2008, Linux Red Hat 5 and 7, Oracle 11gR2 RAC, Oracle12c RAC, ODI(Oracle Data Integrator), Data Guard, Standby database, Informatica 8.6.1 and 9.5.1, PL/SQL, Oracle WebLogic Server, OBIEE, Oracle EBS R12.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Responsible for Performance tuning, cloning, patching, backups and upgrade of databases.
  • Worked with developers to make structural changes to the databases when design changes are to be implemented and also implemented those changes in Informatica mappings as well.
  • Lead the Upgrade of all production, staging and Development databases from Oracle 9i and 10g to Oracle 11gR2.
  • Permanently refreshed development and test databases from productions databases.
  • Installed and configured Oracle Enterprise Manager 10g release 2 (10.2) and later upgraded to Oracle Enterprise Manager 11g Release 1 (11.1).
  • Patched Oracle production, developments and staging servers with quarterly security patches to mitigate security vulnerabilities and provide product enhancement.
  • Developed, customized and implemented database backup and recovery procedures for all production and development systems.
  • Worked with developers on daily basis to promote database objects in production.
  • Installed and configured physical standby database to support the AFSP (Alien Flight Student Program) and RMS (Reporting Management System) applications including the configuration of Data Guard broker and ASM instances on sun servers.
  • Installed Informatica Power Exchange version 8.6.1 as well as Windows Server 2003 Resource Kit Tools and established connectivity through ODBC data sources.

Confidential

Database Engineer

Responsibilities:

  • Provided primary administrative supports that include proactive and reactive maintenance for large complex database using Oracle9i and 10g databases in mainly UNIX, LINUX environment and Windows Systems.
  • Performed database performance tuning, SQL statement tuning and optimization and tables Partitioning.
  • Refreshed development and test databases from copies of production instances.
  • Worked in a cross-functional environment with project managers, other engineers to make structural changes to the databases when design changes are to be implemented.
  • Worked with offshore software development team to provide database and applications support.
  • Planned and performed database upgrades from Oracle 9i to 10gR2 and applied quarter maintenance release patches.
  • Responsibilities also include solving support issues for assigned service requests and complete all support requests in a timely manner.
  • Deployed codes to production environment and ensured continuous 24x7 operation and availability in support of mission critical of business applications.
  • Modified UNIX Shell scripts to automate database operations.
  • Troubleshot Backup errors and performed RMAN database backup and restore as needed.
  • Created Standby databases including the configuration of data guard on remote servers for disaster recover purpose.

Technical Environment: Linux, Windows Servers, SQL server, Oracle 9i, Oracle 10g,and Oracle 11g Database, Oracle Data guard, ASM, Grid Control.

Confidential

Database Engineer

Responsibilities:

  • Provided 24X7 Operational Support to the Mission Assurance Division and its customers. He serves as Primary and Technical Point of contact for all CIP (Critical Infrastructure Protection) databases and System Administration.
  • Provide work coordination and management for teams of DBAs, including task assignment and coordination, and status reporting.
  • Kept the project manager and product committee informed of task accomplishment, issues and status.
  • Experience administering enterprise level GIS applications (ArcSDE and other ESRI products). Support geospatial data acquisition, processing, and analysis within the context of the DOD mission critical and research availability of remotely sensed data, especially high-resolution imagery, and other data to help developing geospatial information products in response to needs of the organization mission.
  • Led the migration, upgrade and installation, configuration and testing of ArcSDE and ArcGIS desktop applications from version 8.3 to 9.2.
  • Provided GIS support on the ISR/GIG project, OCONUS Military Mail and SPI data using ESRI ARCview software for Image Analysis and processing.
  • Responsible for installation, maintenance support, upgrades, monitoring and tuning of oracle and Microsoft SQL Server databases. Environments included Oracle 9i and 10g running on HP-UX UNIX, LINUX and Microsoft SQL Server7/2000.
  • Researched, Implemented and tested Oracle Advanced Security to integrate with Microsoft Active Directory (KDC) to allow enterprise users to authenticate to multiple databases using a single, centrally managed password (Single Sign-On).
  • Implemented HP Data Protector backup solutions used to backup Oracle and SQL Server production, development instances to tape and authored backup and recovery documentation.

Technical Environment: HP-UX, GIS, Oracle 9i, Oracle 10g, OEM.

We'd love your feedback!