SUMMARY:

• Oracle database expert with well over 20 years of experience in relational database installation, configuration, creation, tuning, maintenance, and user management.
• Having extensive experience as a Lead Oracle database Administrator, Cloud Architect, Oracle Database Manager, Application/database Performance tuner, Security
• Administrator, data warehouse/transaction databases, Oracle Fusion Middleware, Oracle unified directory, Oracle access manager, Oracle Identity Management,
• WebCenter, WebLogic administrator, Informatica, Oracle Data Integrator, Power BI tools and SOA Oracle Enterprise Manager (OEM) and system architecture specialist.
• Expert in Oracle Exadata, Exadata appliances, Goldengate, RAC (Real Application Clustering), OCAC and in RMAN (Oracle recovery Manager). Expert PeopleSoft and
• Oracle application DBA. Extensive experience in install, manage, and troubleshoot of MySQL, PostgreSQL database of very large sizes. Serving as the team lead for various projects and an Oracle instructor, excellent at assisting other members of the project team. He has been involved in multiple oracle installations, upgrades, manages complex projects and leads high performing teams, skilled architect, designer, and strategic thinker, delivers effective and sustainable
• IT solutions. He has managed, administered, and coordinated complete life cycles of multiple system and applications projects in multiple industries including public sector, financial, manufacturing,, telecommunication, and consulting.

TECHNICAL SKILLS:

Databases: Oracle 19c/12c/11g/10g, SQL Server 2012/2014/2016/2017, SQL Server Always - ON

Oracle Tools: Golden Gate, Exadata, OBI, RMAN, RAC, OEM, TOAD, Data Guard, ODI, Erwin.

OS: Linux, Sun Solaris, HP-UX, AIX, Windows

Products: PeopleSoft Financials, HCM, Payroll, Benefits, eRecruit, CRM, Student Administration, Apache, PIA, Tuxedo, Application Servers, Confidential WebSphere, WebLogic, PUM Server, Tableau, Integration Broker, Quest STAT, Hadoop, Big data analytics

Component Interface: PeopleTools, SQR, Business Object, Application Engine, Workflow

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Install, upgrade, maintain, support Oracle RAC/Data Guard/Vault, Oracle Application databases.
• Responsible for creating, manage, and patching of Oracle RAC environments including OCAC.
• Involved in installation/migrating Oracle databases to Cloud - AWS, Azure and Oracle Cloud.
• Managing multiple PeopleSoft application and PeopleTools upgrades simultaneously on Oracle OCI.
• Lead architect for designing, building, implementing database solutions on Oracle Cloud Infrastructure (OCI).
• Successful database migration of PeopleSoft environments by rehosting “lift and shift” to OCI including DBaaS.
• Implemented Oracle data guard between multiple data centers for Disaster recovery plan.
• Installing 19c Oracle RAC/Grid Infrastructure including database migration.
• Configured and managed Oracle database security including with PII data.
• Successfully created, managed various application architect following microservice architectural style.
• Install, configure, manage Oracle RMAN for database backups, and recovery.
• Install, configure, manage Oracle WebLogic servers, and deploy applications.
• Install, configure, manage Oracle OEM for database monitoring as well to monitor WebLogic.
• Installing advanced features of Oracle enterprise manager 13c and automate infrastructure upgrades using infrastructure code (Ansible/Chef).
• Involved in Golden Gate installation, configuration, replication, tuning, maintenance, patching, and problem diagnosis and resolution.
• Implementation of monitoring scripts for Golden Gate in shell or Perl scripting, creation of the Golden Gate replication for tables from source to target.
• Troubleshoot performance-related tuning for a Golden Gate replication.
• Analyzed entity relationship diagrams (ERD), dimensional models, and translating into table structures, keys, and indexes.
• Work with Oracle middleware products to provision and administer them in OCI environment.
• Provide and implement performance tuning recommendations of all components in OCI.
• Advise, provide guidance, and develop Disaster Recovery strategies for the Exadata Database machine and OCI.
• Solid skills to configure Exadata to meet company internal security requirement.
• Install, upgrade, maintain and secure the integrity of the College databases on OCI.
• Execute and maintain secure backup and recovery procedures for all databases hosted on premises and on OCI.
• Troubleshoot, monitor, and tune databases making recommendations and taking action to ensure optimal performance.
• Work with security teams to ensure system access, auditing, and security controls are compliant with college security policies.
• Develop and maintain scripts in Python, PowerShell, bash, python, Perl, etc. to automate startup, shutdown, maintenance, monitoring, and data transfer processes.

