SUMMARY

• Around 10 years of oracle database administrator experience and experience in managing database implementation projects, I is uniquely qualified for a role as a database administrator. For over 8 years, I has worked as a Database Administrator, which includes prod, test and dev servers.
• This work has included more database administration skill development, which will be useful for future organizations wif whom I is employed. I understand teh inner - workings of databases and work diligently to ensure their security and integrity.Areas
• Around 10 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security wif Oracle (7,8,9i, 10g, 11g, 12c, 18c and 19c) on Sun Solaris, Red Hat Linux, oracle Linux, HP-UX, AIX, and Windows 2000/2003/2008 Platform.
• Experience wif RMAN, Oracle Enterprise Manager (OEM), RAC, OEM Grid control, Data warehousing, Oracle Data Guard.
• Proficient in space management, capacity planning, monitoring and management.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning teh tables and Indexes.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Implemented oracle OID.
• Experience wif oracle multitenant.
• Experience wif oracle engineered systems EXADATA, ZFS and ODA.
• Created a shell script to automate database refresh using RMAN.
• Knowledge in Oracle Applications schema teh E Business Suite (EBS) and other Oracle products.
• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager.
• Experience on Data Replication using Golden Gate and Oracle Streams. Hands on experience on setting up teh environment for unidirectional, bidirectional propagation in Oracle Streams.
• Experience in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle database.
• Experience 10046 and 10053 trace events.
• Experience In building OBIEE repository layers and BI Publisher.
• Migrated databases to Exadata x5, x6, X7 and X8 from non exa.
• Experience in patching exadata cell nodes.
• Experience in tuning databases based on exadata standards.
• Experience in migrating databases from non-exadata to exadata.
• Experience in applying security patches to teh databases.
• Deploy and maintain MongoDB databases/DB projects
• Manage and maintain both MongoDB servers across multiple environments.
• Perform Database Administration activities wif Cassandra.
• Experience in scaling Cassandra clusters to support high read/write throughput and tuning Cassandra.
• Performed full, incremental and cumulative backups using RMAN.
• Expert in performing manual recovery using RMAN wif and wifout catalogue.
• Experience wif Oracle Advanced Security including Data Encryption, Data Autantication, and Data Integrity.
• Proficient in working wif Data Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Familiar wif Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Configured and administered replication using Oracle Streams and Oracle Golden Gate technology.
• Worked on new advanced features including Load Balancing, Transparent Application Failover (TAF), Transparent Data Encryption (TDE) and Hardware Security Model (HSM).
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Migrating existing 11g/12c databases to 19c using transportable tablespace method. Upgraded supported versions to 12cR1 using DBUA (direct path upgrade)
• Migrating teh databases from Non-ASM to ASM.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003, Oracle Linux 6, 7.

RDBMS/ NoSQL: Oracle 9i,10g,11g,12c,19c SQL 2012,2016 MYSQL 5,8 mongo DB.

Languages: SQL, MYSQL, PL/SQL, C, C++, XML, Unix Shell Scripting, Python, Perl, HTML.

Software Applications/ Tools: OEM, DATAGUARD, Recovery Manager (RMAN), Data-pump, STATSPACK, ASH, AWR, TKPROF, ADDM, ERWIN, ETL, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD, SQL*LOADER, Erwin, putty, WinSCP3, SQL*PLUS, Net Backup, EXPLAIN PLAIN, OLTP, Oracle Golden Gate, DPA, SMU.

Protocols: FTP, SFTP, SSH, Telnet, TCP/IP

Oracle Appliances: Exadata, ODA, ZFS, ZDLRA.

Cloud: Oracle cloud infrastructure, AWS.

PROFESSIONAL EXPERIENCE

Confidential, Chambersburg, PA

Lead Oracle Applications Database Administrator

Responsibilities:

• Experience in migrating databases non Exadata to Exadata X8
• Upgraded golden gate to 19c on Exadata frames.
• Upgraded databases on exadata to 19c
• Built disaster recoveries in 19c using data guard from non-Exadata to Exadata.
• Installed, configured and maintained Oracle 11GR2, 12C Real Application Cluster (RAC) databases including a 4 and 8 Node RAC on EXADATA x6, X7 and x8
• Migrated databases from Legacy IBM environment to Exadata X7 and X8full rack frames.
• Experience is setting up and fixing issues wif ACFS replication on Exadata frames.
• Upgraded grid infrastructure to 19c on Exadata.
• Installed, configured and maintained Oracle 11GR2, 12C Real Application Cluster (RAC) databases including a 4 and 8 Node RAC on EXADATA x6, X7 and x8
• Configure and build Golden Gate Extracts/replicate for Uni-directional and Bi-directional replications on Exadata and Non-Exadata servers using DBFS and ACFS storage.
• Knowledge of Exadata Cell table Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Worked on Oracle Exadata servers.
• Worked wif network and Linux teams to configure teh network on teh Exadata x6 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12cR1
• Configured and modified Exadata x6 and X7 machines as per Confidential requirement and specifications after Oracle handed over teh standard Exadata machines.
• Worked wif Storage team in configuring NetBackup and Data domain on Exadata X7 machines.
• Configured ZFS appliance to all Exadata machines for configuring teh backups.
• Experience in upgrading grid homes 11g and 12c to 19c.
• Upgraded Oracle Golden Gate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Applied One off-patches on 19c oracle and golden gate homes.
• Configured ZFS-7 appliance across all clusters for backups.
• Worked on golden gate trial file encryption as well.
• Configured DNFS on oracle homes to boost teh RMAN backups on ZFS appliance.
• Experience in building component databases using ACTIFIO snap clone management.
• Support up to 40TB plus size of Business Critical Databases; play a lead role in database optimization and instance and resource monitoring.
• Design, deploy and support highly available and scalable distributed Cassandra (Datastax OR Apache) database solutions
• Experience in building and managing big file table spaces.
• Experience in setting upOracle Golden Gateone-way, two-way/bi-directional, active-to-active and active-to-passive data replication wif conflict detection and resolutions. Extensive skills in upgradingOGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Experience in using Artifactory and integrating wif Jenkins for deployment process.
• Worked on Jenkins for continuous integration CI and for End-to-End automation for all build and deployments.
• Worked on multi-tenant architecture including PDB’s and CDB’s
• Worked on continuous deployment CD pipeline wif Jenkins.
• Worked on fixing teh issues in teh Jenkins deployment pipeline.
• Automated regular day to day activities in Jenkins.
• Built CDC and Kafka Replications.
• Created databases instances in oracle cloud consoles.
• Created PDB and CDB’s in 12c.
• Testing and implementing differentphysical and logicalbackup and recovery methods including point in time, media recovery, full/partial, expdp/impdp.
• Creating Database Guaranteed Restore Point before application upgrade and flashing back teh database in case required by application team.
• Implementation ofFlashback Technologyand Created and monitored database objects like Tables, Indexes, Views, Users and DB links
• Fixing teh bad execution plan by pining teh good execution plan for SQLs using SQL Baseline/SQLT,Use Explain Plan, Oracle hints and creation of new indexes to improve teh performance of SQL statements.
• Set up & manage database security by creating new users, roles, profiles, and provide required user privileges.
• Migration of databases of size 5TB using Golden Gate wif minimum downtime.
• Experience in patching/upgrading databases hosted on oracle cloud consoles and also worked on setting up teh monitoring using OEM.
• Performing Database refresh of size 3TB+ at schemas and table level using data pump utility.
• Configure and set up Oracle Data Guard environment for disaster recovery purpose and Active Data Guard for reporting purpose.
• Perform teh Dry run for disaster recovery using Snapshot database and actual annual disaster recovery test by using teh Data Guard Switchover functionality.
• Performed disaster recovery test by converting physical standby to snapshot standby.
• Resolving Undo issues during teh database refresh of LOB table’s size of 500+ GB.
• Taking care of table space related issues like increasing teh storage parameter values, resizing teh data files, adding new data files etc.
• Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on teh target servers and monitor databases.
• Install, configured and documented teh upgrade of Oracle GI home from 11gr2 and 12.1 homes to 18.3/18.4 and 19.3/19.5/19.6
• Setup physical standby’s (DATAGUARD) for several Databases running 11g and 12c as well (CDB and Non-CDB), Configured Data guard broker between teh primary and standby databases, perform Switchover/Failover and monitor teh data guard status via command line and GUI.
• Converted physical standby to Snapshot standby and back to physical standby.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Plugging from and Unplugging into XML files, creating teh Container database and pluggable databases. Migrating teh 11g database to 12c pluggable database.

Confidential, Charlotte, NC

Sr. Database Analyst and DMA

Responsibilities:

• Experience in migrating databases from non-ODA databases to ODA.
• Experience in upgrading databases.
• Experience in building databases using OAKCLI and ODACLI
• Experience in building RAC, DATAGUARD and GOLDEN GATE replication.
• Experience in backing up databases ODA to ZFS.
• Experience in OEM 13c by creating monitoring templates.
• Experience in patching ODA using OAKCLI
• Experience in configuring huge pages.
• Experience in rebalancing ASM disk groups.
• Worked on managing disk group redundancy.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Installed, configured and maintained Oracle 11GR2, 12C Real Application Cluster (RAC) databases including a 4 Node RAC on EXADATA x6.
• EXADATA monitoring, Setting up teh alerts for database, listener, tablespace monitoring, ZFS backups setup from OEM 12c.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• First hands-on experiences in software and firmware maintenance of both teh Database and Storage servers in teh Exadata database machine including upgrades and patching.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for teh Exadata Database machine.
• Solid skills to configure Exadata to meet company internal security requirement.
• Analyze and determine teh feasibility of leverage teh Oracle Enterprise Manager solution to report on performance, provide metrics, and become teh centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade teh Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Installation, Configuration and maintenance of Oracle Golden gate software on Unix systems, Sybase, Sun Soloes systems, Oracle Golden Gate on Oracle Exadata Database Machine,Configured DDL replication from Oracle on Sun to Oracle on Linux.
• Skills to configure Exadata to meet company internal security requirement.
• Analyze and determine teh feasibility of leverage teh Oracle Enterprise Manager solution to report on performance, provide metrics, and become teh centralized proactive maintenance solution for Exadata distributions.
• Experience in working wif people-soft developers for application upgrade.
• Written scripts to automate RMAN clone process.
• Enrolling users and maintaining system security.
• Tuning database performance issues by using resource management feature.
• Experience in performing database migration using data guard.
• Installed OEM 13c for database monitoring.
• Experience is scheduling jobs in autosys.
• Experience is building component databases using ACTIFIO and snap clones.
• Experience is building and maintaining replications in ATTINUITY.
• Performed Disaster Recovery tests.
• Experience in tuning queries by baselining.
• Worked on oracle PeopleSoft upgrade.
• Performance tuning using sql tuning advisor and implement Index and profile recommendations.
• Experience in baseline SQL ID’s using best plan hash values.
• Experience is database re-org to fix fragmentation in database and worked on segment advisor reports.
• Experience in fixing teh golden gate replicate lag.
• Experience in purging bad sql plans and creating new execution plans.
• Setup and managed replication among several databases
• Converted physical Standby to Snapshot standby for testing process.
• Resolving teh conflicts between teh target and source database in Oracle Golden Gate
• Created new Golden Gate processes for new tables, implemented DDL Replication between Source and Target Instances.
• Created Golden Gate EXTRACT and REPLICAT files.
• Worked on diff golden gate options like filter, supplemental log, trandata etc.
• Enabled trail file encryption in golden gate
• Worked on POC for golden gate hub model.

Confidential, Pittsburgh, PA

Sr. Oracle Database Administrator

Responsibilities:

• Supported 100+ databases including RAC Production database, a data warehouse database and lot of Development and Test databases.
• Support and implement high availability environment using Oracle RAC, Oracle Data Guard, 11g/12c Grid, and Golden Gate.
• Responsible for administration and supporting Oracle 12c,11g, 10g RAC databases in DEV, QA, UAT and Prod environments.
• ASM, OEM, Diagnostics, Tuning, Monitoring and Configuration.
• Perform backup and recovery procedures using RMAN wif EMC Networker or IBM TSM.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Proactive database monitoring using 11g grid monitoring tool.
• Experience in migrating existing applications to AWS.
• Perform additional tasks as requested by teh manager.
• Will be managing daily operations related to multiple Oracle Database environments running on IBM AIX, Linux and Exadata.
• Perform DB Migrations and copying data from Prod to Test and Dev as well.
• Monitoring and managing teh storage cell in Exadata.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, and schemas.
• Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
• Starting and stopping teh agents to clear metric alerts and collecting ADDM reports in OEM.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Involved in Tuning teh RAC interconnect Finding RAC wait events. And Tuning teh RAC using teh Enterprise Manager Grid Control.
• Experience in ASM administration tasks on ODA and Exadata.
• Configured parameters for teh Bi-directional replication using Golden-Gate.
• Implemented Golden Gate for Active-Active Replication between teh Datacenter for High Availability.
• Worked on Oracle Exadata Backup Configuration utility.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g wif Oracle Enterprise Manager (OEM) 12C cloud Control.
• Maintain, support, configure and administer all development associated wif Oracle E-Business Suite (R12), including Financials.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying teh join methods (Nested/Hash/Merge join/Sort merge join) between teh row sources for tables, to improve teh performance of SQL statements.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.
• Used Tivoli Workload Scheduler (TWS) for different os to perform execution of track jobs on several environments.
• Export and Import of database objects to copy from one database to another database between different environments.
• Responsible for Capacity Planning and Upgrade of Hardware and storage Arrays.
• Scheduling and maintaining RMAN (Recovery Manager) backups to teh FRA.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Installed Oracle Discoverer and Integrated wif EBS.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.

