SUMMARY:

• 12+ years of experience as Oracle Database Administrator in various domains such as Aviation, Retail, Telephony, Finance.
• Experienced in using different versions of Oracle 9i & 10g, 11g, 12c Database.
• Managing and creating oracle database, Oracle Storage Structures.
• Installation of servers and clients.
• Creating and administrating database objects like table, views, indexes etc.
• Expertise in user account management like creating users, disabling users, responsibility management.
• Performing Export & Import operations.
• Skilled in maintaining several Database instances running on Windows & UNIX environments.
• Hands on Knowledge in NoSQL Databases (Mongo DB and Casandra).
• Proficient use of advanced replication using Oracle Streams and experience in using utilities like TOAD, SQL Developer, SQL*Plus, SQL*Loader, data Migrations using export/import as well as traditional UNIX command that requires for Oracle DBA.
• Extensive experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Experienced in day - to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Proficient in Oracle Enterprise Manager, grid agent installation, OSM patching, alert notifications, job scheduling, adding and monitoring targets by grid.
• Sound Knowledge in Backup and Recovery procedure which includes documenting the process.
• Highly accomplished in Performance Tuning.
• Skilled with Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
• Hands on experience in Recovery Manager (RMAN).
• Exposure to RAC Implementation, ASM, clusters event issues.
• Good knowledge and experience in SOA maintenance, ESB, BPEL service check, Queuing de-queuing in SOA DB.
• Experience in Security infrastructure including Oracle Virtual Directory.
• Experience in installing and configuring Golden Gate 11g/12c and using replication procedures to support data replication in the Oracle database environment.
• Experience in building Standby databases; Implementing FSFO (Fast start failover) on 11G databases and configuring disaster recovery site using Data guard.
• Modeling and designing Data, OLAP, Logical and Physical Database Design of tables, tablespaces, Users, roles, privileges, creating storage structures or using ASM and Performance Tuning. Experienced in IBM Optim archival solutions.
• Sound Knowledge in performing production support activities, involving in P1, P2 on-call bridges.
• A proactive team player, quick learner, Self-motivated, hardworking professional with good organizational, leadership, project co-ordination, interpersonal, excellent analytical, problem solving and troubleshooting skills with result-oriented attitude towards work.

TECHNICAL SKILLS:

Database: Oracle No SQL Databases (Cassandra, Mongo Db)

OS: Linux 4.0, Windows 2000 Advanced Server, UNIX

Oracle Tools: Oracle Enterprise Manager (OEM), Oracle Database Configuration Assistant (DBCA), Oracle NET 8 Configuration Assistant, RMAN, SQL*Plus, SQL*Loader, Export/Import, Golden gate

Design Methodologies: Waterfall, Agile

Ticketing Tool: Jira, Remedy, Service Now

Version Tools: Git, SVN, CVS, VSS(Visual Source Safe)

WORK EXPERIENCE:

Confidential, Malvern, PA

Senior Oracle DBA and Mongo DBA

Responsibilities:

• Supporting 100+ databases ranging in size between 30 GB to 50Tb. Plan and Implement Disaster Recovery (DR) and High Availability using RAC and Data Guard.
• Installed and configured RAC (2 node) and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.
• Installation of MongoDB Database on Windows and Linux Machines, manage and maintain MongoDB servers across multiple environments.
• Update Spatial Oracle 10 g databases on Windows 2003 servers to Oracle 11 g on both Windows 2008R2 servers to Linux servers.
• Highly experienced in Oracle12c, 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs and Spatial Database.
• Implement mongo dB master-slave replication across multiple data centers. Setting up mongo dB database and hardware alerts using Nagios.
• Expertise in handling team of 15 DBAs, ticket allocation, ticket report creation and chart presentation on behalf of DBA team.
• Work on golden gate replication.
• Proactively monitoring OEM Grid peak loads, notification alert, failed jobs, configuring new jobs in OEM.
• Performed health checks in RAC instances using Crsctl and Srvctl utility.
• Perform Database refresh from Production RAC environment to TEST RAC environment.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
• Database development and warehousing with SQL Server 2012 and MySQL 5.6.
• Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.
• Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
• Install Golden Gate for replication of database on 11gR2 RAC environment.
• Create JSON files for implementing and populating the data in to HUB tables.
• Work with operations and deployed the required scripts and JSON files.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Perform various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Implement physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
• Generate and automate Stats pack/AWR reports from Oracle 11g/10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Use Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.
• Hands on experience in Involved in release Documentation.
• Active partition in daily status scrums, Bi-weekly client meetings.
• Mentor for L1 team members, arranging various knowledge sharing sessions.

Environment: Oracle 11gR1, 11gR2,11.2.0.3,12c RHEL 5.8, HP-Unix 7, Solaris 10, DBUA, Mongo DB, Splunk, Nagios, RMAN, ATG, Oracle Enterprise Manager Grid Control, RAC, ASM, Shareplex, Golden Gate, Data guard, SQL*LOADER, AWR, ADDM, ASH, VPD, Oracle Wallet, Data pumps, Exports/Imports, OBIEE, SOA, SQL developer, TOAD, putty

Confidential, Conshohocken, PA

Senior Oracle Database Administrator

Responsibilities:

• Involved in the complete Database Support for 8 applications like SIEBEL CRM, Sabre, OBIEE, SOA.
• Provide end to end support in OBIEE db issues while installation and upgrade.
• Analyze application flaws checking for CPU waits, server parameter issues, SGA related issues long running SIEBEL queries.
• Extensively involved in Backup and Recovery, RMAN configurations, deciding backup strategy, working on failed backup jobs.
• Work on multiple user stories in Agile methodology like new script generations and implementation, report generation, health check routine automation.
• Skilled in setting new standby environment, Standby synchronization with production databases.
• Worked with technical and non-technical teams across Amazon (AWS).
• Used Opscenter to monitor prod, dev, test, and fst Cassandra clusters.
• Set Cassandra backups using snapshot backups.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Responsible for data base migration between data centers through data pump or replication and upgrade of database versions.
• Strong experience in SQL & Database Level performance tuning skills.
• Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
• Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
• Configured Unidirectional and bi-directional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
• Experience in Oracle Golden Gate with very large Data bases.
• Experience in data filtering using Oracle Golden Gate.
• Implemented conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
• Involved in the installation of 11 g RAC on LINUX environment.
• Installation, configuration and monitoring of MongoDB.
• Performed upgrade of oracle database from Oracle 10g to 11g and 11g to 12c with Oracle Database Upgrade Assistant (DBUA) in development, test and production environment.
• Experience in backup and recovery and migration using RMAN, datapump and export/import.
• Experience in handling out of sync data issues with Oracle Golden Gate.
• Experience in performance tuning for Oracle Golden Gate Extract and Replicates.
• Experience in migrating Databases along with Golden Gate from HP UX to Sun Solaris.
• Experience in Oracle Golden Gate Veridata 12c, and with Transportable Table spaces.
• Created table spaces, tables, users for custom applications. Worked on Table Partitioning.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Worked on Real Application Testing (RAT).
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance.
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Implemented Data Guard for Disaster recovery system using Oracle 11g.
• Created and managed users, roles, privileges, profiles.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.
• Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Experience ensuring the high availability and integrity of databases.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Wrote PL/SQL Procedures, functions, packages for various requirements in the database.
• Active support in SSFP release in AA.
• Efficiently work on JIRA tickets raised by application teams.
• Active partition in daily status scrums, Bi-weekly client meetings.
• Mentor for L1 team members and arrange various knowledge sharing sessions.

Environment: ORACLE 11g/12c/13c, OEM 12c, Golden Gate, Linux, Solaris, JIRA, Mongo DB, SIEBEL CRM, OBIEE, SOA, SQL developer, TOAD, putty

Confidential, Folcroft, PA

Oracle DBA

Responsibilities:

• Proactively working on Production Support activities.
• War room support specialist in Black Friday, Thanks giving, cyber Monday.
• Expertise in handling team of 15 DBAs, ticket allocation, ticket report creation and chart presentation on behalf of DBA team.
• Attending L3 meetings and discussion on new database RFPS like upgrades, service creation.
• 24*7 On call support for P1, P2 issues, attending bridges, providing timely updates on P1 issues.
• Supporting application teams in respective CRs.
• SME for Optim Archival solution from IBM, creating optim job script, scheduling and deciding archival and purging strategy. On call support in Optim issues.
• Administered, maintained, monitored and configured Oracle databases for several clients in a 24X7 support environment for multiple Oracle RAC and stand alone databases of size varying from 300GB to 2TB and MS SQL Server databases.
• Configured and maintained Standby Database in Remote Location for Disaster Recovery using Data Guard.
• Implementation, configuration and management of backups using RMAN, Datapump and Veritas netbackup utility and user managed backups. Backup/Restoration, scheduling Backups and taking Logical Backups.
• Conducted sizing and capacity planning for databases. Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Managed and monitored DR and standby databases by EOM and various applications. Monitored database performance during peak and non-peak loads.
• Refreshed and cloned databases on regular basis in multi technology environment and performed DB upgrade / migrate on various and cross platform.
• Responsible for setting up standards for database maintenance and monitoring.
• Responsible for Report generation, monitoring disk usage, keeping systems healthy and routine checks for the production environment. Worked on database administration an shell scripting in UNIX platform
• Created shell scripts on UNIX platform to automate database backups, alerts and operations.
• Coordinated with Unix Administrators for space management on various servers and help in Oracle.
• Created users, tables with appropriate table space, Indexing and database links.
• Automated processes, scheduling jobs per user requirements using DBMS JOB.
• Used OLTP class of program by managing transaction oriented application for data entry and retrieval transaction.
• Tuned the Databases for optimization using STATSPACK and EXPLAIN PLANS, Estimating Table & Index Size.
• Monitored and optimized the performance of the database to ensure that database resource such as table spaces, memory configuration, sessions, archive files, etc., are in their proper status.
• Scheduled jobs through Oracle Job Scheduler.
• Created/Altered/Modified database objects. Configured and managed users, security.
• Responsible to troubleshoot both Oracle applications and backend data base errors.
• Extensively used metalink for resolving technical issues, opening SR and use collaborative support for database related issues.
• Kernel parameter changes support, OS watcher enabling disabling.
• Skilled in handling ASM issues, SAN issues, disk failures.
• Exposed to various Oracle applications Oracle Retek, Oracle Ego handling Database and application issues.
• Experience in backups and recovery such as checking failed jobs, scheduling/updating backup jobs, deciding backup strategy for new database, maintaining cold backup details.
• Experience with handling MY SQL database issues.
• Handled large databases sized 250G-15T.
• Active participation in cluster issues, service load balancing issues. Proactively working on creation of new standby environment.
• Monitoring long running sessions, locks, hanging sessions. Performance tuning expertise.
• Analyzing index, gather table statistics.
• Maintaining and suggesting partition details. Working on lower environment refreshes.
• Maestro job scheduler job creation and support. xposed to service now tool.

Environment: Oracle 10g/11g/12c/13c, OEM 11g/12c, Oracle Retek, Oracle Ego, HPOV, Netapp, Maestro scheduler, IBM Optim, Protegirty, Service Now, TOAD, SQL Developer, Win SCP, putty

Confidential, Philadelphia, PA

Database Specialist

Responsibilities:

• Active involvement in OSM installation and configuration, handling DB issues, access controls while OSM upgrade.
• Support in day to day application maintenance in production and lower environments like tracing session, generate/analyze tkprof, long running sessions monitoring.
• Perform multiple Export/Import.
• Release support like new SOA(CHOIS) services launch, configuration/issues checking in access logs and error logs in SOA database.
• KAS-FUTUR billing application production and lower database support involves checking out hanging transactions in MQ/DB, working in database CRs.
• Generating and analyzing AWR report.
• Automation of backup scripts, scheduling cron jobs.
• SIEBEL DB support understanding queries and suggesting performance improvement solutions.
• Gather statistics on schema/ tables, rebuild indexes.
• Analysis on OSM database and implementation of partitioning tables, maintaining partitioned tables.
• Successful OEM 10g installation, OEM PSU release.
• Working on ERD and Data modeler for new DB objects getting launched in service, extensive use of MS-Visio.
• Handling privacy and user access control on all database environments.
• Automation of jobs like creating on demand shell scripts, ASM disk space usage, archive space usage, server cleanup utility.
• Daily ETL jobs status check and database error resolve.
• Extensive use of Remedy.
• Establishing relationships among them, defining mechanisms for managing different application's databases, working on changes that are imposed, auditing and reporting on the changes that are made.

Environment: Oracle 9i/10g, OEM 10g, OSM, SIEBEL CRM, SOA, Netapp, Remedy, TOAD, SQL Developer, Win SCP, putty, Windows Server

Confidential, Topton, PA

Database Administrator

Responsibilities:

• Production support activities such as handling L2 tasks executing changes on production and lower environments.
• Handling Oracle database installation, patching on lower environments.
• Perform Export/Import.
• User creation and maintenance, access control, security clearance.
• Database monitoring for performance issues.
• Responsible for SIT and UAT database issues.
• Data retrieving, querying, storage and manipulation and also performed Unit test on Cashplus product.
• Monitoring & Managing the Tablespaces and datafiles growth.
• Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
• Regular checking of Alert log file.
• Responsible for taking full cold database backup.
• Data upload using SQL* loader oracle utility.
• Providing support for the smooth functioning of the Database to developers.
• Maintaining CVS updates as per each releases specific to banks.
• Schema creation and maintenance on lower environment as per product enhancements.
• JP1 job scheduler job creation and updating.
• Active participation in production support weekly meetings.
• Working on multiple JIRA issues.

Environment: Oracle 9i/10g, OEM 10g, OSM, SIEBEL CRM, SOA, Jira, TOAD, SQL Developer, Win SCP, putty, Windows Server