SUMMARY

• 9+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle RDBMS.
• Involved in all phases of the SDLC from analysis, design, development, testing, deployment
• Strong experience in Data warehouse concepts, ETL & Reports (SSIS & SSRS)
• Developed Complex database objects such as Stored procedures, functions, Packages & Triggers using SQL & PL/SQL
• Experience in Dynamic SQL, Collections & Exception Handling & Oracle Analytic Functions
• Experience in working with Cursors, Ref Cursors, Oracle Collections, Partitioned tables, Exchange Partition Options & Transportable tablespaces
• Experience in Performance Tuning - tuning Oracle memory & SQL utilizing diagnostic tools such as AWR, Explain plan, SQL Trace, SQL Tuning Advisor, TOP commands, HINTS
• Excellent communication, interpersonal & analytical skills and strong team & PROJECT management skills
• Experience in RAC setup on RHEL, creating ASM disk groups & ASM instance
• Configuring TAF & managing database services
• Preform ongoing database maintenance, patching and upgrading for Oracle
• Plan, test & implement backup & recovery strategies using RMAN & datapump
• Plan, test & implement database refresh procedures using data migration techniques, shell scripts, auxiliary database, cloning
• Performance tuning Oracle Memory / Instance, SQL Queries, ADDM & AWR; OEM
• Experience in working in Development, Staging & Production Environments

TECHNICAL SKILLS

• Oracle PL/SQL Programming
• Oracle 9i 10g 11g & 12c (RAC)
• Oracle DBA (RAC & ASM
• Oracle SQL Developer
• TOAD
• SSMS
• BIDS
• Data Modelling
• OEM Grid control
• AWR
• ADDM
• VPD
• ETL & Reporting - SSIS & SSRS
• SCP
• Win SCP
• Putty
• Performance Tuning
• SQL Server Versions 2008 R2 & 2016
• Data Migration & Database Refresh
• Oracle Support & Metalink
• Shell Scripting
• SSIS
• SSRS
• Erwin4.0/7.3
• Windows & Linux 5.x
• Shell scripts
• Agile & Version control tools- Visual Studio
• TFSSCRUM
• JIRA
• VersionOne
• ConnectWise

PROFESSIONAL EXPERIENCE

ORACLE PL/SQL Applications Developer/ DBA

Confidential, NJ

Responsibilities:

• Developing Stored Procedures, Triggers, Functions
• Setting up multi-tenant schema and data population
• Performance tuning/designing partitioned tables
• Extensively working on partitioned tables, exchange partitions and developing related stored procedures
• Preparing scripts for migration of data from development to staging to Production release & version control
• Designing E/R Models for better understanding of schema

Environment: - Oracle 12c, Multi-Tenant Arc. PL/SQL

Oracle DBA/Developer

Confidential, NJ

Responsibilities:

• Design E/R Models & solve critical database issues; space management
• Apply PSU patches & design data migration plans
• Implement Oracle FGA using custom made PL/SQL procedures, custom made functions to setup Oracle’s VPD & database maintenance tasks
• Test & Implement Oracle’s RMAN backup & recovery policies
• Performance tuning & designing database refresh procedures for test environments

Environment: - 2 node RAC Oracle 11gR2, SQL Server 2012, MySQL

Sr. DBA/Developer

Confidential, NJ

Responsibilities:

• Performed initial installation/creation of 11g Oracle databases
• Implemented conceptual database designs and logical models
• Planned and implemented backup and recovery strategies
• Performed capacity planning for database growth, user management & space management

Environment: - standalone 11g production & development databases, initial setup

SR. Oracle Developer/DBA

Confidential

Responsibilities:

• Worked on numerous US Healthcare domain projects for clients GE (General Electric), Hyland software, Ability Networks)
• Working with clients, information architects, system admin and developers to define information flow helping to transform business requirements into environment specific databases
• Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)
• PL/SQL Development & Coding
• Configuring TAF & database services, testing failover operations for RAC
• Performed ongoing patches both rolling & downtime patches
• Performed Database Refresh from Production to QA, Staging and Development databases using shell script.
• Implementing BDD code and packages in the staging environment
• Configuring RMAN backup & testing recovery including flashback recovery
• Maintaining Recovery catalog database
• Creating RMAN auxiliary instance for developers testing environment
• Creating & Managing application users using Authstore application, post database refresh

Environment: - Max db. size 17 TB, OS- RHEL 5.x, Sun Solaris 5.10, Production (3 node RAC), Staging & Testing db.

Sr. DBA/Developer

Confidential

Responsibilities:

• Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)
• Developing and maintaining operational standards/procedures for Oracle
• Optimizing database uptime/availability and performing database audits
• Creating physical standby for failover and monitoring log sync operations
• Managing user accounts
• Performance tuning sql and instance

Environment: - Max db. size 5 TB, 2 node RAC setup, standalone databases & physical standby

Oracle DBA

Confidential

Responsibilities:

• Oracle Standalone Db. Installation, Design & Maintenance for new project at client side BOBCARDS.
• Implementing Physical Standby Db. on Production environment & Performing DR Drill activity
• Database Purge from Production to the Legacy database
• Monitoring databases for redo log gaps, database users & quota management, creating database objects & index management, DB Links, import & export of data using Datapump
• Creating, Scheduling & Monitoring database backups using RMAN & OEM
• Generating Explain plan, Statspack report & troubleshooting database performance issues

Environment: - Max db. Size 2 TB, Oracle 9i & 10g R2, RHEL 4x; Production & Test db. Standalone with physical standby