SUMMARY:

• Certified Oracle database administrator with 8 years’ experience in IT industry as Oracle DBA, Oracle 11gR2/10gR2 and 12c ORACLE RAC, System Administrator & Technical Architect in progressively complex environments.
• Experienced in Oracle database 10gR2/11gR2 and 12.1 installations, implementation, upgrades from 10g to 11gr2 and 12.1
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g & 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems
• Experienced in Oracle installation, Upgrades, Cloning, Space Management, Performance Tuning, Backup and Recovery, Security Administration, Patching.
• Hands - on experience in upgrading/migrating the Oracle databases.
• Participate in the evaluation and recommendation of DBA tools and new DBMS technologies
• Extensive experience in Configuration of RMAN, Planning and scheduling Backups using RMAN, Hot Backups and Logical Backups, Oracle utilities and tools like OEM, Import-Export, Data Pump, and DBCA Installation, maintenance and tuning of RAC applications.
• Hands on experience of daily monitoring of Oracle instances and maintenance of databases using Oracle Enterprise Manager(OEM 12c), Oracle GRID and SQL*Plus Command line scripts
• Hands on in Oracle Golden Gate installation, configuration in Uni-directional mode, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Working experience with Very-Large databases (VLDB) up to 40 terabytes database with 38 servers including 6 Productions, 6 testing, 6 Development, 6 HFM/FDM servers 3 shared services, 3 web services.
• Experience in implementing, configuring and managing Data Guard with Physical Standby Databases for High availability configuration.
• Experience in performance tuning of database, memory & I/O using tools such as AWR, ADDM and analyzing queries.
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA view using EXPLAIN PLAN, SQL-TRACE and TKPROF
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player,Self-motivated, dedicated in any work environment
• Excellent communication and inter-personnel skills.
• Ability to work independently as well as in a team environment.

TECHNICAL SKILLS:

Operating System: HP-UX 10.x, 11.x, Solaris 2.5, 9, 10, Red Hat Linux, window & AIX

RDBMS: Oracle 10gR2/11gR2 and 12c, RAC, Data Guard, Golden Gate 11g

Languages: SQL, PL/SQL, T-SQL, C, UNIX Shell Scripting & Perl Scripting

Software s and Applications& Tools: DBCA, DBUA, Oracle Data Guard, OEM (Cloud Control 12c)ASM, Cluster ware, VCS, SQL*PLUS, SQL*LOADER, EXP, SANSQL TRACE, EXPLAIN PLAN, TOAD, TKPROF, STATSPACKAWR, and ADDM, SQL DEVELOPER. DATA PUMP. RMAN, INDEX: UTILITY. ERWIN, SQL SERVER 2008/2012, GOLDEN GATE 11g:

Web Tools: HTML and XML, SQL NET.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle database Administrator.

Responsibilities:

• 24 X 7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues. Monitoring and maintaining 3 node RAC instance on ASM clusters. Providing support to the Development team and handling release schedules
• Hand - on experience to perform Cloning of development & test databases from production using RMAN and traditional copy method from a local backup or an archived backup
• Hands on Experienced in day-to-day DBA activities including schema management (creating users, privileges, roles, quotas, tables, indexes, sequence), table space management (creating table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity, Unix file system), scheduling jobs, UNIX Shell Scripting.
• Hands on experience using Oracle enterprise manager cloud control 12c for overall database analysis including database performance and monitoring.
• Hands on experience using Index rebuild utility in Hyperion financial management application and analyzed critical tables to ensure good performance of database.
• Experience in Scheduling & automating back-end jobs using DBMS SCHEDULER package and CRON-jobs to run periodically as requested.
• Recommend and schedule SQL scripts to monitor table space and extent growth and developed scripts to Automate database operation and database monitoring.
• Proficient in ASM dick group and Capacity planning for database growth project. Make documentations of tablespace growth monthly.
• Used ADDM (Automatic Database Diagnostic Monitor) AWR (Automatic Workload Repository) for analyzing the database performance and tuning.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues - helping to transform business requirements into environment specific databases.
• Worked Closely with Oracle support in identifying some long standing issues and also extensively use of new oracle Metalink.
• Utilized RMAN for incremental, point-in-time recovery and full database backup including Recovery strategy and even performed cloning of database.
• Supported and resolved conflicting issues in Golden Gate replication in production and development databases.
• Established standards, policies and procedures for Golden Gate replication.
• Experience in implementing partial and full database replication using Golden Gate.
• Proficient in creating new Application for application team for data load/ test in production and QA environment.
• Experience in writing SQL script to monitor active user s login in database and HFM/FDM applications.
• Hands on experience to performed upgrades from Oracle 11Gr1 to 12.1 and applied patches
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Involved in both Functional and Technical lead for Oracle applications implementation and development projects.
• Schemas refresh using (Export/Import) Data Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins
• Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• Monitoring, Administrating & Troubleshooting for RAC databases, Resolving Performance Issues, Adding and removing Nodes, Non-RAC to RAC, RAC to Non-RAC, Tuning, Patching, up-grade, allocating space from ASM disk group to tablespace.
• Provide recommendation and implementation of Oracle new release and features on Oracle product for database and application. and mentoring junior staffs on Oracle new technology tools and best practice.

Confidential

Oracle Database Administrator.

Responsibilities:

• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle and managed disk groups Monitoring and maintaining 2 node RAC instance on ASM clusters. Providing support to the Development team and handling release schedules
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Create database Link that can be shared by multiple sessions using a single network connection from the source database to the target database.
• Hands on experience in code promotions from development to production databases.
• Ensured proper setup and maintenance of security and privileges granted to user and application in development and production database environments
• Performed troubleshooting of Oracle development databases from user end to Database standpoint.
• Hand - on experience to perform Cloning of development & test databases from production using RMAN
• Supported Golden Gate replication in production databases.
• Expertise in Oracle Golden Gate installation, configuration in Uni-directional mode, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Golden gate process monitoring scripts to track issues and implement required corrective actions.
• Created new Golden Gate processes for new tables, implemented DDL Replication between Source and Target Instances
• Data Replication using Golden Gate from source to target database.
• Provided technical assistance and professional direction to developers in coding and performance tuning actions where required.
• Resolved urgent technical issues under extreme time constraints ensuring the continuous and efficient operation of the databases with changing resource needs.
• Hands on experience in performance tuning of application, SQL analyzed access paths and indexes, monitored and tuned overall database performance using OEM 12c.
• Experience using enhanced features in OEM 12c like - Real Application Testing, Table and
• Partition recovery using RMAN, Invisible columns, DDL Logging.

Environment: Oracle 11gr2, Red hat Linux, VMware Workstation/ Windows XP. RMAN, PL/SQL developer. SQL*Loader, SQL*Plus, oracle SQL Developer, Oracle RAC, SQL Servers 2005.2008. OEM-12c, Oracle Golden Gate.

Confidential

Oracle Database Administrator.

Responsibilities:

• Creating and installing databases according to clients request for Organization standard. Create tables, table spaces, and data objects, setting privileges, indexes, user & password, Management, Security administration
• Implemented, configured, and managed databases in Windows Servers
• Management of Objects, Schemas, Partitioning the tables and Indexes
• Supporting everyday deployment of custom packages.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) Database instances
• Maintaining the tablespaces, log files, control files and data/temp files.
• Handling the tickets, supporting the users on various issues daily/ weekly.
• Extensive experience in planning coding and testing of PL/SQL code in an Oracle 10g and 11g databases.
• Gather statistics on a regular basis to provide the optimizer with information about Schema object.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues
• Experienced in managing, monitoring and troubleshooting SQL Server.2008/2005; Monitoring space and growth.
• Hand - on experience in performing full database recovery and Incremental recovery
• Using RMAN on a weekly request.
• Actively participated in team weekly meetings and exhibited excellent communication Skills.
• Writes recommendation and well versed in performing SQL tuning and Database Performance tuning been done based on reports generated by SQL Trace, TKPROF, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• 24x7 remote support and on call Database support for Database developers & end-users.

Environment: Oracle 10g/11g, Sun Solaris, Red hat Linux, VMware Workstation/ Windows XP.RMAN, PL/SQL developer. SQL*Loader, SQL*Plus, oracle SQL Developer, Oracle RAC.SQL servers 2005.2008. OEM 11g. IBM AIX.

Confidential

Oracle Database Administrator.

Responsibilities:

• Analyzing, designing, coding, testing and implementation of database structures suchAs Oracle 10g Database upgraded to Oracle 11gr1 Database
• Installing Oracle Database Software 10g/11g also cluster management and verifying
• Cluster process to ensure smooth operations.
• Monitoring Database and Monitoring scheduled daily autoclone.
• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring
• The performance of the database using of OEM, AWR Reports. Alert logs file.
• Monitoring and maintaining 2/3 node RAC database and providing support.
• Assists management in evaluating and overseeing implementation of changes/
• Enhancements to a database management system (DBMS) and alternative software
• Solution to achieve client and management objectives
• Creating users, roles and profiles, granting and revoking privileges and access for database object.
• Worked on modifying various database init parameters according to the requirements.
• Worked on database patching/upgrading.
• Worked on schema level backups and refreshes using exp/expdp, imp/impdp utilities
• Worked on recovery/refresh of a database when required using RMAN utility.
• Managed and participated in daily maintenance of table spaces and data files
• Participated in performance tuning of a database and data cleanup for optimal
• Performance
• Actively participated in team meetings and exhibited excellent communication skills.
• Creating users, roles and profiles, granting and revoking privileges and access for database object
• Create and maintain shell scripts to take cold backup and hot Backup.

Environment: Oracle 10g/11g, Sun Solaris, Red hat Linux, VMware Workstation/ Windows XP RMAN, PL/SQL developer. SQL*Loader, SQL*Plus, Oracle Developer, Oracle RAC. SQLServers 2000/ 2005. OEM.

Confidential

Oracle Database Administrator.

Responsibilities:•

• Taken backups of the entire database using RMAN utility.
• Managed and participated in daily maintenance of table spaces, data files.
• Created schemas, tables, table spaces, indexes and other database objects based on the
• Specific requirements.
• Worked on maintaining and updating the database schemas as requested.
• Worked on maintaining and correcting the table spaces and data files as needed.
• Worked on gathering statistics of a given schema; analyzing a particular schema
• Participated in performance tuning of a database and data cleanup.
• Handling backup / recovery of database and perform system file backups and restores.
• Troubleshooting database issues and performance problem
• Database Design, Tuning, Software Installation & Performance Monitoring

Environment: Oracle 10g, Sun Solaris, Red hat Linux, VMware Workstation/ Windows XP RMAN, PL/SQL developer. SQL*Loader, SQL*Plus, Oracle Developer, Oracle. SQL Server 2005