OBJECTIVE

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

Summary

• Certified Oracle database administrator with seven 7 years' experience in IT industry as Oracle DBA, Oracle 11g/10g, ORACLE RAC, System Administrator Technical Architect in progressively complex environments.
• Experienced in Oracle database 10g/11g installations, implementation, upgrades from 10g to 11gr2.
• Extensive knowledge on database administration for Oracle 8i, 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 and 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
• Installation and Configuration of Oracle databases 11g/10g, and SQL Server databases 2005/2008
• 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 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, 2.6, 8, 9, 10, Red Hat

Linux and window NT 2000/2003/ XP

RDBMS: Oracle 11g/10g, RAC, Data Guard, Oracle Stream.

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

Applications 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 .

Web Tools: HTML.

Professional Experience

Confidential

Oracle database Administrator

Roles and 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
• 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.

Roles and Responsibilities:

• 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.
• 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

Confidential

Oracle Database Administrator.

Roles and Responsibility.

• Maintaining the tablespaces, log files, control files and data/temp files.
• Supporting everyday deployment of custom packages.
• 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
• Performed conversion Non RAC single instance to Real Application Cluster RAC Database instances
• 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

Oracle Database Administrator.

• Maintaining the tablespaces, log files, control files and data/temp files.
• Creating users, roles and profiles, granting and revoking privileges and access for database object.
• Monitoring Database and Monitoring scheduled daily autoclone.
• 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.
• 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
• Performed SQL Queries/ Application and Database performance monitoring and
• Tuning using various tools like ADDM, AWR,

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

Confidential

Oracle Database Administrator.

Roles and Responsibility

• Monitoring Database and SQL scripting to generate HTML Based Daily Monitoring Report
• Actively participated in team meetings and exhibited excellent communication skills.
• Performance
• Participated in performance tuning of a database and data cleanup for optimal
• Worked on gathering statistics of a given schema analyzing a particular schema.
• Worked on maintaining and correcting the table spaces and data files as needed.
• Worked on maintaining and updating the database schemas as requested.
• Managed and participated in daily maintenance of table spaces and data files
• Worked on recovery/refresh of a database when required using RMAN utility.
• Worked on schema level backups and refreshes using exp/expdp, imp/impdp utilities
• Worked on database patching/upgrading.
• Worked on modifying various database init parameters according to the requirements.
• 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.