SUMMARY:

• Strong ORACLE 12c/11g/10g Architect/DBA/Development (Application and Production Support). Well versed in support of high availability systems including Replication, Data Guard (standby), Real Application Clusters, Exadata in Unix, Linux and Windows systems etc.
• Conversant with AWS cloud Technologies and related toolsets.
• Experience in Big Data migration, development projects using HDFS, Hive, Impala, Sqoop.
• Developed data analysis scripts and optimized distributed computing in Hadoop/Spark using Python, Pysql.
• Experience in Supporting Oracle 10.2.X - 12.X, Exadata Servers, Installation and Configuration of multi node 64-bit Oracle 11.2.0.3 RAC cluster on Dell 2800 Servers running Redhat Linux AS 5.X.
• Experienced in database design, SQL, PL/SQL (Stored Procedures, Functions, Packages, and Triggers), SQL Tuning, and Dynamic SQL.
• Top Notch SQL performance tuning, troubleshooting skills and adept at application design issues.
• In-depth experience with Pro*C (with co-related queries, file pointers, library functions, changing database connections) and PL/SQL, SQL tuning (ref cursors, Pipeline functions, PL/SQL tables, bulk
• Expert in day-to-day administration. Extensive experience in supporting mission critical instances, operations) very Large databases, data warehousing, OLTP/OLAP Strong with installation, configuration, physical & Logical database design, performance tuning, backup and recovery, Disaster recovery. Experience supporting validated and strictly controlled environments.
• Strong experience working as an Application Support DBA. Responsible for Application Design, Installing Oracle Servers, Creating Development and Testing databases, assisting developers with Fine tuning application code.
• Data warehousing experience includes Star and Snowflake Schema Design, Home grown ETL scripts in Shell and Pl/SQL, SQL*Loader, Informatica Development, partitioning which includes Range, List and composite, Batch Jobs Strong in Data Mapping and Data Loading techniques
• Strong with Data modeling using ERWin, Forward/Reverse engineering, Normalization etc
• UNIX Administration experience includes Installation, configuration, troubleshooting, fine tuning and support of HP and Solaris Platforms.
• Used Oracle Features Like Analytical Functions, In-Line Views, Materialized Views for Query Re-write, Invoker rights for Stored Procedures/Functions/Packages, Schema/System level Database triggers, Bulk DML, Collections, Function Based Indexes, DBMS Packages, etc
• Adept at C, Pro*C, PL/SQL, Sqlplus and versed in Java/XML/XSLT.
• Strong Unix development skills in Shell, Awk, Sed, Expect, Perl, Python.
• Supported fortune 500 clients and large mission critical databases from clients like Barclays, BankofAmerica/Merrill Lynch, Confidential, Confidential, UBS-PaineWebber, AXA, Fleet Securities, Johnson & Johnson, PSEG, Shop Rite.
• Strong Leader with sense of ownership, commitment, excellent communication, team building and mentoring skills.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.20, AIX 5.2, SUN SOLARIS 9, Red Hat Linux AS 4.0, OS2, WindowsHadoop/Big data/Cloud: AWS, HDFS, Hive, Sqoop, Parquet, Oozie, Hue, HBase, MapR, Impala

Hardware: HP 9000, RS 6000, SUN E10K/5500/Ultra/Fire 880, Compaq 6500/3000

Languages:: Python, C, Pro*C 2.2, Sql*Plus, PL/SQL 10

Web: Weblogic 8, IIS, HTML, JavaScript, Java, XML, XSLT, XSQL, and XPath

UNIX utilities:: Shell, Perl, Awk, Expect, Make, dbx, xldb, Sed, SCCS, PVCS.

Databases and utilities:: Oracle 8i-12c, Erwin, Designer 2000, Export/Import, Sql*Loader, OEM Grid.

ERP/Data Warehouse: Peoplesoft (HR 8, Financials 8, EPM 8.8, BAM 8.8), SQR, Informatica, Data Stage

Tools: Crisp, CodeWright, Exceed, MS Excel/Project, Documentum, Sql*Studio, Embarcadero.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Senior Performance Analyst/Oracle DBA/Architect

