SUMMARY

• Certified DBA with more TEMPthan 10 years of experience as an Oracle Database Administrator on various Operating Systems viz. Sun Solaris, Linux/Unix, AIX and Windows server
• Driving high - availability, secure and robust 24x7 production environments
• Experience in Oracle 12c/11g/10g/9i database administration, implementation, troubleshooting and tuning
• Setup, configuration and installation of teh single instance/RAC environment and ASM in VCFS, SRDF and VM environments
• Upgrade experience of Oracle databases from 10g to 11g and 12c (PDB and non-Container)
• Setup of OEM Grid Control, 12c and 13c Cloud Control for existing databases
• Migration experience across platforms and upgrades from single instance databases to RAC environment
• Configured and maintained Physical Standby Databases for teh Production databases using DataGuard
• In-depth expertise in all facets of Database Design, Application Tuning, Backups and Recovery, Security Management, Disk Space, File System Management and Monitoring
• Strong experience with supporting Data Warehousing as well as OLTP environments
• Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup & Recovery using RMAN, Trouble shooting production issues, Performance Tuning, Extensive SQL and PL/SQL troubleshooting
• Managing Database Structure, Storage Allocation, table partitioning, Building objects Table/Index segments, Views, Rollback/undo segments, Constraints, Triggers, Database Access and Security
• Experienced in using SQLT, Explain Plan, TKPROF, STATSPACK, Auto Trace, SQL Trace, Advisors, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve instance/database performance.
• Worked with Advisories such as SQL tuning advisor, Access advisor, Undo advisor, Memory advisor, MTTR Advisor, Segment advisor and ADDM
• Experienced in administering, monitoring and tuning Databases using TOAD, OEM Grid/Cloud control, SQL developer, BMC Performance Manager
• Strong background in configuring, troubleshooting,tracing and encrypting networking for Oracle databases, along with database level encryption
• Implemented Auditing consistently at various levels including database level, FineGrained (FGA) to maintain security throughout teh environment.
• Extensively used SQL *Loader, export/import utilities and DataPump
• Created scripts to automate load process and for daily / weekly backups
• Job scheduling through cron, OEM as well as DBMS Schedular
• Experience with working on Amazon Cloud (AWS), implementation and testing
• Strong working noledge of Bi Publisher, OID/OVD, APEX in 12c PDB
• Strong working noledge of Weblogic Server administration
• Experience with working on Exadata Quarter Rack
• Sound noledge with INFORMATICA and COGNOS for data extraction / reporting purpose

TECHNICAL SKILLS

RDBMS: Oracle 12c, 11g, 10g, 9i - Single instance, RAC, Standby environments

Tools: OEM12c/13c, BMC Performance Manager, IGNITE, RMAN, SQL*plus, ISQLplus, DataPump, SQL Loader, SQLT, BiPublisher, Weblogic, Command Line, Command Editor, Development center, Oracle Developer 2000/6i,WINSCP,VNC, INFORMATICA, SharePoint, VISIO, BI Publisher, OID/OVD, Apex

Operating System: Solaris, Linux, HP-UX, AIX, Windows NT/2003/2000

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, COBOL, JAVA, C, C++

Oracle Tools And Utilities: Import/Export, Data Pump, SQL *Loader, SQL Trace, OEM, Explain Plan, Auto Trace, AWR, ASH, ADDM, RMAN, FTP, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Vienna VA

Senior Oracle DBA

Responsibilities:

