CAREER OBJECTIVE:

To obtain a challenging position in a high quality fast paced engineering environment where my resourceful experience and academic skills will add value to organizational operations as well as boost business growth.

SUMMARY:

• An Oracle Professional over 8 years of experience as an Oracle DBA as well as an IT specialist.
• I have Worked extensively on Oracle 12C, 11g and 10g versions involving database administration, production support, on call support, installation, configuration, upgrades, patches, migration, backup (RMAN) and recovery, performance tuning, GoldenGate monitoring as well as configuration, cloning, ASM for storage management space management and security & risk, management, RAC and Dataguard installation/configuration and monitoring for High Availability as well as disaster recovery.
• Extensive knowledge on enterprise wide Disaster recovery drill planning, scheduling as well as implementing it seamlessly. High level self confidence in what I do and always open to technical criticism.
• Full responsibility and expertise in database administration (DBA), performance tuning, database backup & recovery, security & risk management, optimization, data migration, replication & integration of Oracle instances and SQL - server databases using Datapump & Oracle GoldenGate
• Successfully developed and implemented Client/Server applications on multiple platforms in multi-terabyte databases. Actively involved in software development planning, implementation, maintenance, support, troubleshooting, documentation and training (complete SDLC).
• Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure and fully confident in the work I do and always open to different views & opinions.
• Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production implementation/support activities.
• Authoritative in design, development, documentation and review according to standards wi.
• Excellent team player and works independently. Actively participates in team meetings and maintains good relations with everyone on the team and other teams.
• Backup and recovery (using OS scripts, RMAN and Log Miner)
• Database level performance tuning (using OEM, statspack, tkprof and trace analyzer. Good in analyzing, troubleshooting and proactively fix red flags before they become a bottleneck to performance )
• Use ASM for operation and performance optimization and storage management simplification.
• Oracle Server installation and patching
• Database creation, patching and migration of multi-terabyte databases.
• SQL*Net configuration (over TCP/IP)
• Hands on experience in PL/SQL and SQL
• Replication (snapshots/materialized views) using goldengate.
• Usage of (Global Data Services) GDS for scalability and high availability for application workloads running on replicated databases
• Bulk loads and data migrations/replication (using SQL*Loader/ GG/data pump import/export) over
• Unix shell scripting (Korn shell) and Windows command prompt (.bat & .cmd)

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12C

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, Service Manager, DB Configuration Assistant) Toad, OEM 12c Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, ASH, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, Erwin, QDesigner, Remedy, Oracle GoldenGate (OGG), Putty, Oracle Client 11g, Fidelity Replication. Delphix for virtualization, SharePoint, Apex, Jira

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP - UX), LINUX OEL 6

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2/EXADATA - X86 / Linux & Windows - standalone & Virtual AS/400 midrange- Risc/Unix - Standalone & Virtual

PROFESSIONAL EXPERIENCE:

Confidential, Merrimack, NH

Oracle Application Database Administrator

Responsibilities:

• App DBA supporting both transactional databases(OLTP) and Asset Management Data Warehouse operation data store(ODS) databases ranging from 10 TB to 50TB, supporting over 70 production databases (RAC multiple nodes) and more than 200 non prod oracle databases ranging from single instances to multiple instance databases.
• Attend weekly Change Advisory Board meetings with all stakeholders to review changes from Developers and get a clear understanding of the changes that I will supporting and also to get the necessary approvals before the changes can go into production.
• Provide DBA support for any prod problems/issues and also provide On call support (Primary & secondary) on a weekly rotation basis (8:30am - 8:30pm - Monday through Sunday and handover to Offshore DBA). Acknowledge page reception and quick escalation for critical issues (4H and above). Get root cause after fix is implemented and make sure the issue doesn’t re-occur.
• Supported Fidelity Data Query Services (FDQS) which was fidelity Software as a service (SaaS) offering.
• Check daily DBMS health check reports and periodic audit check logs to see if there are any issues and address them before they become major issues to the health and security of the database.
• Proactive monitor GoldenGate extract and replicats to fix any issues (Abends or Lags) and try to suppress alerts which are noise.
• Supported information/data security through the use of Transparent Data Encryption (TDE) and Virtual Private database (VPD) Information barrier technology.
• Provide support for Adhoc service requests for development work (JIRA) and work on Incident Management tickets and Change Management tickets opened through Service Manager/Service Now ticketing system and also via email/sametime/phone.
• Experience in scheduling weekly installs via ApplyIM tool and performing manual installs via command line interface. I also possess great experience in job scheduling via Autosys and Cron.
• Plan and communicate database outages in advance and send out advisories to end users regarding planned downtime in cases like Upgrades, Patching and config changes which can’t be done with database being online.
• Worked on Multitenant Databases (Oracle 12c CDB’s & PDB’s ) and on Delphix VDB’s
• Provide daily DBA support to engineering teams as well as life cycle projects and actively participate in code reviews of SQL’s and PL/SQL’s and
• Trouble shoot batch cycle issues and SLA delays as well as Materialized views, GoldenGate and advanced replication issues.
• Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc… Actively engage in database design, infrastructure review (Capacity, Throughput, DR and HA (Dataguard & Real Application Clusters -RAC)
• Hands on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple table spaces from logical and physical data model
• Supported Shared Technology Services (STS), Fixed income (FI) and Pyramis Global advisor (PGA) within Asset Management Group in Fidelity.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Experience on standardizing, consolidation and creation of core roles (1 read & 1 write with exception of 1 business role and 1 Tech role) to simplify role requests process and make role requests from developers to go through risk.
• Daily review of AWR reports and proactively review performance bottleneck SQL’s and engage/advice engineering team to fix their code either with bind variables or to avoid certain join operations.

Tools: Used: Toad, Putty, OEM 12C, AWR/ASH/XPLAN, APEX, ARROW, JIRA, GoldenGate, GGMonitor, Autosys, Cron.

Confidential, Wilmington, DE

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).
• Monitored Real Application Cluster (RAC) databases for high availability, scalability, manageability and load balancing with the use of TAF on both 2 and 3 nodes RAC databases
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Analyzed SQL queries causing performance problems and tuned them to improve performance up to 40%.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g expdp/impdp data pump.
• Analyzing schema of databases created to collect statistics using the DBMS STATS package.
• Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.
• Troubleshoot installation errors both independently and with Oracle support (via My oracle Support)
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), SQL*Plus, as well as pre-developed UNIX shell scripts.

Tools: Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, RMAN, DATAPUMP

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Supported the Implementation of Standby Databases on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 10.2.0.3, 10.2.0.4. Security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and Perl based utility “Opatch”.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Performed space management, capacity planning, disaster recovery and overall database maintenance.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, North Canton, OH

Oracle Junior DBA

Responsibilities:

• Configure. Implement & Deploy Oracle 9i (9.2.0.8) & Oracle 10g (10.2.0.4), single instances on SunOS 5.9 using files systems for storage & VERITAS Clustering for high availability using IBM’s HACMP
• Create oracle databases (single instance) on configured servers using both the DBCA & Database creation scripts.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

Tools: Used: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN