SUMMARY:-

• Accomplished Oracle DBA with 8 years of experience in Oracle Database Administration in large-scale production environments across multiple platforms Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup recovery Hands-on experience with Oracle Real Application Clusters RAC 10g/11g, Data Guard. Ability to work both as an individual contributor and as a member of a team
• Extensive experience in implementation, maintenance, installation, administration of Oracle databases 11g/10g/9i across various operating systems including Unix, Sun Solaris, HP-UX, RHEL and IBM-AIX
• Migrated single instance databases to multimode 10g/11g RAC environment for high availability and load balancing.
• Excellent experience in configuring and tuning of Oracle 10g/11g RAC, CRS and ASM for high availability databases.
• Installed and maintained Multi node Real Application Clusters RAC 10g/11g with through knowledge of Automatic Storage management ASM .
• Experience in the data Migrations using Data pump 10g, Export/ Import 9i
• Instance tuning including Shared Pool, Buffer Cache, Large Pool, Redo log buffer, Sort area rollback segments I/O, Query response time hit/miss ratio etc
• Delivering SQL and Database performance tuning services via V /GV views, Explain Plan, AWR statspack reports, ADDM, Tkprof, SQL Tuning Advisor, Oracle Enterprise Manager OEM , Grid control.
• Experience in writing UNIX SHELL Scripts to automate business process and daily backups, check the status, space management and performance of the database using the Cron utility.
• Created database objects like tables, indexes, synonyms, views etc. using SQL Plus, used SQL Loader control files to load data from external data sources into Oracle database.
• Proactive monitoring of database storage and performance. Troubleshooting through examining Oracle Alert logs, Trace files and Routine maintenance.
• Experienced in Oracle Support raising SR processes for technical requests through Metalink.
• Experience in fulfilling DBA daily activities, including schema management, user management creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence , space management tablespace, rollback segment , monitoring alert log, memory, disk I/O, CPU, database connectivity , scheduling jobs, UNIX Shell Scripting.
• Experience in design, creation and maintenance of the oracle databases.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases Data Guard .
• Installed and Worked on Oracle RAC- ONE NODE databases.
• Planned, implemented Backup Recovery procedures. Performed Backup Recovery activities using RMAN.
• Worked on 12C Enterprise Manger
• Solid experience in 10g/11g new features like Oracle Enterprise Manager OEM , Grid Control, AWR, ADDM, ASH.
• Experience in using oracle packages such as DBMS STATS, UTL FILE, DBMS JOBS and DBMS SCHEDULER
• Thorough Knowledge of the Oracle architecture, Oracle Memory Structures, Logical Physical structures.
• Knowledge in using Autosys for scheduling, reporting and monitoring jobs.
• Experience working with HOT Backups and COLD Backups
• Intermediate knowledge of Oracle Streams
• Knowledge of Extracting, Transforming and Loading ETL data using SQL Loader utility.
• On call 24X7 Production Support.
• Keeping the database upto date by applying the latest PATCH SETS using the OPATCH utility.
• Knowledge of Data Warehouse and OLAP and ETL procedures.
• Knowledge of Golden gate.
• Demonstrated ability to work well with a wide variety of people at various levels, faster co-operation and Collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed.

TECHNICAL SKILLS:-

PROFESSIONAL EXPERIENCE:-

Confidential

Oracle DBA Lead

Responsibilities:

• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Implemented the 2 Node Oracle 11g RAC on Sun Cluster and did all the trouble shooting to make the CRS and RAC Setup a stable one.
• Implemented the MAA Maximum Availability Architecture having 11g Physical Data Guard for 2 Node RAC System.
• Installed, configured and maintained Oracle 11g Software
• Installed 11gR2 11.2.0.3 Oracle Rac One-node on many servers.
• Upgraded existing Oracle 10g R2 databases to 11g R2 and above by applying the relevant patch sets.
• Developed shell scripts for RMAN and also designed the various test cases to test the effectiveness of RMAN backup and recovery strategy.
• Cloning of production database to the test environment using Recovery Manager RMAN.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility including the rolling patches for Oracle RAC databases.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager / Grid Control to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Developed Shell scripts for Alerts for ORA- errors, backup and recovery, Import and export procedure, Unix Shell scripting in ksh to be controlled from Crontab.
• Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
• Granting roles and privileges to end users
• Loading data into database tables using SQL Loader
• Participated in many DR drills for various applications.
• Performed Point in time recovery for the databases when requested during application upgrades.
• Worked on database creation and configuration, space management and other database maintenance procedures in a multiple oracle production and development environments
• Supported Automatic Storage Management ASM database and performed migration of normal database to ASM database using RMAN.
• Scheduled various jobs using UNIX Crontab utility.
• Experience in taking logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.

ENVIRONMENT: Oracle 10g/11g RAC, Sun Solaris 10, Suse Linux, HP-UX, Oracle Enterprise Manager OEM Grid Control, TOAD, FTP, putty, SQL Developer.

Confidential

Oracle DBA

Responsibilities:

• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.
• Configured and maintained 2 node RAC cluster.
• Setting the parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and managing Undo Data.
• Carrying out EXPORT and IMPORT operations on Oracle Database using the DATAPUMP utility.
• Monitoring the performance of the database using of OEM Oracle Enterprise Manager .
• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.
• Upgraded from Oracle 10g R2 to Oracle 11g R1 database
• Mentored and provided oversight and backup for the production Databases.
• Installed, configured and implemented 10g Dataguard as a physical standby database.
• Developed backup and recovery strategies with the use of incremental cumulative and differential backups using RMAN
• Involved in Capacity planning meetings operations.
• Automating the daily routine activities backups using the DBMS JOBS, DBMS SCHEDULER.
• Used Automatic Workload Repository AWR for analyzing the database performance.
• Use TOAD to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
• Automating the routine DBA tasks through CRON
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles for user actions in the database.
• Used Flashback feature to return database objects to a previous state.
• Communicated with Oracle support via the Metalink in order to troubleshoot important issues.

ENVIRONMENT: Oracle 10g and 11g, RHEL 4, HP-UX, Windows 2008, Oracle Enterprise Manager OEM, Toad, Sun Solaris

Confidential

Oracle DBA

Responsibilities:

• Provided 24x7 dedicated on-call support for both Production and development databases.
• Installation and creation of Oracle 10g databases on Production and Test Linux servers. Responsible for upgrade migrating databases from 9i to 10g.
• Refresh test database from production using Recovery Manager RMAN .
• Experience in using FTP utility program for copying files on UNIX and Windows systems.
• Handled configuration of database memory structure, storage allocation, user accounts, roles and privileges for database operations and security maintenance.
• Responsible for monitoring and estimating the size of the database growth, and configuring the database accordingly.
• Creation and maintenance of stand by database by using oracle high availability method Oracle Data Guard for Disaster Recovery.
• Developed backup and recovery strategy and taking periodic backups of the databases using RMAN.
• Tuned Stored Procedures, Packages, and Cursors for better performance of the database.
• Developed shell scripts for monitoring alert log, taking backups and timely execution of the jobs using crontab utility.
• Used Datapump to migrate the database across various environments.
• Applying patches to the database using opatch utility whenever required.
• Experienced in tuning SQL statements using Explain Plan, SQL Trace and TKPROF.
• Trained and Assisted Junior Members of the team.
• Monitored alert log file for sudden alerts and errors.

ENVIRONMENT: Oracle 10g, Toad 8.5, Windows XP, Sun Solaris 5.6, RHEL 4, Data Guard OEM, RMAN, Expdp/Impdp, SmartFTP, Putty.

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g databases on Sun Solaris Operation System.
• Implemented Real Application Cluster RAC Setup Administration using Sun Cluster.
• Supported different Databases like Production, Development, Testing, UAT and Training.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Designed Logical and Physical Modelling using C.A Erwin.
• Logical to Physical Transformation using Erwin
• Forward engineering using Erwin
• Reverse engineering using Erwin
• Model to model comparison using Erwin
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, table space, Control files, log files and user profiles
• Performed Backup and Recovery with export and import for non archive and archive database using RMAN, scheduled backup on Solaris NT environments using the incremental complete and full backup strategies based on the database purposes.
• Automated back-up procedures using crontab.
• Performed activities such as Query Optimization, Database Consistency Monitoring. Configured and managed replication server.
• Expertise in Installation, Configuration, Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance and configure database stand by database using Data Guard.
• Automated database backup using shell scripting.
• Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
• Worked on performance and tuning on SQL queries wherever it is required.
• Install OCI header files on Client Machines.
• Migration of database from one server to another server.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Rename the database and database SID.
• Create Directory in the database.
• Moving data files from one location to other.
• Scheduling Oracle Jobs in the database.
• Analyze the schema and tables.
• Finding average row length for all the tables in each schema.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Efficient in using the Oracle Tools like SQL Plus, SQL Loader, TKPROF, LOGMINER, STATSPACK, SQL Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter's.
• Develop table structures, PL SQL stored procedures and database triggers to implement.
• Responsible to provide 24 x 7 database administrative activities over different database servers

Environment: Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard, CICS business rules.

Confidential

Oracle DBA/Developer

Responsibilities:

• Created new Table Spaces, added Data Files and resolved Disk Contention Issues.
• Monitored, Allocated Share memory, Table space as needed and managed Replicated servers.
• Monitoring daily Hot Backups and weekly Cold Backups performed using RMAN.
• Monitoring inconsistency Issues long Transactions and Locking Issues.
• Monitoring Alert log file and Trace file.
• Performing analysis and diagnosis of Database Performance Statistics.
• Monitoring performance using Advisors, AWR, ADDM, SQL Tuning etc.
• Monitoring Online and Offline backups with RMAN as well as User managed.
• Schema and Table level replication using export/import.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Applying and monitoring Patches on Oracle 9i database.
• Responsible for granting required privileges and roles to users.
• Creation and maintenance of database objects.
• Managing table spaces, User Profiles, Indexes and Storage parameters.
• Scripting languages mainly HTML, XLML and JSP.
• Working as a Database developer, writing SQL Queries.
• Involved in developing and implementing PL/SQL functions, Stored Procedures and Triggers.

Environment: UNIX, Oracle 8i/9i, PL/SQL, SQL Loader, RMAN, Oracle Enterprise Manager OEM , Shell Scripting, Java, HTML, Oracle forms and reports 6i/9i.