Objective:

An Oracle Certified Database Administrator with over 13 years of technical and analytical experience who is specialized in database security, performance tuning, E-Business suite, high availability, disaster recovery solutions and SQL Server 2008/2012 Cluster.

Professional Summary

• Senior Certified Oracle professional DBA with more than 13 years of Oracle Production DBA and 5 years of Oracle APP DBA and 10 years SQL Server experience, providing 24x7 Supported and maintained large Production Dev databases on Various Platforms demanding high availability and increased performance.

• Extensive Experience with the database from designing, developing, implementing and administering, which includes installations, support, troubleshooting, backup recovery, testing, networking, monitoring managing of users, performance tuning of applications and the databases Oracle 12c/11g/10g/9i as well using SQL, PL/SQL, ORACLE RAC Real Application Cluster , Data Guard Database, ASM , OEM 12c, Oracle Utilities, Oracle Enterprise Manager Oracle Management Server on Unix Windows platforms.
• Strong experience on RMAN backup and recovery , database performance tuning, Flashback technology, Datapump, Import/Export utilities, SQL Loader, applying patches and troubleshooting.

• Expert in Support and Maintenance, Performance tuning, shell scripting, database upgrades and solid experience Oracle cloud control 12c and Weblogic Servers installation, configuration, maintenance.
• Extensive experience for Installation, Configuration, Maintenance, Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications E-Business Suite 11i/R12 using Rapid install, Adadmin, Adpatch, Autoconfig, Rapid clone, Auto Patch.
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Solid experience in Installing, Implementing and configuring of MS SQL Server 2005/2008/2012 databases, Implementing Maintenance Plan and experience of Database Mirroring and Clustering.
• B.Sc. Degree in Computer Software Engineering and Certificate in Database Application Developer, Oracle OCA and Oracle OCP.
• Strong Technical background, excellent analytical ability, good communication skills and team player.

Technical Skills

Database Management Systems DBMS : Oracle 9i/10g/11g/12c Administration, Oracle RAC 10g/11g, Data Guard, Golden Gate, Data Warehouse, Microsoft SQL Server 2005/2008/2012 Administration, MySQL

Software Application and Tools : Oracle E-Business Suite 11.5.9/12.1.3,Database tools for administration, PL/SQL, Oracle Enterprise Manager 11g and Cloud Control 12c , Web Logic Server 11g ,Oracle Automatic Storage ASM Management, Backup Technology Oracle RMAN , Data Pump, SQL Loader, SQL Plus , TOAD, Spotlight , Explain Plan , Netbackup , Erwin, Rational Rose , Cognos BI , Oracle Developer Forms and Reports

Programming Languages and Technologies : Oracle SQL,PL/SQL , UNIX shell scripts , SQL Server T-SQL , ASP.NET, ASP, PHP, Perl, XML, CSS, XSL, XSLT, JavaScript ,C , Visual Basic.Net, Visual C ,Java and J2EE

Operating Systems Platforms : Sun Solaris, IBM AIX, UNIX, Red Hat Linux, Oracle Solaris,

Microsoft Windows 2003/2008/2012 Server

Professional Experience

Oracle Database Administrator

Confidential

• Planning, Implementing and Validating various versions of Oracle Databases 11gR2 upgrades on all the environments in a procedural approach Dev, Test, Stage and Production also Planning of backout procedures like building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Recovering Databases when there is any Physical or Logical Corruption.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues
• Implemented Oracle Patches CPU, PSU on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab UNIX , Scheduled Tasks Windows and Maestro 7.0 Job Scheduling Tool .
• Knowledge of the Oracle Golden Gate configuration and troubleshooting..
• Used DBMS packages to schedule jobs, re-engineering, gathering statistics, mview refresh.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Assisted developers with the Tuning during the development and tuned the applications.
• Solid experience on high availability SQL Server solutions, including Replication Models Snapshot/Transactional and SQL Server clustering Active-Active, Active-Passive .

Oracle Database Administrator

Confidential