• Administered multiple RAC, standby (with DataGuard), VCFS databases across different platforms, including upgrades, patching, troubleshooting and migrations for 11g,12c (CDB and non-CDB) environments.
• Patched 11g, 12c environments using OEM FLEET maintenance as well as manual methods.
• FLEET maintainance included patching (Bundle, CPU's PSU's and one-off's) using EMCLI,check applicability, Subscribe, DEPLOY, UPDATE targets (Grid, DB, Agents) following creation of Glod Images using OEM 12c/13c. Environments included both primary/standby sites homes in RAC, VCFS and single instance environments.
• Worked on Navy Federal's domain migration project related to EUS autantication.
• Implemented encryption via TDE encryption wallet/keystore for critical tablespaces.
• System maintainance also included removing/Re-adding nodes to a RAC cluster.
• Migration activities also included switching from 11g to 12c CDB/PDB setup (including backups) as part of teh consolidation project.
• Worked on multiplexing OCR/Vote disk on new ASM disks for fault tolerance during storage maintanance.
• Implemented/setup OEM13c with Weblogic and OMS repository from scratch on new servers for testing purpose as well as performed in-place upgrade for teh existing OEM12c repository, OMS on Linux, followed by upgrading agents. Administration included setting up groups, metrics/thresholds/alerts within OEM.
• Standby databases troubleshooting and administration with DataGuard including rebuilds (via Active Duplication and RMAN backups), log gaps/lags due to network glitches (MRP crashes) or scheduled maintenance, manually sync'ing standby with primary, scheduled manual switchover roles.
• Sound noledge of Weblogic including accounts/groups administration and BiPublisher setup/administration for creating new models and migrating reports/models between environments.
• Extensively used DataPump and RMAN for object/schema/database level refreshes.
• Used database, session as well as network (client & server) tracing methodologies to troubleshoot and gather diagnostics for bottlenecks (database/network side) as well as performance impact/issues from teh client side.
• Database side administration/tuning included SQL profiles/plan stability for queries/jobs, ADDM/AWR reports to find bottlenecks, hints for in-house developed codes.
• Helped with generating data from databases, formatting, exporting and uploading them to MainFrame Datasets via ftp.
• Actively participated in scheduled DataGuard Switchover and RAC failover exercise to maintain teh stability of teh systems.
• Extensively used RMAN for 11g,12c scheduled backups using robust strategies including archived logs for standby environments.

Environment: Linux AIX 7.2 bit), Linux x86-64, Oracle 12.1.0.2, 11.2.0.4, RAC/VCFS/Standby (With DataGuard Broker), 12c CDB/PDB's, RMAN, OEM12c/13c, Bi Publisher, Weblogic, SCAN, TAF

Confidential, Suitland MD

Senior Oracle DBA

Responsibilities:

• Supported 11g,12c databases (Single Instance to 3-Node RAC on ASM/ACFS/File System) through all Dev, Test, Prod environments
• Created, patched and configured 12c multitanent databases in a RAC environment for in-house consolidation project.
• Migrated 11g databases to 12c PDB using Transportable Tablespaces, database and DataPump.
• Created non-Container 12c 2-Node RAC catalog database for teh 12c consolidation project.
• Configured and Managed RAC/ASM instances, SCAN listeners, schema/tablespace/profiles management, Resource Manager for 12c PDB’s.
• Applied quarterly PSU/OJVM and one-off bug patches to RAC/Grid/Database/Agents in rolling & non-rolling fashion for 11g and 12c environments.
• Configured backup strategies for 12c non-container and container (including PDB) databases.
• Managed existing disk/tape based backups, validations and restore/recovery for all teh environments.
• Performed semi-annual disaster recovery exercise for production databases and created related documents for audit review.
• Managing Production Physical Standby database including resolving log gap issues, role-reversal from ‘Snapshot Standby’ to ‘Physical Standby’.
• Created shell scripts for database active duplication automation.
• Installed OEM plugins for DBaaS (Database as a Service), Schema as a Service, PaaS (Platform as a Service) testing via OEM.
• Installed OEM 13c and migrated groups/accounts, alerts, metrics from OEM12c.
• Installed and patched Enterprise Management agents.
• Created separate dynamic propagating groups/admins for various Business Groups within teh organization with modified monitoring templates (Verying thresholds as per user requirements) in OEM 12c. Also created custom DBMS jobs from within OEM for database/server monitoring.
• Custom metric extensions for Targets as per customers requirements.
• Working on database consolidation project, infusing multiple schemas/databases into 12c pluggable databases 2-Node RAC).
• Worked on Weblogic and MiddleWare components,http cluster, including Admin/Managed servers, troubleshooting, startup/shutdown, automation and deploying new contents in a clustered environment.
• APEX installation/migration within 12c PDB and CDB.
• Extensive exposure to BI Publisher reporting, scheduling, trouble shooting, Data Modelling and access management.
• Migrate Reports/Data Models within BI Publisher environments.
• Worked with ODSM/OID to administer groups, members and integrate single sign-on for various applications.

