SUMMARY:

• 12+ Years of experience in IT Industry as an Oracle Database Administrator on different flavors of UNIX and Windows environments
• Experience as a Sr. Oracle DBA, Sr. Oracle consultant, Tech Lead and Management level.
• Installed Oracle Golden Gate, Oracle 12c Database, RAC 12c/11g/10g, Oracle 13c/12c OEM, created new user, tablespace, datafiles, Backup with Data Pump, HOT & Cold BACKUP, RMAN BACKUP, .
• Installation experience in Oracle 13c,12c,11g,10g,9i OEM, ASM, Data Guard, Administration & Managed Oracle RAC 12c/11gR2.
• Experienced as Oracle DBA in production, development and test environments
• Installed and Configuring Oracle11g grid and Data Guard maintenance in large environments.
• Creating database and database objects like table, index, table space, rollback/undo segments and views and analyzed relevant objects to collect statistics to tune the database performance.
• Performing migration and up - gradation of databases to Oracle 12c,11g and 10g and multiplexing of control files and redo-logs, Used SQL*LOADER for data loading, logical backups- Import/Export and DPUMP.
• Constructing catalog databases and developing scripts to perform the backups of large databases with RMAN. Detecting and diagnosing the production issues to improve system performance, SQL tuning, Experience with STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and TKPROF
• Experience in Oracle Golden Gate installation ver-11g/12c, configuration and troubleshooting Golden Gate issues, implemented uni and bi-directional process.
• Interacting with the Oracle support on Service Requests and implementing the solutions for successful completion of the tasks.
• Worked on TOAD, SQL Developer, VLDB, Table Partition and troubleshooting.
• Worked in UNIX (Sco HP UNIX, AIX, Linux and Sun Solaris), shell script, CRONJOBS Script, Linux & Solaris installation.
• Worked on Outlook express, Lotus Notes, Tivoli and BMC Remedy (IBM).
• Strong technical and analytical skills, interpersonal and communication abilities.
• Consistently maintain a positive attitude, work well under pressure, a team player and quick learner.
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS:

Database Developer: Well understanding AWS, PL/SQL, Procedure, Function, DML, DDL and developed scripts

Databases Admin: Oracle 9i/10g/11g/11gR2/12c/13c, RAC/ Data Guard, ASM, Golden gate and Managed SQL server

Tools: EXP/IMP, Data pump, RMAN, OEM, TKPROF, EXPLAIN PLAN, ASH,AWR,ADDM, SQL Developer,, SQL*Loader, TOAD, SQL Developer, OEM, Oracle agent, Database security, Audit table and VM ware.

Platform: Sun Solaris, Oracle Linux, Redhat 6/7, AIX, HP Sco open server and Windows.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Oracle DBA

Responsibilities:

• Installed Oracle 12c, RAC, standalone server with ASM 12c and OEM 13c on Linux platform.
• Created PDB/CDB new databases, schemas refresh- Data Pump.
• Used tools for Oracle SQL tuning - OEM, AWR/,ADDM,ASH and EXPLAIN Plan
• Designed Database Architecture (Logical / Physical)
• Schemas objects dropped and created new objects as per application requirement.
• Resolved - RMAN backup back up failing issues, RMAN performance tuned & ASM configuration issues etc.
• Handling databases issues, RAM decreased from 32 GB to 8 GB, Listeners Issues etc.
• Converted CDBs databases to non-CDBs Oracle 12c.
• Discuss ongoing issues with the client according to application team feedback.
• Frequently involved in meeting with client and teammates.
• Taking Initiative to share the problem with team member and advice to teammate for the correct solution.
• Reduced dramatically Admin alert issues, adding datafiles & related issues; creating new Tablespace, users, patch, performance tuning. etc.
• Modifying and writing new shell scripts, crontab, High usages of CPUs, indexes, Patching & long queries.
• Ongoing proactive database-level performance tuning and pro-actively monitor database systems to ensure secure services with minimum downtime
• Managed database objects in a large critical system and provided end to end DBA support and application side
• Analyzed and resolved complex technical problems regarding the integration of object- oriented applications and infrastructure with relational database technology.
• Monitored databases and performs tuning enhancements to optimize their performance. Developed and maintained utilities to automate problem determination, change implementation, and monitoring activities.
• Helped the team to use existing infrastructure to achieve maximum benefit to reduce cost and maximum performance.
• Changes were made dynamically whenever possible to fulfill high-availability requirements
• Was responsible for implementation and release of database changes as submitted by the development team.
• Interacted with development teams, business owners, and various levels of management.
• Coordinated all Oracle system changes with the Operational DBA teams.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Checking Automatics status of Data Guard synchronization, deleting old archive logs on standby server, sending alert email to team as a proactive alert.
• Synchronized the Data Guard to removing GAP / rebuild Data Guard from scratch.
• Tested DR drill and shared document with team.
• Frequently involved in Emergency & High priority tickets

Environment: Oracle 11g/12g/13c/ Golden Gate /RAC/ ASM/Data Guard environment, GoldenGate Linux (24x7)

Confidential, Woodlands Hills, CA

Sr. Consultant

Responsibilities:

• Oracle installed 10gR2 / 11gR2 RAC, ASM and Data Guard on new servers
• Installed Oracle Clusterware, RAC administration and OCR backup.
• Configured RMAN, Import & Export and DATAPUMP.
• Designed Architecture physical and logical.
• Data migrated (used Import & Export and Data pump utility) from Oracle 8i, 9i to 11gR2
• Created new users, roles and maintained database security.
• Created shell scripts and CRONTAB automating backups.
• User security & database security, USERS Management, DDL & DML statements.
• Managing TABLESPACE, adding datafiles, Redo log, UNDO & Control file management.
• Tuned SQL queries using TKPROF, Analyzer (Monitor USAGE), AUTOTRACE and EXPLAIN Plan.
• Troubleshoot and changed CHAR to byte as per application requirement.
• Managed TABLESPACE, datafiles, and Redo log, Recovered user table with FLASHBACK.
• Generated and analyzed STATSPACK / AWR / ADDM reports and monitored statistics for performance tuning of the database,
• Provided 2nd/3rd level support, including on-call support through rotational basis.
• Diagnosed and remedy Oracle database problems, following company incident management process.
• Complete support and handling of various internal Trouble-ticket work requests.
• Provided support of Oracle partitioning, maintenance, and monitoring of Oracle databases.
• Provided schema management for objects such tables, views, indexes etc, and meet internal database standards.
• Installed and administer Oracle OEM Control.
• Provided support Oracle databases through TOAD and Oracle Enterprise Manager (OEM).
• Configured/trouble-shoot Oracle connectivity/communication software.
• Day to day activities, Follow up with clients and resolving database issues.

Environment: Oracle 9i/10g/11g RAC/ ASM/ Data Guard environment, SunOS (24x7)

Confidential

Oracle DBA

Responsibilities:

• Backup, recovery and configuration of RMAN catalog.
• System tuning & SQL tuning with EXPLAIN, AUTOTRACE, TKPROF, Analyzer Monitor Usage and CBO.
• USED STATSPACK and ADDM/AWR.
• Planned the size of Database and used Oracle Enterprise Management (OEM)
• Used SQL Loader, External Table and Data Pump
• Responsible for the physical, logical database design, data conversion
• Managed TABLESPACE, Redo log, UNDO & Control file management.
• Database Management: Physical and Finance Database eliminated duplicate records.
• Created UNIX shell script, new user, Indexes and maintained security.
• Maintained duplicate record writing script in SQL, Tables, indexes and procedures.
• Performed Regular checkup of production and test databases and performance of Oracle application system.
• Was responsible for implementation and release of database changes as submitted by the development team.
• Interacted with development teams, business owners, and various levels of management.
• Provided support 24x7

Environment: Oracle 9i, AIX and 10gR2 and Linux (Red Hat)

Confidential

Oracle DBA

Responsibilities:

• Oracle Database Management and Inventory Management.
• Installed Oracle 9i and 10g on UNIX platform.
• Created new users, schema, roles, Index and maintained old indexes.
• Data manipulation and change the price of items through SQL.
• Developed new procedures, Function, Package, Database triggers and maintained SQL scripts.
• Maintained backup through (hot & cold backup) and shell script.
• Configured STATSPACK on Oracle 9i.
• Backup (import and export), Recovery and load data from flat file through SQL*Loader.
• Developed new reports; old rates and new rates, stock & sales status, dead inventory and
• Developed new script for data query using SQL; daily, weekly, monthly and yearly sales report.