We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

SUMMARY:

  • Oracle Certified Database administrator, with more than 12 Years of IT working
  • ExperienceSolid 10 Years
  • Experience in Oracle Database administration OLTP and OLAP, ETL/Data Warehouse And SQL Server 2008,2012 and 2014, Strong experience on Oracle Real Application Cluster (RAC), ASM, Data Guard/Standby,11G Snapshot Standby Database, Oracle Application Server 10g, Oracle Fusion Middleware 11g, Oracle Database Appliances(ODA), Oracle Data Integrator (ODI) SQL, PL/SQL functions, procedures, triggers and Packages, Oracle Flashback, Shell Scripting, Oracle 6i, 10g and 11g forms and reports, Weblogic Configuration, Oracle Advanced Replication, (OHTTP)Oracle web tier, LogMiner, OEM, Grid Control, BI (Business Intelligence) Publisher, Oracle Access manager(OAM), Oracle Identity Management(OIM), Oracle Internet directory(OID) Import & Export, Data Pump, RMAN(backup and recovery), Sql*Loader, Database Performance tuning, Applying patches, Partitioning and troubleshooting, Excellent knowledge of Various operating systems and System Administration on Unix OS including AIX, Sun Solaris, 8, 9, 10, 11, Linux RHEL 3, 4, 5, 6, Windows server 2003,2008,Xp on 9i, 10g, 11g, 12c.
  • Very technical and best practice oriented, good communications skills, Able to work as a team
  • Player, team leader or independent

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

  • Senior Oracle Database Administrator that is responsible for managing and upgrading ORACLE Non - RAC and RAC Clusters which are used by Mission critical customer facing Applications with the goal of improving the database system scalability, performance and functionality which resulted in the business satisfaction and the cost savings.
  • Support Installation, Configuration, Migration, Upgrading, Patching, Tuning, RMAN and Data Guard for Database and Application servers on Solaris, Linux and windows Servers platform.
  • Support 10+ Terabyte Production RAC and Non-RAC Databases and applications plus Data Guard Servers.
  • Installed and configured Oracle Database 12C.
  • Upgrade Oracle Databases from 11G to 12C.
  • Troubleshoot performance and Apply PROD Fixes.
  • Applied Quarterly CPU (CRITICAL PATCH UPDATES) Patches on all the Databases.
  • Installed, Configured, Upgraded and Managed OEM 12C (12.1.0.5) and Agents.
  • Upgraded OEM from 12C to 13C.
  • Created/updated Shell Scripts and Oracle SQL, PL/SQL Scripts to monitor databases and other related activities.
  • Installed and configured Standby (Data Guard) Databases (Active and Snapshot).
  • Performed Switchover and Failover from production to standby.
  • Performed backups and tested crash recoveries using Cold, Hot backups with RMAN and also tested various recovery procedures.
  • Importing and exporting data to and from the database servers using data pump (EXPDP & IMPDP) and Creating & maintaining detailed configuration documentation, and maintenance plans for the database environment.
  • Creating tables, views, indexes, database links, views, materialized views, stored procedures, and other database objects as needed.
  • Creating and assigning database roles and privileges and Performing Oracle and SQL performance tuning tasks using AWR, ADDM and TOAD.
  • Analyzing, capturing data requirements, data definitions, business rules, and data quality requirements.
  • Install, Configure, Supports and Mange SQL Server 2012/2014.
  • Raise Oracle SR tickets and working with remedy ticketing system in support of production and Non-production servers
  • Managing the storage environments for the databases from ASM and File System, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.

Confidential

Senior Oracle Database Administrator

Responsibilities:

  • Carry out all major service delivery and support areas: Installation, Configuration, Migration, Upgrade, Patching, Cloning, Tuning, RMAN, MAA and Data Guard for Database and application servers primarily on Solaris and Linux Servers platform.
  • Support 4+ Terabyte Production RAC and Non-RAC Databases and applications plus Standby servers.
  • Installed and configured Oracle Database 12C.
  • Apply Oracle CPUs Patches on Databases.
  • Upgrade Oracle databases from 11G to 12C.
  • Troubleshoot and Apply PROD Fixes.
  • Troubleshoot performance and database code issues across all the environments (Prod, Non-Prod).
  • Support Oracle 11G Fusion Middleware servers including OAM, OIM, OID, Web Logic, Forms and Reports
  • Apply Oracle Weblogic Patches.
  • Create/update UNIX shell scripts and Oracle SQL, PL/SQL scripts for database monitoring and other related activities.
  • Convert Forms and Reports from 10g to 11g.
  • Compile Forms and Reports.
  • Upgrade Oracle Database servers from 10G to 11G.
  • Wrote RMAN and shell scripts for Production and non-production databases.
  • Created Shell Scripts to Baseline FMW and Databases.
  • Manage Users access/privileges and groups through OID (Oracle Internet Directory) and Databases.
  • Upgrade Oracle Databases from 11.2.0.3 to 11.2.0.4.
  • Upgrade Oracle 11G FMW ( Fusion Middleware ) from 11.1.1.6.0 to 11.1.1.7.0.
  • Upgrade OEM 12C from Release 3 (12.1.0.3) to Release 4 (12.1.0.4)
  • Support User Accounts on Databases and Fusion Middleware level.
  • Installed, configured and upgraded BI Publisher 11G.
  • Troubleshoot and Support BI Publisher reports including Create reports, Data models, Data sets and Data sources and schedule jobs.
  • Working on the Remedy ticketing system.
  • Using Oracle Data Integrator (ODI) to support the Data warehouse databases.
  • Installed, configured and support the new 11g Snapshot Standby Database.
  • Creating and maintaining databases and database objects including logical and physical data models, DML, DDL, DCL, tables, object types, views, synonyms, users, sequences
  • Installed and configured and upgraded OEM 12C and Agents.
  • Troubleshoot and Support Standby Databases (Active and Snapshot).
  • Install, configure, troubleshoots and supports SQL Server 2008/2012.
  • Strong experience in writing and improving SQL Server T-SQL queries.
  • Experience working with SSMS, SSRS, SSAS & SSIS (reporting, analysis & integration services).
  • Monitor and schedule blackouts through OEM 12C for all the FMW and Database servers.
  • Uses Oracle tools and utilities like RMAN, CMD, DGMGRL, SRVCTL, Import/Export (and Data pump) plus SQL*Loader and 3rd party tools like Toad.

Confidential

Senior Oracle Production/ Application DBA

Responsibilities:

  • Perform DBA responsibilities including creating and maintaining database objects, user profiles and access privileges, Performance monitoring and tuning databases backups, etc.
  • Manage Production, non-production, DR databases and Application Servers.
  • Provide programming support for applications using SQL, PL/SQL and UNIX scripts including Stored Procedures, Triggers, and other objects as required.
  • Proactive monitoring performance, Plan growth and changes (capacity planning) and manage parameters to provide fast query responses to 'front end' users.
  • Accept responsibility for problem escalation to line manager, in the event of database availability and performance problems and provide realistic, achievable potential solutions to the problems.
  • Installed, configured and upgraded Oracle Database from 10G to 11G.
  • Installed, Configured JDK, Weblogic on Windows, Linux and Solaris.
  • Installed and Configured Oracle Fusion Middleware 11gR2 for deploying DCMS tailored forms-based applications.
  • Converted and Compiled Oracle Code (Forms, Libraries, Reports, Menus….).
  • Integrated/Migrated Custom Applications DCMS "Daybreak" to work with 11G Fusion Middleware.
  • Upgrade Application server from 10G to 11G.
  • Troubleshoot and develop solutions for problems related to database and Oracle Applications.
  • Deploy Zip Codes using Sql*Loader.
  • Install and configure the new 11g Snapshot Standby database.
  • Liaise with application and business clients to gather requirements, design and deploy standard systems which clearly differentiate between production, development, UAT, and DR.
  • Involved in on-call support on a rotating basis with other team members to support production systems environments.
  • Monitor and raise Oracle Service Requests (SR).
  • Use Oracle specific tools and utilities like OEM, CMD, RMAN, DGMGRL, SRVCTL, Import/Export (and Data pump), SQL*Loader and 3rd party tools e.g. Toad etc.
  • Deploy Builds to DCMS and ELA Production and non-Production Databases.
  • Apply Production Fixes to DCMS and ELA Production Databases.
  • Used remote tools to connect after hours like FTP, PuTTY, VPN, etc.
  • Resolved rollback segment errors by creating bigger UNDO table space and increasing the retention time and this increased performance to the users.
  • Design and plan infrastructure for oracle database including Allocating system storage and planning future storage requirements for the database system.
  • Configured and implemented backup and recovery strategies using Recovery Manager (RMAN) backup on the Production and non-Production servers.
  • Troubleshot and resolved locking issues on DCMS Daybreak application.
  • Keep a checklist and methodologies which defines required deliverables at each stage.
  • Apply Patches & Bug fixes on Oracle databases and applications tiers on Sun Solaris Sparc servers.
  • Wrote RMAN script to duplicate production database to a test instance.

Confidential

Oracle Principal Consultant

Responsibilities:

  • Production DBA responsible for responding to problems on over 100 databases for over 7 clients with different environments in Oracle 9i,10g and 11g {Standard & Enterprise Edition} plus the Data Guard databases.
  • Fulfill DBA daily activities including user management (*creating users, synonyms, privileges, roles, quotas, table, index, sequence* etc.), space management (table space, undo segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
  • Responsible for all levels of Support, troubleshooting, customer consultation and performance tuning in a 24 x 7 x 365 environment for Oracle 9i, 10g, and 11g on different platforms (UNIX, Linux and Windows) worked with large clients such as:
  • Travelx USA
  • Travelx UK
  • Securenet
  • NaviNet
  • Webs
  • Europ assistance USA
  • OmniComm
  • Fedbid
  • EOriginal
  • Installed Linux Enterprise 4 & 5.
  • Excelling experience in Installing and configuring Oracle Real Application Cluster (RAC) cluster on Oracle 10g and 11g R2 With ASM and Raw Devices and 11g CRS providing high availability to the Oracle production environment.
  • Manage and Supported Oracle RAC (Real Application Cluster) on Oracle 9i, 10g and 11g.
  • Excelling experience in Installing and configuring Oracle Database Appliances (ODA).
  • Excelling experience in Installing and configuring OHTTP (Web tier).
  • Excelling experience in Installing and configuring Web Logic.
  • Excelling experience in Installing and Troubleshooting Oracle 6i, 10g and 11g Forms.
  • Excelling experience in Installing and configuring and Managed (OEM) Oracle Enterprise Manager Database and Grid Control 10g and 11g.
  • Configured UTL SMTP to send Emails from the server.
  • Successfully completed 6 projects on Oracle RAC - Configure, implement, and support
  • Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
  • Monitor and Tune the databases through command line (pro active scripts) or OEM to insure satisfactory performance.
  • Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
  • Created database users, table spaces, tables, and indexes, constraints, Function, stored procedures, Packages and triggers, profile, roles and allocating default table space for users.
  • Resolve lock issues, space management issues, security, user management, privileges, roles and auditing.
  • Worked with archive and no archive log mode.
  • Implement disaster recovery sites using standby Oracle Data guard/Active Data Guard Modes Maximum (Performance/Availability/Protection) and configure it with DG broker.
  • Manage, support and maintain Oracle Data Guard 10g providing high availability and disaster recovery for Oracle production environment.
  • Upgrade and migrate Oracle databases from 10g to 11g R2.
  • Applied Oracle patches and troubleshooting.
  • Detect and correct any performance issues.
  • Successfully changed the Database Name.
  • Successfully converted the database character set from single byte to multi-byte (UTF8).
  • Reconfigured production SAN environment, created new logical volumes for Oracle files (control files, data files, flashback logs, redo and archive log files) based on the best suited RAID levels and RAW devices for ASM.
  • Configured and Performed backups and tested crash recoveries using Cold, Hot backups with RMAN and also tested various recovery procedures.
  • Setup RMAN Catalog for all the Oracle databases.
  • Using Export, Import and Data Pump.
  • Schedule and create scripts to refresh the DEV databases from Production.
  • Experience in writing Shell Scripts for automating backups and restoration.
  • Monitored and tuned SQL and PL/SQL code using Quest TOAD for maximum efficiency and performance reducing execution times.
  • Compile /Migrate Oracle Forms & Menus & Reports from 6i to 10g to 11g.
  • Rewrote sections of PL/SQL code to improve performance.
  • Responsible for disaster recovery planning.
  • Performed Switchover and Failover from production to standby and vice versa.
  • Monitored and followed up Tar’s service requests raised with Oracle Support.
  • Write and Fine-tune UNIX scripts and setup Crontab jobs, schedule tasks, Oracle and UNIX alerts system to facilitate Weekly /Monthly/Daily updates/jobs.
  • Modified Oracle initialization parameters.
  • Analyze Redo Log Files Using LogMiner.
  • Create SSH keys between the Database servers (production and standby).
  • Add LUNS to the ASM and monitor the database and do capacity planning.
  • Partitioned (Hash, Range, List) large tables to increase performance.
  • Ran a (Stats pack, EXPLAIN PLAN, AWR) reports to evaluate the performance activity.
  • Wrote Oracle scripts to update and modify policies in the databases.
  • Create SQL trace files and used the TKProf tool to analyze them in as needed basis.
  • Ran a (trace plan, ADDM, and OEM tuning advisor in order to make tuning recommendations for slow running queries.
  • Excelling experience in Installing SQL Server 2008/2012 .
  • Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and Database Engine Tuning Advisor.
  • Created new databases and objects like Tables, Procedures, Functions, Indexes and Views using T-SQL and SQL Server Management Studio in Development and Production environment for SQL Server 2008.
  • Define and implement ETL development standards and procedures for Data Warehouse environment.
  • Managed data warehouse projects improvement and growths.
  • Wrote Shell Scripts to monitor slow running queries table space and extent growth.
  • Configured network configuration using TNS, LISTENER, Net Configuration Assistant.
  • Customized Oracle 10g Grid to send email alert when thresholds are out of given range.

Confidential

Oracle Database administrator

Responsibilities:

  • Provided 24 x7 database administrations, user/production support and monitoring.
  • Provided database Installation and configuration on both windows and Linux platforms.
  • Provided Oracle application Server installation and configuration.
  • Provided Oracle Developer Suite 10g, 6i installation and configuration.
  • Oracle RAC 10g installation and configuration.
  • Setting up Linux kernel parameters for Oracle.
  • Linux permissions and file structures for Oracle.
  • Documented Change Request Design Documents and install scripts for enhancement issues.
  • Solid experience in all kind of backup and recovery (logical & physical) using OEM, RMAN, TOAD, SQL*PLUS.
  • Created databases and imported schemas and ran the applications in the right way.
  • Provided Patching and Upgrading Oracle 10g.
  • Solving day-to-day user Problems (VPN at client location or by phone) in applications / database / network.
  • Good PL/SQL experience (working with the developers solving problems).
  • Reported to direct supervisor with a database status report.
  • Documented new system and created the entire Database Run book & Redbook.
  • Experienced in Export & Import user level, table space level, and database level.
  • Provided Monitoring & Managing the Table spaces and Data files growth.
  • Monitored locks and various sessions using OEM.
  • Controlled database privileges and managed user accounts.
  • Maintaining several Database instances running on Windows environments.
  • Worked on 6i and 10g Oracle applications, Installation of servers and clients.
  • Created and administrated database objects like table, views, indexes etc...
  • Provided support for the smooth functioning of the Database to developers.
  • Worked with archive and no archive log mode.
  • Worked on all kinds of flashback.
  • Restoration and Recovery from backup.
  • Setup RMAN catalog for all the Oracle databases.
  • Data transfer from excel, to oracle database using TOAD.
  • Provided Performance Tuning.
  • Provided Network connectivity and configuration.
  • Tuned PL/SQL code using Quest Toad.
  • Tuned Oracle initialization parameters and adjusted Oracle buffer cache to reduce disk access time.
  • Modified tables to allow parallel querying and loading.

Hire Now