SUMMARY

• Has experience working as an Oracle/Cassandra DBA which includes experience in 10g, 11g, ASM, Data Guard and RAC combined with large database/dataset and database security.
• Involved in Oracle EBS upgrade from R12.1.3 to R12.2.2 and 11i to R12.
• Experienced with all facets of Oracle DBA day - to-day activities like production, database monitoring, Backup &Recovery (RMAN), Cloning, Troubleshooting production issues, and Physical Database Design.
• Managing oracle 12c, 11g RAC (3, 2 node) in production, Development and non-production environments.
• Proven Experience in High Availability like RAC and implemented 11g RAC 2/4 Node with ASM/Non-ASM storage.
• Involved in Database Migration from RHEL 5.7 to Oracle Unbreakable Linux Network (ULN) OEL 5.7 using RMAN.
• Well versed with SQL and PL/SQL, Strong Unix shell scripting skills for automating theDBAtasks.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Good experience in applying security patches and migration of Oracle server from 10g to 11g, 9i to 10g.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Worked with SAN, NAS for ASM disks
• Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.
• Extensively worked on Oracle 11g RAC, 10g, 9i, Sql server 2012, RAC, ASM, OEM, Grid Control, RMAN, Flash Database, Data Guard Standby Database, Database Tuning, Database Security, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility.
• Proved Experience in Maintaining Documentation and Capacity Planning.
• Strong experience in working with oracle memory tuning (ASMM, AMM).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Well versed in creating and managing of Tables, table spaces, Segments, Extents, and Data Blocks.
• Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Experienced in Database performance tuning, SQL debugging/tuning, Application server tuning, DB sizing and capacity planning.
• Secured the applications by implementing DMZ, SSL, and SSO.
• Hands on experience in complete recovery, incomplete recovery (PITR), Flashback Recovery, Disaster Recovery, recovering data files, table spaces, and control files.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and Interim patches, Patch sets as per the Oracle recommendations.
• Performed backups using conventional hot & cold backups and RMAN.
• Experienced with methodologies for service delivery such as the IT Infrastructure Library (ITIL).

TECHNICAL SKILLS

Databases: Cassandra, Oracle 12c, 11g R2 RAC, 10gR2 RAC, 9i

Operating Systems: Sun Solaris, HP-Unix, RHEL 6, Red Hat9, AIX, Linux and Windows

Languages: SQL, PL/SQL, Java, C, CQL

Tuning Tools: EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

Data Modeling: Erwin, DB Artisan, Rational Rose

Tools: DBUA, Autoconfig,, Adpatch, Adadmin, Admergepatch, Adutconf, Adrelink, RMAN, OEM, OAM, Toad, Exp/Imp,, Putty, ADI, Tkprof, ASH, RAC,RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan 4.0, Migration, ASM, Cloning,.

GUI Tools: Oracle Enterprise manager, SQL Developer, OpsCenter

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Database Admin

Responsibilities:

• Designed, document and implement new installation for Cassandra 5 Node cluster infrastructure on Linux and CentOS.
• Implemented backup solutions and database health checks.
• Working on Cassandra schema, CQL query, Cassandra command line utility and Datastax Ops Center.
• Proactively analyzing performance to identify bottlenecks.
• Handling incidents, bugs and providing solutions with root cause analysis.
• Installed, configured theOracle 11g,Oracle11iappstech stacks and R12 tech stacks
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizingoracleprocesses and increasing SGA overall.
• Performed 11i to R12 Basic upgrade process involving Rapid Install & Autopatch
• Administer Cassandra databases, i.e. install, check alert log, health check of database.
• Coordinate and suggest PM, SA and LOB DBA to allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Configured DR Data guard architecture for Oracle and Cassandra effective fast starts of the fail overs.
• Performed extensive support to the AD admin, auto patching and patch merge processes for all the modules inOracle.
• Bi-directional replication and Uni-directional replication in DATASTAX Cassandra.
• Perform Daily Monitoring ofOracleinstances usingOracleEnterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Create multiple 11g databases on RHEL5 in development.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL, Solaris and Windows 2003.
• Used scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache server configuration.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Rebuilding of Indexes for better performance ofOracledatabase.
• Upgraded Oracle database using DBUA or Data Pump Export/Import.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Written Shell scripting which monitors the server's performance and logs output on periodic basis to database using Perl Scripting.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Experience in using flashback feature oforaclethroughout the project.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT) .
• Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Zero Downtime Migration to Oracle Exadata with Oracle Dataguard and Oracle GoldenGate.
• Experienced with Operations support within an ITIL Service Operations management framework, including use of Service Now or Remedy service management tools.
• Worked on multiple storage devices (ZFS, Exadata).

Environment: Oracle11gR2/10g, RHEL, RAC, RMAN, PL/SQL, SQL*Loader, Toad for Oracle, Golden Gate, OEM, SQL Loader, Cassandra DB, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential

Oracle DBA

Responsibilities:

• Upgrade ofOracleApplications EBS from R12.1.3 to R12.2.2.
• Upgraded Grid Infrastructure(RAC) on Standalone server from 11.2.0.4 to 12.1.0.2.
• Prepared Proof of Concept (PoC) for upgradingOracleEBS from 11i to R12.2.2.
• Installed and Configured Fusion Middleware, Discoverer, SOA, PO, GL Wand, BPM, OBIEE, APCC, SSO, OIM, Access Manager, Payables and Procurement, Workflow work and OID.
• Upgraded JRE from 1.6 to 1.8 on instance level and deployed JRE 1.8 for Windows Clients in Oracle E-Business Suite Release 12
• Setting up the Environments with Oracle Apps Fusion & IBM WebSphere components in both Windows and LINUX/UNIX environments.
• Installation, configuring and maintainingOracle11g databases on ASM.
• Preparing document for Cross Platform migrations from Oracle 9i, 10g to 11g.
• Cloning ofOracleApplications 11i with RAC and ASM.
• Working on the Platform migration and building the environments in sync with the current environments with Oracle Apps Fusion components including Oracle WebLogic, SOA, Oracle HTTP Server, Life ray portal, Webcenter Content, capture servers. And OneGate product.
• To tune and configureOracle11g database for optimum performance.
• Upgraded and Migrated Databases from 11g to 12c and applying patches as needed.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM.
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server.
• Worked closely with developers helping them identify and fix issues. (Eg: User login issues, concurrent managers, OID authentication, and vertex connectivity).
• Responsible for identifying gaps with and automating end-to-end Production to non-Production Refresh process.
• Worked on SAN / RAID configuration.
• Installation, configuration, upgrade and maintenance of Oracle databases of Oracle 10g & 11g on RHEL.
• Involved in database Export/Import and performing backups using RMAN.
• Working with Networked Attached Storage (NAS) & Tivoli Storage Management (TSM).
• Involved in the Analyzing and monitoring the system performance and tune accordingly.
• Worked actively in planning for storage space requirements and placing them for optimum I/O performance.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Worked intensively on database migrations.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Created Users, Roles, Privileges, Profiles and managing security.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*Net connectivity.
• Experiences with OID servers.
• Worked as a SME for Oracle RAC/OEM

Environment: s: Oracle 11g/10g/9i, Oracle Applications 11i, R12.1.3, R12.2.4 RAC, RMAN, Import/Export, Data Guard, ASM, Performance tuning, Patchset, Upgrade, Migration, SQL, PL/SQL, SQL*PLUS, Korn Shell, Perl Scripting, Sun Solaris and Linux.

Confidential

Oracle Applications DBA

Responsibilities:

• I was responsible for the support and maintenance of the company's financial and student databases.
• Involved in the upgrade of the11.5.5 applications instance to 11.5.8 and the database from 8i to 9.2.0.4 onto RAC nodes.
• Administered and maintained production, development, QA, test and patch instances of the Oracle production databases on a round-the-clock basis.
• Configured the workflow notification mailer.
• Installed and managed the daily business intelligence DBI 6.0.
• Reviewed, explored and applied the Oracle applications patches when the business requirements demanded.
• Worked on OLTP and OLAP database systems.
• Cloned the Oracle applications production system for development purposes, using RAPID clone.
• Developed and implemented the Disaster Recovery (DR) strategy for Oracle E-Business Suites.
• Developed and implemented backup and recovery strategies.
• Checked alert logs and troubleshoot and resolved the database issues, adding data files, resizing data files and analyzing tables, recovering and renamed the databases to create and sink the development data with production data in RAC environments.
• Installed Oracle RAC 9i on Linux Platforms.
• Interacted with the Oracle customer support and logged iTAR when required.
• Patched security vulnerabilities when released by Oracle support.

Environment: Red Hat Linux, HP-Unix, Oracle Applications 11.5.8/11.5.9 , (Financials & CRM Modules), Oracle 9i, Oracle Forms 6i, OAM, License Manager, STATSPACK, Rapid wiz, Rapid Clone, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, SQLplus, OEM, EMC Storage)

Confidential

Intern DBA

Responsibilities:

• Installed, created and maintained new oracle 9i and 8i instances.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times.
• Connectivity with different client programs using ODBC.
• Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage Confidential process level, file growth, user login, and user's setup.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle file structures.
• Involvement in all phases of the project life cycle.
• Developed and modified PL/SQL code to make new enhancements or resolve problems as per customer requirements.
• Involved in optimizing SQL statements using indexes and hints.
• Setting up configuration parameter of MySQL Database (my.inf).
• Frequent analysis of objects or schemas to improve the speed of the database.
• Analyze SQL statements using Explain plan.

Environment: Oracle 10g, 9i RHEL, UNIX Shell Scripts, TOAD, PL/SQL Developer, SQL Server 2000