SUMMARY:

• 8+ years of experience in Database Administration with Oracle, Exadata, Goldengate, Mongodb, SQL Server. Seeking an opportunity to offer my skills and experiences in the field of Information Technology where my analytical and technical skills will contribute to the overall goal of the organization.
• Extensive knowledge on installation and administration of Oracle 12c/11g/10g/9i RAC, ASM, Filesystem with experience in very large - scale database environments and mission critical systems.
• Working knowledge on Oracle Enterprise Manager 12c.
• Installed and configured Enterprise Manager 12c, deployed agents on target servers for monitoring databases and performance tuning activities.
• Configuring Oracle Automatic Storage Management.
• Involved in migrating databases from Filesystem to ASM.
• Experience in administration of Oracle Real Application Cluster (RAC) with ASM, and manage RAC instances using CRSCTL and SRVCTL utilities.
• Upgraded Grid and Oracle Infrastructure on multi-node RAC cluster from 11.2.0.3 to 11.2.0.4.
• Installed and configured Container and Non-Container 12c databases for new application builds.
• Implemented and configured replication technology using Dataguard & Oracle GoldenGate.
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using GoldenGate.
• Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with Zero downtime.
• Experience in setting up physical standby database to implement disaster recovery and performed annual DR exercises.
• Extensively used BMC Remedy and Service Now Ticketing systems for monitoring.
• Performance tuning of the database - SQL Tuning, Partitioning, parallelism, Used Tuning utilities like STATSPACK, AWR, ADDM, Database Replay and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAINPLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in a variety of hardware and software platforms including UNIX/Linux, Sun Solaris, HP-UX, IBM AIX and Windows.
• Data transferring and Refreshing with export/import utilities, Data Pump (including Network links and DB links) and data loading using SQL*Loader and External tables.
• Backup, Recovery and Cloning of databases using RMAN. Table recovery using RMAN a new feature of 12c
• Proficient in setting up and troubleshooting network connections (i.e. setting up Listener and TCP/IP Connections).
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various UNIX Shell Scripting for managing the user's roles and privileges, scheduled backups, manage statistics, Disk space management.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Good co-ordination and communication with system administrators, Business, Data Analysts and development teams.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

TECHNICAL SKILLS:

• Oracle Database 9i
• 10g
• 11g
• 12c
• RAC
• Exadata
• ASM
• Dataguard
• Performance Tuning
• Goldengate
• OEM
• Mongodb
• SQL Server
• Datapump
• Cloning
• Database backup & recovery
• DR setup and test LINUX
• IBM AIX
• Solaris
• Windows
• Putty
• VNC Server
• SQL Developer
• Shell Scripting
• CRON
• PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Peapack, NJ

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Database 12c, Oracle 11gR2 using DBCA and manual installation process with RAC and stand-alone features.
• Supported Oracle 12c databases on Exadata X5-2 Server.
• Involved in mongodb installation and administration as per client’s requirement and support mongodb CRUD operations, backup, restore and support.
• Created data model and imported data using mongo import.
• Good knowledge on mongo dump and mongo restore operations.
• Involved in creating replica set for mongo databases.
• Deployed 12c agents on the target servers and add the target Configuration Items to monitor.
• Configured agents to monitor target databases, servers from OEM 12c and OEM 13c.
• Involved in setting incident rules to monitor targets as per business requirements using OEM 12c and OEM 13c.
• Experience in analyzing server and database performance from OEM.
• Configure Oracle Advanced Security to implement Transparent Data Encryption at tablespace, table and column levels.
• Worked with oracle support, applied Security patches to Exadata Servers.
• Expertise working with ASM in RAC environment and Monitoring Health checks OCR, voting files and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2 and 12c)
• Setup physical standby’s (DATAGUARD) for several Databases on versions Oracle 11g,12c including Container and Non-Container databases.
• Involved in migration from RHEL 6.5 to Oracle Supercluster Solaris 11 on ASM.
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status.
• Hands on experience in cloning the non-multitenant container database (Non-CDB's) to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Experience working with SQL Tuning Advisor, SQL Profiles in fixing problematic SQLs with better plan.
• Experience in scheduling tasks using DBMS scheduler to automate jobs.
• Experience in analyzing AWR/Statspack reports and suggest Application teams to improve database performance.
• Involved in annual disaster recovery exercises in co-ordination with application team.
• Upgrade existing 10g/11g databases to 12C on LINUX/Solaris machines using transportable tablespace and datapump method.
• Performed in point-in-time database restore from tapes as per business requirements.
• Involved in restoring databases from Tapes as per application team’s requirement.
• Performed Oracle 9i database migrations from Windows Operating System to LINUX on Oracle database 11.2.0.4.
• Created ACFS Filesystem to install Oracle Goldengate on clustered environment with High Availability.
• Expertise in troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Configured Goldengate for Unidirectional and bidirectional replication.
• Configured extract and replicat pumps for Goldengate replication 11g/12c and troubleshooting issues in Goldengate Environment.
• Create, Track work with tickets (Change Requests, Work Orders and incidents) generated from HP Service Center Tool.
• In-depth knowledge on Change Management process to be followed when implementing production changes.
• Execute changes to database based on approved/preapproved change requests.
• Installed and configured Oracle Enterprise Manager 12c, deployed agents on target servers for database monitoring.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.
• Applied quarterly CPU and PSU patches using OPatch utility.
• Performed patching on Oracle 11.2.0.4 for SGA related memory issues working with Oracle Support.
• Experience in working on ORA-00600 with Oracle Support service requests.
• Expertise in setting up database auditing as per application team’s requirement.
• Performed adhoc deployment requests from application teams following the business approval process.
• Involved in setting up cron jobs to automate database tasks.
• Created VDBs in Delphix as per Application Team’s requirement.
• Involved in improving database performance. Analyzed statspack and AWR reports to make suggestions to application teams as per the analysis.
• Experience in retiring the databases post migration to new and higher versions/environments.
• Involved in Global Command Center calls in bringing the databases back online during unplanned outages.

Environment:: Oracle 12c/11g/10g on Unix/Windows, Exadata, Supercluster, OEM 12c, RAC, Dataguard including DG Broker setup, RMAN, Performance tuning, OPatch, and TOAD for oracle 11.5.

Confidential, Coppell, TX

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Database11g, 12c.
• Installed and configured Oracle Enterprise Manager 12c.
• Plug-in installations on the target servers to extend the functionality of OEM
• Configure Oracle Advanced Security to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Setup physical standby’s (DATAGUARD) for several Databases.
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPatch.
• Performed Cross Platform Migration using Oracle Goldengate to migrate database from IBM-AIX 6.1 to OEL 6.1.
• Performed Zero down time migration from AIX to RHEL using Expdp and Goldengate.
• Configured extract and replicat pumps for Goldengate replication 11g/12c and troubleshooting issues in Goldengate Environment.
• User management, Tablespace management, file system space management, backup management.
• Create, Track and work and tickets (Change Requests, Work Orders and incidents) generated from Remedy on Demand (RoD) Tool.
• Execute changes to database based on preapproved change requests.
• Installed and configured Oracle Enterprise Manager 12c, deployed agents on target servers for database monitoring.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.
• Migrated data from SQL SERVER databases to Oracle databases.

Environment:: Oracle 12c/11g/10g on Unix/Windows, OEL 5.8, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations.

Confidential

Assistant Manager IT-SMG

Responsibilities:

• Worked in 24x7 environment to support credit card related applications.
• Installed and configured Oracle 11g mission critical databases.
• Performed migrations from IBM DB2 to Oracle using sql developer.
• Experience in IBM DB2 LUW administration.
• Performed migration of database from 10g to 11g in development, testing, and in production environment.
• Configured 2 node RAC for Production environment.
• Configured Oracle Dataguard from RAC to Non RAC environment.
• Configured Oracle Enterprise Manager Cloud control 12c for database monitoring.
• Monitored log shipping and resolved gaps in log shipping from primary to standby database in dataguard environment.
• Done migration from non ASM to ASM environment.
• Had a good experience in migrating data using Exp, Imp, Expdp, Impdp.
• Implemented Dataguard physical standby database in 11g for disaster recovery.
• Created range partition for reporting tables as per application team’s requirement.
• Performed RMAN Incremental and Cumulative backups and also developed backup strategies.
• Performed logical backups using both classic and Data Pump methods.
• Performed Patching on Oracle databases using Opatch utility.
• Worked on creation of users, granting privileges to users and also table space management.
• Performed daily monitoring of Oracle databases from Oracle Enterprise Manager and alert log files.
• Installed Oracle Client to access oracle database.
• Performed performance tuning of database by using AWR, SQLT, and EXPLAINPLAN.
• Maintained database security using security compliance auditing and profile management, password complexity in order to control access to database.

Environment: Oracle 10g, 11g, RAC, Data Guard, TOAD, ASM, Resource Manager, Oracle Cloud Control.

Confidential

Oracle DBA

Responsibilities:

• Worked in 24x7 multi-client (entertainment, financial, ecommerce, manufacturing, academic) support environment.
• Installed and Configured 2node RAC on Linux.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Involved in Oracle Grid Control 11g Installation and Configuration.
• Supported Banner applications for academic clients.
• Involved in implementing Disaster Recovery using Dataguard and High Availability using 11gRAC.
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Installation/administration Oracle WebLogic, Oracle Access Manager, and Oracle Internet Directory.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing.
• Supported Oracle EBS 11i, R12 environments.
• Patched EBS instances using adpatch, worked on concurrent manager issues, printer setup in EBS
• Loading data into database tables using SQL *Loader.
• Working Knowledge of installation and configuration of GOLDENGATE in LINUX environment.
• Done Installation and configuration of golden gate on 11g database for the replication.
• Resolving the conflicts between the target and source database extracts and replicats.
• Configuring parameters for DDL support in golden gate replication.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Worked in 24X7 support environment. Experience in using BMC Remedy ticketing tool.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, Oracle Goldengate.

Confidential

Jr. Oracle DBA

Responsibilities:

• Managed and monitored the Oracle Real Application Cluster (2 node RAC)
• Supporting more than 125 production, development, and test databases.
• Performed logical database backups using Oracle Datapump.
• Migrated databases from 10g to 11g using transportable tablespace and data pump.
• Created profiles, users, roles and assigned privileges as per the requirement.
• Involved in migration of databases from standalone (ASM) to cluster Environment.
• Using Automatic Shared Memory Management (ASMM) for optimal use of available SGA memory.
• Configured Recovery Catalog for RMAN backup.
• Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.
• Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.
• Performed Tuning, coding and Monitoring for Oracle Real Application clusters (RAC) nodes, Production Standalone Servers via Toad.
• Tuning SQL statements using Explain Plan and STATSPACK.
• Modified SQL*Loader control scripts for example to eliminate spaces generally used for data loading.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Quest Performance Analysis, Quest Space Management tool, Toad, PL/SQL Developer, OEM, Windows NT/XP.