SUMMARY

• Over 14 years of experience as Oracle DBA in very large Production Environments with Database implementation on UNIX (Solaris, IBM - AIX, HP-UX, Linux) and Windows.
• Extensive experience working on different RDBMS like MySQL,PostGreSQL and SQL Server.
• Over 17 years of experience as an IT professional.
• Data Migration from On-prem to RDS/EC2 and EC2 to RDS using DMS and Data pump.
• Extensive experience in databases on Oracle 8i, 9i, 10g / 11g R2,12c,18c,19c
• Experience in Installation and configuration of Oracle 10g / 11g R2,12c 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 alnog with12c,18c,19c.
• 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,12c, 18c/19c RAC/Non-RAC with/without Dataguard.
• Managed Oracle databases for the Manhattan WMOS application and projects.
• Familiar with many 10g to 19c new RAC and database 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,12c and 18c/19c databases.
• Experience in setting up Grid Control.
• Comfortable with both command-line and GUI interface.
• Hands on experience in implementing 10/11g and 12c/18c/19c Oracle Golden Gate.
• Oracle Database Appliance experience.
• AWS S3 cloud backup and restore experience.
• Working experience with Azure for SQL Server and PostGres databases.
• Experience working with the 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.
• Performed Failover/Switchover on FSFO data guard systems.
• 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 the proxy servers and worked with system admins to set up the 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, 18c, 19c Informix, MS SQL Server 2000/2005/2008 , MS Access, MYSQL, MariaDB, PostGreSQL, AWS RDS/EC2

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, TDE Encryption, DG FSFO

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

DBMonitoring Tools: OEM, Foglight and Spotlight, vRealize Hyperic, VictorOPs, Enterprise Express (12c/13c).

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/PostGresql DBA

Responsibilities:

• Created and managed RAC clusters
• Upgraded databases from 11g to 12c, and 18c and created and managed multiple 12c/18c/19c databases.
• Upgraded all non-extended support 12cR1/2 to 19c.
• Migrated On-premise and EC2 databases to AWS RDS using DMS and Data Pump initial loads.
• Managed RDS migration and worked with DevOps and Solution Architect for smoothe migrations.
• Performed regular planned Switchover / Role Swap to validate DR strategy using Data Guard/DG Broker on monthly basis.
• Managed Oracle databases for the Manhattan WMOS application and projects.
• Managed active Data Guard and used FSFO.
• Worked on Azure data studio to manage PostGres databases.
• Used TDE encryotion (OKV installation).
• Created, installed and upgraded MySQL/MariaDB databases
• Managed PDB/CDB databasee, created/cloned multiple Pluggable databases.
• Migrated multiple databases from on-prem to cloud/AWS (both on EC2 and RDS).
• Monitored performance of MySQL/MariaDB databases and migrated from Linux to Windows machines.
• Performed MySQL database copy/refresh
• Migrate from standalone servers to RAC cluster.
• Migrated from Oracle 11g to PostGres RDS across platform.
• Worked on MariaDB and Postgres on AWS RDS.
• 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.
• Worked extensively on RDBMS architecture and design specially on Oracle
• Created many standalone and RAC clusters with DR solution like data guard including ADG.
• Extensive and robust Performance Tuning and diagnostic experience.
• Experience migrating AWS EC2 Oracle databases to RDS using conventional data dump and DMS solutions.
• Used Performance Insight for troubleshooting and monitoring purpose on RDS.
• Worked with Control-M to manage, modify and schedule Oracle jobs for Oracle financial systems
• Scheduled workloads on daily,weekly and monthly intervals using Control-M and Batch scheduling.
• Migrated different environments from Oracle to MySQL and PostGreSQL
• 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.
• 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.
• Migrated vLarge EC2 instances to RDS using DMS service.

Environment: Oracle 11g,12c,18c/19c on RAC, Oracle Enterprise Manager 13c, Oracle Grid control, RHEL, HP UNIX, Production support on RHEL/Solaris, Microsoft, AWS RDS/EC2

Confidential, Chicago, IL

Production DBA/Sr. Oracle/MSSQL/MySQL 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 the databases, and ensure the backups are successful.
• Hands on experience in implementing 11g Oracle Golden Gate.
• Migrate Oracle databases in Windows and Linux servers, and upgrade the 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 the database by collecting statistics of instance and files by querying data dictionary views, AWR Report, ADDM, and DBVerify to find ways to improve the database's performance.
• Installed, configured and monitored SQL Server Enterprise and Standard edition.
• Hence monitor and optimize the performance of database through OEM too.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

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

Confidential | Chicago, IL

Database Specialist (Oracle/MySQL)

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 the 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 the development environment.
• Write monitoring/health check scripts to alert the team of database uptime/downtime status and sizing issues, which ensured availability 99.99% of the time.
• Provide development and production support, including on call requirements.
• Excellent communication skills and the 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 the 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 the 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 the 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 the 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 the data.
• Work closely with developers and system administrators to ensure all database needs are being met.
• Applied patches or upgrades to the 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.