PROFESSIONAL SUMMARY:

• Work with a wide variety of tools and technology like Ansible, Puppet, Splunk, Nagios for monitoring of applications, backups and health of d Confidential base.
• Use Jira application to keep track of our activities and service Now ticketing system.
• Use of x - matter application for oncall rotation schedule.
• Hands on experience and knowledge in SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle d Confidential base and use of joins and cursors like explicit and implicit cursors.
• Migration of d Confidential base across and within the same platform using tools like transportable tablespace and d Confidential pump.
• Installation of Golden Gate and 11.2.0.4 on linux and configuring the necessary parameters.
• Implemented both unidirectional replication and bi-directional replicate using Golden Gate.
• Resolving abending issues like extract and replicat abend and handling collision issues and utilizing defgen utility.
• Configuring Golden Gate and 11.2.0.4 parameters for replication of tables like

TECHNICAL SKILLS:

D Confidential bases: Oracle 10g, 11g, 12c

D Confidential base Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/D Confidential Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, Remedy, Jira, Service Now, Xmatters, Splunks, Github, Nagios(NRPE monitor), Puppet, Ansible, APEX

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

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers, HP/UX-9000, Red Hat Linux 6.2, 7.3, Confidential DB2.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential

Responsibilities:

• Installed and configured Oracle 12c d Confidential base and oracle grid cloud control 12c to monitor all d Confidential bases.
• Installation of grid infrastructure including ASM and CLUSTERWARE software.
• Crating of oracle and grid account in our company 3 nod rac setup.
• Configured parameters for the unidirectional, Bi-directional replication, such as the manager process, extract, pump and replicat processes.
• Implemented both unidirectional replication as well as bi-directional replicate in Golden Gate and 11.2.0.4.
• Resolving network issues and abending issue in golden gate like extract and replicat abend.
• Have some hands-on administration on the unidirectional golden gate.
• Experience with sql server implement backup strategy and performing backup and recovering strategy.
• Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
• Installed and configured oracle Grid control (12c and 11g)
• Upgrade/Migration of D Confidential bases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Production support on a 24/7 on call support rotation and performing upgrades and applying quarterly patches (PSU AND OJVM)
• Production support on a 24/7 on call support rotation.
• Hands on experience and knowledge in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle d Confidential base.
• Migration of d Confidential base across and within the same platform using tools like transportable tablespace and d Confidential pump. create the wallet and append directory of wallet in sqlnet.ora configure ewallet using oracle wallet manager(OWM) rapki command to create wallets.
• Encrypt d Confidential at tablepace and column levels keys encrypt pen the wallet by connecting to the instance (alter system set encryption key identified by password)
• Encrypt backups by taking backup of the d Confidential base using d Confidential masking in 12c cloud for masking client information d Confidential .
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and windows.
• Performed installation, new d Confidential bases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and d Confidential integrity.
• Increased d Confidential base performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security
• Troubleshooting and debugging of PL/SQL codes for any bottleneck issues.
• Worked with T-SQL statements like DELETE and UPDATE statements and like BULK insert of d Confidential into the d Confidential ble.
• Used T-SQL and SSMS to perform backup (Full backups, Differential Backups, and Transactional log backups) and recovery on Microsoft Sql Server 2008, 2012.
• Exposure with monitoring tools like Solarwinds and Redgate in Microsoft Sql Server.
• Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of d Confidential bases and applications.
• Scheduled meetings with application team for d Confidential base migration review to gather legacy information such as type of application, d Confidential base options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the d Confidential base environments.
• Ensure d Confidential bases adhere to standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC d Confidential base on Red Hat Linux. Providing support to the development team and handling release schedules.
• Implemented ASM on RAC and stand-alone d Confidential bases. Managing disks and disk groups with ASM.
• Installed and administered Real Application Cluster (10g, 11g, 12C RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC d Confidential base; also, managed redo and undo in the RAC environment.
• Applied patches (PSU and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Involved in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified d Confidential base design document with detailed description of logical entities and physical tables.
• Up-gradation and Migration of D Confidential base from 10g to 11gand then to 12c and also applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the d Confidential bases.
• Worked on Automatic storage management (ASM) with EMC storage for managing d Confidential in SAN.
• Experience in Working with RAC D Confidential bases.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Responsible for setup and implementation of 2Node RAC on Confidential -AIX in log and 11gR2 using Veritas clusterserver.
• Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
• Implemented Point in time recovery using RMAN.
• Configuration and implementation of Oracle) for high availability.
• Performed Schema as well as Table Level Replication using Oracle Streams.
• Implemented downstream capture at the destination d Confidential base using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Tuning SQL queries when the performance is poor.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Installed the Oracle software using silent feature and also created d Confidential bases
• Worked on designing, installing & maintainingOCR, 11gRAC and D Confidential guardcomponents of Oracle.
• Supported& maintained the Production/Development d Confidential bases on various servers
• Extensively worked on setting up auditing in many d Confidential bases we supported
• Managing D Confidential base Structure, StorageAllocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated d Confidential bases from NON-ASM to ASM.
• Monitored different d Confidential bases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.

Oracle Administrator

Confidential

Responsibilities:

• Cloned/Migrated d Confidential bases using RMAN and traditional D Confidential pump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered d Confidential bases in case d Confidential base crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
• Installed and configured oracle Grid control (12c and 11g)
• Upgrade/Migration of D Confidential bases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the d Confidential integrity and security using integrity constraints and d Confidential base triggers.
• Provided 24X7 support for all the production and development d Confidential bases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios.
• Established and maintained comprehensive d Confidential model documentation including detailed descriptions of business entities, attributes, and d Confidential relationships.
• Created, documented and maintained logical and physical d Confidential base models in compliance with enterprise standards and maintained metad Confidential definitions for enterprise d Confidential stores within a metad Confidential repository.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using D Confidential pumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle d Confidential base.
• Expertise in implementing d Confidential refreshes (at d Confidential base, schema & table level) using RMAN utility and D Confidential pump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle 10.2.0.1 d Confidential base on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) D Confidential base and Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Successfully upgraded the d Confidential bases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB d Confidential bases to pluggable d Confidential bases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the D Confidential bases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of d Confidential bases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the d Confidential bases.
• Created Physical Standby d Confidential bases using RMAN with zero downtime, performed Failover and Switchover using D Confidential Guard Broker and manually as and when required