PROFESSIONAL SUMMARY
Over **+ years of Oracle experience, and in-depth knowledge in database administration, PeopleSoft, systems analysis, design, development, and implementation of applications in areas of Health Care Services, Insurance Industry, Higher Education, Finance, and Banking Systems using Oracle RDBMS, Oracle tools, SQL Server and Management Studio on UNIX and Windows environment.
Supported Oracle/PeopleSoft Production databases, design, implement & maintain DR with active data guard.
Experienced in data architecture, design, development, and implementation of various IT applications Systems specializing in Oracle and PeopleSoft enterprise FSCM/HRMS/CS/PORTAL applications and custom supporting systems.
Implemented/Worked extensively with Upgrades, Security patching, bundles, Rolling Patches, PUM, OEM, RAC, RMAN, TDE/Wallet, stored procedures, packages, and database triggers, PL/SQL, SQL*Plus, Developer*2000, Pro*C
Extensive experience with Unix, Linux. C/C++, Shell, Perl, Cron Scripts, PowerShell, WinScheduler
Extensive experience of migrating large databases from on-premises to public cloud for Fortune 100 companies without service interruption.
Well round experience with Oracle Integration Cloud (OIC) including integrations between ERP, CRM, HCM and other cloud and on-prem applications.
Work cohesively as part of larger operational teams and cross-functional groups
Certification and Training:
Oracle Cloud Architect Professional
Oracle Cloud Architect Associates
AWS Architect Associate
Oracle 12c on Exadata Training
Oracle 11g New Feature Training
RELEVANT EXPERIENCE
GlobalVox, Herndon, VA Sep 14 – Present
Sr. Cloud Engineer-Architect/Sr. DBA
Client Engagements:
The NCD Apr 22 – Present
Oracle DBA/OCI Admin/OIC Engineer
Create and maintain users, profiles, IDCS groups to controlled user access, OCI Services and Fusion Application access.
Create and implement DB profiles, roles to fine grain DB access and API calls.
Designed, implemented OIC business process to sync data between PaaS and Fusion database thru scheduled and app driven integration.
Administer/support/monitor databases proactively to resolve database performance issues and maintain servers.
Work closely with end-user, business users, developers, unit testers, functional people and handled migration to prod.
Work with businesspeople to provide data for BI Report for management layer.
Develop scripts and processes for data integration and maintenance.
Create partitions for very large tables to improve DB performance.
Work on data growth projection and plan to acquire resources to meet need. Planned data archive and created purge procedure to gain performance and maintain database footprint.
Create/Automate DB backup script, configure DR using OCI to move archive logs to different region and apply on standby.
Initiate and implement DR site for PaaS DB at remote location on OCI.
Check/apply Oracle released DB/System PSU patches on the servers,
Create and enforce IAM, Security, and Life Cycle policies.
Script/schedule RMAN backup to meet business requirement, schedule archive log backups for high transaction time frame.
Develop/debug/performance tune packages, procedures, functions, and triggers in the database.
Support/maintain ORDS/Apex Dev/Test/Prod environments.
Configure/Manage/Audit Alerts on the Security, resource usage, cost consumption.
Perform change management (CM) role on database components and implement change requests.
Partner with security teams to define, document and continuously refine Oracle Cloud roles, responsibilities, and access controls to meet project milestones.
Drove the development of standardize processes for provisioning and deprovisioning user access to Oracle Cloud environments.
Actively participate in user testing cycles in UAT to tweak role definitions and data visibility based on feedback.
Collaborate with project managers and Oracle teams on instance configuration, management, and scheduling activities.
Led end-to-end implementation of Oracle Cloud platforms encompassing setup of users, roles, data security and access models.
Configure and manage roles, permissions, data groups and access levels in Oracle Cloud applications and environments.
Environment: OCI/OIC, Oracle Fusion Procurement/ PIM/OM/FSCM/WMS/OTM(Descarte), Oracle19c/12c, OEM, Data Pump, TDE/Wallet, Win11/19, and Linux
University of Connecticut Sep 21 – Mar 22
Oracle DBA/Exadata DBA
Project: ITS: Manage and create large and complex Oracle databases designed to tailor university application support. Support to CS and FSCM Peoplesoft application and its integration with Control-M scheduler.
Guide and provide analysis to team in installation, upgrade, and maintenance of Oracle databases on Exadata machine.
Create/modify/maintain shell/cron scripts to data administration, alerting/monitoring/automating daily tasks.
Help design and develop new tools, document the procedures and processes.
Maintain and support Oracle RAC databases on Exadata machine, ensure database is encrypted thru TDE.
Monitor OEM alerts, check and resolve occurring issues and take action to prevent further occurrences.
Check RMAN reports to make sure all database backups ran successfully and are recoverable.
Help PeopleSoft Campus Solution application on Oracle Database.
Support CommVault application for encrypted backups.
Setup Data Guard, test out switch/fail over & switch/fail back.
Setup backup jobs using RMAN and recovery strategies, monitor and report back up jobs.
Supported Oracle Exadata, Grid, Database, DB Node and ILOM patching and upgrades.
Maintain, install, upgrade Oracle Database throughout product lifecycle.
Environment: Exadata, Oracle 18c/12c, OEM, Goldengate, Export/Import, SQL*Loader, TDE/Wallet, Win10/19 and Linux
OCR Services Inc: Nov 18 – Sep 21
OCI Admin/DBA
Project: GTM/EASE (Export Automation Solution Essentials): OCR provides a system solution for compliance industries. Industries deals with export/import, Defense, Aerospace, Arms and Sophisticated guns manufactures. Worked as a technical lead on cloud migration program with a scope of transitioning 350+ systems from on-prem data center to AWS and Oracle clouds. I was responsible for designing cloud architecture, leading cloud engineering team and coming up with migration strategy keeping in mind data security, resiliency, scalability, and operational viability. During the project, Created VPCs/VCNs, public/private subnets, implemented security groups, configured firewall/routing/Nat Gateways rules, developed cloud formation scripts, and setup monitoring. Along with my team, Setup NinjaRMM for observability by deploying agents and developed rules to create alert from logs, system activities, and security events. Contribution to the project resulted in migrating all the systems successfully with minimum service disruption.
Created VPCs/VCNs, public/private subnets, implemented security groups, configured firewall/routing/Nat Gateways rules, developed cloud formation scripts, and setup monitoring.
Created security and data backup and recovery (out of region) policies in OCI and S3 and Glacier
Setup Internet and NAT Gateways, Routing Tables, NACLs, and elastic Load Balancers.
Along with my team, Setup NinjaRMM for observability by deploying agents and developed rules to create alert from logs, system activities, and security events. My contribution to the project resulted in migrating all the systems successfully with minimum service disruption.
Created Terraform scripts to automated infrastructure provisioning on cloud to reduce the time
Automated java application installation and setup for immutable infrastructure from start to end using Terraform
and shell scripts, reducing time by 95% and eliminating human error by ~99%
Worked on the following cloud services: AWS: VCN/VPC, Route 53, EC2, S3, SNS, RDS (Oracle and SQL Server), IAM, Glacier and Oracle: Object Storage, Storage/Network Gateway, File Storage, Data Transfer, LB, FastConnect, Site/Client-to-Site VPN, Terraform
Supported EASE/VMI Application on PostgreSQL DB, Created, Backup/Restore Postgres DBs on request bases.
Environment/Cloud Services: AWS: VCN/VPC, Route 53, EC2, S3, SNS, RDS (Oracle and SQL Server), IAM, Glacier and SQL*Loader, Object Storage, Storage/Network Gateway, File Storage, Data Transfer, LB, FastConnect, Site/Client-to-Site VPN, Postgres, BARMAN tool.
Washington State Board of Community and Technical Colleges: Oct 14 – Oct 18
AWS Engineer/OCI Engineer
Supported $70M project through Ciber Inc. worked as AWS/Oracle Admin during the program lifecycle. The scope of the program was to migrate Peoplesoft applications and DBs to AWS cloud and post migration integrate HCM, FSCM, CS, and Portal to enable SSO. The project involved converting data from 38 colleges into 3 PeopleSoft modules, PeopleSoft Implementation and managed services were part of SBCTC project.
During the project,
Developed Oracle RDBMS 11g migration strategy and RMAN scripts to re-platform all DB tenants from Century Link Cloud to AWS Cloud US-West region.
Before migration, I developed AWS infrastructure to host Oracle DB instances supporting Peoplesoft Webservers.
Created PeopleSoft Domains and Databases for Campus, Finance, HCM and Portal.
Integrated all four pillars (Campus, Finance, HCM and Portal) using Integration Broker.
Performance tuned long running SQLs to reduce batch processing time.
Create and keep up todate the Environment summary, Network Diagram, and Port Plan
Design and implemented back/recovery strategy with Failover and Failback for all Databases.
During the project, worked on the following Cloud Services: EC2, RDS, ELB, S3, Route 53, ElastiCache, IAM, Cloud Watch,
Trimac: AWS Engineer/Informatica Developer Mar 15 – Nov 15
Worked on a large Oracle OLTP and Date Warehouse migration (8TB) to AWS IaaS. I worked as Data/ETL engineer responsible for leading ETL and data migration workstreams. During the project, I worked on the following:
Built the staging area by de-normalizing complex joins before using for ETL tools
Developed mappings, look-ups, and batch jobs in Informatica
Executed Informatica jobs to populate data into Data Warehouse (ODS) hosted on AWS infrastructure
Reconfigured Business Object reports to run on ODS
Supported Control M installations and configuration for scheduling batch jobs
Rationalized OLTP interfaces during the project to eliminate redundant interfaces and creating normalized views and data feeds using Informatica.
Create and keep up todate the Environment summary, Network Diagram, and Port Plan.
Hartford Health Care, Hartford, CT Feb 14 – Aug 14
Database Administrator/Consultant
Project: EPIC: Implemented Oracle Data Warehouse on Exadata, configured RAC failover clusters. Created conversion scripts from EPIC to Oracle DWH and supported conversion and migration of data from EPIC Cache to DWH.
Created Oracle database for HHC data warehouse system and PeopleSoft environments.
Supported all PeopleSoft databases and Epic data warehouse database on Exadata clustered environment.
Created and tested RAC failover on Exadata with physical standby database.
Configured Epic system interface to pull the data from Epic proprietary (Caché) database into Oracle database.
Helped Reporting Team/Business Object Team to configure to pull and do reporting using Crystal Reporting tool and Epic provided BO universes on Oracle database to complaint with Law, Medicare, Medicaid, and insured health care programs.
Setting GC threshold alerts on various resource utilization.
Configured Epic interface to send data into Cogido database (Epic provided slicer/dicer analytics tool) which allows monitoring Billing and in/outpatient records for reporting purpose.
Environment: Oracle 12c/11g, Exadata, ASM, RMAN, Cloud Control, Linux/AIX, Cache database, Epic Medical System, Business Object, and Crystal Report.
Open Solutions/Fiserv, Glastonbury, CT Feb 12 – Jan 14
Database Administrator
Project: DNA/Core (Banking System Solutions Services): Worked on few projects, Helped, and supported DNA application. DNA app has many components like Core Banking, Full-service Channel, Self-service Channel, Financial Solution, Document Management, Payment, Lending, and Corp Services.
Resolved issues on database upgrade/migration and disaster recovery failover, failback, and data guard.
Tuned several reporting/processing procedures and database performance
Assisting tech service team from database perspective to upgrade DNA.
Worked with Tech Service/Tech Analyst teams troubleshoot issues between, App Server, Web Server, SAF server, CMC server, ATM, VRU and Database Server. Supporting clients for P1 cases with pager rotation on 24/7 bases.
Implemented TDE/Wallet to protect sensitive information and safeguard Oracle Database.
Environment: Oracle 10g/11g, ASM, RMAN, OEM Grid Control, Export/Import, TDE/Wallet, Windows 03/08 and AIX/Solaris/Linux with/without VM ware.
The Hartford, Hartford, CT Jun 06 – Jan 12
Database Administrator
Project: BI/RAD (Business Insurance/Siebel Upgrade/PeopleSoft Upgrade): Worked on several projects, supported RAD (PeopleSoft) upgrade. Supported Siebel Prod DBs and upgrade from Siebel7 to Siebel8. Worked on Under Writing questionnaires (ICON 2), menu data driven approach for field agents
Conducted upgrade of Application 8 to 9.0 with People tools 8.45 on sun Solaris 9.0 and oracle 11g. An active team player worked very close to the project manager to evaluate and forecast the complex upgrade process.
Analyzed SYS/DDD Audit reports to ensure database integrity and support SOX compliance
Applied maintenance packs, bundles, security patches, coordinated database backup and refreshes, executed post refresh steps.
Ensured resiliency, high availability, and reliability of all enterprise databases. Provided technical expertise in the use of database technology and be accountable for the overall performance of the database environment, including PeopleSoft application and Web Servers using OEM
Built database administration support processes; define roles and responsibilities, security policies, monitoring policies, notification, and escalation procedures to be applied globally
Mentor the members of the DBA team, provide leadership on various technological fronts
Review requirements and evaluate technical risks/benefits for large/complex initiatives, creating contingency plans to support large complex projects
Identify technical database/infrastructure risk and capacity contention areas and implement improvements
Responsible for Create/Maintain, Clone/Copy Database for Siebel upgrade, Install/Upgrade Oracle s/w.
Tuned Siebel provided scripts to complete the upgrade in specific time frame
Data unload/load data using export/import and data pump
Responsible for backup/restore request with/without RMAN, Allocate, manage Physical/Logical storage for performance, Providing support to production database off hours.
Supported ICON 2 application on PostgreSQL, upgraded PostgreSQL from 8.4 to 9
Create/maintain ER diagram using Erwin data modeling tool.
Environment: Oracle 8/9i/10/11g, with/without RAC, RMAN, UNIX Shell, Cron and AutoSys, Perl, Erwin, and Linux AS, PostgreSQL8/9
Education:
Master of Computer Applications, Gujarat University, Ahmedabad, India (1992)
Bachelor of Science, Sardar Patel University, Vallabh Vidya Nagar, India (1989)