SUMMARY

• Around 8 years of experience as a Oracle Data Base Administration in implementing large - scale production environments across multiple heterogeneous system environment including UNIX, Linux, AIX, HP-UX and Windows.
• Around 1 yrs exp as Hadoop administrator in Cloudera Cluster and having Knowledge in all Hadoop distribution modes like (Apache Hadoop cluster, Cloudera, Hattenworks, MAPR).
• Hands-on experience with Oracle Real Application Clusters (RAC10g/11g/12c), Golden gate, Exadata and Data Guard.
• Experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, SUSE, HP-UX, IBM-AIX and Windows platforms.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment.
• Experience in Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Experience in upgrading databases from 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1.
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard,12c, 11g and 10g RAC.
• Experience in building Standby databases, implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active, Dataguard and Snapshot standby database.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Performed data replication, transformation and delivery of database transaction using Golden Gate replication tool.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Proficiency with creating Golden Gate extracts process, extract pump and replicate for all types like classic, Integrated and coordinator.
• Hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g and 12c.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Experience in using OEM, TOAD, and Data Migrations using export/import, ATG, benchmarking using Load testing tools.
• Strong experience in working with Oracle APEX to design and develop the applications.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution and Defrag scenarios across diverse environments.
• Extensive knowledge in Database Cloning using RMAN, VERITAS, Net Backup, IBM Tivoli Storage Manager (TSM).
• Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, data Migrations using export/import, benchmarking using load testing tools.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps.
• Extensive experience on OEM, TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA.
• Worked on POC on OEM 12c Cloud, installed in all our non -prod databases, have good knowledge on 12c.
• Worked on building and rolling out new 12c databases for test/dev./qa environments.
• Documented all Oracle 12c installation/upgradation work and derived KT to all team peers.
• Experience in resolving the Severity 1, Severity 2, and Severity 3 according to the Service Level Agreements (SLA’s).
• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Good knowledge on ITIL processes and concepts for managing incidents, change requests.
• Good Experience and working knowledge on Exadata configuration like 1/8, Quaterr, Half, Full Rack and Infiniband inter connect.
• Transferring compressed files on FTP servers, on UNIX platform and from windows to Linux during the database migrations..
• Hands on experience and Good Knowledge on Hadoop Admin like storage, processing layers and its Eco system tools like HDFS,Namenode,Datanode,YARN,Journalnodes,Zookeepres,Sqoop, Pig, Hive, HBase, Map Reduce, Core java and Oozie.
• Experience on Installing & Configuring Clusters (Cloudera, Hattenworks (Ambari) and MAPR) on Red hat Linux.
• Experience on Hive and HBase for Data Manipulation in Hadoop.
• Experience on developing application on Map Reduce programming model of Hadoop in java.
• Experience on Performance tuning in all layers of Hadoop like storage, processing and its ecosystem level.
• Knowledge and experience in AWS and cloud technologies: DynamoDB, S3, EC2, Amazon RDS and Redshift.
• Strong knowledge of SDLC including, waterfall and agile models of development
• Good woring Knowledge in Mongo db/NoSQL.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i ASM, Grid, Real Applications.

Tools: Asmcmd, OEM, RMAN, Datapump, Vnc viewer, Putty, AWR, Lsnrctl, Tnsping, Opatch, Edit plus, Golden Gate, Winscp, Quality Controller, ADDM, PL/SQL Developer, Oracle APEX.

RAC Utilities: Crsctl, Srvctl, Ocrconfig, Ocrdump, Ocrcheck, Oifcfg, Asmcmd, Taf.

Dataguard: Physical Standby, Active Dataguard, and Snapshot Dataguard.

Programming: Oracle SQL, PL/SQL, C, C++, HTML, CSS, Java Script, Unix Shell scripting.

Version Control: CVS, VSS

Operating System: Red Hat Linux, Oracle Enterprise Linux 4 /5.5/6, Sun Solaris, MS Windows 7, VM Ware.

Data Replication: Oracle Golden Gate 11gR2, 12c

Ticketing Tools: Remidy, Maximo, SAP CRM, IRIS,HPSM

PROFESSIONAL EXPERIENCE

Confidential

Sr Oracle DBA

Responsibilities:

• Provided 24x7 on call DBA support for over 3500 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, and Solaris.
• Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
• Architect for the cross platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces (XTTS).
• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS), Datapump.
• Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Downgraded the 11g database during the version patch failures.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 11g/10g/12c RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• Configured Manager, Extract and replicat processes to set-up uni and bi -directional replication.
• Troubleshoot Golden gate on Oracle and sql server databases.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
• Configured the ACL’s and change the Character set of existing database during migrations.
• Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.
• Partitioned of large tables and indexes to improve performance, availability, creating and rebuilding the Indexes, database reorganization to improve performance of the queries and the database.
• Performed capacity planning, space monitoring like tablespace growth, ASM disk space.
• OS level activities like space monitoring of Mount point and relocating data files for better disk I/O.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Installation and configuration of Oracle APEX and worked with developers to design applications.
• Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA).
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl shell.
• Implemented the Transparent data encryption in oracle databse for datasecurity.

Environment: Oracle 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, Data Pump, TDE,Database design flow charts, ACL, OEM, RMAN, SQL*Loader, NETBACKUP, OLTP, Datacenter, SAN and NAS Migrations.

Confidential

Sr Oracle DBA

Responsibilities:

• Installed and configured RMAN for in 10g.
• Creation and setup of 10g Dev/TEST/QA environment from Production database
• USER Management: User Management (creation/updating) as per Database guidelines, USER access control, capacity planning for every 6months.
• Created Database status reports with the help of Automatic work load repositories .
• Modification of oracle parameters and also involved in the database startup/shutdown activities in a maintenance window.
• Taking Hot and Cold Backups, Exports etc.
• Excellent experience in database backup & recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Involved in Oracle database cloning and datapump activity related to refreshing schema using IMPDP and EXPDP.
• Applied CPU patching as per the patch releases quater wise.
• Monitoring the OEM alerts from OEM and fix the issues pernmatly.
• Installed 10g agents and start,restart,upload the agents when agents are down.
• Full database,Schema, Table refersh from Prd to nonprd using EXPDP/IMPDP.
• Monitoring the RMAN bavkups through 10g OEM.
• Involved in 10g RAC configuration, database,ASM installation.
• Configured the TAF(Transperent Application Failover) for Load balancing.
• Monitored the Voting disk, OCR files and its backup and recovery.
• Database migration from Non RAC to RAC environment.
• 24/7 oncall rotational shifts and resolved the tickets based on priority Sev1,Sev2.
• Decomissioned the oracle databases which are not required based on customer confirmation by maintaining the backup next 6 months .

Environment: Oracle 10gR2, RAC, Data Guard, Sun Solaris Servers, Linux, AIX and Windows XP.

Confidential

Senior Oracle DBA and Hadoop Admin

Responsibilities:

• Worked closely with Systems Analysts, Systems Engineers/Admins and Application Developers through the SDLC from Development to Production.
• Implementation of High Availability solutions with Oracle 12c RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.
• Efficiently performed installation, setup and creation of 4 node cluster RAC with Oracle 11g and 12.1.0.2 database using GRID infrastructure with ASM file systems on RHEL 6.X.
• Maintenance of Oracle 11g/12c Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Upgrade/Migrated applications/databases 10.2.0.4,11.2.0.3 on Solaris/AIX databases to Oracle 12.1.0.2 on Cloud/ Linux RHEL 6.x.
• Installed, configured and Oracle APEX in databases like Oracle 11g.
• Created Snapshot Materialized View for table replication, set up and monitored table level replication using Oracle Golden Gate.
• Performed various tasks in administration of databases including capacity planning, instance creation.
• Build Oracle Data Guard with high availability and performance configurations and participated in Data Guard Switch over and Switch back in 11g and 12c.
• Monitor and maintain system security and Auditing, supported SOX related auditing Controls.
• Design of databases following OFA: Creating Databases schemas, profiles, database links, Snapshots and Synonyms of objects as required to ensure data quality and security to comply with company's business rules. Oracle scripting in Windows/Linux and UNIX platform.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like AWR, and SQL Trace, TK prof, Analyze, ADDM and Explain Plan methods.
• Implemented Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Performed Logical Backups for Database migration using Data Pump, Export/Import and Transportable Table spaces.
• Set up 12C OEM Grid Control to monitor all databases centrally. Monitor health, availability, performance, cloned and schedule backups using 12c Grid Control.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 12c OEM as well as other third party tools (TOAD, SQL Developer).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Managed Oracle databases in very large (over 10 TB) and DB2 databases.
• Performed Database, schema and table refresh from Production to Test and Development environments using RMAN Duplicate, EXPDP/IMPDP, traditional export and import.
• Created and Scheduled jobs through Oracle DBMS Scheduler and Oracle CRON.
• Responsible for Creating and dropping of users, granting and revoking rights as and when required.
• Purging the 6 months old data from the database based on business requirements.
• Applied Quarter wise PSU patching in both standard alone and RAC environment in 11g/12c.
• Supported variety of hardware and software platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX and RHEL.
• Troubleshoot installation errors both independently and with Oracle support (via My oracle Support)
• Monitored and provided weekly reports on the server's memory, disk and CPU I/O using UNIX command-line utilities.
• Worked on Service Level Agreements (SLA’s) and to resolve the Severity 1, Severity 2, and Severity 3.
• Maintain and administer change management policies and updating the ticketing system using BMC Remedy.
• Extensive skills to configure and build one-way, two-way, active-to-active Oracle Golden gate Extract/Replicat for multiple databases.
• Strong experiences in configuration and building heartbeat monitoring in Oracle Golden gate. Develop flexible home-cooked Corn scripts to monitor the Golden gate lags.
• Configure error handling for Oracle Goldengate restart, logging, production support and status reporting.
• Hands-on experiences in trouble shooting and performance tuning Oracle Goldengate replications. Working with Oracle on SRs for critical issues.
• Primary technical resources to upgrade Oracle Goldengate from 11g to 12c in Exadata machine environment design Goldengate HA solutions by using Oracle 11.2.0.4 Cluster ware functionality.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Setting up High Availability Oracle Golden gate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack .
• Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC Hybrid Columnar Compression techniques.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Develop and record certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Solid Understanding of Hadoop HDFS, Map-Reduce and other Eco-System Projects.
• Installation and Configuration of Hadoop Cluster in all distributions like Cloudera, Hattenworks(Ambari),MAPR.
• Working with Cloudera Support Team to Fine tune Cluster.
• Plug-in allows Hadoop Map Reduce programs, HBase, Pig and Hive to work un modified and access files directly. The plug-in also provided data locality for Hadoop across host nodes and virtual machines.
• Developed map Reduce jobs to analyze data and provide heuristics reports.
• Adding, Decommissioning and rebalancing nodes.
• Created POC to store Server Log data into Mysql to identify System Alert Metrics.
• Rack Aware Configuration.
• Configuring Client Machines.
• Configuring, Monitoring and Management Tools.
• HDFS Support and Maintenance.
• Cluster HA Setup as per the business requirement.
• Applying Patches and Perform Version Upgrades.
• Incident Management, Problem Management and Change Management.
• Performance Management and Reporting.
• Recover from Name Node failures.
• Schedule Map Reduce Jobs -FIFO,FAIR share and Capacity scheduler.
• Installation and Configuration of other Open Source Software like Pig, Hive, HBASE, Flume and Sqoop.
• Integration with RDBMS using Sqoop and JDBC Connectors.
• Working with Dev Team to tune Job Knowledge of Writing Hive Jobs.
• Good working knowledge in Spark, Ranger Authorization.
• Working with data delivery teams to setup new Hadoop users. This job includes setting up Linux.
• Performing cluster/node migrations and upgrade (new hardware and/or new OS version And/or new Hadoop version) with OS or Hadoop tools or manually.
• Handling Ganglia & Nagios alerts to handle CPU, Memory, Storage and Network.

Environment: RHEL,HDFS (Cloudera, Hattenworks(Ambari),MAPR) HBase, CDH Manager, YARN, Hive, Pig,Sqoop,Flume. Oracle 12c/11g, RAC 11g, OEM 11g, Grid Infrastructure, Oracle, Grid Control, Performance Tuning, OSQ, Import/Export, Data pump, Oracle Data guard, PL/SQL,Toad, OEM, Putty, VM Ware, Unix Shell Script, Linux, Solaris, HP-UX, Secure Shell, OBIEE 11g, Windows NT, Golden gate and Exadata.

Confidential

Oracle DBA

Responsibilities:

• Provided 24x7 on call DBA support for over 3000 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, and Solaris.
• Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
• Architect for the cross platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces (XTTS).
• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS), Datapump.
• Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Downgraded the 11g database during the version patch failures.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 11g/10g/12c RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• Configured Manager, Extract and replicat processes to set-up uni and bi -directional replication.
• Troubleshoot Golden gate on Oracle and sql server databases.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
• Configured the ACL’s and change the Character set of existing database during migrations.
• Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.
• Partitioned of large tables and indexes to improve performance, availability, creating and rebuilding the Indexes, database reorganization to improve performance of the queries and the database.
• Performed capacity planning, space monitoring like tablespace growth, ASM disk space.
• OS level activities like space monitoring of Mount point and relocating data files for better disk I/O.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Installation and configuration of Oracle APEX and worked with developers to design applications.
• Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA).
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl shell.
• Implemented the Transparent data encryption in oracle databse for datasecurity.

