Summary

An Oracle DBA with around 5 years of IT experience in Oracle 11gR2, 10gR2, 9i, 8i 11gRAC, 10gRAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, streams, data guard etc. in a variety of environments like UNIX Solaris, HP-UX, AIX , LINUX Windows NT 4.0/2000/2003 in production, test as well as development databases.

Technical Skills

Experience Summary

• Involved in each phase of life cycle SDLC including requirement gathering, technical design, development, system integration phase, quality Assurance phase, development and production support activities.
• Experienced in using Oracle's Transportable Tablespace TTS to migrate Tablespace across Oracle databases.
• Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
• Full responsibility and expertise in database administration DBA , performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.
• Successfully developed and implemented Client/Server applications on multiple platforms. Actively involved in software development, implementation, software maintenance, software support, troubleshooting, documentation, training.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks
• Experience with IAM Solution, Oracle Identity Manager.
• Performed FLASHBACK features to handle efficient database recovery.
• Experience on ASM/GRID on 12C Real Application Cluster Environment
• Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.
• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents
• In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.
• Experience Designing Enterprise Security Solution.
• Experience with Radiant Weblogic Virtual Directory, Synchronization, and correlation server, etc.
• Knowledge of multiple Technology platforms and Architecture.
• Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN with VERITAS Net Backup.
• Hands on experience in Performance Tuning and Memory SGA Tuning by identifying top Sqls/Sessions and Tuning.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command.
• Hands on Design, implementation, Configuration, Integration and Deployment Experience Oracle ,Sun, WebLogic Technologies
• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.
• Experienced in loading data from flat files using SQL Loader and External Tables.
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Monitoring Reorganizing Tablespaces/Tables/Indexes.
• Skilled in using tools such as SQL Developer and TOAD.
• Replication snapshots/materialized views
• Bulk loads and data migrations using SQL Loader, data pump import/export
• Unix shell scripting Korn shell and Windows command prompt .bat .cmd
• Expert in RMAN backups including full, incremental and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Oracle Identity Management Architecture IDA

Professional Experience

Confidential

Role: Oracle Database Administrator

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX Database sizes range from 400GB to 20TB in ODS EDW environments .
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• Creating Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and Active Session History ASH .
• Big Data Administration/Engineering, EXADATA, NoSQL database servers
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning.
• Proactive Monitoring of database by checking Alert Logs Trace files.
• Provided support for both production and development teams in identifying and resolving performance issues associated with sql tuning using OEM and performance views.
• Experience in Database Cloning and refreshing using Data Pump Export Data Pump Import.
• Setting init.ora parameters, maintaining Data Files, Control Files, and Redo Log Files, managing Table spaces, segments, extents, indexes and managing Undo Data.
• Setup of High Availability of the database using RAC, and Data guard.
• Implemented and configured many Physical Standby Databases using Data Guard.
• Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Expert level skills in applying One-Off patches and Quarterly PSU's.
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting tuning of 10 Oracle databases 10g 11g single instances running on both IBM AIX 5.3, SunOS 5.8 HP-UX B.11.11
• Create oracle databases on configured servers using both the DBCA Database creation scripts.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tools TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle .
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM client , Oracle 11g database control SQL Plus, as well as pre-developed UNIX shell scripts.
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP FTP extensively for the File transfers from machines to remote server.
• Application of Oracle software patches when/where necessary.
• Backup/Recovery monitoring and reporting using both BMC Sql Backtrack as Oracle RMAN
• Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• Installed and configured 11gR2 two-node RAC on linux 5.1 for a high visibility project.
• Backup and recovery utilizing RMAN.
• Managing two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM reports for the Better performance.
• Performed HOT backup and COLD backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods.
• IBM TSM Tivoli Storage Manager install/upgrade from version 3.1.00 to version 4.0.10.
• Work closely with Systems Analysts, Systems Engineers/Admins Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering Server hardware/OS specifications for Oracle Installs , Database Designing Physical Logical and Implementation, database user creation and database access both at role table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.
• Tools Used: Oracle RMAN, Oracle 9i 9.2.0.8 , DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Role: Oracle Database Administrator

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC Real Application Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups hot cold in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance V dynamic performance views at peak load of the Databases and viewing Alert log files Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Role: Oracle Junior DBA

• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design Logical Physical of Databases
• Preparing Backup and Recovery Plan.
• Create oracle databases single instance on configured servers using both the DBCA Database creation scripts.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control SQL Plus, as well as UNIX shell scripts.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

Tools Used: Oracle 10.2.0.1, Oracle 9i 9.2.0.8 ,RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN