SUMMARY:

• Having 8.2 years of experience as an Confidential 12c/11g/10g/9i/8i DBA on different UNIX/Linux and Windows platforms advanced features including Confidential Exadata , Golden gate , ASM 11g/10g and Confidential RAC 11g/10g , GRID, Dataguard , Enterprise Manager.
• Worked as a Tech Lead, handled a team of 5 members.
• Experienced in handling Exadata Machines installation and configuration.
• Experienced in Patching Exadata components like compute nodes, storage nodes and Infiniband switches & virtual machines.
• Experienced in Virtual Machines administration in Exadata Machines.
• Experienced in monitoring configuration for Exadata Machine components with OEM 12c.
• Experienced in replicate data using Goldengate tool.
• Proficient in databases Performance Tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
• Handled RCA’s and produced results.
• Experience in fixing Confidential Networking issues.
• Fixing TNS Remote poisoning attack issues.
• Installation, configuration and administering Confidential Golden Gate replication
• Perform various tasks like installation, configuration, upgrades, migrations, patching, performance tuning, backup and recovery, production support cloning, space management, database security
• Implemented RMAN backup (Full, incremental) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Performance Tuning i.e. tuning applications, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Reorganization of tables, indexes, table spaces, data files, redo log files, and control file as per the requirements of the databases performance and space management requirements of the Servers.
• Experience in Partitioning tables and indexes.
• Successfully implemented physical standby database using Confidential Data Guard feature for High availability configuration
• Implemented the Golden Gate Unidirectional for reporting database
• Operational Responsibilities - Database refreshes / backups, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Configured/Implemented Database security using methods like wallet, TDE etc.
• Experience monitoring and managing the databases in OEM Grid Control (10g, 11g, 12c, 13c)
• Accessing remote database with DB link, HSODBC, ODBCINST and third-party tools.
• 24*7 production database support with Support to developers & end-users

Languages: SQL, PL/SQL, HTML, DHTML, Bash, Perl

Database: Oracle 9i, 10g, 11g, 12c, SQL Server

High Availability: RAC, Dataguard

Engineered Systems: Exadata

Replication Tools: Goldengate

Monitoring Tools: OEM, Grid Control

ERP: Confidential EBS

Operating Systems: HP-UX, Linux, Solaris, Windows NT, Windows 2003 and 2008 Server, Linux (OEL4)

PROFESSIONAL EXPERIENCE:

Confidential

DMA/ Senior Oracle DBA

Responsibilities:

• Experienced in handling Exadata Machines installation and configuration.
• Experienced in Patching Exadata components like compute nodes, storage nodes and Infiniband switches & virtual machines.
• Experienced in replicate data using Goldengate tool.
• Responsible for Exadata infrastructures, strategies, enterprise solutions, administrations.
• Defined and implemented HA/DR solutions using Confidential Data Guard, Confidential RAC for the
• Company’s mission critical applications to maintain business continuity.
• Looking in to day-to-day activities of Production database, monitoring its growth and performance.
• Experience in fixing Confidential networking issues.
• Fixing the TNS remote poisoning attack issues.
• Experience in Database security methods like TDE, wallet.
• Worked on Backup and Recovery strategies, improve database functionality, consolidate databases, and provide periodic health check to ensure your system is operating at maximum efficiency.
• Experience in installation, implementation, maintenance, and operations of middleware and related infrastructure components.
• Strong understanding in PL/SQL and SQL and able to write SQL query.
• Actively participate in developing Shell scripts to automate and monitor.

Environment: Exadata, GoldenGate, Oracle 10g, 11g, 12c, RAC, SQL, PL/SQL, Linux/Windows, RAC, RMAN, Confidential Enterprise Manager (OEM).

Confidential

Senior Oracle DBA, Tech Lead

Responsibilities:

