SUMMARY

• Having more than 10 yrs of experience in Information technology with a strong success record in Database Administration, System Analysis Design,SDLC and Software Development.
• Strong knowledge and experience with Oracle 11g/10g/9i/8i/8.x/7.x RDBMS onUNIX/Linux/ Windows environment.
• Migrating and Upgrading the Databases between different environments and versions.
• Procedures using RMAN, VERITAS Net Backup.
• Excellent knowldege using Oracle Forms Developer 6/6i and Reports 6/6i.
• Ability to grasp and adapt new technologies and systems quickly. A commited team player.
• Knowledge and proven domain expertise in Energy Utility areas, Transportation and Policing.
• Certified Oracle 9i DBA, Certified Oracle Forms Developer Release 6/6i.
• Worked on more than 5 TB of Data.
• Installation, upgradation and maintenances of Oracle RDBMS on UNIX/Linux and Windows platforms.
• Backupof database Logical and Physical hot and Cold Procedures and also using RMAN.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation
• Extensively worked on Oracle Utilities Data Guard, Data Pump, Flashback, SQL LOADER and RMAN.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Experience in using GoldenGate to support data replication in the Oracle database environment.
• Recovery of database in case of database crash, disk /media failure etc.
• Database desing and Implementation.
• Implement and maintain database security create and maintain users and roles, assign privileges .
• Strong Exposure on High Availability Concepts RAC, Standby , Database Cloning, and Oracle Streams.
• Strong knowledge and experience of managing Oracle 9i, 10g and 11gR1, 11gR2 RAC environments using the OEM GridControl tools.
• Perform database tuining, application tuning and performance monitoring using STATSPACK, EXPLAIN PLAN ,TKPROF,AWR,ASH,ADDM report.
• Create and maintain documentation and standards.
• Capacity planning, capacity monitoring and management.
• Work as a part of team and provide 24x7 support when required.
• Load and extract formated data in and out of database ETL .
• Perform general technical troubleshooting and give consultation to development teams.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROFand ADDM reports.
• Experience in Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN.
• User requirement study
• Creating libraries for standard reusable procedures functions.
• Prototype devlepment based on the design specification.
• Designing various data entry forms.
• Design various custom reports and essential lexical reports.
• Installation and setting up the software for run time environment.
• Training the end users.
• Sytsem support modifications according to the user request.
• Writing data conversion procedures.
• Integrated testing of application.
• Installation and configuration of RAC10g 11g on RHEL/SLES.
• Shell scripts bash,bourne,csh,ksh,sh
• Professional Certification / Special Training and Education:
• Oracle Certified Professional OCP 9i Database Administrator.

TECHNICAL SKILLS:

• RDBMS : Oracle DB 10g / 9i / 8i / 8.0 / 7.x, SQL Server 2000 / 7, MS Access
• Middleware : Oracle 9iAS, Oracle Weblogic Server 10.3.3
• Operating System Sys Admn : Sun Solaris 10 / 9 / 8 Red Hat Linux 7.1 / 9.0, Novell Netware 4.x, Windows 2000
• Programming : PL/SQL, Shell Scripts ksh,csh , perl scripting.
• Tools : TOAD, OEM 10g, Oracle Developer Suite, Nimsoft, Unicenter.
• Hardware : Sun Fire, Sun Enterprise, Compaq, DELL Enterprise servers,
• IBM minis
• CASE Tool : Designer 2000 R 6i Knowledge of Process Modeler,
• ER Diagrammer,Database Transformer, Application
• transformer, Design Editor and Design Capture , power designer 15.1

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

• Responsibilities include supporting Verizon Wireless systems in a very large complex Solaris, AIX and Linux environment.
• POC for highly mission critical system and leading team of 5 DBAs.
• Providing 24/7 database administration support for 4-node Oracle 11g RAC databases in production and 2-node RAC in pre-prod, development, test, training and integration environment.
• Planned and rolled out Phase-I SOX database security compliance across the enterprise production systems.
• Supported Oracle quarterly rolling PSUs for RAC databases and OS patches.
• Leading IBM IIDR/CDC heterogeneous data replication - implementation, upgrades, support from/to DB2/Mainframe and Oracle.
• Built 3 node Oracle 11g RAC GI/ASM/DB on RHEL and configured application schemas, tablespaces and scripts for export and RMAN backup.
• Participated in Oracle SuperCluster/Exadata architecture, database consolidation, capacity planning, LDOMs and Zones for non-prod and prod systems.
• Configured unidirectional Oracle Golden Gate and supported Shareplex 3-way replication between Oracle databases in 3 data centers.
• Installed and configured 2-node Oracle 12c RAC.
• Coordinate, plan and implement monthly Enterprise Releases.
• Attend code reviews for Enterprise releases and weekly VCOPs changes.
• Presented IBM IIDR/CDC data replication and OEM 12c Change Management to EOS DBA group.
• Performance tuning explain plans, SQL tuning, SQL profiles, top activity, top SQLs, AWR global/diff, top events.
• Installed and configured Active Data Guard.
• Supported PCI Layer 3 migration including firewall rules testing.
• Implemented SharePoint ticketing system for DBA tasks and problem/incident management.
• Providing on-call support for Verizon EOS Oracle systems.
• Implementing CA's dSeries job automation for non-prod and prod Application related jobs.
• Configured RMAN Init level 0/1 backup policies and VTL/TSM backups.
• Supported ICONIC load testing and monitored database performance.
• Received Certificate of Appreciation for Outstanding Personal and Team Commitment from Verizon management.

Environment: Oracle Database 10g, 11g R1, 11g R2, Sun solaris 5.9 , Redhat linux AS 6.2, TOAD ver. 11.5. OEM 10g Grid, OEM 12C, dbArtisan,

Confidential

SrOracle DBA

Responsibilities:

• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• 24 X 7 Production Oracle database support, administration and on call rotation.
• Installation and configuration of oracle 10g and 11gR2RACdatabases.
• Upgrading databases from 10g to 11.2.0.3.
• Implemented Golden Gate replication solution.
• Configured initial and incremental load using golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate with zero downtime.
• Installed and configured Golden Gate director server/client for monitoring golden gate processes.
• Upgraded OWB repository from 10g to 11.2.0.3.
• Maintained and upgraded databases and software.
• Worked on rolling patch apply throughout the environment with no downtime.
• Monitored system resources and takes action to keep the system at optimal performance using Grid Control.
• Planned and implemented a backup and recovery strategy using RMAN and Data Guard.
• Worked on database refresh using hot backup and rman backups.
• Worked on SQL explain plans and query performance, session tracing.
• Application Tuning: Identifying the sql's causing I/O bottlenecks, sql's of high cost and giving recommendations to the development teams accordingly.
• Configured Oracle grid control to manage the entire database in single centralized location.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Implemented oracle high availability solution using Oracle Physical Logical Standby.
• Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance.
• Worked on schemas creation and maintaining large partitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Monitoring space requirement for production databases.

Environment: Oracle 10g/Oracle 11g/RAC, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard

Confidential

Oracle DBA

Responsibilities

• Provided support for all the databases as an operational database administrator
• Configuration and Creation of Databases
• Develop and deploy logical and physical test and production database solutions for Oracle 9i, 10g database and SQL Server 2005 Databases.
• Worked on recovering data files, control files, block corruption.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Involved in the maintenance of the database at Segment level, also user management activities depending on the data access requested by a specific user.
• Upgrade/Migrated the production and development databases from 9i to 10g,
• Installed Oracle 10.2.0.5 on Linux, AIX, Windows 2003 Server, HP-UX and Solaris.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs issues resolutions and personal research.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import move procedures.
• Installed and configured the Oracle Cluster ware cluster file system for RAC.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions.
• Taking periodic Backup of the Database and the software using RMAN.
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Scheduling jobs using Oracle Job Scheduler.
• Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Installation and configuration of Oracle Client software and Tools.
• Monitoring and Optimizing database performance.
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• SQL scripts to monitor Tablespaces and extent growth.
• System monitoring and maintenance to ensure the high availability.
• Generating administrating Reports of Database on free space statistics, cache statistics and database.
• Creating, altering and dropping data files, tablespaces, and schema objects in the database.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• OS level activities like space monitoring of Mount point.
• Storage Management, Managing Space, Tablespaces, Segments and Extents.
• Taking Hot and Cold Backups, Exports etc.
• Creating the database tables, setting privileges, indexes, user logins, passwords security .
• Responsible for monitoring daily and weekly backups, alert logs space.
• Resolving network related issues.
• Responsible for schema comparison using TOAD.
• Automated the process of analyzing tables every night.
• Installation and configuration of Oracle Client software and Tools.
• Worked with application developers in resolving application issues.
• Responsible for optimizing the queries and application tuning.
• Installed and Implemented Backup Recovery procedures.
• Proactive database monitoring using automated scripts based on v views.
• Developer Environments setup using database cloning.

Environment:Oracle Server 8i,Oracle Server 9i, Oracle 10g, SQL, PL/SQL, SQL Server 2000 2005 ,Linux ,Shell scripting.

Confidential

Oracle DBA

Responsibilities:

• 24 7 Production Database Administration Support
• Installation and configuration of Oracle Server software 9i and 10g
• Created Oracle 9i and 10g databases, allocated system storage and planned future storage requirements for the database.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers
• Automated hourly, daily, weekly system health reporting using crontab, PL/SQL and shell scripts.
• Developed UNIX shell scripts with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Created database links for accessing data from remote databases.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
• Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
• Implemented Recovery Manager RMAN . Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Implemented and maintained Database security.
• Created / Altered / Dropped Users as and when required and administer their respective quotas.
• Implemented cloning using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Created Database Links and Snapshots Materialized views .
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Configuring network components like TNSNAMES, SQLNET etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Performance tuning using AWR, TKPROF, EXPLAIN PLAN STATSPACK, AWR, ADDM
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: 10g RAC/Oracle 9i/Oracle 8i, Data Guard, HP-UX, Red hat Linux, RMAN, ASM, SQL Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential

Oracle DBA/Developer

• Involved in the process of tuning and refining queries of various applications.
• Prepare the documents of the process and knowledge transferring about the project tothe new team members.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Wrote scripts for Startup, Shutdown and automation of backups.
• Monitoring and Management of table space growth, extent growth.
• Storage and space management including table spaces and data files.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup recovery, space management in database, user and roles administration, schema management.
• Involved in 24x7 Oracle Production Database Administration.
• Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.
• Installed and configured Oracle 10g.
• Migrated Oracle 9i database to Oracle 10g.
• Monitoring Database for fragmentation and correcting them.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan
• Planning and implementation of Backup and recovery procedures and Maintenance of Database.
• Performed Backup/Recovery using RMAN.
• Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Interfacing with Oracle Corporation for technical support.

Environment:: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting