SUMMARY

• Over 7+ years of experience as Oracle DBA in the IT industry.
• Expert in Implementation Oracle 10g/11gr2 Grid (RAC, CRS, ASM, Database) and Configuration for High Performance and High Availability with latest Cluster Technology.
• Expertise on Managing Oracle 11g/10g/9i/8i,RAC 24*7 on call production DBA Support on Linux, Solaris, HP - UX, Dynix, Win NT and Win XP/2000
• Enviornment including E-Business Suite Implementations with full project life cycle experience skills.
• Expertise in Design and Implementation of Database Systems to provide database support for systems/projects, rehosts, migrations and conversions.
• Implementation of all Oracle's latest Tools/Products/ to the Advanced Global next generation Information Systems Client/Server
• Architecture Technology for large/medium/high Oracle Databases in Global Market Production/Development Projects in a good Advanced progressive environments.
• Experience in Configuring, Administration and Management of Oracle Dataguard in 10g/11g version.
• Performance tuning of Queries, Database Performance improvements on Critical production Enviornment. Performance tuning of SQL
• PL/SQL Queries, tuning using dbms profiler, sqlt, Trace analyzer, RDA, ash reports, AWR report, AWR SQL Reports. Analysis of Wait events and analysis of trace files using debug commands.
• Experience in Implementing and administration of Oracle Ebusiness Suite projects and upgrades of Oracle Ebusiness Suite instance from 11.5.8 to 11.510.2 and 11.5.10.2 to R12.
• System administration and troubleshooting of Concurrent Managers, Forms, Reports, Web server Printer issues on the Ebusiness Suite 11i instance, R12 instance, OID and SSL configuration.
• Helped different Customers/clients to upgrade their databases of different sizes (database sizes from 1 gig to 12 Terabyte support) on different OS Environment.
• Experience in troubleshooting issues in Oracle golden Gate and Migrating databases from Oracle 10g to 11g using Oracle Golden Gate.
• Have worked on and implemented process as per the ITIL Framework Enviornment and adheres to operational/business SLA required for the organization.
• Excellent in Implementing Oracle 10g Interconnect DBA Support, Implementation.
• Handled large databases size in production ranging from 1GB to 30 TB.
• Oracle Data Centre Migrations, Consolidation and Upgrade/Migrations of Oracle Databases for different Oracle Versions and platforms. Patching and Cloning of Oracle and Oracle Apps Instances.
• Logical & Physical DB Design involving Change Management process with ITIL Oriented framework with adherence to business SLA depending on the business environment.
• Worked on Oracle features in Oracle10g/11g (Partition, Parallelism, Compression), Oracle 9iAS, SQL*PLUS, Pro*C, IMP/EXP, IMPDP/EXPDP, RMAN, ASMCA, DBCA, SQL*Loader, Oracle Golden Gate Support.
• Exposure working in different domains such as wireless, manufacturing, telecom Banking and Logistics.
• Exposure on Managing other Database Variants like MSSQL Server 7/2000, MYSQL, Postgres Adaptive SQL, Sybase,DB2.
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability.
• Strong Logical and Analytical Reasoning Skills, Excellent Management skills, Excellent Communication with good Listening, Presentation and

TECHNICAL SKILLS

Operating Systems: Linux / Windows 2000 Server, HP AIX.

Database: Oracle 9i, Oracle 10g, RAC, Oracle 11g RAC, MySQL, DB2.

Administrating Tools: Oracle Server, Apache Server, TOAD.

Oracle 10g: Application Server, Oracle Enterprise Manager (OEM), DBA Studio, SQL Developer, Oracle Grid, Rapid SQL, Oracle 12C Grid Control.

Languages: HTML, DHTML, JavaScript, PHP, ASP, PL/SQL, SQL.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Administering Oracle 11g/10g production, test, development environment on IBM-AIX.
• Database Refreshing / Replication from production to testing using Datapump Exp/Imp.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases.
• Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Installed and implemented GoldenGate to replicate data between databases.
• Configure and build heartbeat monitoring in GoldenGate.
• Identified and produced necessary documentation of best practices for GoldenGate.
• Implemented necessary monitoring scripts for GoldenGate in unix/perl scripting.
• Recovery of Database using oracle recovery manager RMAN (Performed full recovery and point in time recovery
• Installed and configured Oracle Label Security in 11gR1 & R2 for row level security of sensitive PI data.
• Installed and configured Oracle Database Vault in 11gR1 & R2 for fine-grained access control and for separation of duties in the database.
• Created and configured Realms, command rules for restricting privileged users such as DBAs from accessing/altering highly sensitive data in the database.
• Installed and configured Database Vault in a 12c test environment with advanced secure application roles for POC.
• Architected and implemented GoldenGate replication between SQL Server data warehouse and Oracle capacity and performance management repository.
• Implemented transparent data Encryption (TDE Used TDE with both Encrypted columns and Tablespaces.
• Used Oracles Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Created and monitored Virtual Private Database (VPD) policies for securing sensitive data in PI tables.
• Performed database cloning to setup test and development database.
• Conducting sizing& capacity planning for Oracle databases.
• Migration of Database from 10g to 11g and applying patches whenever required.
• Migrated from SQL server database to oracle database.
• Upgrade of Databases from 10g to 11g.
• Installed ASM environment and migrated database from NON-ASM to ASM.
• Configured and monitored Physical Standby database for maximum performance mode - Oracle Data Guard

Environment: IBM-AIX 6.1, Oracle 10g, 11g, and 12c, RAC, OEM 11g, 12c, Transparent Data Encryption (TDE), Datapump exp/imp, Data Guard, ASM, Golden Gate, Exadata, Control M, Oracle Label Security, Oracle Database Vault, Oracle Virtual Private Database (VPD

Confidential, NYC, NY

Senior System Engineer (Database Administrator)

Responsibilities:

• Serve as single point of contact for Confidential at onsite for all operational issues at onsite. Co-ordinate with application teams for CTB activities and performance management.
• Perform planning scheduling of CTB activities in co-ordination with Confidential stakeholders.
• Perform workload management for the respective region. Participate and assist in critical RTB activities escalation. Lead Sev1 incident management activities.
• Manage RMAN backups of critical Production database. Performance monitoring and tuning of all Oracle databases.
• Installation and configuration of 11gR2 2-node RAC. Upgrades of prior versions to Oracle latest release.
• Perform analysis of existing implementations and make recommendations to further improve performance, availability, scalability and reduce cost and take lead in getting those recommendations implemented.
• Manage backup and recovery process and/or support the off-site backup and recovery teams as needed. Plan for and execute any required database upgrades and migration (patches etc.
• Change/Incident Management - coordination and management of both planned / scheduled changes and incidents relating to the production and non-production portfolio of UK&EMEA databases.
• For planned / scheduled work review and approve the change, identify conflicts, assign resource and ensure successful completion / implementation.
• Interaction with clients, application support teams, management, vendors and other infrastructure teams ensuring that correct solutions are implemented, incidents resolved and that needs are met on timely basis. Working on Business
• As Usual and Change The Business related Projects.
• Manage standards and strategies for security, database objects and backup/recovery.
• Work closely with database teams across Confidential Regions and establish database standards, procedures and automation strategies for tools and monitoring and maintain database and user security policies and standards.
• Supporting high level DR systems where EMC SAN level replication (SRDF) is configured between data centers.

Confidential

Senior System Engineer (Database Administrator)

Responsibilities:

• Responsible for database administration for a large and complex application.
• Responsible for performance & tunning of the database. Interacting with Oracle support for technical assistance. Troubleshooting calls and requests raised from end users and providing support for database.
• Monitoring OS and hardware configurations and performance on DB systems and work with Systems Administration teams to ensure availability DB systems. Monitor and configure data guard for disaster recovery.
• Monitors and manages database backups, logs and journals; installs, maintains and upgrades database software; restores and recovers data as required.
• Performed table re-organization when required for better performance. Monitoring database using Oracle 12C Grid computing.
• Performed and coordinated action plan tasks to improving production reliability and Performance. Analyzed application performance and performed and coordinated OS, network, database, procedural and application improvements.
• Analyzed and implemented improve database monitoring Worked closely with release managers to analyze and improve change management procedures. Deploy database changes into staging and production during release cycle.
• Work with System Administrators (UNIX & NT) to ensure Oracle related matters are handled properly. Performed table re-organization when required for better performance.

Confidential

Senior Consultant (Database Administrator)

Responsibilities:

• Providing support for 160 Production Environment with 24*7 DBA support and 200 Test & Development Environment databases.
• Size of the databases from 10GB to 4TB. Installation, Upgradation, Maintenance of Oracle Databases.
• Managing the ASM Instance and ASM Disk Group.
• Monitoring database using Oracle 10g Grid computing. Performed and coordinated action plan tasks to improving production reliability and Performance.
• Analyzed application performance and performed and coordinated OS, network, database, procedural and application improvements.
• Analyzed and implemented improve database monitoring Worked closely with release managers to analyze and improve change management procedures.
• Deploy database changes into staging and production during release cycle.
• Applying the Opatches on production and test environment.
• Gathering the statistics of the tables, Logming. Applied and managed the application of DDL and DML patches daily. Performance Tunning using
• Explain Plan, Autotrace, Statspack and AWR Report. Creating shell scripts to ease routine activities.
• Upgrading from Oracle 9.2.0.x to Oracle 10.2.0.x & upgraded from Oracle 10g to Oracle 11g.
• Co-ordination with change and release manager for new changes in application. Involved in on-call support on a rotating basis with other team members.
• Capacity and Storage planning for future storage requirements. Interacting with Oracle support for technical assistance.
• Involved in attending CAB meeting and daily meeting for suggestion & service improvement.

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Involved in designing the database, identification of the objects and creating tables.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Developed PL/SQL scripts for exception handling.

Environment: ORACLE 8i, 9i, SQL, PL/SQL, Cron job, Import/Export, UNIX AIX 5.1.