Confidential

Senior Oracle Cloud Architect

Responsibilities:

• Oracle DBA for SAP to support Development, TEST, COOP, and Production systems.
• Support SAP Basis Administration in a Unix/Oracle environment, SAP Solution Manager, use of Maintenance Optimizer for patching and upgrades, SAP interfacing and communicating with SAP product integrators.
• Managed Spring Boot framework for building monoliths and microservices.
• Managed multiple PeopleSoft customers cloud hosted solutions in GCP, OCI, AWS and OCAC.
• Maintain Oracle EBS Financials, Supply chain management, and HCM hosted on GCP, OCI.
• Database migration of “lift and shift” from on-premises to cloud hosted infrastructure on GCP, OCI.
• Create, configured, maintain PeopleSoft databases in Oracle cloud including DBaaS systems.
• Create, manage, patch, troubleshoot, support Oracle DBaaS RAC databases in OCI.
• Created, managed DNS configuration, firewall rules, security list in OCI as well as AWS.
• Install, configure, manage Oracle RMAN for database backups, and recovery.
• Install, configure, manage Oracle OEM for database monitoring as well to monitor WebLogic.
• WebLogic administration including install, configure, manage, patching, and performance tuning.
• Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate OGG in both homogeneous and heterogeneous environments including Oracle to Oracle and MS SQL Server to Oracle.
• Primary technical resources to upgrade Oracle Goldengate from 11g to 12c in Exadata machine environment.
• Design Goldengate HA solutions by using Oracle 11.2.0.4 Cluster ware functionality.
• Configure Single Sign-On between multiple PeopleSoft systems.
• Configured and managed Experian data quality (EDQ) and Oracle business intelligence (OBI).
• Worked in detail with install, configuration of HTTPS security, SSL s, openSSL, Apache.
• Installed, configured, deployed latest Elastic Search 6.1.2.
• Managed and performed WebLogic administration for multiple installations.
• Installed Nagios and configure monitoring for PeopleSoft WebLogic, tuxedo, Apache, database backups, external systems.
• Implemented PeopleSoft system auditing with multiple scenarios and customer requirements.
• Responsible for end-to-end system wide patching including Linux OS, WebLogic, Oracle Database patching including OCI console.
• Provided 24X7 support for all components of PeopleSoft systems.
• Created multiple PeopleSoft database support documents for other team members.

Confidential

Senior Oracle DBA Lead

Responsibilities:

• Install, upgrade, maintenance, support Oracle RAC/Data Guard/Vault, Oracle Application databases.
• Responsible for creating, manage, and patching of Oracle RAC environments.
• Worked for different RAC related issue such as hang check, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss, etc.
• Successfully completed Oracle database upgrade to 12c for more than 30 production applications.
• Build more than 20 production servers and 40 non-production Oracle and SQL Server database servers in cloud and on-prem (hybrid solution).
• Involved in installation/migrating Oracle databases to Cloud (OCAC) - AWS, Azure and Oracle Cloud.
• Design, test, document & implement RMAN backup and recovery strategy for all corporate databases.
• Responsible for applying patches and fixes to all Oracle/MS-SQL Server/PeopleSoft and other corporate applications including providing 24X7 production support.
• SQL code review, performance analysis, query tuning, database application design, physical data modeling, and support development team.
• Responsible for installing, managing, and patching of all PeopleSoft components including Tuxedo, webservers, application server, and process schedulers.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Maintain, upgrade, troubleshoot issues related to Oracle EBS, Financials, and HCM.
• Setting up High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments.
• Implementation, troubleshooting of integration broker, LDAP/LDAPS, single sign-on, profile management.
• Successfully implementation of Oracle Internet Directory (OID) and migration from onames to oid.
• Automated refresh of PeopleSoft reporting database from production every night.
• Created PeopleSoft system operations guide for team which help new members to understand system and custom configuration and in troubleshooting.
• Install, configured, monitor Oracle/MS-SQL Server/PeopleSoft database and application activities including data masking using Oracle Enterprise Manager (OEM) and Quest Foglight for monitoring and performance tuning of MS-SQL Server Databases.
• Expert in design, configuration, administration of Oracle and SQL Server database including PeopleSoft on physical and virtual servers in cloud.
• Successful migration of Oracle including PeopleSoft, SQL Server databases from in house physical data center to public cloud, private cloud, IaaS, PaaS and to vendor hosted SaaS solutions.
• Implemented data guard for database cloning and active standby configuration for PeopleSoft databases.
• Implemented Oracle database and GIS application single sign-on with cost effective solution using Kerberos.
• Configured and Managed Oracle RMAN backups on Linux and MS-SQL database backups on Windows to disk and to tape using TSM Tivoli.
• Helped team to write scripts to automate non-production database refresh from production database.

Confidential

Senior Oracle DBA

Responsibilities:

• Successful PeopleSoft implementation on Oracle database for various clients in Financials, HCM 9, Benefits, Payroll, Pension, Time, and Labor on different PeopleTools versions.
• Responsible to create, monitor, manage, patching of Oracle RAC databases, ASM, RMAN and Data Guard.
• Oracle database and environment setup, installation, design, testing, capacity planning, space management and administration.
• Performance Tuning, Backups and Recovery with RMAN, RAC, Security Management, Database Administration and Monitoring.
• Re-organized heavy transaction tables and temporary tables in separate table spaces as part of database re-org to improve performance with uniform extent size and NOLOGGING for temporary tables.
• As Technical Lead responsible for supporting multiple clients for production support and upgrade of Oracle databases, SQL databases, and PeopleSoft applications (Student Admin, Financials, HCM) including 3rd party software’s.
• Upgrade Oracle databases from 9i to 10g on AIX and Windows environments.
• Responsible for DB2 databases including backups and recovery as and when required including disaster recovery.
• Provide 24X7 on-call support to all designated clients.
• Developed and proposed new backup strategies in accordance with customer needs.
• Extensive in hand knowledge of Autosys for scheduling PeopleSoft batch jobs, databases nightly backups, troubleshooting, adding new jobs, changing existing jobs.
• Worked on creating troubleshooting documents for production support as document for other members of the team.
• Automated refresh of non-production databases and PeopleSoft file system from production environment.
• Create new PeopleSoft databases for new application upgrades or for new application testing.
• Worked extensively on Unix and windows scripting.
• Provide cross to new team members.

Confidential

Oracle DBA

Responsibilities:

• Manage multiple production/test databases. Specialize in Oracle, Advanced PL/SQL queries, DBMS, RAC installation, Data Guard databases for multiple applications, performance tuning.
• Involved in database installation, configuration, creation, tuning, maintenance, and user management.
• Involved in supporting production/test/development databases. Responsible for refreshing of the development databases from production database.
• Implemented Data Guard, maintain primary and standby database.
• Responsible for database backups and recovery as and when required including testing disaster recovery using RMAN.
• Tuned long running queries & queries having high CPU. Involved in 24/7 monitoring and performance of batch jobs.
• Performed logical/physical database backups using various methods, including exports, cold backups, hot backups, and Oracle Recovery Manager backups. Involved in oracle partitioning and creating materialized views.
• Expert in PL/SQL packages, stored procedures functions and triggers.
• Involved in Oracle 10g database level performance tuning and backup and recovery using RMAN. Extensively used Oracle 10g AWR, ADDM, SQL Optimizer, Explain plan for over all Database performance.
• Developed and proposed new backup strategies in accordance with customer needs. Apply Oracle database releases and patches.
• Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance.
• Worked on creating troubleshooting documents for production support as document for other members of the team.
• Developed and automated UNIX shell scripts to backup both logical and physical backups to tape using the OS backup.
• Implemented materialized views in Oracle Teradata database. Worked as lead DBA in DSS systems.
• Automated Refresh of non-production databases and PeopleSoft file system from production environment.
• Creating new databases for new application upgrades or for new application testing.
• Writing SQL, shell scripts to automate batch jobs and performance monitoring.
• Worked as a team member in implementing and Configuring Oracle Real Application clustering (RAC).
• Worked extensively with PVCS - change management tool.