• Monitored VLDB applications running on 2/3 node Veritas clusters for various production, performance issues.
• Responsible for database architecture, Hands on SQL tuning, PLSQL Development, mentoring developers in using oracle latest features, interpret query plans, generating stats, dealing with query plan flips, pipeline cursors, analyzing awr/addm and make the development teams self sufficient.
• Top Notch SQL, DB, Application Performance tuning skills along with an out of box approach towards complex issues in Equities, Fixed income applications. Decreased the critical batch load times by making use of PLSQL pipeline functions, array processing with bulk operations. Extensive SQL tuning on OLTP applications by way of indexing, partition pruning, stats gathering, proper sequence and scheduling of critical jobs.
• Supported Mission Critical applications (30 TB) running on Exadata and resolved various bottlenecks.
• Installed, Configured Oracle Gateway for accessing data from Sql Server into Oracle real time.
• Responsible for Installation and Configuration of multi node 64-bit Oracle 11.2.0.3 RAC cluster on Dell 2800 Servers running Redhat Linux AS 5.X.
• Familiar with Oracle Discoverer, App Server, Web Server and other middle tier Components.
• Extensively monitored the database for performance using OEM grid control, AWR reports, Oracle Wait Interface and command line utilities like - Explain Plan, Auto trace, 10046 and 10053 events.
• Extensively configured Data Guard, flashback database and well versed in resolving Data Guard issues, Data Restore scenarios.
• Responsible for end to end analysis of performance analysis (Database, Application Server and Webserver), load estimation and capacity planning.
• Responsible for setting up Rman backups, TSM (Tivoli) backups and scheduling Autosys jobs.
• Well versed in Disaster Recovery exercises, failover, switchover, production issues remediation, escalation procedures and quick resolutions. (Oracle 11g/Oracle 10g, Exadata, Oracle App Ser/Mid Tier, Oracle Gateway, Discoverer, Rman, SQL, PLSQL, LDAP, Shell, Autosys, Tivoli Storage Manager, Shell, Awk)

Confidential, Princeton, NJ

Oracle Consultant/Performance DBA

• Worked extensively on tuning mission critical OLTP applications in Asset Management, News Plus and Data Warehouse projects.
• Involved in Installation and Configuration of two node 64-bit Oracle 10.2.0.1 RAC cluster on Dell 2800 Servers running Redhat Linux AS 4.0.
• Extensively monitored the database for performance using OEM grid control, AWR reports, command line utilities like - Explain Plan, Auto trace, 10046 and 10053 events.
• SQL Performance Tuning was achieved by reducing multiple DB calls using WITH clause, incorporating Analytical Functions, new Indexes, Sql Query Hints, Ref Cursors and caching tables.
• Assisted the Developers in XMLDB development and supported Oracle 10g R2 Oracle Text.
• Wrote SOP Guides as required by the client (Oracle 10.2.0.1 Oracle Text, XMLDB, Red Hat Linux AS 4.9 Update 3, Grid Control, Oracle 9.2.0.7, PVCS, PLSQL, Shell)

Confidential, Roseland, NJ

Oracle DBA/Architect

• Installed and Configured Oracle 10.2.0.3 servers, Migrated Oracle 9i databases to Oracle 10.2.0.3.
• Assisted the DBA team in identifying the performance bottle necks using Oracle wait interface and fixed the I/0, CPU intensive SQL’s.
• Assisted in converting, testing and deploying third party application LONG columns into BLOBS.
• Extensively involved in tuning the ETL operations and decreased the ETL turn around time as well Report response time - by rewriting SQL, using Materialized with Query Rewrite. (O racle 10.2.0.3/9.2.0.7 , AIX 5.2, SQL, PLSQL, XDK, StatsPack, Embarcadero 8, Unix Utilities, PVCS)

Confidential, Mahwah, NJ

Oracle Consultant (Performance, Development, DBA)

• Responsible for Installation and Configuration of O racle 10g/9i databases , upgrading Oracle 8i databases which support Data warehouse and various OLTP applications in FDA regulated environment.
• Successfully tested switchover, swapping of database roles and deployed Oracle Data Guard for various production databases.
• Converted various access databases to Oracle 9.2.0.5 . Responsible for writing and maintaining the documentation as per FDA regulations. Attended the 21 CFR part 11 and Sarbanes Oxley audit classes .
• Extensively worked on third party applications like LanDesk, NetRegulus, Adaytum and fixed performance bottlenecks . (Oracle 10.1.0.4, Oracle 9.2.0.6/8i, SunFire V880, Veritas NetBackup, SunOS 9, Cognos, ReportNet, Adaytum, Korn Shell)

Confidential, Jersey City, NJ

Oracle PeopleSoft/Data Warehouse DBA

• Involved in the design/development/Production support of Peoplesoft instance running on Oracle 9i. Supported Data Warehouse and other OLTP applications.
• Installed, Configured and upgraded Oracle 9.2.0.3 on Red Hat Linux Advanced Server 2 for development and Oracle 9.2.0.3 on Solaris 8 for production.
• Strong experience in configuring, maintaining Peopletools, Peoplesoft 3-tier architecture, application servers, Web servers and Process schedulers.
• Experienced in troubleshooting, performance tuning of the 3-tier architecture. Created, supported various peoplesoft databases for development, testing and production environments.
• Performed project migration among various Peoplesoft database environments. Experienced in creating, maintaining Peoplesoft databases within the same Oracle database instance. ( Sun E10K, Solaris 8, Red Hat Linux, Erwin 4.6.2, Oracle 9.2.0.3, XDK, Rman, PeopleTools 8.44, PS Financials 8 sp3/HR 8.3 sp1, EPM 8.8/BAM 8.8, Weblogic 8, Informatica 6.2, Sql*loader, Veritas NetBackup, Java, XML, XSLT, Shell)