Data Oracle
Resume:
Jigar Patel
*****@**********.***
SUMMARY
8+ years of Professional experience as Database Administrator on Oracle 8i/9i/10g/11g/ 12c on various Platforms like Linux, SOLARIS, HP-UX, AIX and Windows.
Supported as Production and development DBA on OLTP, Data warehouse, OLAP, DSS environment. Involved in Change/Release/Patch management and offshore co-ordination, Product development, data center Migration, Upgrade and Integration. Administration including design, deploy, tune, trouble-shoot. Efficient to manage 50+DB. VLDB size in 125 TB.
Domain knowledge such as finance, telecommunication, Insurance, Investment banking. Worked on Oracle 11i, SAP, SIEBEL, peoplesoft, and other existing In-house applications.
Install 10g/11g/12c Binaries, Trouble-shooting of installation.
Goldengate installation, patching, upgrade for one/one and one/many environments. Performed lot of migrations /upgrade with no downtime export/import and Goldengate configuration.
Goldengate monitoring scripts for lag/discards/abended processes etc.
RAC Installation and Admin on UNIX platform. Load balancing. Manage fail-over. Backup CRS files. Tune cache fusion. Resource utilization on Nodes. Worked on VERITAS Cluster ware.
Managed ASM, create and prepare disk for ASM. Create ASM instance. Add/remove disk. Manage space on disk groups. Expertise on asmcmd commandline. Handle 4TB database on ASM.
Create databases using DBCA and Manually. Configure Listener, Tnsnames, pfile, password file.
Upgrade databases from 9i /10g/11g to 12c. Apply PSU and bug fix patch. Trouble-shoot upgrade process.
PATCHING regular PSU patching, Bug fixes, in Standalone and cluster environments for 9i/10g/11g/12c RDBMS.
Database Vault configuration for restricting privileged user to access application data and more.
Data Masking to protect Sensitive data like SSN, credit card in lower environment refreshed from Production.
Transparent Data Encryption (TDE) enabled tablespace to protect data accessing directly from Storage tier.
Migration of database and application on cross-platform from 8i/9i/10g/11g to 12c.
Change db name using NID, CCSCAN utility for change character set.
Data Guard Management, creation Physical/logical standby. Detect archival gap. Fail-over, switchover, snapshot standby database for DR testing. Open physical standby. Flashback of database. Configure Active data guard.
Backup/Recovery using RMAN and user managed. Create backup/restore strategies. RMAN, UNIX script for backup. Logical backup of schema using exp/imp. Clone database.
PL/SQL objects creation. Create trigger/ function/ stored procedure/ packages. Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Write database Monitoring PL/SQL objects. Create Materialize view.
Performance, Tuning of databases using ADDM, AWR, explain plan, stats pack, TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table. Top sql/session, bottleneck issues. Tune init parameter. Full table scan and Index usage.
Loading data using Import/export/ sql loader. Purging /cleansing data. Working Knowledge of Data stage, Informatica, Autosys. Refresh schema.
Scripting – Shell, Perl, PL/SQL, SQL. Write script for Monitoring, maintenance. Audit and as per required.
Technical Skills:
RDBMS : Oracle 8i/9i/10g/11g/12c
Operating System : Hp-Ux, Solaris, AIX, Linux, windows
Technology : EMC, Hitachi SAN. NAS. VERITAS cluster file system, RAC
Tools : TOAD, OEM, grid control, sql developer, Putty, Goldengate
PROFESSIONAL EXPERIENCE
Equifax Jul-18 to Till Date
Alpharetta, GA
Sr. Oracle DBA
Responsibilities:
Supported as ON-CALL DBA for weekly rotation.
Cross Platform database Migration from AIX 11g/12c to Linux 12c using Datapump/Goldengate/XTTS.
Create Active Dataguard Database for disaster recovery and high availability.
Create bi-directional Goldengate for cross-site load balancing and Disaster recovery.
Installation and configuration of Goldengate for migration with Zero downtime.
Create and manage wallet for TDE encryption tables/Tablespaces.
Cross Platform migration of very Large databases in size of ~100TB using goldengate and XTTS (Transportable Tablespaces)
Environment: Oracle 11g/12c, Putty, IBM AIX, OEM 12c, RAC, Active Dataguard, Goldengate
BIAS Corporation Jul-17 to Jul-18
Roswell, GA
Sr. Oracle DBA
Responsibilities:
Database Migration from 11g/12c to 12c Exadata using Datapump/Goldengate/XTTS.
Create physical standby/ Active Dataguard Database for disaster recovery and high availability.
Installation and configuration of Goldengate for migration with Zero downtime.
Resolved issues with Goldengate components like Extract, Replicat, Trail Files, GGSCI commands, Tranlog options etc.
Create and manage wallet for TDE encryption tables/Tablespaces.
Cross Platform migration of very Large databases in size of ~30TB using goldengate and XTTS (Transportable Tablespaces)
Environment: Oracle 11g/12c, Exadata, Putty, OEM 12c, RAC, Active Dataguard, Goldengate
Office of the State Comptroller Nov-14 to Jun-17
Albany, NY
Sr. Oracle DBA
Responsibilities:
Support PeopleSoft database such as IH, HC, CR and FS for Re-design project.
Managing around 50 databases with 15 uni/bidirectional goldengate configurations.
Installation, configuration and support oracle goldengate unidirectional table/schema level between DB2 to oracle rdbms replication.
Resolved issues with Goldengate components like Extract, Replicat, Trail Files, GGSCI commands, Tranlog options etc.
Perform routine database tasks, which include but not limited to backup management, space management.
Configure Oracle wallet to setup TDE tablespace and column encryption and transfer data securely between Database and oracle Client.
Performed upgrade and migrated DBs from 10.2.0.4 to 11.2.0.4 using goldengate.
Migrated DBs from AIX to Linux using goldengate and export import.
Take part in planning meetings for capacity, infrastructure, migration etc.
Database vault configuration to Control database access on privileged user access to application data
Data masking to protect user sensitive data like SSN, Credit Card number.
Setup/administer Oracle database security environment with wallet, vault, encryption, Masking.
Configure/Support Active Dataguard on for Disaster recovery;
Setup of 11g R2 8 node RAC on IBM AIX for STG, PRD and DR environment. Load testing of Oracle RAC with help of swingbench load runner /Benchmark Factory. Testing of TAF, load balance and node eviction.
Develop UNIX shell scripts for daily and weekly backup jobs, Backup reports, trace file delete.
Cloning/duplicate of database with OEM 12c and Manual.
Provide technical assistance and troubleshooting support to developers and PS Admin;
Database/ASM/Server/Storage monitoring through OEM 12C
Environment: Oracle 11g, Toad, Putty, IBM AIX, OEM 12c, RAC, Active Dataguard, Goldengate
DSNY (Department of Sanitation) Apr-13 to Oct-14
New York, NY
Sr. Oracle DBA
Responsibilities:
Supporting over 100 databases on various platforms. Mainly RHEL/Solaris. RDBMS 10g and 11g
Working as goldengate replication expert.
Support GPS and Peoplesoft database such as Finance and HR for DSNY.
Work 24*7 as a part of on call schedule.
Write process/work instruction documents for the DSNY SMART.
Setup/administer Oracle database security environment;
Configure/Support Active Dataguard on for Disaster recovery;
Configure/Support Goldengate 11g on for Bidirectional replication for sqlserver using goldengate
Setup of 11g RAC on RHE Linux for STG & PRD environment. Load testing of Oracle RAC with help of mercury load runner. Testing of TAF, load balance.
Help design Export, Pump and Replicate parameter files for replication. Between sqlserver / oracle databases in an effort to consolidate Peoplesoft and GPS database.
Develop UNIX shell scripts for daily and weekly backup jobs;
Develop/maintain Oracle database operational procedures;
Cloning/duplicate of database with RMAN backups.
Manage distributed databases and configuring client/server and Web-based environments;
Provide technical assistance and troubleshooting support to developers;
Review database design specifications and application coding routines to ensure adherence to best practice methods for database usage;
Manage Database through EMC VERITAS Cluster.
Database monitoring through OEM 12C
12c Exadata migration from 11g.
Environment: Oracle 10g/11g, Exadata, Toad, Putty, SOLARIS, OEM 12c, VCS, Active Dataguard, Goldengate
Pfizer Mar-11 to Mar-13
Collegeville, PA
Oracle DBA
Responsibilities:
Work 24*7 as a part of on call schedule.
Involved as primary DBA in datacenter closer project with team of five DBAs.
Setup and maintenance of DATA GUARD on 10g, 11g for Disaster Recovery and reporting purpose with various modes.
Upgraded and migration from 10g to 11g using GOLDENGATE with zero downtime on production database.
Worked with Oracle Enterprise Manager, Net configuration assistant.
Created database links to retrieve data from multiple servers.
Planned the index rebuilding, index analyze and table analyze on periodical basis.
Upgrade database from 9i to 11g. Performed a data conversations and compilation of invalid objects.
Installed and configured Oracle 9i/10g on SOLARIS, REHL/HP-UNIX.
Create databases manually. Configure Listener, Tnsnames, pfile, password file.
Upgrade databases from 8i/9i /10g to 11g. Apply PSU and bug fix patch. Trouble-shoot upgrade process.
Build and tune databases, setup and implementation, backup and recovery procedures
RMAN backup tape identification in case of database restoration.
Database restore using RMAN.
Database/schema refresh using exp/imp & expdp/impdp.
Environment: Oracle 8i/9i/10g/11g, Toad, Putty, HP-UX, RHEL, LINUX, SOLARIS, AIX, Goldengate, Active Dataguard, OEM 11g R2.
Contact this candidate