SUMMARY:

• An Oracle DBA with 7+ years IT experience in Oracle (11gR2, 10g, 9i) 11g RAC, 10g RAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, streams, Installation of
• Golden gate and OEM etc. spanning industries like banking, financial, Healthcare in variety of environments like UNIX, LINUX, Windows NT 4.0/2000/2003 in production, test as well as development databases.
• Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• M.S and B.E. (computer science) with 7+ years’ experience in the domain of database administration.
• Currently designated as an Lead Oracle DBA with Confidential ., Phoenix USA.
• Analyzing the type of oracle database required for the application(RAC/STANDALONE)
• Experience in installation, configuration, administration of Oracle 9i, 10g, 11g, 10g RAC, 11g RAC database in Unix/Linux and Windows environments.
• Installed oracle database server on HP - UX, Solaris, IBM AIX, Red Hat Linux environment.
• Experience in Real Application Cluster environment (RAC) with ASM and OCFS2 file systems.
• Analyzing the network VLAN requirement and firewall security ports from database perspective
• Building the Database Environments depending on the application requirement.
• Installation of Goldengate for the two way replication of real time data between the two sites.
• Installation of veridata application used for running the jobs to check the data consistency accros the primary and the secondary DB site.
• Creation of new user accounts, created profiles, roles and assigned them to different users
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Continuous research in leveraging new features of oracle and bringing them under day to day DBA activities
• Expertise in scheduling the jobs using Grid control.
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle Enterprise Manager.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE,11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experience in applying security patches to the databases
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Experienced in Oracle Support processes for technical requests through Oracle and other Support
• Demonstrated ability to work well with a wide variety of people at various levels, faster co-operation and
• Creating and monitoring the different tablespaces like user, Undo, temporary tablespaces
• Database Re-organization (database, Tablespaces, tables etc.). Re-org is done from time to time for the primary storage objects like tables.
• Conversion of Dictionary Managed Tablespaces to Locally Managed Tablespaces.
• Creation of new database links.
• Planning and Performing the Cold and Hot backup of the databases.
• Performing Logical backup using Export utility and recovering specific object or schema using Import utility.
• Performing Differential backups of the database using Recovery Manager (RMAN).
• Transported tablespace’s from production database and plugged-in it in development database for the usage of developers
• Upgradation of Oracle database 9i,10g to higher version.
• OEM installation: Installation of Oracle Enterprise Manager with the repository database and configuration of targets For database monitoring and administration.
• Making the Database architectural decisions for hardware and software requirements.
• Configured Data Guard (Physical Standby database) for the production database and tested for Switchover, Failover, Activating the Standby to Primary with No data loss
• Performed database cloning through Rman/Physical Backup.
• Knowledge on concepts and new features of Oracle 11g
• SQL Tuning using Explain plan, TKPROF with SQL trace

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 5.9,5.10,, AIX 5.1, 5.2, RHEL 5.6,5.8 and Windows 95/98/ME/NT/2005/2008XP.

Databases: Oracle 12c/11g/10g/9i, Oracle ExaData, Oracle Golden Gate

Programming Languages: SQL, PL/SQL, UNIX Shell ScriptingTools

ETL Tools: EM, SQL*Loader, TOAD, Hamerora,RMAN

DB Utilities: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROFESSIONAL EXPERIENCE:

Confidential

Lead Oracle DBA

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
• Analyzing the type of oracle database required for the application (RAC/STANDALONE)
• Worked on VISIO for defining the network diagram from Database perspective.
• Analyzing the network VLAN requirement and firewall security from database perspective
• Installation and configuration of the Database environments depending on the application requirement.(RAC/Standalone)
• Installation of Goldengate for the two way replication of real time data between the two sites.
• Installation of veridata application used for running the jobs to check the data consistency across the primary and the secondary DB site.
• OEM installation: Installation of Oracle Enterprise Manager with the repository database and configuration of targets For database monitoring and administration.
• Installation and configuration of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
• Creation of ASM diskgroups and adding asm disks in the diskgroup
• Creation of ACFS filesystem (ASM Cluster file system) using asmcmd, mkfs and acfsutil
• Configuring the Powerpath configuration for proper multipathing in RAC environment.
• Making the Database architectural decisions for hardware and software requirements.
• First in Confidential to configure the high availability service for Goldengate replication using VIP.
• Configured manual OEM agent installation for Automation of OEM agent installation through puppet.
• Achieved building all the Development, QA and Production database servers prior to the timespan provided.
• Proactively interacting with the System admins to work together for building all the environments.
• Proactively coordinating with the application and application DBAs team for getting the standards and requirements in place.
• Worked together with the Architects to get the firewall network setup from database perspective.
• Worked on Fixing of the TNS poison vulnerability for securing the DB environment on RAC and standalone servers.
• Implemented ASM on RAC. Managing disks and disk groups with ASM.
• Performed migration activities from 10g to 11g R2 for large databases.
• Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
• Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shooted database issues with OEM grid control.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Automated routine DBA tasks like backup’s and stats by using Grid control job’s
• Provided Assistance to application team at the time of SQL tuning in applications.
• Migrate 11g to 12c Database, Upgrade 11,2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog..
• Troubleshoot server and database problems to maximize database availability.

Environment: Oracle 9i/10gR2/11gR2/12c, RAC, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Lead Oracle DBA

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
• 24*7 production Support for mission critical production systems
• Installation of Oracle 8i/9i/10g/11g and database creation
• Implementing Security features as specified by the Client’s Security policy.
• Performing regular database backups
• Monitoring space, wait events, locks and long operations running on the database
• Monitoring the alert log for the database performance and resolving the performance issues.
• Partitioning big tables and Indexes for optimal performance
• Archiving the data from the tables and backing up the archived data for the Business requirement
• Generating statspack reports/AWR on regular basis to identify the database performance at peak load
• Tuning the SQL statement by analyzing the explain plan and ADDM reports
• Implemented scripts to monitor and get information on free space, alert log errors
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Managing Users, Monitoring sessions related to users specific, Sessions related to application specific for tuning the performance of the database.
• Configuring various cronjobs within the Oracle Server.
• Managing batch processes running against the database, Cron jobs placed within the oracle server.
• Migrating the data from one database to the other using Export / Import Utility.
• Scripting the Backup of Development and End-To-End Environment using RMAN utility on to Disk / Tape.
• Migrating the databases from one server to the other using RMAN utility.
• Duplicating the databases using RMAN utility.
• Configuration of OEM alerts & jobs for db
• Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux.
• Implemented ASM on RAC. Managing disks and disk groups with ASM.
• Performed migration activities from 10g to 11g R2 for large databases.
• Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
• Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shooted database issues with OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point) .
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Automated routine DBA tasks like backup’s and stats by using Grid control job’s
• Provided Assistance to application team at the time of SQL tuning in applications.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Analysing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT).
• Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.
• Additionally, part of rotation on call DBA to support databases 24X7

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control

Confidential

Lead Oracle database administrator

Responsibility:

• :
• Obtain and Maintain DBMS Software & Patches
• Oracle Database Upgradation 9i to 10g (10.2.0)
• Decommissioned of Databases.
• Oracle Client Installation on Solaris10, Linux & HP-UX.
• Manage ASM on RAC environments.
• Planning the Cold and Hot backups for the database
• Scheduling the rman backup jobs for the database in OEM
• Worked on the capacity planning for the database size/tablespace size
• Worked on user management, Tablespace management
• Extending the database storage capacity by creating new table spaces. Adding data files as per requirement.
• Managing Users, Monitoring sessions related to users specific, Sessions related to application specific for tuning the performance of the database.
• Create and managed the user profiles
• In depth understanding about the oracle architecture
• Worked on import/export of the database/schema
• Troubleshoot Error-07445 and 00600 errors with Oracle support
• Modify Static & Dynamic Parameters on RAC environments.
• Refresh database using exp/imp and Data pump.
• Remove audit logs older than 30 days.
• Interacting with Oracle Support for technical assistance requests.
• Configuring RAC for load balancing with other integrated applications.
• Create and relocate services in RAC.
• Managing Physical structure of Oracle database like Data files, Redo log file and Control files.
• Three Node cluster failover test.
• Worked on the RMAN database test on lower environment.
• Creation of standby database as per requirement and maintenance.
• Generated the AWR report for the analysis of performance and wait events on DB

Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control