SUMMARY:

• An experienced Oracle database administrator with leadership and management responsibilities dealing with production systems of large corporations is seeking an IT/Oracle DBA role. Highly skilled to address large scale business databases with in - depth knowledge on Oracle.
• Qualified to play an integral role in the field of information technology where talents and experience will contribute to achieving company goals
• Certified Oracle database administrator with seven (7) years’ experience in IT industry as Oracle DBA, Oracle 11gR2/10gR2, ORACLE RAC, System Administrator & Technical Architect in progressively complex environments.
• Experienced in Oracle database 10gR2/11gR2 installations, implementation, upgrades from 10g to 11gr2.
• Extensive knowledge on database administration for Oracle 9i, 10g & 11g 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, Oracle Application System Administration, configuration, performing Post Installation troubleshooting on Unix, Linux and Windows, Oracle database (10g,11g).
• 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
• Working experience with Very-Large databases (VLDB) up to 40 terabytes database with 38 servers including 6 Productions, 6 testing, 6 Development, 8 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
• Strong technical background in systems architecture, database design, and Database administration.
• Excellent communication and inter-personnel skills.
• Ability to work independently as well as in a team environment.
• Quick Grasping, Easily adoptable to any environment and tackling all challenges

TECHNICAL SKILLS:

Operating System: HP-UX 10.x, 11.x, Sun Solaris 2.5, 9, 10, Red Hat Linux and window NT 2000/2003/ XP

RDBMS: Oracle 10gR2/11gR2, RAC, Data Guard, Oracle StreamGolden Gate Replication.

Languages: SQL, PL/SQL, T-SQL, C, UNIX Shell Scripting, and PerlScripting

Software sApplications& Tools: DBCA, DBUA, Oracle Data Guard, OEM (Cloud Control 12c)ASM, Cluster ware, VCS, SQL*PLUS, SQL*LOADER, EXPIMP, (expdp, impdp), SAN, SQL TRACE, EXPLAIN PLANTOAD, TKPROF, STATSPACK, AWR, and ADDMSQL DEVELOPER. DATA PUMP. RMAN, INDEX UTILITY. ERWIN, SQL SERVER 2008/2012. ORACLE GOLDEN GATE.

Web Tools: HTML and XML, SQL NET.

PROFESSIONAL EXPERIENCE:

Confidential, New-Jersey

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
• Troubleshooting node eviction, checking CRS logs, VIP change, RAC service management, RAC database init parameters etc.
• 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.
• Verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out of space conditions.
• 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.
• Experience with using of Flashback technology and FAST RECOVERY AREA.
• Utilized RMAN for incremental, point-in-time recovery and full database backup including Recovery strategy and even performed cloning of database
• 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 and usage database and HFM/FDM applications.
• 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.
• Training and mentoring junior staffs on Oracle new technology tools and best practice.

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. Windows server 2005, 2008 and 2012.OEM Cloud control 12c. IBM AIX. SQL server 2012

Confidential

Oracle Database Administrator

Responsibilities:

• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle and managed disk groups.
• Administered Real Application Cluster (11gR2 RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS.
• 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.
• Monitoring and maintaining 2 node RAC database. Providing support to the development team and handling release schedules.
• 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.
• Identify and resolving the conflicts between the target and source database in Oracle Golden Gate
• 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.
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks
• And tapes using best business practices.
• Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose and troubleshoot both physical standby and logical standby in fail over capability.
• Write SQL scripts to monitor table space and extent growth and developed scripts to automate database operation and database monitoring.
• Export / Import of Tables, Schemas, Tablespaces and Databases Using Export/Import
• Utility and Datapump

Environment: Oracle 11g, 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, New- Jersey

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.
• Extensive documentation of all changes made in production and non - production environment.
• 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 coding, tuning SQL statements, troubleshooting problems and errors from database standpoint.
• 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.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Production, 6 testing, 6 Development and 3 Standby databases.
• 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, New-Jersey

Oracle Database Administrator

Responsibilities:

• Analyzing, designing, coding, testing and implementation of database structures such
• As Oracle 10g Database upgraded to Oracle 11g 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. Providing support to the
• Development team and handling release schedules.
• 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.
• Maintaining the tablespaces, log files, control files and data/temp files.
• Performed SQL Queries/ Application and Database performance monitoring and Tuning using various tools like ADDM, AWREnvironment: Oracle 10g/11g, Sun Solaris, Red hat Linux, VMware Workstation/ Windows XP RMAN, PL/SQL developer. SQL*Loader, SQL*Plus, Oracle Developer, Oracle RAC. SQL Window servers 2000/ 2005. OEM 11g

Confidential, New- Jersey

Oracle Database Administrator

Responsibilities:

• Monitoring Database and SQL scripting to generate HTML Based Daily Monitoring Report
• 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
• 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 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.
• Maintaining the tablespaces, log files, control files and data/temp files.
• Create and maintain shell scripts to take cold backup and RMAN Backup.
• Setting up Printers and Profile options.

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. SQL Servers 2000/ 2005. OEM.