PROFESSIONAL SUMMARY

• Oracle DBA wif 8 years of Exposure on Production, Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.
• Learnt basics and teh architecture in Hadoop and teh Hadoop eco system
• Responsible for management and support of all Production and Development Databases. Actively participated wif teh design teams in planning hardware and teh software implementation for present and future needs of clients and teh company.
• Experience in Application Development, Database development and 24x7 production system support handling large databases using Oracle 12c, 11g, 10g, 9i on various platforms like AIX 7.1., Solaris /RedhatEL 7.0/ /UnixWare / HP UNIX and WinNT 2003/2008
• Experienced as an Oracle Senior DBA and proficient in Oracle 9i, 10g, 11g, 12c software installations, database Capacity Planning, Backup Implementation, Tuning Oracle 9i, 10g, 11g on UNIX, Linux platform and VERITAS cluster ware.
• Skills in High Availability technologies like RAC, ASM.
• Experienced in maintaining teh Replication of DB through Oracle Golden Gate.
• Experienced in maintaining Oracle Data Guard & Standby Database and providing critical solution wif strategic disaster recovery plans wif different recovery procedures and methods
• Involved in teh Database Cloning.
• Experienced in upgrading databases from 9.2.0.8 to 11.2.0.3 and 10gR2 to 11gR2 and 12c. Faced challenges in resolving issues while upgrade.
• Created Unix shell scripts for startup/shutdown, monitoring, backups and maintenance of database using Unix CRON.
• Skills in Oracle features like Data Guard, experienced in planning and implementing Disaster Recovery Strong interpersonal, time management and organizational skills. Proven team player wif strong ability to multitask and Working closely wif clients to provide delivery on time.
• Automated startup/shutdown scripts for Database applications.
• Provide technical support and assistance to all database end - users and Creating users, allocation to appropriate tablespace quotas wif necessary privileges and roles for all databases
• Skills in Oracle Installations and Upgrades
• Skills in RMAN utility, export-import, Data pump, OS backup for backup and recovery databases.
• Created User and Roles and granted appropriate Roles, Privileges and Profiles
• Maintained 500+ databases in 100+ servers of more than 10TB of DB space.
• Experienced in Incident Management, Change Management, and Problem Management.
• Implementing 4-eye check process in implementing scheduled Changes.
• TEMPHas effectively handled all of Customer/end user requests like user creation, refreshes & other L1/L2 tasks by strictly adhering to defined SLAs/SOWs.

TECHNICAL SKILLS

• Programming Languages: PL/SQL, C & Data Structures, Java

  Databases: Oracle 12C/11G/10G/9i, Teradata, MS Sql Server 2008

  Oracle High Availability: 10G/11G RAC, ASM, Data Guard, Golden Gate

  Oracle Tools: GUI,DBCA,DBUA,NETCA,OEM(10G/11G/12C),SCP

  Incident Management: Citrix, HP OpenView

  Oracle Utilities: Data pump, RMAN, export-import, srvctl, cluvfy, crsctl, olsnodes, ADDM, AWR, SQL*Loader, Toad, and tkprof

  Operating Systems: Windows, Mac OS, Linux, Sun Solaris, AIX, HP UX.

  Languages: SQL, PL/SQL, Unix Shell Scripting

  Other Tools: SFTP, XMANAGER.

  PROFESSIONAL EXPERIENCE

• Confidential, Stamford, CT, USA

  Senior Oracle and Golden Gate DBA

  Responsibilities:

  Environment: Oracle Golden gate, Oracle 12C Clusterware, OEM 12c, Oracle 11gRel2, Oracle 10g Rel2, OEM Grid Control, Oracle data guard, AIX 7.1, 6.1, crsctl, cluvfy, srvctl, oracheck, oswatcher, SQLTXPLAIN, Autosys.

  Confidential, Overland Park, KS, USA

  Senior Oracle DBA

  Responsibilities:

  Environment: Oracle 11g/10g, RMAN, RAC, Redhat Linux, Data Guard, IBM AIX Server Environment

  Confidential, Southlake, TX, USA

  Oracle DBA

  Responsibilities:

  Environment: Oracle 11g/10g/9i, RMAN, RAC, CRS, Linux, Sun Solaris, HP UNIX and Windows

  Confidential

  Oracle DBA

  Responsibilities:

  Environment: Oracle 9i/8i, HP-UX, Linux 7.3, Windows NT

  • Involved in analyzing teh AWR, ADDM, and ASH reports to make out teh performance issues in teh database and making teh changes respectively for teh continuous improvement.
  • Worked on performance tuning in teh production environment wif keen observation and continuous monitoring for teh better future of teh databases if any alerts or warnings raises due to customization in applications.
  • Auditing and performance of database in different situations
  • Involved in installing OSWatcher, Orachk, and TFA for teh better performance and monitoring.
  • Worked for teh RAC databases wif scan listener administration and infrastructure.
  • Performed teh RAC database build wif 4 nodes from development servers to production.
  • Involved in 12c installation and fixed all teh errors came across on linux environment.
  • Worked extensively on CRS communication related issues wif proper understanding.
  • Involved in ASM related issues and performed numerous number of tasks on adding/dropping disks to teh disk groups.
  • Raised so many SR’s wif oracle on various issues related to CRS and ASM.
  • Involved in migration of single instance database to RAC nodes on 11gR2
  • Written templates for teh upgradation of 11gR2 database to 12c
  • Worked extensively on database refresh from one environment ot another using RMAN and Datapump.
  • Involved in upgrading 10g database to 11gR2
  • Applied required patches from oracle metadata site as per teh organization requirement
  • Worked on Oracle GoldenGate to implement Change Data Capture(CDC) and replication between teh primary and secondary databases.
  • Involved in implementation of different high availability solutions using Oracle 11g RAC, Physical and Logical Standby database using Active Data Guard and Oracle Golden gate.
  • Performed GGSCI commands using teh utility ggsci to setup, manage, monitor and troubleshoot teh different components of teh Golden gate replication configuration.
  • Involved in making teh Golden gate parameter files for Extraction and Replication Setup for GoldenGate Database User wif necessary privileges
  • Performed RMAN duplicate database refresh multiple times and expertise.
  • Performed CORE DBA tasks such as Database Administration on Oracle 10g, 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
  • Implement physical database changes, testing, and performance tuning.
  • Plan and Design Backup/Recovery solutions using shell scripts and Import/Export.
  • Experienced in creating users and roles.
  • Handled database server tuning, application tuning, maintaining documentation and capacity planning.
  • Applied PSU and CPU patches for databases and on teh RAC nodes.
  • Created Tablespaces and data files and monitored them for any space issues
  • Configured LISTENER & TNSNAMES files & Troubleshooting
  • Rebuilt teh indexes to improve teh performance.
  • Security Administration including teh management of profiles, roles, users and their privileges.
  • Monitoring and maintain teh database using Oracle Schedulers, and Unix Cronjob scripts for package startup/shutdown and backups.
  • Monitored databases using oracle enterprise manager.
  • Applied BUG patches which are caused by Ora - 600 and Ora - 7445 and a few other issues.
  • Resolving teh locks on teh database.
  • Monitoring performance using AWR reports.
  • Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
  • Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas wif necessary privileges and roles for all databases
  • Communicated wif Oracle to get teh necessary patches required to fix up teh database changes needed using Oracle SR Support and coordinating teh patches and implementing teh necessary changes.
  • Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
  • Used RMAN scripts to take backup of teh ASM files and delete teh archive logs based on teh sysdate.
  • Performed switch over and fail over on Standby database.
  • Performed RMAN duplicate database refresh multiple times and expertise.
  • Performed addition of services using srvctl and modified a few services by concentrating keenly on monitoring.
  • Involved as an oracle database management professional and support over 400 Oracle database clients running on 9i, 10g, 11g.
  • Involved in regular day to day activities for production databases.
  • Installation of Oracle databases.
  • Applying PSU and CPU patches for databases.
  • Creating and managing Table spaces and data files
  • Configure LISTENER & TNSNAMES files & Troubleshooting
  • Rebuilding teh indexes to improve teh performance.
  • Security Administration including teh management of profiles, roles, users and their privileges.
  • Monitoring and maintain teh database using Oracle Schedulers, and Unix Cronjob scripts for package startup/shutdown and backups.
  • Monitored databases using oracle enterprise manager.
  • Resolving teh tickets by meeting teh SLA.
  • Refresh teh Database using RMAN and exports/imports.
  • Applied BUG patches which are caused by Ora - 600 and Ora - 7445 and a few other issues.
  • Monitoring teh CPU utilization and troubleshooting if it crosses teh threshold value.
  • Resolving teh locks on teh database.
  • Supported various Clients in assisting and resolving teh issues.
  • Created Quarterly Health check reports for production database.
  • Monitoring performance using AWR reports.
  • Used Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
  • Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
  • Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas wif necessary privileges and roles for all databases
  • Communicated wif Oracle to get teh necessary patches required to fix up teh database changes needed using Oracle SR Support and coordinating teh patches and implementing teh necessary changes.
  • Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
  • Used RMAN scripts to take backup of teh ASM files and delete teh archive logs based on teh sysdate.
  • Performed switch over and fail over on Standby database.
  • Audit of teh Data/Database objects for auditors.
  • Created Oracle best practices document, Database monitoring scripts used for day to day Monitoring.
  • Involved in installation and configuration of Oracle 8i/9i
  • Performed tablespace and user level tasks by monitoring for any kind of severity issues.
  • Responsible for configuration of client installations on teh client server
  • Worked on backup and restore activities on DR and standalone database servers
  • Management of users including creation, alter, grant of system/db roles and permissions on various database objects.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, daily maintenance activities and clearing up old alert log files which are no more necessary and occupies space.
  • Experienced in design & maintenance of Oracle Data Guard & Standby Databases.
  • Hands on experience in troubleshooting high availability scenarios involving Clustering, Database Mirroring, and Replication.
  • Involved in switchover activities communicating wif teh Apps DBA.
  • Involved in design and maintenance of Oracle Data Guard & Standby Databases.
  • Performed locking and unlocking of users when ever needed depending upon teh clients requirement.
  • Involved in teh tasks related to database refresh using exp and imp.