SUMMARY

• Over 8 years of experience as Oracle DBA in very large Production Environments with Database implementation on UNIX (Solaris, IBM - AIX, HP-UX, Linux) and Windows.
• Over 10 years of experience as an IT professional.
• Extensive experience in databases on Oracle 8i, 9i, 10g / 11g R2,12c
• Experience in Installation and configuration of Oracle 10/11g Real Application Clusters (RAC)
• Experience on working Exadata.
• Experience on OEM, Database Control, Grid Control
• Experience in data transfer utilities like SQL*loader, Data pump and import/export.
• Upgradation of database from Oracle 9i to Oracle 11g R2 and 11g to 12c.
• Experience in handling recovery issues using Oracle Flashback Technology.
• Configured ASM for Oracle databases.
• Performance Tuning experience using Explain Plan, Autotrace, TKPROF and Statspack utility and Tuning database using ASH, AWR, ADDM.
• Experience on Adding and removal of nodes in RAC environment
• Proficient in building and handling databases on Oracle 11g RAC and Dataguard.
• Familiar with many 11g and 12c new RAC features.
• Experience on Backup and recovery, duplicate database using RMAN.
• Extensive experience in database cloning and refreshing.
• Experience in Toad for database maintenance tasks
• Additional responsibilities have been Interaction/Communication with Oracle for Technical Support and handling day to day problems, assisting developers and other users in writing complex queries.
• Knowledge about PERL and Shell Scripting.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Automated Storage Management (ASM) for 10g, 11g and 12c databases.
• Experience in setting up Grid Control.
• Comfortable with both command-line and GUI interface.
• Hands on experience in implementing 11g Oracle Golden Gate.
• Oracle Database Appliance experience.
• AWS S3 cloud backup and restore experience.
• Experience working with teh scrum teams.
• Experience creating AWS oracle RDS databases and managed, refreshed oracle RDS databases.
• TDE Wallet Encryption experience and applied GDRP practices on variuos platforms.
• Oracle Backup and Recovery (Cold backup / Hot backup / RMAN backup).
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Extensive experience of Oracle memory management and setup of oracle HugePages for large SGAs.
• Experience in Application tuning using session trace file and TKPROF utility.
• Experience on Atlassian technologies like Bamboo,Stash,Jira and Confluence.
• Hardworking, result oriented good interpersonal and communication skills.
• LDAP directory server, used for storing data. Oracle unified directory (OUD) experience.
• Set up teh proxy servers and worked with system admins to set up teh Replication Gateway
• Activce directory, Windows Servers, Exchange, Storage experience.
• Experience as Informix DBA in large production environment on Unix environment.
• Experience installing, managing and upgrading MySQL databases.
• Worked on different change management tools.

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10g, 11g, 12c, Informix, MS SQL Server 2000/2005/2008 , MS Access, MYSQL, AWS RDS

Database Technologies: RAC, Dataguard, ASM, Import/Export, Datapump, SQL*Loader, Statspack, ASH, AWR, ADDM, SQLT, Oracle Scheduler, TKPROF,ADRCI, Data Pump,RMAN, Flashback, S3 Backup, GoldenGate, DataGuard, ODA, Oracle Streams

DB Management Tools: OEM, Toad, Cron jobs, SQL*PLUS, SQL Developer, DBVisualizer, GIT. DBVisit

DBMonitoring Tools: OEM, Foglight, Spotlight, vRealize Hyperic, VictorOPs

Operating System: Red Hat Enterprise Linux, Sun Solaris, AIX, UNIX, MS DOS, Windows 98/NT/2000Languages SQL, PL/SQL, UNIX Shell, T-SQL, C, C++, PERLWeb Server/Tools IIS, Websphere, HTML, XML

Documentation Tools: Confluence, JIRA, Bamboo, Stash, BMC Remedy,Snow Tool, Zoom

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Production DBA/Sr. Oracle DBA /MySQL DBA

Responsibilities:

• Created RAC clusters
• Upgraded databases from 11g to 12c and created and managed multiple 12c databases.
• Created, installed and upgraded MySQL databases
• Monitored performance of MySQL databases and migrated from Linux to Windows machines.
• Performed MySQL database copy/refresh
• Migrate from standalone servers to RAC cluster.
• Extensive experience in Information Technology in ODI 10g &11g (Oracle Data
• Integrator).
• Worked on technologies like Oracle, Oracle Data Integrator.
• Created Data Guard for RAC Environments.
• Installed Golden Gate for real-time uni-directional replication.
• Develop RMAN scripts for backup and recovery of databases.
• Design, document, implement and maintain all work.
• Refreshes and restores on daily basis.
• Rebuilding of indexes on monthly basis.
• Helped network and system admins during weekly maintenance.
• Created cron jobs for full and incremental backups, cold backups, purging, cleanup and refreshes.
• Provided user management support.
• Installed, configured and troubleshooted GoldenGate for WMS and JMS services.
• Retrieved and analyzed database health check reports (ASH, AWR, ADDM)
• Created company's data guard documentation and created physical standby and active DG
• Perform Backup and Recovery thru RMAN.
• Configured, troubleshooted GoldenGate configuration on a JMS services
• Installed configured different GoldenGate versions.
• Full fill developers request to refresh schema's on a daily basis.
• Worked with Oracle in troubleshooting issues.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Worked on configuring Oracle 11g two node RAC database on ODA Oracle Database Appliance
• Troubleshoot network and performance issues
• Provided on-call support on rotation basis.

Environment: Oracle 10g, 11g on RAC, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP UNIXDataguard, Golden Gate, Production support on RHEL/Solaris, Microsoft

Confidential, California | CA

Primary DBA

Responsibilities:

• Experience in providing 24X7 on-call support to maintain all Databases up and running in Production environment
• Provided primary administrative support for Oracle 10g/11g databases in UNIX and WINDOWS environments.
• TDE encryption (Wallet encryption) experience for 11g and 12c and enabled encryption on tablespace, table and column levels.
• Supported Exadata and ZFS using ASM storage.
• Configured and managed AWS/S3 backups.
• Worked with third party backup tools like DDBoost and NetBackup.
• Migrated databases to Amazon (Zero-Downtime Migration) including Data Replication.
• Used diffeerence tools/strategies to migrate Oracle databases including AWS DMS, RMAN, Data Pump Export and Tsunami UDP.

Environment: AWS,RDS,Linux,GoldenGate, DataGuard, Streams,Upgrades

Confidential, Chicago, IL

Production DBA/Sr. Oracle/MSSQL DBA

Responsibilities:

• Experience in providing 24X7 on-call support to maintain all Databases up and running in Production environment
• Provided primary administrative support for Oracle 10g/11g databases in UNIX and WINDOWS environments.
• Oracle Audit Vault experience.
• Supported Exadata and ZFS using ASM storage.
• Installed MSSQL Server databases.
• Worked on MSSQL Backups/Restore.
• Implemented, configured and maintained critical SQL Server RDBMS systems.
• Tuned MSSQL queries using Profiler and SQL Server Trace.
• Configured and managed AWS/S3 backups.
• Worked with third party backup tools like DDBoost and NetBackup.
• Good ODA and Exadata experience and restored databases on ZFS arrays.
• Configured 11gRAC on ODA Oracle Database Appliance .
• Utilize UNIX shell scripting to automate system administration on Oracle database.
• Provide Oracle Database Administration support and troubleshooting, including install Oracle software, patches and upgrades; manage and monitor Table spaces and Tablespace quotas
• Responsible for Database installs and upgrades. We have recently upgraded all of our databases from Oracle 10.2.0.2 to 11.2.0.3 successfully.
• Performed backups, restores, cloning, or refreshing databases and applications. Ensured availability of client production systems and internal instances.
• Use RMAN to take incremental or full backup of teh databases, and ensure teh backups are successful.
• Hands on experience in implementing 11g Oracle Golden Gate.
• Migrate Oracle databases in Windows and Linux servers, and upgrade teh database on those servers.
• Installed Data guard standby databases and performed disaster recovery testing.
• Added, modified or removed users, roles and privileges, profiles, and other data accesses.
• Performed Windows Server and UNIX system administrator tasks as part of maintenance.
• Installation and configuration of single instance and RAC databases.
• Configuration of RMAN backups clubbing them as Autosys jobs scheduled in Autosys.
• Developed Oracle backup and recovery strategy and scripts with RMAN.
• Used EXPORT/IMPORT/DATAPUMP to do table level and full database defragmentation.
• Monitor teh database by collecting statistics of instance and files by querying data dictionary views, AWR Report, ADDM, and DBVerify to find ways to improve teh database's performance.
• Installed, configured and monitored SQL Server Enterprise and Standard edition.
• Hence monitor and optimize teh performance of database through OEM too.
• Performing all teh Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all teh databases.

Environment: Production and Non-Production support on Linux/HPUX and NT.

Confidential | Chicago, IL

Database Specialist

Responsibilities:

• Analyze customer data for data integrity and Normal Form standardization
• Installed, created and upgraded oracle databases.
• Created physical standby and Active data guard.
• Develop matching methods to enrich customer data
• Analyze long data processes and streamline for time efficiency
• Part of design team for developing new processes and procedures to maximize process efficiency.
• Worked on ETL tools like Alteryx and Omikron to consolidate and filter teh customers' raw data.

Environment: Microsoft Access, Omikron, Alteryx, Data Normalization, Production and Non-Production database support on Linux and Solaris.

Confidential | Chicago, IL

Oracle DBA

Responsibilities:

• Installing, Monitoring, Upgrading Oracle 9i to 10gR2 to 11gR1/R2
• Develop RMAN scripts for backup and recovery of databases.
• Work in Oracle 10G and setting up 2 node RAC on LINUX platform for teh development environment.
• Write monitoring/health check scripts to alert teh team of database uptime/downtime status and sizing issues, which ensured availability 99.99% of teh time.
• Provide development and production support, including on call requirements.
• Excellent communication skills and teh ability to work independently or in a team environment.
• Design, document, implement and maintain all disaster recovery procedures which result in no data loss.
• Perform daily operational duties/security for all users of teh databases.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Ability to work in a stressful environment while handling demanding internal and external clients.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Designed teh database schema and create any necessary database objects.
• Perform Backup and Recovery thru RMAN.
• Full fill developers request to refresh schema's on a daily basis.
• Installed, configured and troubleshooted teh lags in GoldenGate.
• Resolved db performance issues.
• Worked as primary on-call DBA.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.

Confidential | Skokie, IL

Oracle DBA

Responsibilities:

• Created 3 production physical standby databases and 9 non-production physical standby databases.
• Successfully configured multiple standby databases for a production database. (standby from standby)
• Worked with Real Application Cluster (RAC) databases.
• Installed, created and configured 8i, 9i and 10g databases and Clients.
• Install and configure Oracle software.
• Refresh schema level and full level production to non-production databases.
• Designed teh database schema and create any necessary database objects.
• Formulate optimal application SQL using Grid Control and v$queries.
• Ensured database security is implemented to safeguard teh data.
• Work closely with developers and system administrators to ensure all database needs are being met.
• Applied patches or upgrades to teh database as needed.
• Used SRVCTL utility for managing multiple instances and nodes.
• Responsible for having multiple OCFS locations in RAC environment.
• Managed and multiplex Voting Disk and OCR file for maximum RAC availability.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Perform Backup and Recovery thru RMAN.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments.
• Environment: Oracle 8i/9i,10g on RAC, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP Unix PL/SQL, TOAD and SQL *Plus.

Environment: Oracle 8i/9i/10g, Sun E450/4500, Oracle Enterprise Manager, Solaris, HP UNIX, PL/SQL, TOAD and SQL *Plus, Production and Non-Production on Linux/AIX/Solaris

Confidential | Downers Grove, IL

Oracle DBA

Responsibilities:

• RMAN, Import/Export, database creation, upgradation, grants and roles etc, creation of Physical Standby Database was major task.
• Cloned, refreshed and duplicated teh databases using Data dump and Recovery Manager (RMAN).
• Installed, Configured, Upgraded and Maintained teh standalone and RAC databases.
• Upgraded UAT and production databases from 9i to Oracle 10g.

Environment: Oracle 9i/10g, OEM, Solaris, TOAD, SQLPlus, Prod,Non-Prod and UAT, Performance Tuning.