SUMMARY:

• Overall 11+ years of technically competent experience in the field Oracle Database Proficiency (9i, 10g, 11g,12c&19c) Administration with Goldengate expertise and 2.5 years on AWS Cloud Services includes database migration to AWS Cloud and Amazon Redshift.
• Motivated and skilled Oracle Database Administrator (Architecture, Configuration, Security Management, Storage Management, Performance Troubleshooting, Backup & Recovery).
• Proficiency in Oracle Database (9i, 10g, 11g,12c&19c) Administration on RHEL 4/6, SUN Solaris, AIX, SUSE and Windows Platforms and performing DBA duties like Installation, Cloning, Patching and Migration/Upgradation
• Good Expertise of Configuring, Setup and maintenance of 4 - 6 nodes Multi-Site 19c RAC.
• Worked on encryption environment and created oracle wallets, encrypted tablespaces via TDE and configure SSL listeners.
• Good Expertise on implementing unidirectional and Bi-directional configuration of Goldengate 19c on Goldengate HUB via remote capture/replicat.
• Good understanding on Goldengate MSA 19c. Installed and configure Microservices setup on GG HUB.
• Good Hands on setting up OEM database and configure Gold Images.
• Experience in identified poor SQL statements using EXPLAIN PLAN, SQL TRACE, TKPROF and monitored via OEM 13c and created SQL profiles.
• Exadata Planning, Configuration and Installation.
• Good Expertise on Configuring DDBoost domains for RMAN Backups, Integrated the backup with Cohesity tool.
• Patching Oracle DBs using OEM Grid Control. Extensive use of Oracle Enterprise Manager Cloud Control 13c for database monitoring and tuning efforts.
• Hands on experience on moving on premises Oracle databases to AWS Cloud database.
• Experience in installation, upgrade and migration of PostgreSQL database from Oracle DB.
• Good Exposure on Oracle Autonomous Database, Oracle Cloud Infrastructure.
• Create and Prepare an EC2 instance in AWS for Oracle Deployment and deploy legacy Oracle 11g/12c in EC2.

TECHNICAL SKILLS:

Business Tools:: OEM 13c/12c, Toad 12c, SQL Developer, Putty, PostgreSQL Workbench, AWS and Tableau.

Business Skills:: Business Requirements Defination, Business Process Mappings, Impact Analysis, Team Management, Stakeholder Management, Process & Change Management

Methodologies: Agile/Scrum

Databases:: Oracle, MySQL, Amazon RDS, Amazon Redshift and Dynamo DB (NO-SQL), PostgreSQL

Languages:: PL/SQL, UNIX Shell Scripting, Python

Technical Expertise:: Oracle 9i/10g/11g/12c/19c, Oracle 12c, AWS Cloud, Redshift, Tableau,12c GoldenGate19c, Unix - Linux/SunOS

SQL Interpreters:: Toad, Putty, Secure CRT, OEM 13c/12c, Power Designer, MySQL Workbench

Domain Expertise: Project Lifecycle Management, Network Management System, Columbia Management, Asset Management, Portfolio Management

PROFESSIONAL EXPERIENCE:

Confidential, Eversource, Connecticut

Team Lead

Roles and Responsibilities:

• Working as Technical Architect and Oracle Tower Lead for on one of the critical migration projects. Involved in end-to-end development including detailed analysis of the requirements, design, implementation, testing, UAT and deployment to prod.
• Implementing high availability solutions by setting up Multi-site 6 node RAC Cluster for business-critical Databases and build physical standby’s and maintain DR sites using Database Monitoring process and procedures.
• Setup Active-Active Bi-directional 19c Goldengate via Goldengate HUB.
• Setup Goldengate Microservices architecture 19c on Goldengate HUB.
• Good Hands on configure GG monitoring via GG Monitor and Veridata.
• Worked on encryption environment and created oracle wallets, encrypted tablespaces via TDE and configure SSL listeners Expertise on setup Cascade Goldengate topology across multiple Data centers and configured both uni and bi-directional replication.
• Hands on Experience on working with Multiple Teams like Storage, Network, UNIX to setup VPLEX, XtremeIO, private IP’s, Subnets, interfaces configuration for Multi-site 4 nodes RAC clusters.
• Having good hands-on experience on configuring both Physical and Logical Standby databases.
• Good understanding of covert RAC to Non-RAC Environments.
• Support regular BAU maintenance activity of DB Patches, Upgrades, RMAN Refresh, Clone etc.
• Build and configure ADG with snapshot and also performed Switchover, Failover using dataguard broker.
• Run orachk utility to ensure system is healthy and should not have database vulnerabilities.
• Installed and configure OS Watcher to monitor systems health check.
• Configure GIMR for RAC performance checks.
• Having good experience on Database Security - SOX, non-sox related application.
• Provide technical/Strategic direction for Automation of Oracle DB Builds

Confidential, California

Senior Technical Consultant

Roles and Responsibilities:

• Implementing high availability solutions (Disaster Recovery) for business-critical Databases using Oracle Data Guard and maintain DR sites using Database Monitoring process and procedures.
• Modify existing databases and database management systems or direct programmers and analysts to make changes and develop database parameters or specifications and guidelines for system implementation.
• Convert physical standby to snapshot database for DR validation.
• Good Expertise on implementing Bi-directional configuration of Goldengate 12c.
• Good hands-on working oracle wallets and setup encryption keys.
• Configure and setup auditing for better tracking of user activities on the databases. Implement Security standards on the database to make it more secure and vulnerable free.
• Migrate existing Oracle databases from on premise to AWS using AWS Data Migration Services and AWS Schema Conversion Tool.
• Good understanding of Amazon S3, Elastic Load Balancer, Redshift and implemented solutions to load data into S3 and migrated the lower environment data to AWS Cloud.
• Create and Prepare an EC2 instance in AWS for Oracle Deployment and deploy Oracle 12c in EC2.
• Involved POC for Oracle RDS instance and enabled Multi-AZ deployment. Created a standby database and did failover to other AZ.
• Involved in POC team to setup oracle-standby 19c dBs with Ansible (GitHub)

Confidential

Senior Oracle DBA

Roles and Responsibilities:

• Acted as a single-point-of-contact between US and Offshore team to understand the business requirements.
• Gained domain knowledge of application in terms of Business Impact and Application outage and developed some methodologies through automated scripts.
• Worked as IAAS-PAAS DBA (Infrastructure as a service and platform as a service) for handling issues and implemented to fix in case of any bugs being identified.
• Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM 13/12c and Creating SQL Baselines
• Install and configure Oracle Golden Gate 12c and implemented DDL and Bi-directional replication.
• Supported quarterly patches (PSU), One off Patches and perform version upgrades and database migrations.
• Creating SQL profiles for the reported queries with plan fluctuations, picking the bad execution plans, to fix them to use the best available plan with the optimizer with every execution.

Confidential, Minneapolis

Oracle Database Administrator

Roles and Responsibilities:

• Lead a 6-7 members team and acted as a SPOC to handling Clients requirements in terms of Creating and managing Oracle Databases
• Worked with Oracle Support for handling Critical production issues and implemented to fix in case of any bugs being identified.
• Have good understanding and hands on Oracle 12c Data Guard. Created and maintained physical and logical stand by databases for mission critical applications.
• Support DR Replication activity.
• Understanding and implementation of Oracle iReceivables (on Oracle EBS R12.2.4)
• Automating the routine processes such as table space/file system monitoring; partition maintenance, statistics gathering and automating backup/alerting process through UNIX shell scripting.
• Supported on Build and maintain DR sites using data guard Database Monitoring and administration of oracle database using Enterprise Manager Grid control OEM 12c
• Involved in RAC performance issues.
• Database Monitoring and administration of oracle database using Enterprise Manager Grid control (OEM). Supported security related CPU and One-off patches using Opatch utility.
• Scheduled jobs in the database using CRON Jobs and DBMS JOBS.
• Generate Stats pack, AWR and ADDM reports for Performance analysis.
• Used Export/Import, Data Pump Utilities to move the data between different databases
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.