SUMMARY

• With over 8 years of oracle database administrator experience and experience in managing database implementation projects, I am uniquely qualified for a role as a database administrator.
• For over 8 years, I have worked as a Database Administrator, which includes prod, test and dev servers.
• This work TEMPhas included more database administration skill development, which will be useful for future organizations with whom I am employed.
• I understand the inner - workings of databases and work diligently to ensure their security and integrity.
• 8 Plus 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 with 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 with 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 the tables and Indexes.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Implemented oracle OID.
• Experience with oracle multitenant.
• Experience with oracle engineered systems EXADATA, ZFS and ODA.
• Created a shell script to automate database refresh using RMAN.
• Knowledge in Oracle Applications schema the 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 Gloden Gate and Oracle Streams. Hands on experience on setting up the 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 the databases.
• Deploy and maintain MongoDB databases/DB projects
• Manage and maintain both MongoDB servers across multiple environments.
• Perform Database Administration activities with 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 with and without catalogue.
• Experience with Oracle Advanced Security including Data Encryption, Data Autantication, and Data Integrity.
• Proficient in working with Data Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Configured and administered replication using Oracle Streams and Oracle Gloden 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 the 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 Gloden Gate, DPA, SMU.

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

Oracle Appliances: Exadata, ODA, ZFS, ZDLRA.

Cloud: Oracle cloud infrastructure, AWS.

PROFESSIONAL EXPERIENCE

Confidential, Oaks, PA

Sr. Oracle DBA

Responsibilities:

• Experience in migrating databases non Exadata to Exadata X8
• Upgraded gloden 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 with 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 Gloden 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 with network and Linux teams to configure the network on the 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 the standard Exadata machines.
• Worked with Storage team in configuring NetBackup and Data domain on Exadata X7 machines.
• Configured ZFS appliance to all Exadata machines for configuring the backups.
• Experience in upgrading grid homes 11g and 12c to 19c.
• Upgraded Oracle Gloden Gate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Applied One off-patches on 19c oracle and gloden gate homes.
• Configured ZFS-7 appliance across all clusters for backups.
• Worked on gloden gate trial file encryption as well.
• Configured DNFS on oracle homes to boost the 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 Gloden Gateone-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgradingOGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Experience in using Artifactory and integrating with 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 with Jenkins.
• Worked on fixing the issues in the 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 the database in case required by application team.
• Implementation ofFlashback Technologyand Created and monitored database objects like Tables, Indexes, Views, Users and DB links
• Fixing the bad execution plan by pining the good execution plan for SQLs using SQL Baseline/SQLT,Use Explain Plan, Oracle hints and creation of new indexes to improve the 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 Gloden Gate with minimum downtime.
• Experience in patching/upgrading databases hosted on oracle cloud consoles and also worked on setting up the 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 the Dry run for disaster recovery using Snapshot database and actual annual disaster recovery test by using the Data Guard Switchover functionality.
• Performed disaster recovery test by converting physical standby to snapshot standby.
• Resolving Undo issues during the database refresh of LOB table’s size of 500+ GB.
• Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
• Install, configured and documented the 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 the primary and standby databases, perform Switchover/Failover and monitor the 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 the Container database and pluggable databases. Migrating the 11g database to 12c pluggable database.

Confidential, Los Angeles, CA

Sr. Oracle DBA 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 the 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 the Database and Storage servers in the 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 the Exadata Database machine.
• Solid skills to configure Exadata to meet company internal security requirement.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Installation, Configuration and maintenance of Oracle Gloden gate software on Unix systems, Sybase, Sun Soloes systems, Oracle Gloden 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 the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Experience in working with 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 pla hash values.
• Experience is database re-org to fix fragmentation in database and worked on segment advisor reports.
• Experience in fixing the gloden 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 the conflicts between the target and source database in Oracle Gloden Gate
• Created new Gloden Gate processes for new tables, implemented DDL Replication between Source and Target Instances.
• Created Gloden Gate EXTRACT and REPLICAT files.
• Worked on diff gloden gate options like filter, supplemental log, trandata etc.
• Enabled trail file encryption in gloden gate
• Worked on POC for gloden gate hub model.

Confidential, Irving, TX

Sr. Oracle DBA

Responsibilities:

• DMA for Exadata.
• Experience in Exadata network administration by managing CISCO ethernet switch, InfiniBand switch and ILOM network.
• Experience in Exadata Storage Administration.
• Experience in managing Exadata cell servers.
• Experience in Running Exadata health checks using Exachk.
• Experience in working with oracle and fixing issues caused by SQL QUARANTINE.
• Experience in monitoring cell disk, grid disk, cell flash cache, flash disks, OS administration, InfiniBand connectivity administration.
• Worked on Hybrid Columnar Compression (HCC) and advanced compression in Exadata.
• Experience in patching cell nodes, InfiniBand switches and spine switches.
• Experience in Operating System Administration like Setting up users,applying patches, managing disk space, NFS mount and high availability management during patching
• Migrated databases from ZFS 3 to ZFS 5 and in EXADATA from X3 to x5 and x5 to x6.
• Configure ZFS to Exadata machine and created projects in ZFS.
• Experience in Resizing ASM disks in Exadata.
• Experience in building ASM and RAC cluster nodes in Exadata.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Experience in Grid Infrastructure Administration like cluster ware, ASM disk group
• Installation of 2 Node RAC databases on Exadata X6-2 in Dev, Model and Prod Environments.
• Will be managing daily operations related to multiple Oracle Database environments running on IBM AIX, Linux and Exadata.
• Monitoring and managing the storage cell in Exadata.
• Experience in ASM administration tasks on ODA and Exadata.
• Worked on Oracle Exadata Backup Configuration utility.
• Experience in patching Exadata cell nodes and switches.
• Supported 100+ production instances (RAC) of very large databases.
• Involved in 24x7 support for production database with on-call pager.
• Supported Data ware housing applications with size of 500TB (includes prod, test and dev).
• Successfully implemented oracle 11g grid control in different environments.
• Experience in oracle BDA (Big Data Appliance).
• Experience in performing refreshes using SMU.
• Experience with managing oracle multitenant CDB and PDB and managing security in multitenant PDB.
• Experience with automation/configuration management using either Puppet, Chef or Ansible.
• Experienced in handling database issues using OEM as well as command prompt.
• Upgraded the databases to version 12c from 11g and 10g
• Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
• Up-gradation and Migration of Database from 10g to 11gand tan to 12c and applying patches whenever required.
• Experience with managing storage in oracle multitenant CDB and PDB.
• Experience in moving data from database to BDA.
• Experience in copying tablespaces from database to BDA to HDFS and measure performance before and after moving.
• Managed functionality and efficiency of operating system and storage cells in ODA and EXADATA.
• Experience in Exadata storage administration including cell disk, grid disk, flash disk and flash cache.
• Experience in patching Exadata machine including cell node, infini band switches.
• Experience in implementing Exadata specify features like smart scan, HCC (Hybrid columnar compression).
• Experience in building RAC clusters (11.2 and 12c) and ASM on ODA.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Familiar with Storage systems and Backup environments, particularly IBM Tivoli Storage Manager (TSM) and data domain.
• Experience in devops automation frameworks using Puppet, Ansible, Chef.
• Developing automated deployment solutions using a configuration management system using Puppet.
• Experience in design and documentation of backup/restore strategies via enterprise class backup solutions such as IBM TSM, EMC Data Domain and automated tape.
• Experience in creating partitions and daily snapshots.
• Written shell scripts to automate day to day monitoring jobs.
• Performed cross platform migration from SOLARIS, AIX to LINUX.
• Implementing and/or upgrading Oracle EBS R12
• Performed AUDITING on licenses for OEM (Tuning and Diagnostics pack)
• Worked on Automatic Storage Management (ASM) for managing data in SAN, also used ASMCMD utility for monitoring the ASM, Installation of ASMLIB rpm packages.
• Migrating OCR, Voting disks and data ASM disk groups to a new SAN.
• Worked on performance - tuning of Gloden Gate.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK and sql profile.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Upgraded OEM from 12c to 13c.
• Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
• Implemented partitions on a table in production database to improve performance.
• Written SQL scripts to monitor tablespace and extent growth.

Confidential, Eden Prairie, MN

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 Gloden 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 with 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 the 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 the 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 the agents to clear metric alerts and collecting ADDM reports in OEM.
• Installed Gloden Gate for replication of database on 11gR2 RAC environment.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Experience in ASM administration tasks on ODA and Exadata.
• Configured parameters for the Bi-directional replication using Gloden-Gate.
• Implemented Gloden Gate for Active-Active Replication between the Datacenter for High Availability.
• Worked on Oracle Exadata Backup Configuration utility.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Maintain, support, configure and administer all development associated with Oracle E-Business Suite (R12), including Financials.
• Used 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.
• 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 the 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 with 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, Boston, MA

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 Gloden Gate for future purposes dat is for reducing the complexity involved in Oracle Streams.
• Created custom services on RAC database for distribution of load across the nodes
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with 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 TEMPthan 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 Gloden Gate EXTRACT and REPLICAT files.
• Resolving the conflicts between the target and source database in Oracle Gloden Gate
• Created new Gloden 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 Gloden 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 with 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 with SNAPSHOT TOO OLD error, involved in tuning this error
• Developed a bunch of Index monitoring scripts to sort out the 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 TEMPhas been performed against the 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 with the 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

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 the grid control.
• Configured and troubleshoot ASM Cluster File System (ACFS) for Grid/RAC cluster.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Modify Oracle PL/SQL Procedures and Functions as per the client requirements.
• Refreshed tables using materialized views.
• Hands on experience on performing database and application tuning by analyzing the 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 the necessary user management.