SUMMARY:

• An excellent IT professional with 16 years of focused experience in various domains including Banking Financial, Healthcare, Transport and Manufacturing.
• Experienced in database deployment on Cloud platforms like Azure and AWS.
• Experience in managing MongoDB (NoSQL) databases on Linux platform.
• Managed SQL Server databases, Blobs, tables on Azure platform.
• Experience building POC on block chain and distributed ledger using Multichain platform on AWS.
• Extensive experience in relational database design, analysis, development, administration, implementation, troubleshooting and support.
• Proficient in Oracle 9i/10g/11g/12c software installations, migrations, database capacity planning, automated backup implementations, high availability, disaster recovery management, performance tuning of databases on Unix and windows NT platforms
• Experience with architecture group in complex designs of the logical and physical model of the databases.
• Thorough understanding of the Oracle DBMS technology, data dictionary and internals.
• Experience with Oracle Golden Gate replication and administration tasks including setup of unidirectional and bidirectional replication across heterogeneous and homogeneous platforms.
• Good experience with troubleshooting Golden Gate replication related issues at various process levels like extract, data pump, replicate, initial load, log dump and change synchronization.
• Good understanding of Exadata architecture.
• Extensive experience with Data Guard setup, troubleshooting, switchover, failover, active Data Guard, fast starts failover and snapshot standby databases.
• Excellent knowledge on query optimization and database performance tuning.
• Extensive experience with performance tuning and health check of Oracle databases using AWR/ADDM Reports, Explain Plan, SQL Trace, TKPROF and OEM 12c.
• Installed and configured Oracle Enterprise Manager (OEM 12c) in a multi tiered environment with 800+ oracle databases. Mass deployed the OEM Agent software to servers to discover targets in the grid.
• Extensive experience in supporting production databases running 24x7 mission - critical applications.
• Extensive experience with UNIX shell scripting and implementing automated nightly jobs to schedule the backups, exports, refresh test database from production databases.
• Very strong in problem resolution, handling pressure and system downtimes.
• Experienced with ITIL/ ITSM best practices on Change and Incident management.
• Created documents related to database standards and best practices.
• Mentored junior team members.
• Good communication and project management skills.
• Excellent team player and capable of working independently.
• Flair to learn and implement new technologies.

ORACLE RAC EXPERIENCE

• Planning, deploying and supporting of RAC using Oracle cluster ware, ASM, ACFS on 10g/11g/12c versions.
• Experience in Installation & configuration of Oracle cluster ware & database software (troubleshooting using cluvfy & handling common issues that arise during integration, bugs, network issues, configuration files issues, OCR issue, de installation & clean-up of cluster ware).
• Working experience with customers for different RAC related issues: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, voting disk loss & so on
• Working with backup and recovery issues related to corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & flash recovery area.
• Experience in resolving and diagnosing node eviction issues.
• Experience in Clusterware, GI and database upgrades from 10g to 11g and 12c.
• Experience in add/removal of nodes in cluster environment.

ORACLE DBA EXPERIENCE

• Over 13 years of experience as Oracle DBA (12c/11g/10g/9i/) in production, dev /test environments.
• Experience working in 24x7 production environment and providing on-call and day-to-day support.
• Worked on datacenter migration projects.
• Experience in migrating a non-ASM single instance to ASM RAC Instance, ACFS
• Strong troubleshooting, problem solving, analytical and design skills.
• Expertise in Oracle enterprise manager (OEM 11g and 12c), TOAD, Sql Developer.
• Installed and configured Oracle Enterprise Manager (OEM 12c). This also involves configured Oracle Management Service (OMS) and Oracle Management Repository (OMR). Configured Data guard for OMR database for disaster management.
• Deployed OEM Agent software on the database server and configure the target to the OEM Cloud control.
• Also worked on upgrade of existing
• Experience with OEM Provisioning and patching tool.
• Experience in logical and physical design of databases for OLTP and OLAP databases
• Expertise in handling very large database (VLDB), Data warehouse (DW) and OLTP environment.
• Experience in database version upgrades from Oracle 9.x to Oracle 11.x and 12.x.
• Expertise in performance tuning of production database towards optimal performance based on the changes in the database, storage structures, and application changes.
• Experience in Oracle 12c/11g/10g/9i - installation and implementation of new features.
• Experience in capacity planning, space management.
• Expertise in Oracle backup & recovery using RMAN (Recovery Manager), user managed backup.
• Experience on Oracle Golden Gate replication and administration tasks.
• Experience in Oracle advanced compression, wallet management and transparent data encryption.
• Experience in database security, auditing, FGA.
• Experience in database cloning, refreshes across different environments.
• Experience in database migrations using data pump, Exp/Imp, RMAN, transportable tablespaces, cross platform migrations.

TECHNICAL SKILLS:

Operating Systems: Linux, AIX, Sun Solaris, SCO UnixWare, Windows

Tools: /Utilities RMAN, SQL Backtrack, BMC Patrol, DB Artisan 8.5.4, TOAD, OEM 12cErwin, Autosys, Provisioning and Patching tool, Multichain

Databases: Oracle 12c/11g/10g/9i/8i, Microsoft SQL Server 2012/2008/AzureMongoDB

Languages: SQL, PL/SQL, T-SQL, Shell scripts, Perl, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. DBA

Responsibilities:

• Installation, configuration of MongoDB (NoSQL) databases.
• Installation, configuration, upgrade, patching and support of Oracle databases 11g, 12c R1/R2.
• Performance tuning by configuring database parameters, EXPLAIN PLAN, SQL TRACE, AWR/ADDM reports, SQL Profiles.
• Database backup & recovery using RMAN, EMC Networker Data Domain.
• Migration of databases across data centers from 11g to 12c.
• Identifying bottleneck SQL in production databases proactively based on Database reports (AWR, ADDM) considering various statistics for SQL and providing tuning suggestions proactively.
• Coordinating with application teams during release cycles to identify and tune SQL queries using hints to use optimal plan, query rewriting, PL/SQL performance code design review and tuning suggestions.
• Data extraction and load using materialized views.
• Installed and configured Oracle Enterprise Manager (OEM 12c). Configured Oracle Management Service (OMS) and Oracle Management Repository (OMR). Configured Data guard for OMR database for disaster management.
• Oracle and (SQL Server or MySQL) along with Mongo Db experience.
• Engineered replication solution using Golden Gate.
• Logical Data modeling and creating physical database designs using ERWIN for DW databases.
• Application database support by creating schemas, tablespaces, partitions, indexes, etc.
• User access management by creating roles, views and object/system privileges.
• Database cloning using RMAN and schema refresh using Data pump utilities.
• Administration and support of Oracle RAC database, Active Data Guard.
• Writing shell scripts to monitor activities like availability of database & listeners, space utilization, gathering statistics, index rebuilding etc.
• Work with Oracle Support for managing critical database issues.
• Worked on Solution requests for provisioning of physical/virtual servers for new databases.
• Created documents related to database standards and best practices and mentored junior team members.

Solution Environment: Oracle 11gR2/12c, AIX, Linux, MongoDB 3.4

Tools: OEM Cloud Control 12c, RMAN, ERWIN, SQL Loader, EMC Networker Data Domain/AVMAROracle Golden Gate, Data Guard, ASM, ACFS, Ops Manager, Studio 3T, Compass.

Confidential, Beaverton, OR

DBA/Developer

Responsibilities:

• Database support of Oracle and SQL Server databases.
• Manage SQL Server databases, Blobs on Azure platform using Azure portal and storage explorer.
• Identifying bottleneck SQL in production databases proactively based on Database reports (AWR, ADDM) considering various statistics for SQL and providing tuning suggestions proactively.
• Extensive use of Explain Plan, autotrace, Tkprof, Statspack, ASH, AWR, TOAD.
• Coordinating with application teams during release cycles to identify and tune SQL queries using hints to use optimal plan, query rewriting, PL/SQL performance code design review and tuning suggestions.
• Data extraction and load using materialized views.
• Creating PowerShell scripts for database monitoring like database and tables growth, index fragmentation, deadlock, CPU, I/O and memory.
• Creating database reports and generating adhoc data requests for management.
• Database Backup and Disaster Recovery for Azure databases.
• Database management by creating schemas, tablespaces, partitions, indexes and coding in PL/SQL and T-SQL packages, procedures, functions and triggers.
• Expert of data backup, recovery, security, integrity, PL/SQL and SQL.
• Designed and implemented replication solution using GoldenGate.
• Created scripts to monitor for alerting on lags, failures and issues on GoldenGate.
• Logical Data modeling and creating physical database designs using ERWIN.
• User access management by creating roles, views and object/system privileges.
• Database cloning using RMAN and schema refresh using Data pump utilities.
• Migration of databases.
• Administration and support of Oracle RAC database, Data Guard.
• Work with Oracle Support for managing critical database issues.
• Acquired familiarity with agile methodologies.

Solution Environment: Oracle 11g/12c, Linux, Windows, SQL Server 2012, Azure, RAC, Golden Gate

Tools: Data Guard, TOAD, Atlassian Suite (JIRA, Confluence, Bit Bucket), PowerShell, SQL Server Management Studio, Azure Storage Explorer, Cloudberry Explorer.

Confidential, Peoria, IL

DBA

Responsibilities:

• Installation, configuration, upgrade, patching and support of Oracle databases.
• Database backup & recovery using RMAN.
• Patch deployment using Provisioning and Patching tool.
• Upgrade of Oracle 10g/11g databases to Oracle 12c.
• Migration of databases across data centers.
• Identifying bottleneck SQL in production databases proactively based on Database reports (AWR, ADDM) considering various statistics for SQL and providing tuning suggestions proactively.
• Extensive use of Explain Plan, autotrace, Tkprof, Statspack, AWR, TOAD.
• Coordinating with application teams during release cycles to identify and tune SQL queries using hints to use optimal plan, query rewriting, PL/SQL performance code design review and tuning suggestions.
• Data extraction and load using materialized views.
• Creation of database scheduler jobs.
• Installed and configured Oracle Enterprise Manager (OEM 12c). Configured Oracle Management Service (OMS) and Oracle Management Repository (OMR). Configured Data guard for OMR database for disaster management.
• Engineered replication solution using GoldenGate.
• Deployed GoldenGate in cascaded replication, cross database replications
• Worked on customizing the Oracle GoldenGate to use data pump for initial sync
• Developed GoldenGate Monitoring tool to monitor for alerting on lags, failures and issues.
• Configured GoldenGate to maintain replication to other Oracle, MySQL and SQL Server databases.
• Logical Data modeling and creating physical database designs using ERWIN for DW databases.
• Application database support by creating schemas, tablespaces, partitions, indexes, etc.
• User access management by creating roles, views and object/system privileges.
• Performance tuning by using EXPLAIN PLAN, SQL TRACE, AWR/ADDM reports, SQL Profiles.
• Database cloning using RMAN and schema refresh using Data pump utilities.
• Expert of data backup, recovery, security, integrity, PL/SQL and SQL.
• Familiarity with database design, documentation and coding.
• Administration and support of Oracle RAC database, Active Data Guard.
• Writing shell scripts to monitor activities like availability of database & listeners, space utilization, gathering statistics, index rebuilding etc.
• Work with Oracle Support for managing critical database issues.
• Worked on Solution requests for provisioning of physical/virtual servers for new databases.
• Created documents related to database standards and best practices and mentored junior team members.

Solution Environment: Oracle 10gR2/11gR2/12c, AIX, Linux, Microsoft SQL Server 2012, MySQL

Tools: OEM Cloud Control 12c, RMAN, ERWIN, SQL Loader, TSM/TDPO, EMC Data Domain/AVMAROracle Golden Gate, Data Guard, ASM, ACFS

Confidential, Chicago, IL

Database Administrator

Responsibilities:

• Installation, configuration, patching and upgrade of Oracle software.
• Troubleshooting of Oracle 9i/10g Performance issues with Oracle Support.
• Project management with onsite/near shore/offshore teams (USA, Mexico and India) at onsite.
• Administration of Oracle RAC, Data Guard (Active Data Guard) and Streams architectures.
• Data Guard configuration, administration, switchovers to physical standby database.
• Database backup implementation & monitoring using RMAN & SQL Backtrack.
• Performance Tuning of Oracle databases using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR/ADDM reports and OEM grid.
• Write shell scripts to monitor activities like availability of database & listeners, space utilization, gathering statistics for the cost base optimizer, index rebuilding etc.
• Application database support: create & manage tablespaces, partitions, indexes and other database objects.
• Managed multi-terabyte databases and partitioning.
• User security management by creating of roles, views and granting object/system privileges.
• Perform schema refresh using export/import and Oracle Data pump utilities and full database refresh by database cloning procedure.
• Write PL/SQL programs (Procedures / Functions / Triggers / Packages).
• Administration of SQL Server 2005/2008 databases.
• Created documents related to database standards and best practices and mentored junior team members

Solution Environment: Oracle 10g/11g, ASM, ACFS, Data Guard, RAC, Streams, SQL Server 2005/2008.

Tools: BMC Patrol, SQL Backtrack, RMAN, DBArtisan 8.5.4, OEM Grid

Confidential, New York, NY

Database Administrator / Developer

Responsibilities:

• Maintenance and support of 24x7 up databases.
• Installation, configuration, patching and upgrade of Oracle software.
• Performance Tuning.
• Coding Procedures / Functions / Triggers in PL/SQL and T-SQL.
• Schema refreshes using export/import.
• Developing new reports, handle change & enhancement request, providing adhoc data request.
• Performing data extraction, transformation and load (ETL) using SQL*Loader, External tables.
• Writing Perl scripts for providing adhoc data extract in excel formats and CSV files.
• Interacting with clients for requirement gathering and design of new reports.
• Scheduling the jobs using Autosys.

Solution Environment: Oracle 9i /10g, Sybase, Linux, Perl, Autosys

Confidential

Database Developer / DBA

Responsibilities:

• Plan and schedule Daily, Weekly and Monthly Backups. Test and implement restore procedures for complete and incomplete recovery using RMAN.
• Configure TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Performance Tuning of Oracle databases using STATSPACK, EXPLAINPLAN, SQLTRACE, and TKPROF.
• Created users, roles and granted privileges according to the business requirements.
• Implement security by creating of roles, views and granting object/system privileges.
• Perform schema refresh using export/import.
• Coding PL/SQL blocks (Procedures / Functions / Triggers / Packages) in Oracle.
• Write shell scripts to monitor activate like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Working on Logical Data modeling and creating physical database designs using ERWIN.

Solution Environment: Linux, Windows, Oracle 9i, Forms 6i & Reports 6i, Visual Basic 6.0, Crystal Reports