• Performed Oracle software installations, database creation, database upgrades ,applied patches and helped application team set up the various environments DEV, UAT, TEST,QA
• Created database schemas, tablespaces, users, tables, PL/SQL stored procedures, functions, triggers, etc.
• Promoted the applications and database environments to UAT, QA environments when development was complete.
• Refreshed different non-Production database instances /schemas with Production data using Oracle data pumps and Import/Export tools and migrating development changed to UAT and Production environment following RFC process.
• Created, managed, monitored, backed up and recovered multitenant container database CDBs in oracle 12c using multiple pluggable databases PDBs.
• Implemented of EM12c installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Configured RMAN database backups using Veritas Net Backup and enhanced RMAN backup scripts for hot backup, archive log and cross check scripts.
• Implemented RMAN backup and recovery procedures to enable efficient cold and hot database backup with minimal human error and database downtime.
• Configured and administered RAC on Oracle 11g environment, ASM load balancing,OCR and voting disk.
• Configured administered of Oracle Data Guard environments, Database Failover Database Switchover and performed Dataguard standby switchover and fail over tests to ensure maximum business continuity.
• Developed and enhanced administrative UNIX shell scripts and Oracle scripts for proactive Database monitoring, maintenance and database backup and automated regular tasks to help minimize human error.
• Performed database restores and recoveries provided and tested Disaster Recovery plan for production databases to ensure that the corporate data is protected from misuse and loss.
• Maintained and monitored performance, space utilization, uptime and availability of all database systems. Report on all performance metrics and monitored the overall health of Cloud Control system Manage targets and hosts.
• Provided SQL tuning recommendations to development team and provided security administration including managing role and end user database permissions in accordance with customer policies.
• Provided steps for upgrade from 10g and 11.2.0.1 to 11.2.0.3 upgrades.
• Monitored Production environment and resolution of severe performance tuning using tools such as STATSPACK, AWR, TKPROF.
• Performed Maintenance, Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications e-Business Suite and responsible for new implementation of Oracle Applications 12.1.3 using Oracle database 11.1.0.7. Installed E-Business suite software.
• Applied patches, created database users, used autoconfig, addadmin, adpatch and rapid clone.
• Cloned E-business suite environment to provide testing and standby environment. Configured and tuned of the EBS environment including concurrent managers, work flow, application servers and databases.
• Performed trouble shooting and Uploaded budget data to production Oracle Financials database using Oracle's General Ledger Open Interfaces, and automated this process with interactive UNIX shell scripts.
• Installed, configured, monitored and troubleshoot Oracle Fusion Middleware systems in non-clustered and clustered configurations and create and extend WebLogic domains for Fusion Middleware components.
• Installed, configured and administered all development, QA and production SQL Servers/databases. Performed day to day Database Maintenance tasks, Clustered Non-clustered Database Monitoring, Backups and Disaster Recovery Planning, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Worked extensively on Clustering, Replication and handled multiple SQL Server 2012 Instances on Cluster environment for Server projects. Troubleshooting production issues and raising high availability.
• Roster on call responsibilities and On call 24x7 Support production and development/test databases.

Oracle Database Administrator

Confidential

• Provided Oracle Database Administration support and troubleshooting, including install Oracle software, patches and upgrades, manage and monitor Tablespaces.
• Performance Tuning Monitoring, estimate the number of users, CPU and Disk space requirement, identifying bottleneck and rectifying it, fine-tuned store procedures to improve performance, database loads performance improvements, proper setup of database files and file groups to boost performance.
• Configured and manage RMAN backup and recovery and implemented backups using RMAN as a primary backup mechanism.
• Provided Oracle RAC Database Administration support including Administering Oracle Clusterware components like Voting Disk and Cluster Registry, Adding and Deletion of Nodes RAC Instances, Oracle RAC Database Performance and Tuning issues and Oracle RAC Database Backup Recovery.
• Installed standby database and configured data guard in 10g environment and tested switchover and failover procedures.
• Analyzed capacity and growth of databases using various automated stress testing tools and performance optimization and Monitor performance through AWR ADDM.
• Implemented database level security using Roles.
• Performed disaster recovery, capacity planning, real time monitoring, troubleshooting and proactive maintenance and Utilized UNIX shell scripting to automate system administration on Oracle database.
• Installed, configured and managed Oracle Enterprise Manager OEM for managing of Oracle databases.
• Upgraded Oracle database from 10g to 11g in Dev, Test and Production environments with little downtime.
• Used Oracle tools like Data Pump, SQL Loader, RMAN, OEM and Installed and Upgraded Oracle.
• Performed Installation, Configuration, Deployment of Oracle E- Business Suite 11i/R12 and responsible for Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configuration.
• Applied Patching, Upgrades and Cloning For 11i/R12 Apps.
• Provided support for current applications and solve other issues according to on-call database support.

Oracle DBA / SQL Server DBA

Confidential

• Managed and maintained hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Installed and tested new versions of Oracle database, applications and patches.
• Performed disaster recovery testing using RMAN backup and recovery tools. Cloning and refreshing. Databases and applications. Ensured availability of client production systems and internal instances.
• Monitored and optimized performance, resources, and operation of all systems.
• Managing table spaces, data files, redo logs, tables and managing security, roles, privileges and profiles.
• Upgraded Oracle database from 9i to 10g in Dev, Test and Production environments.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provided technical support for database maintenance and disaster recovery with High Availability like Mirroring and replication for SQL Server 2005/2008.

Oracle Database Administrator

Confidential

• Oracle DBA with responsibility for performance, Backup and recovery, tuning and Networking.
• Supported the ORACLE production and development databases.
• Installed, configured and maintained Oracle 9i database server covering over 800 users.
• Designed the recovery plan. Supported the testing group in tuning automated bridging applications.
• Analyzed objects for Production Databases, transfer data to other platforms and build indexes.
• Planed and implemented various Transact-SQL statements, stored procedures and triggers.
• Monitored system performance using Enterprise Manager and Query Analyzer to optimize the data.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Be On-Call for the production database and provided support for banking and financial systems.

Software Developer

Confidential

• Developed application and databanks using Oracle, SQL server and Visual Basic including personnel, secretariat, and storage systems.
• Developed an application for the petrochemical Company in Visual basic using ActiveX and Winsock controls, interfacing with other applications and accessing an Oracle database.