PROFESSIONAL SUMMARY:

• Professional and highly motivated having 9+ years of DBA, Golden Gate and Development work experience in the software industry with Oracle DBA (9i, 10g and 11g).
• Experience of Database Administration, design, development, maintenance and production support of relational databases, upgrade and migration.
• Installation and configuring of Oracle 9i/10g/11g on various platforms like LINUX,AIX,Solaris and Windows.
• Having knowledge in Oracle E - Business Suite R12 Applications Database.
• Configure and Implemented Golden Gate.
• Having good knowledge in Oracle Architecture.
• Involved in all phases of database development, from needs assessment to QA/QC, design and support.
• Train the new Recruiters.
• Tuning of the SQL Queries, which takes long time to process the request using Explain Plan,Hints to reduce the response time.
• Proficient in all DBA responsibilities such as backup and recovery of Oracle databases, user management (synonyms/privileges, roles, quotas, table partitioning, index), space management, monitoring (alert log, memory, disk I/O, CPU, network activity).
• Experience and implemented Industry level Backup strategies, Configured the backups in an optimal way so the load will be manageable and overcoming from backup hung scenarios.
• Applying PSU on all the production & development & ST databases on every quarter.
• Experience in Table space management both Local and Dictionary
• Implementation of Oracle Backup and Recovery strategies using RMAN (recovery manager) and creating RMAN scripts.
• Lead and provide knowledge expertise for Database Security requirements for team.
• Apply regular maintenance and critical patch updates in a timely manner.
• Experience in Active Database Cloning using RMAN.
• Created and maintained database refresh for Test/QA environments.
• Configured all types of DATAGUARD modes and ensuring high availability.
• Regular DBA Health Checks & Status of all the Instances on different Servers.
• Having experience in Oracle Real Application clusters (10G RAC) and Oracle11g.
• Very organized, versatile, self-motivated team player with strong analytical, relationship management and people management skills with effective written and oral communication skills.
• Ability to understand client’s business requirement and to provide practical solution as agreed with in the given time line to fulfill their requirements

TECHNICAL SKILLS:

Tools: Golden Gate, DBArtisan, TOAD, DBverify, RMAN, Export & Import, Data Pump, TKProf, Explain Plan, SQL* Loader, Clearcase and KintanaReporting Tools: AWR, ADDM, DBA Pool-Analyzer, Statspack, ASH

Utilities: PuTTY,JIRA

Operating system: RHEL 4/5, IBM-AIX, HP-UX

Database: Oracle 8i / Oracle 9i / Oracle 10g / Oracle 11g (Administration)

EXPERIENCE:

Confidential, NJ.

Sr. Oracle DBA/Project Manager

Responsibilities:

• Handling 300+ databases with 100+ Production databases including RAC databases.
• Performing installation, up-gradation and patching of Oracle Server software
• Worked in 24x7 production environment and provided on-call and day-to-day support.
• Configure and Implemented Golden Gate.
• Resolving the Issues and updating the Tickets status to the client
• Managing database servers and its availability
• Performed day-to-day operations like troubleshooting client connectivity, user / application errors, monitoring database growth, review of alert, listener and other logs, monitoring scheduled jobs that include statistics gathering, backups, snapshot refreshes etc.
• Perform logical and physical backups for recovery by using exp/imp,OS backups and RMAN tool.
• Created several databases manually and also by using DBCA tool for supporting Production/QA/Test and Development environments.
• Tuning of the SQL Queries, which takes long time to process the request using Explain Plan,Hints to reduce the response time.
• Applying security patches for DEV, UAT and PROD environment.
• Performing cloning and database refreshes as and when requested by users
• Automation of Monitoring alert log on time base for ORA errors, and space utilization issues
• Working on UNIX shell scripting for monitoring and scheduling backups at scheduled intervals and other jobs
• Taking backup of database using Logical (Export and Import), Physical (Hot and cold) Backups and using Recovery Manager
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
• Installation of RAC and Managing RAC Environment efficiently
• Working on database application and performance tuning
• Maintaining and monitoring database security
• Monitored the production Oracle alert logs for database errors.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Handling database change request from the application developers on need basis
• Troubleshooting database problems faced by the application developers/users
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Responding to alert mails
• Monitored system resource availability and responded to system memory and data issues.
• Creating technical documentation and imparting knowledge sharing within the team
• Raising TAR and consulting with Oracle Corporation as and when ever required

Environment: Linux, UNIX, Solaris, HPUX, AIX and Oracle 11g/10g/9i.

Confidential

Senior Oracle DBA

Responsibilities:

• Handled 200+ databases with 75+ Production databases (24 X 7) including RAC databases
• Supported various Oracle Database for applications such as SAP, PeopleSoft, JD Edwards and other in house application / Data Warehouses for NBCU
• Managed database servers and its availability
• Applied Security Patches for DEV, QA, TEST and PROD
• Performed Cloning and database refreshes as and when requested by users
• Worked on UNIX shell scripting for monitoring and scheduling backups at scheduled intervals and other jobs
• Taken backup of database using Logical (Export and Import), Physical (Hot and cold) Backups and using Recovery Manager
• Involved in performance tuning
• Maintained and monitoring database security
• Monitored the production Oracle alert logs for database errors.
• Implemented and maintained database security (create and maintain users, roles and assign privileges)
• Handled database change request from the application developers on need basis
• Troubleshooted database problems faced by the application developers/users
• Monitored and coordinating application outage activities
• Responded to alert mails
• Created technical documentation and imparting knowledge sharing within the team
• Raised TAR and consulting with Oracle Corporation as and when ever required

Environment: Linux, UNIX, Solaris, HPUX, AIX, Windows and Oracle 11g/10g/9i.

Confidential

Oracle DBA

Responsibilities:

• Installed oracle 8i/9i/10g on Linux/Windows
• Performed database refreshes using cold and hot backup
• Involved in database cloning
• Checked database health and ensured the database availability and monitored the database and User requests/Tickets
• Worked on Oracle software installation, created database creation and applied patches
• Took logical and physical backup
• Handled overall database activities such as creation of table space; users, schema, objects, defining role and access privilege for users
• Created technical documentation and thus imparted knowledge sharing within the team

Environment: Linux, Win 2000 and ORACLE 8.x/9.x/10g.

Confidential

Oracle DBA

Responsibilities:

• Managed and executed database change requests
• Handled database Refresh from production to development and support databases
• Performed Data transfer using Oracle transportable table space feature
• Involved in DBCC requests handling, batch job monitoring, database health checking, ensuring the database availability and monitoring the database
• Created roles and profiles
• Created the users with necessary privileges, roles, profiles and space quota
• Worked on Table space creation and maintenance support such as adding data files to the production, development and support and test databases
• Maintained redo log and archived log files
• Involved in index creation and rebuilding to improve the query performance
• Resolved row chaining and migration
• Handled Application level tuning (TKPROF/Explain Plan/SQL Trace)
• Monitored the CPU usage and IO statistics to identify any OS level Performance killers
• Involved in Space management on temp, data and index table spaces in all the production, support, development and test instances
• Handled Database change request from the application developers as when required
• Monitored and scheduled jobs
• Performed Troubleshooting of database problems faced by the application developers/users

Environment: Linux and ORACLE 8.x/9.x/9i

Confidential

Oracle DBA

Responsibilities:

• Created users and gave specific roles and privileges
• Monitored the database performance
• Designed Table spaces/Tables/Indexes
• Monitored the database growth and increased the table space size
• Performed logical backup (exports and imports)
• Collected statistics and analyzed the trend of database

Environment: Linux, Oracle 9i/8.x/7.x and Microsoft Windows NT 4.0

 Confidential

 Oracle Developer

Responsibilities:

• Set up and maintained documentation and standards
• Installed and configured Oracle 8/ 8i on Windows NT Server, personal Oracle 8 on Windows95
• Worked on stored procedures, packages and PL/SQL block coding
• Migrated user profiles from oracle 7.3 to oracle 8i and security management for 8i
• Created and maintained database objects

Environment: Windows NT/2000, Windows Advanced Server and Oracle 8.x/7.3