SUMMARY:

• Over 16 years of total IT experience, including 13 years on Oracle RDBMS(8i,9i,10g,11gR2,12C) with through understanding in Linux, Solaris, HP - UX, AIX UNIX and Windows 2003/2008 server.
• Strong knowledge in Oracle 10g and 11g RAC(2 node,3 node and 4 node cluster) and Node addition in ASM and Deletion and upgradation of the standalone databases.
• Migrating the Oracle 11g database from AIX server to AWS RDS by data pump.
• Working knowledge of AWS EC2, AWS RDS, AMI, Snapshots, EBS, S3, VPC,NACL, Security Groups, AWS IAM,AWS Direct Connect.
• Design the overall Virtual Private Cloud VPC environment including server instance, storage instances, subnets, availability zones.
• Experience in DW data model(star,snowflake schema),ETL architecture and repoting.
• Generated AWR reports from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Involved in SQL Query tuning and provided tuning recommendations to jobs, time/CPU consuming queries.to 11g RAC environment.
• Migration of oracle 11g (windows) to 12C (AIX) by data pump.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace & TKPROF.
• Support Golden Gate install, configuration, design, maintenance, tuning and support for both unidirectional and bidirectional Replication issue.
• Configuring the Initial Load, Data Selection and Filtering, Macro, DDL Replication.
• Strong in setting up Standby Database using RMAN tool, Activating Standby Database & Re-building Standby.
• Install and administration of Oracle Enterprise Manager (OEM) Grid Control,OEM 12C/13c,Oracle OMS and agent.
• Develops database solutions by logical designing of the proposed system,defining database physical structure, functional capabilities, security, back-up, and recovery specifications.
• Strong in Oracle DBA activities including installation, migration/upgradation
• Strong in configuration, backup, recovery, PL/SQL, SQL scripts programming.
• Experience working with Oracle Active Data Guard & Data Guard Broker .
• Configured the advanced replication between multiple Master Sites using Oracle Streams and Oracle golden gate advanced queuing.
• Strong in Database Migration / Data Center move.
• Strong in space management on different server.
• Know how to Tune the Application, Database (Shared Pool, Redo log, buffer cache, undo segments, I/O distribution)
• Availability to 24x7 on-call support on rotation basis for Production systems Support.
• Posse’s excellent analytical, problem-solving and learning skills as well as keen interest in the emerging technologies.
• Strong backup and recovery by RMAN .
• Strong in HOT and COLD backup, Export & Import
• Expert in physical & logical backup by Shell Script, RMAN and DATAPUMP.
• Know how to resizing the tablespaces and how to de-fragment the database, how to check system disk space.
• Strong in database Refresh and database cloning.
• Very strong in disaster recovery.
• Knowledge of shell scripts and Perl scripts.

TECHNICAL SKILLS:

Operating System: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 6,Red Hat Linux RHEL 5.x and Windows 95/98/ME/2003/2008/XP

Languages: SQL, PL/SQL

Tools / Methodologies: RMAN, OEM 12c/13c, Enterprise Manager Console, Oracle Connection Manager, SQL*Loader, EXP, IMP, Data Pump (expdp, impdp), Sql Developer, TOAD, Imp/Exp 32, Grid Control, Putty,AWS

Other Utilities: Shell scripts

Database: Oracle 7.0/8i/9i/10g/11.2/12C administration, Mongo DB,AWS RDS,EC2

Middleware: Oracle Golden Gate 10.4 /11.2/12 C

PROFESSIONAL EXPERIENCE:

Confidential, Miami

ENVIRONMENT: RHEL 5.9,AIX 6.1,7.1

Senior Database Administrator

Responsibilities:

• Install and configuration 2 or 3 node 11g RAC database and support the RAC Databases.
• Working knowledge of AWS EC2, AWS RDS, AMI, Snapshots, EBS, S3, VPC, NACL, Security Groups, AWS IAM and AWS Direct Connect, DynamoDB etc.
• Migration of oracle 11g in windows to oracle 12c(Linux).
• Create standby Database by Data guard and did the switchover and failover.
• Refreshing schemas from production to QA and Dev.
• Migrating the Oracle 11g database from AIX server to AWS RDS by Oracle datapump.
• Restarting failed ControlM jobs like (RMAN archive /incremental jobs, NFS backup failure jobs).
• Monitoring OEM for any performance issues (TOP Activity, AWR Report, Locking, Blocking, Long running jobs, Waiting, Execution Plans..etc).
• DBMS Software Updates - Installation of DBMS software per best practices. Security Patch apply and version upgrade evaluation, planning and installation.
• Create databases and install software on 10g, 11gR2 and 12C.
• Create 10g,11g databases and upgrade database from 10g to 11g by Data Pump.

Confidential, NJ

ENVIRONMENT: RHEL 5.9,AIX 6.1

Senior Database Architect

Responsibilities:

• Database Architecture and Performance Tuning
• Oracle Golden gate experience on large systems.
• Implement Conflict Detection and Resolution (CDR), Heartbeat for Lag, Exception Handler, DDL, Macro and GG lag.
• Worked independently and interact with the application, SA and DBA teams to solve business problems.
• Architecting new solutions or products and also solve deep into production issues.
• Experience with Oracle 12C.

Confidential

ENVIRONMENT: AIX 6.x

Senior Oracle DBA

Responsibilities:

• Support Golden Gate install, configuration, design, maintenance and support for both unidirectional and bidirectional Replication issue.
• Identify and solved all the Golden gate related issue and Materialized view related refresh issue in Development, SIT,UAT,TRM and PRM Environment.
• Generated AWR reports from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Install and administration of Oracle Enterprise Manager (OEM) Grid Control,OEM 12C,Oracle OMS and agent.
• Experience On-premise to AWS RDS Migration experience for Windows and Linux servers.
• Designing and deploying scalable, highly available systems on AWS.
• Working knowledge of AWS EC2, AMI, Snapshots, EBS,S3,VPC,NACL, Security Groups, AWS IAM,AWS Direct Connect.
• Experience in Identifying appropriate use of AWS architectural best practices.
• Involved in SQL Query tuning and provided tuning recommendations to jobs, time/CPU consuming queries.
• Support any replication issue and all database issue.
• Refresh the schema from one environment to another environment.
• Load the Conversion data from Dev environment to UAT, SIT, TRM, and PRM Environment.

Confidential, Calabasas, CA

ENVIRONMENT: Linux 6.x

Senior Oracle DBA

Responsibilities:

• knowledge of AWS services like EC2, S3,RDS,VPC etc.
• On-premise to AWS Migration experience for Windows and Linux servers.
• AWS VPC Design and Implementation.
• Working knowledge of AWS EC2 services in details like AMI, Snapshots, EBS etc.
• AWS Networking knowledge NACL.s, Security Groups,AWS IAM.
• Setup and Manage AWS Direct Connect and VPN.
• Experience in defining new architectures and ability to drive project from architecture standpoint.
• Experience to build scalable production systems (load balancers, mem cached, master/slave architectures).
• Define Migration strategy to move application to cloud.
• Develop architecture blueprints and detailed documentation. Create bill of materials, including required Cloud Services (such as EC2, S3 etc.) and tools;
• Design the overall Virtual Private Cloud VPC environment including server instance, storage instances, subnets, availability zones, etc.
• Design the AWS network architecture including VPN connectivity between regions and subnets.

Confidential, Sunnyvale, CA

ENVIRONMENT: Linux 5.x, AIX 6

Senior Oracle DBA

Responsibilities:

• Create the Physical Standby database,setup dataguard broker, switchover and failover.
• Create databases and install software on 10g, 11gR2. Security Patch apply and version upgrade evaluation, planning and installation.
• OEM (Grid Control) Installation, Oracle OMS and OEM agent installation and administer the database by OEM.
• Migration of oracle database from 10g to 11g by data pump.
• Install MongoDB and setup MongoDB instance with 3 member replica set.
• Install and configuration 2 or 3 node 11g RAC database and support the RAC Databases. install, configuration, design, maintenance and support for both unidirectional and bidirectional Replication issue and implementation, Configuring the Initial Load, Data Selection and Filtering,Macro,DDL Replication etc.
• Develops database solutions by logical designing of the proposed system,defining database physical structure, functional capabilities, security, back-up, and recovery specifications.
• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU,Wait etc.). Performance parameters adjusted as needed.
• Create database backup scripts, maintenance scripts.
• Setup Bi-directional replication by Oracle Streams.
• Given the grants and roles to users, given the profile to users.
• Planning for systems physical environment, hardware capacity planning.
• Raise a service request to Oracle Metalink to resolve the critical issue.
• Copy the data from One database to another database, from one schema to another schema by Oracle DATAPUMP.
• Tune the database for application slowness.
• Migrate the database from One server to another server.
• Create the MYSQL database and administer the MYSQL databases.
• Refresh the Test/Dev/UAT database from production.

Confidential

ENVIRONMENT: Red hat Linux, Windows 7

Senior Oracle DBA

Responsibilities:

• Provided On call Production DBA support(24/7)
• Create databases and install software on 10g, 11gR2.
• Create 10g and 11g databases and migrate database from 10g to 11g by Data Pump
• DBMS Software Updates - Installation of DBMS software per best practices. Security Patch apply and version upgrade evaluation, planning and installation.
• DBMS configuration planning for systems physical environment, hardware capacity planning and licensing of enterprise environment.
• Know how to raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.
• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Create database maintenance scripts.
• Implementing Oracle security.
• Create Oracle Backup setup and scripts for RMAN.

Confidential

ENVIRONMENT: Red hat Linux 5, Solaris 8

Senior Oracle DBA

Responsibilities:

• Create databases and install software on 10g, 11gR2.
• Create 11g RAC database and support the RAC Databases.
• Provided On call Production DBA support(24/7)
• Support Golden Gate install, configuration, design, maintenance and support for both unidirectional and bidirectional Replication issue and implementation, Configuring the Initial Load, Data Selection and Filtering, Macro, DDL Replication etc.
• Replacing a failed ASM disk.
• Create standby Database by Dataguard and did the switchover and failover.
• DBMS Software Updates - Installation of DBMS software per best practices. Security Patch apply and version upgrade evaluation, planning and installation.
• Migrate Dev, Production database from 10g(Windows) to 11gR2(Linux).
• DBMS configuration planning for systems physical environment, hardware capacity planning and licensing of enterprise environment.
• Know how to raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.
• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Experience in data modeling.
• Supporting databases on VMWARE based virtualized environments.
• Create database maintenance scripts.
• OEM (Grid Control) Installation, Oracle OMS and OEM agent installation and administer the database by OEM.
• Implementing Oracle security.
• Create Oracle Backup setup and scripts for RMAN.
• Microsoft SQL Server Administrator.
• Install and configure MySQL software and MYSQL Database Administration.

Confidential, Bethesda, Maryland

ENVIRONMENT: Red hat Linux 5

Oracle DBA

Responsibilities:

• Create 10g and 11g databases and migrate database from 10g to 11g by Data Pump
• Provided Production DBA support.
• Strong in Database Migration.
• Performance Tuning after Migration.
• DBMS Software Updates - Installation of DBMS software per best practices. Security Patch apply and version upgrade evaluation, planning and installation.
• Experience in utilizing Oracle Enterprise Manager for monitoring and management of database environment.
• Did the complex data modeling, mapping, integration for databases.
• DBMS configuration planning for systems physical environment, hardware capacity planning and licensing of enterprise environment.
• Configured the advanced replication between multiple Master Sites using Oracle Streams and advanced queuing.
• Know how to raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.
• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• OEM (Grid Control) Installation, Oracle OMS and OEM agent installation and administer the database by OEM.
• Implementing Oracle security.

Confidential

ENVIRONMENT: Sun Solaris 10 and HP-UX 11i v2, Linux,Windows

Senior Oracle DBA

Responsibilities:

• Installation and Configurations of Oracle 10g (ASM) on HP-UX 11i V3.
• Migration from Oracle 9.2.0.8(Windows) databases to Oracle10.2.0.3(HP UX 11iV3)
• Responsible for administration and supporting Oracle 9i and 10g databases.
• Write scripts for Oracle Database security, creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces, creation and maintenance of tables and indexes.
• Strong in Database Migration/upgrade.
• Create RAC database and setup RAC Environment in HP-UX Environment.
• Creating the standby database and DG Broker setup and switchover and failover testing.
• Extensive experience with database replication technologies (Data Guard/Standby)
• Backup setup and all the maintenance scripts setup.
• Package failover setup in Service Guide environment.
• Did the database replication by Oracle Streams and maintained it.
• Creating and rebuilding indexes and optimizing the code to improve the performance after analyzing the trace files.
• Develops database solutions by logical designing of the proposed system,defining database physical structure, functional capabilities, security, back-up, and recovery specifications.
• Applied Oracle Security patches in different server.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR,ADDM, Explain Plans and monitor the database performance on daily basis. Optimize the database by changing the parameters.
• Setup backup by RMAN in RAC environment (shadow copy) and shell scripts and recover the database by RMAN
• OEM (Grid Control) Installation, Oracle OMS and OEM agent installation and administer the databases by OEM.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.

Confidential

ENVIRONMENT: Red hat Linux 4, Solaris 8, Windows 2003.

Oracle DBA

Responsibilities:

• Installation of Oracle 9i,10G software
• Upgrade/Migration the database from 9i to 10G, Performance Tuning
• EM installation and configuration on Linux, Oracle application server Installation.
• Export and Import of the database
• Applying Oracle Security Patch.
• Experience working with TCP/IP and DNS.
• Setting up Backup Script by shell scripts and RMAN in the RAC environment
• Expertise in Oracle Enterprise Manager (OEM) in 10g.
• Created the standby database by Data Guard Broker and did the switchover and failover.
• Database Backup and Recovery in 9i and 10G.
• Write and Tune the PL/SQL code.
• Duplicate database and Standby Database Creation(10G)
• Partitioned large tables to increase the performance. Responsible for optimizing the queries and application tuning.
• Extensively involved in maintaining & updating the database.
• Maintaining the database availability and security.

Confidential

ENVIRONMENT: Red hat Linux

Oracle DBA

Responsibilities:

• Support for RAC databases
• Created and Support for Standby databases in 9i.
• Security Administration by adding or removing user, profiles, roles.
• Support SQL Server databases.
• Backup and Recovery (RMAN) and by export and import.
• Performances Monitoring by Fragmentation of free space in each tablespaces and growth rate at which free space is being consumed.
• System Failure recovery, Routine Maintenance.
• File System Maintenance
• Installing Oracle
• Applying Security Patch, Release work
• Extensively involved in maintaining & updating the database.
• Maintaining the database availability and security.