Environment: Oracle 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, Data Pump, TDE,Database design flow charts, ACL, OEM, RMAN, SQL*Loader, NETBACKUP, OLTP, Datacenter, SAN and NAS Migrations.

Confidential

Oracle DBA

Responsibilities:

• Planned, Designed, migrated multiple Oracle 10g/11g databases.
• Installed, Configured Oracle 10g/11g databases on Red hat Linux environments and later Setup the data guard between primary and DR sites and migrated database from Solaris to RHEL5.
• Extensively used Data pump for migration of databases as well as for restoration of prod. Data into Dev/QA environments.
• Extensively used Oracle 11g features and implemented best practices in multiple applications.
• Supported production, QA & Dev oracle 10gr2/11gr2 databases.
• Managed Portfolio tool build project from Database requirements, backup strategy, storage requirements and implementing in Dev/QA/PROD/DR environments.
• Implemented and RMAN database backups (Disk & net backup tape) and restored as per special request.
• Implemented Database releases for multiple complex applications in various environments for multiple trading & equity applications.
• Implemented &supported Database security procedures for databases.
• Extensively worked on capacity planning & performance tuning of various applications and databases in securities domain as per change control process.
• Implemented and supported oracle 10g/11g Streams replication between different sites.
• Implemented various Backups in OLTP applications as well as restored from tape Whenever need arises.
• Pro-actively provided Database support to application developers as well as customers for troubleshooting as well as Improving performance of the applications.
• Migrated Oracle 10gr2 to 11gr2 in Solaris / Linux servers.
• Implemented Fog light across ML dev/qa/Prod servers for monitoring database servers.
• Extensively used clarity Grid app, autosys, crontab tools for installation & configuration as Well as administration of Oracle databases.
• Interacted & resolved issues with help of oracle customer support for TAR's raised in metalink.
• Troubleshooted Oracle 10g Production and development databases from user end to Database end on 24x7ENVIRONMENT: Oracle 11g / 10g / 9i, Grid Control, TOAD, UNIX HP, Red Hat Linux, Unix Sun Solaris 8 & 9 (Sun Fire 6800/6900),Microsoft Windows server 2008, SSAS,SSIS,SSRS, Oracle Data Integrator and ETL .
• Set up the 11g Uni directional replication for 11g databases.
• Monitoring the Ms Sql server databases on daily basis like Backup failures, space management, performance tuning.

Environment: Oracle 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, Data Pump, OEM, RMAN, SQL*Loader, NETBACKUP, OLTP, Datacenter, SAN and NAS Migrations MS SQL Server, Golden gate.

Confidential

Oracle DBA

Responsibilities:

• Responsible to Support the Production/Development databases that includes on site coverage and 24*7 after-hours coverage based on a rotating on call schedule.
• Maintenance of Production and Development Transaction and Data Warehousing databases.
• Used EMC BCV Sync& Split strategy for backing up and restoring the databases.
• Used OracleData Pump Utility for transferring the data from production to Lower environments.
• Troubleshoot problems using tools such as RDA, DBVerify, Oradebug, network diagnostic tools, etc.
• Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL batch queries. Regular scripts were run to monitor and manage space in Table spaces.
• Configured Table Partitioning using Range, Hash and Composite partitioning techniques.
• Splitting partitions, re-creating indexes, and analyzing indexes.
• Day to Day General Administration. Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Setting up and Managing Flash Recovery Area. Worked on 10g Flashback Technologies: Flashback version query, Flashback Transaction Query, Flashback Table. Configured and Enabled Flashback Database.
• Performance tuning with ADDM, AWR (Stats pack) and used Oracle Enterprise Manager (OEM) grid control for monitoring.
• Developed scripts to support and implement database builds.
• Regularly Gathered Statistics for Schemas using DBMS STATS.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Supported existing My SQL databases.
• Responsible for the database development and version control of the db deploy and builds.
• Developed PL/SQL Stored Procedures, Packages, Functions & Database Triggers.

Environment: Oracle 10gR2, RAC, Data Guard, Sun Solaris Servers, Linux, AIX and Windows XP, SQLT.