Confidential, Pittsburgh, PA

Sr. Oracle DBA

Responsibilities:

• Upgraded databases from 10.2.0.4 to 11g R2
• Installed, configured and maintained 11g R2 databases on standalone servers and Real Application Cluster (RAC) 2 Node RAC
• Managed Oracle Real Application Cluster (2 Node RAC) running on ASM storage
• Hands on experience in migrating Non-RAC environments to RAC environments both manually and by using R-CONFIG
• Evaluated Golden Gate for future purposes that is for reducing teh complexity involved in Oracle Streams.
• Created custom services on RAC database for distribution of load across teh nodes
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group wif different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• Having good experience in build stage, installed Oracle databases on ASM using DBCA.
• Maintained Production and Development Oracle databases.
• Used OWB repository from 10g to 11.2.0.3
• Supporting more than 125 production and development databases on 10g and 11g.
• 24*7 on-call production database support and maintenance including remote database support.
• Worked as lead DBA for off-shore team.
• Setup and managed replication among several databases
• Converted physical Standby to Snapshot standby for testing process.
• Used new features in Oracle Data-Pump for export and import.
• Involved in creating Golden Gate EXTRACT and REPLICAT files.
• Resolving teh conflicts between teh target and source database in Oracle Golden Gate
• Created new Golden Gate processes for new tables, implemented DDL Replication between Source and Target Instances.
• Knowledge on Different Oracle frameworks for data warehouse.
• Migrating databases on to EXADATA using Golden gate and traditional export and import.
• Experience in Data Analysis and Data Visualization.
• Upgraded Oracle10.2.0.2 database to 10.2.0.4 and applied Patches using OPatch Utility.
• Using Automatic Shared Memory Management (ASMM) for optimal use of available SGA memory.
• Maintained catalog server and registered database in catalog.
• Used SQL Tuning Advisor and SQL Access Advisor to fix bad SQL
• Used Oracle Enterprise Manager 10g/11g Grid Control to monitor databases.
• Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.
• Worked on Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Used Data pump new features, Remap Tablespace, Remap Table, Remap Schema, Parallel while refreshing data between different environments.
• Experience in HDWF Interface Tables
• Experience in Validating and Integrating data and loading it into HDWF.
• Used Transportable Tablespaces to migrate tablespaces from one database to another.
• Working Experience wif latest TOAD having new features, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace.
• Used TKPROF to analyze trace files and tuned long running Queries on Database.
• Familiar wif SNAPSHOT TOO OLD error, involved in tuning this error
• Developed a bunch of Index monitoring scripts to sort out teh unused space occupied in tablespaces
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed exports/imports, hot/cold backups and recovery of Corrupted Blocks using RMAN.
• Created Materialized Views and fine-tuned them for better performance
• Functionality testing has been performed against teh identified modules.
• Tuning SQL statements using Explain Plan and STATSPACK
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Created DB Links to access remote data and bit-map Indexes for data warehouse databases
• Implemented database refresh wif teh hot backup using full export.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Confidential, Pittsburgh, Pennsylvania

Oracle Database Administrator

Responsibilities:

• Assisted in installation and configuring ORACLE 9i/10g on Linux and Windows NT.
• Performed data modeling, system design using entity relationship diagrams, data flow diagrams, Normalization for reducing data redundancy in database objects.
• Assisted in migrating databases from Oracle 7.3, 8i to 9i and 10g.
• Maintenance and Administration of Oracle Databases for Developers and Testers.
• Upgraded databases from Oracle 8i to 9i. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Supported and troubleshoot databases on VERITAS Cluster on top of Solaris 8.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Planned and implemented backup and recovery strategies using RMAN.
• Implemented logical backups using Oracle export/import utilities.
• Installed, configured and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded teh grid control.
• Configured and troubleshoot ASM Cluster File System (ACFS) for Grid/RAC cluster.
• Writing Oracle scripts for teh SQL and PL/SQL requirements for various applications.
• Modify Oracle PL/SQL Procedures and Functions as per teh client requirements.
• Refreshed tables using materialized views.
• Hands on experience on performing database and application tuning by analyzing teh reports generated by STATSPACK.
• Performed partitioning of large tables for increased performance.
• Assisted in writing scripts for database jobs and scheduling them through cron utility.
• Unloaded data using UTL FILE.
• Assisted in creating users, granting roles and teh necessary user management.