• Worked as a Tech Lead, handled a team of 5 members.
• Involved as DBA for knowledge transfer activity.
• Maintained and monitored both Confidential and SQL server databases.
• Database support (Monitoring, Administration, and Tunings & Backup) in Confidential 10g, 11g, 12c
• Database up gradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g
• Responsible for implementation and management of Dataguard.
• Remote database administration of the instances
• Managed and maintained RAC databases.
• Looking in to day-to-day activities of production database, monitoring its growth and performance
• Experience on working on the DB’s hosted on Clustered Servers using Veritas
• Linux crontab configuration to automate the shell scripts
• Working on DR Drills
• Worked on partitioning of tables.
• Perform database software installation/patching/ upgradation to development, test and production servers
• Management of Confidential Instance, physical structure of the database like data files, redolog files, control files (mirroring of the control file) and storage management
• Creating users with restricted access, profiles and attaching them with users
• Working knowledge of ticketing tool (Remedy)

Environment: Oracle 10g, 11g, 12C, SQL, PL/SQL, Linux/Windows, RMAN, Confidential Enterprise Manager (OEM), Dataguard, Grid Infrastructure, SQL Server.

Confidential

Oracle DBA

Responsibilities:

• Migrated database of different release from Solaris to Linux
• Database up gradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g.
• Setting up Grid control 11gr2 infrastructure to monitor databases.
• Basic Unix Shell Scripting Knowledge (Actively participate in developing Shell scripts to automate the DBA processes for our Client for Service Improvement)
• Working on DR drill (RMAN and NetBackup tool)
• RMAN extensively worked on backup and restore strategies. Implemented backup and recovery of Databases using Recovery Manager, hot backups, cold backups and logical backups
• Create backup and verification policies
• Database support (Monitoring, Administration, and Tunings & Backup) in Confidential 10g, 11g
• Working knowledge on Data guard (Transferring log files from primary to standby database and manually applying the logs at standby side etc.)
• Analysing the segment fragmentation and re-organizing tables and partition tables
• Performing Archiving and purging activity as per the policy
• Performed database software installation/patching/up gradation to development, test and production servers.
• Performed RAC Installation and patching.
• Experience in administration and monitoring of RAC databases.
• Configuring ASM and creation of ASM database
• Interacting with the Confidential support ( Confidential Meta-link) and open the Service Request (SR) in case of major issues
• Raising TAR and coordinating with Confidential Support in resolving Confidential issues
• Creating users with restricted access, profiles and attaching them with users
• Monitoring the table growth, database growth, current users, and system resource usage and so on
• Configured listener.ora and tnsnames.ora as on when required for clients
• Generate Root Cause Analysis (RCA)
• Linux Redhat 4, 5 OS configuration and installation
• SQL script, cronjobs, ksh scripting, dbms jobs /dbms scheduler job setup
• Uploading/transferring by the help of SQL Loader, WinSCP, PSCP and other utilities

Environment: Oracle 10g/11gR2, SQL PLUS, PL/SQL, Solaris, Linux/ UNIX, Grid Infrastructure, Confidential Enterprise Manager (OEM). Confidential .

Oracle DBA

Responsibilities:

• Responsible for both manage and support all Production, Development and Staging Instances of Confidential Version 8i, 9i, 10g and 11g.
• Maintaining databases in 24x7 Production environment
• Monitor and troubleshoot various database remotely
• Also refreshing Database as per the requirements of the clients (CLONING, Export, Import, Datapump)
• Ensuring successful & periodical Backup & Restoration
• Develop, Implement and administer database policies and procedures
• Provide 1 st level technical support and assistance to all database end-users
• Install new versions of database software and perform maintenance functions of the database
• Reorganization of tables, indexes, table spaces, data files, redo log files, and control file as per the requirements of the databases performance and space management requirements of the Servers
• Database Backup Management using exports or online backups/Data Pump
• Monitoring the database for CPU utilization and killing unwanted user processes
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management
• Administrating Database in various platforms like WINNT 4.0 / 2000, SUN SOLARIS, and HP-UX & Linux
• Create new Databases, perform regular backups for all the database and main the DB’s
• Working knowledge of ITSM ticketing tool (Remedy 6)

Environment: Oracle 8i/9i/10g,11g, SQL PLUS, Unix/windows, Confidential Enterprise Manager, RMAN.