Environment: Linux x86-64, SunOS SPARC, Oracle 12c / 11g, RAC, Data Pump, RMAN, Oracle Enterprise Manager (OEM) Cloud Control 12C/13c, DataGuard, Bi Publisher, WebLogic, OID/ODSM, SPLUNK

Confidential, Washington DC

Senior Oracle DBA

Responsibilities:

• Provided on-call support via pager rotation in a complex Oracle 10g,11g environment consisting of over 150 single instance, DataGuard, RAC databases.
• Support included System stability, OS and Database performance tuning,query tuning including hints/SQL Profiles/Outlines, capacity planning, Database/system statistics and new implementations.
• Actively participated in semi-annual Load Shift exercises of databases and related resources between data centers.
• Provided complete support/expansion of Oracle database systems including patching/upgrades, refreshes, backups, resource management, schema/user management, instance/query tuning using AWR, ADDM, Oracle-provided advisors via OEM and command-line, SQL, session and NET tracing.
• Executed Aix-linux migration projects for majority of teh databases, which included database storage migration from file systems to ASM, upgrades from 10g to 11g, floating VIP's, SRDF and VCFS supportable systems spread across two data centers in a VM environment.
• Executed different techniques for migration projects according to teh complexity of teh existing systems, dat included Datapump, Active Duplication, Cold backup/Restore, Transportable Tablespaces, along with executing post-migration tasks such as RMAN/TDPO/Catalog configuration, scheduling and stability testing of teh entire system.
• Migrations involved setting up of databases on new Linux platforms, associated RPM's, installation/setup of software, floating VIP's, Auditing and offsite database archive shipping, cronjobs, ASO encryption (network and tablespace level/Wallet), RMAN configuration including catalog setup, TDPO configuration, connectivity and scheduling.
• Setup as well as troubleshoot network related issues during existing database migrations as well as newly added systems after merger with IFC across different VLAN's, Intranet, PDMZ and Infra zones.
• Actively participated in testing with Amazon Cloud (AWS) which included initial setup of databases/cloning on teh cloud server, execution and capturing of execution plans of existing systems to compare performance with Cloud systems, parameter tweaking. Teh testing included mount point devices of different IOPS (2k, 4k) as offered by Amazon.
• Performed Exadata POC on a quarter Rack, which included setup of database instances (SIngle instance, tan converted to 2-node RAC), Query execution and runtime comparison between Exadata and existing production environments.
• Active participant of Client's internal auditing compliance team to address all Oracle related Audit and security issues.
• Worked closely with Application owners/developers and Vendors to implement new systems, capacity planning, database/system pre-requisites and post-implementation support.
• Hands on experience with implementing/testing Oracle 12c Pluggable databases in test environments. Also prepared Multitanent POC documentation for teh team.
• Implemented OEM Cloud Control 12c for testing purpose.
• Knowledge of MongoDB setup, Primary-Standby and backups.
• Very proactive by nature and eager to learn new technologies as well as improve upon existing Oracle noledge.

Environment: Linux x86, AIX 5.3/6.1, Oracle 12c / 11g / 10g, RAC, SQL*Loader, Data Pump, RMAN, Oracle Enterprise Manager (OEM) Cloud Control 12C, DataGuard, Exadata, MongoDB, EMC SAN, SPLUNK

Confidential, Colorado Springs, CO

Oracle DBA

Responsibilities:

• Supported L1 through L4 and production Supply Chain system in a RAC and stand-alone environments.
• Actively participated in new applications implementations like KRONOS and SPOTLIGHT (Tibco product) which included database install/setup, initial capacity planning, schema/account setup and their respective space quotas, resource assignments using Resource Manager, followed by performance tuning for application-generated queries, ad-hoc queries and teh ASM/Database instance.
• Worked closely with teh development teams in troubleshooting packages, procedures and scripts.
• Upgraded lower level 10g databases to 11.2.0.3.
• Applied CPU,PSU and one-off patches in a timely manner.
• Responded to tickets related to backup failures and helped with designing backup strategies for newly setup systems using RMAN.
• Supported teh database upgrade tasks including ASM and CRS components,followed by performance comparison exercises between teh old and new systems which included AWR snapshots comparison using DBMS SWRF INTERNAL.AWR EXTRACTand DBMS WORKLOAD REPOSITORY.AWR DIFF REPORT TEXT.
• Extensively Used SQLT XTRACT, XECUTE,XPLAIN, COMPARE and PROFILE to extract diagnostic details regarding problematic queries, generate reports and implement recommended Profiles, along with SQL Tuning advisor.
• Proficient with using various database hints to troubleshoot and test queries for performance enhancements.
• Extensively used AWR reports, EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF for query refining/tuning and to determine database bottlenecks.
• Converted existing OUTLINES in 10g to PROFILES. Also migrated existing functional PROFILES to new systems.
• Generated SQL Profiles in a separate category TEMPthan teh default for selective database schemas using logon triggers.
• Modified DBTIMEZONE to reflect Eastern times for systems operational via a different region in clustered environment.
• Extensively used DATAPUMP to refresh database objects, schemas and databases at different levels by applying appropriate filters .
• Customized database auto stats gathering in 11g for different maintenance windows according to teh requirements.
• Created manual stats gathering jobs for certain database objects using DBMS SCHEDULAR.
• Locked in statistics for a few static database objects after removing unnecessary histograms.
• Modified DB parameters like cursor sharing, parallel automatic tuning, query rewrite integrity, and optimizer index cost adjustment according to database performance needs.
• Strong working noledge regarding 11g SQL Plan Management.

Environment: Linux x-86,Solaris 9/10, Oracle 11g / 10g, RAC, SQL*Loader, Data Pump, RMAN, Oracle Enterprise Manager (OEM) Grid Control 12C, EMC SAN

Confidential, Collegeville, PA

Oracle DBA

Responsibilities:

• Provided 24/7 On-call support to Production tickets revolving around file system issues, job failure, tns connection issues, locks, tablespace utilization, backup failures, outdated system/objects/dictionary statistics.
• Installed new 11.2 databases with ASM, ASM related RPM’s and applied appropriate upto date patches including PSU’s and CPU’s.
• Provided support in an environment with over 150 database instances on various platforms including AIX, Linux x-86 and HP UX.
• Migrated existing databases from file systems to ASM.
• Administered ASM instances by adding, removing and rebalancing of new disks to teh existing Disk Groups.
• Set up new databases to OEM grid, installed agents on servers.
• Worked with relinking of Oracle software along with graceful startup/shutdown of single instance, clustered and primary/standby databases, ASM, CRS, agent after any upgrade/patching of teh hosting servers.
• Involved in restoring/recovering of corrupted tablespaces/datafiles using point-in-time recovery on an auxiliary instance.
• Utilized DBVERIFY,RMAN validate backup features to deal with Database Corruption.
• Closely involved with teh applications team in strategizing capacity planning including tablespace size and allocation, database parameters, roles, privileges, profiles, resources etc.
• Extensively used AWR reports to tune various database components for current as well as new databases.
• Utilized Oracle hints to optimize local/distributed queries as part of troubleshooting performance issues.
• Extensively used ORADEBUG, explain plans, SQL Trace using logon triggers, autotrace, oracle listener and SQLNet tracing and observe wait events as part of query and database tuning.
• Created Stored Outlines for queries with performance degradation in new environment and imported those Outlines from old to new environment. Also used SQL Profiles for improving queries.
• Gatheird object/system statistics. Making sure objects have upto date stats, as part of performance tuning.
• Fluent with database as well as operating system utilities such as vmstat, topas, glance, iostat to determine bottlenecks.
• Implemented change requests as forwarded by teh design/development team and closely worked with data modelers including creation/modification of tables, indexes, sequences, triggers, constraints etc.
• Performed schema, object and tablespace refreshes across environment including complex partitioned tables/indexes and related dependencies.
• Extensively used DataPump for refreshes, backups.
• Maintained table partitions by spreading new partitions across various available mount points (LV’s) and moving existing partitions from existing tablespaces to new ones on different mount points.
• Setup database auditing for logons and implemented scripts for archiving teh audit data.
• Implemented profiles according for different groups of database accounts and related priorities alongwith enforcing password complexity using Oracle’s default verification routine.
• Monitored backups and manually ran backups for failed jobs at teh table, tablespace and database level.
• Strategized backup levels for new instances using incremental, cumulative and differential backups.
• Maintained DB Links across environments.
• Actively involved in providing support during unexpected single instance, clustered database crashes including preparing trace/alert logs for TAR, gathering HCHECK outputs, SystemStateDumps and RDA related information for Oracle Support and closely working with support to work on related SR’s.
• Setup cleanup scripts for old database trace files.

Environment: AIX / V5.3-6.1 (TL-9), RHEL 4 ES, Linux x-86,HP-UX 11.31 ia64, RAC, Oracle 11g / 10g / 9iSQL*Loader, Data Pump, RMAN, Oracle Enterprise Manager Grid Control, SAN

Confidential, Memphis, TN

Oracle DBA

Responsibilities:

• Installed and created new 11g databases with ASM on OEL.
• Setup a 3-node 11g RAC and migrated an existing 3TB database to teh new environment.
• Migrated databases with varying sizes, from 10GB till 3TB using Corss-Platform transportable tablespaces.
• Designed new disk structure and capacity planning for ASM disks in relation to teh new databases prior to migration.
• Setup of OEM Grid Control for teh existing databases.
• Applied patches to Oracle,CRS in a timely manner.
• Daily administration tasks including troubleshooting ORA errors, connectivity issues, user/account management, space management.
• Backups of existing databases using RMAN and Storage-level cloning.
• Extensively used AWR reports to tune various database parameters for teh current as well as new database during teh testing phase.
• Query tuning by using explain plan, SQL trace and utilizing various hints to make sure teh queries have optimal execution path.
• Implemented Resource Manager to reserve optimal system/database resources for critical jobs.
• Extensively used DataPump and EXP/IMP to move schemas, tablespaces and database objects.
• Implemented Resource Manager for proper distribution of resources according to priorities.

Environment: Solaris 10, OEL, RAC, Oracle 11g / 10g / 9iSQL*Loader, Data Pump, RMAN, Oracle Enterprise Manager (OEM), SAN, Equilogix

Confidential, Wilmington, DE

Data Warehouse Oracle DBA

Responsibilities:

• Database administration, including upgrades, migration, patching (CPU/PSU/One-off).
• Day to day administration tasks including accounts management, roles/privileges, resource management etc.
• Upgraded existing Oracle 10g databases to 11g R2.
• Administered more TEMPthan 50 databases including RAC, single-instance, ASM instance, primary/standby.
• Built new Oracle 10g databases with ASM on AIX platform.
• Participated in capacity planning for tablespace sizes and types according to requirements.
• Tested new implementation, installation, backout strategies related to Oracle 11g on RHEL x-86 64-bit.
• Supported system administrators during teh upgrades of servers, by relinking Oracle software along with startup/shutdown of single instance, clustered and primary/standby databases, ASM, CRS, agent.
• Relocated archive logs generated to alternate destination due to various reasons like on-going maintenance, backup failures, excessive log generation, slow moving backups etc.
• 24/7 On-call production support, involving responding/troubleshooting to Production tickets including file system maintenance (reaching capacity), load-job failure, database related issues including tns connection, locks, tablespace utilization, TEMP/UNDO issues, backup failures, gather system/objects/dictionary statistics etc.
• Utilized DBVERIFY,RMAN features to deal with Database Block Corruption.
• Installed and Implemented Grid Control for complete administration of databases throughout teh environment, including monitoring, backups, paging etc.
• Configured SSH from open to secure for individual/shared accounts.
• Backup strategies using shell scripts for incremental, cold and archive log backups.
• Generated AWR reports via OEM Grid Control to investigate database workloads.
• Fluent with Oracle DataPump and exp/imp.
• Extensive use of Oracle hints to optimize local/distributed queries like driving site - index - full - pq distribute as well as troubleshooting job loads issues and utilized tools such as explain plans, auto-trace, sql trace, query hints, troubleshooting locks within teh database, wait events, database parameters tuning according to teh environments
• Administered and resolved tablespace related issues with ASM and raw devices.
• Supported AIX system administrators during SAN migrations (EMC upgrades) by gracefully starting up, shutting down databases, ASM, CRS, agent and modify ASM disk strings related to powerpath changes (addition of new PowerPath devices) during teh upgrade. Also created NFS mounted file systems to temporarily divert archive logs to a new destination.
• Administered ASM instances by adding/removing new disks to Disk Groups and rebalancing.
• Troubleshoot user issues with their respective queries by utilizing database utilities as well as OS-level utilities such as vmstat, topas, iostat to determine root cause.
• Created triggers to utilize ORADEBUG utility and put in trace events at teh individual session level.
• Implemented Resource Manager for proper distribution of resources according to priorities.
• Implemented various backup strategies with RMAN including cold, archive and incremental backups.
• Supported table/object restores from TSM according to user requests and created views/grant privileges according to company's policies.
• Administered primary/standby Catalog instances for various blocks and resolved issues related to log shipping.
• Actively participated in CyberArk project by migrating all clear-text passwords to CyberArk system for compliancy.
• Actively supported teh team during unexpected instance crash of multi-node clustered databases including gathering of trace files/alert logs, HCHECK, ORADEBUG, SystemStateDump and prepare TAR for Oracle support.
• Supported in disaster recovery mock scenarios by switching primary databases roles to standby and vice versa.
• Implemented Product User Profile to restrict database level actions for associated database accounts.
• Implemented database-level and OS-level auditing for various environments.
• Created and administered public/private DB Links across various environments.
• Performed extensive research related to Mata-masking during database upgrades to 11g.
• Supported teh senior Oracle DBA by implementing Materialized Views strategies according to requirements and created automated jobs for refreshes.
• Actively researched and implemented various table and index partitioning techniques for optimum performance of teh database and supported exchange partition jobs for new loads.
• Very proactive by nature along with excellent communication skills.

Environment: AIX / V5.3-6.1 (TL-3, TL-6, TL-9, TL-4), RHEL 4, RAC, Oracle 11g / 10g / 9iSQL*Loader, Data Pump, RMAN, Oracle Enterprise Manager (OEM), SAN-EMC

Confidential, Chicago, IL

Oracle DBA (Production Support Environment)

Responsibilities:

• Setup Oracle 10g test and development environments with ASM.
• Implemented DataGuard as a standby database for disaster recovery situations.
• Upgraded test database to new releases.
• Applied critical database patches in a timely manner.
• Provided general database administration services including user management, account. management, resource management, database security, roles, profiles.
• Created DB-Links between databases.
• Extensively used DataPump for data transfer between databases.
• Strong working noledge with SQL Loader.
• Strong noledge with ERWin data modeling and designing tool.
• Extensive performance tuning experience on critical development databases.
• Extensively used EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF for query refining.
• Strong background of indexing and partitioning for high scalability and enhanced performance.
• Continuously monitored Oracle Optimizer, supplied with teh latest statistics for optimum execution plan.
• Wrote several shell scripts for checking oracle errors in alert file and backup log files.
• Managed critical database backups in a timely fashion by using RMAN and actively participated in test-runs related to recovery of databases when required.
• Strong noledge with database cloning.
• Implemented Resource Manager for optimal database performance and efficient use of database and system resources.
• Provided support to system administrators in setting up systems for database implementation including upgrading, patching etc.
• Supported teh SharePoint server and application by implementing a fresh implementation and providing administration and resource management.
• Administered SharePoint by managing users, groups, roles and content management.
• Developed regular performance reports, status reports in a timely manner.
• Created Visio diagrams for graphical representation of process flows.
• Fulfilled teh role of a System’s Analyst by getting requirements from business analysts, creating functional documents and implementing teh requirements at teh database level.
• Created CRONJOB’s at teh operating system level for automating various tasks.

Environment: RHEL-5, Windows 2003 Server, ASM, Oracle 10g / 9i, SQL*Loader, Data Pump, RMAN, INFORMATICA 8.1.1, Oracle Enterprise Manager (OEM), SharePoint MOSS, VISIO