SUMMARY:

• 9+ years of technical expertise in providing solution design and developing application using Oracle 9i/10g/11g/12c. Analyzed, designed and implemented business application in Oracle using AGILE development methodology.
• Expertise in creating, implementing, maintain oracle applications using oracle packages, stored procedures, function, and triggers. Written automated script for creating user, employees and application access responsibilities.
• Expertise in Exadata X6 - 2 Eighth Rack with upgrade memory and storage (DR aslo), 2x database server’s, 44 core databases with 109 TB mirror database disk storages production database. And 2x database server’s, 88 core database with 181 TB mirror database disk storage non production databases.
• Expertise in working with ZFS ZS5-2 Storage appliance rack, with advance gateway support.
• Expertise in creating, modifying report using OEM 13c/12c with BI publisher 11.1.1.9, 12.2.1.
• Expertise in cursors and ref cursors for data processing.
• Expertise in creating in automated script for running nightly process for ETL data push from flat file to database tables. Also verifying database connection.
• Expertise in creating nightly process for monitoring size of tablespace and verify the threshold limit for the tablespace. Created script that runs in crontab for ETL and performance monitoring.
• Expertise in writing bash scripts for automated process like verifying DBlink’s.
• Expertise in using PL/SQL wrappers to protect the PL/SQL procedures or packages, also made utilization of Oracle supplied packages like UTL FILE, UTL STMP, DBMS JOBS, DBMS SCHEDULER, AND DBMS SQL inside the procedure and package.
• Experienced in Performance Tuning of queries using Explain plan, TKPROF and Indexing. Analyzing the explain plan using v$sql plan and dbms xplan.display.
• Expertise in using the oracle profiler in package. i.e., DBMS PROFILER and DBMS HPROF.
• Data migration utilities like SQL Loader, data pump utilities like Export/Import. Written code and implemented pl/sql packages to perform application security and batch scheduling.
• Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experienced in high availability technologies such as Oracle 11g/12g RAC, Veritas cluster, HACMP, ASH, ASM, Data Guard/Standby database, Database Replication/Clone.
• Experienced in installing and managing Grid control. Experienced in implementing databases on SAN, NAS systems.Troubleshooting performance issues and fine-tuning queries and stored procedures using Explain plan, SQL Trace and TKPROF.
• Experience in creating reports using different reporting tools like report builder, MSBI, informatica powerbuilder.
• Experience in installation of Oracle Transportation Management (OTM).
• Setup Expert in disaster recovery. Worked with development teams and data administration staff to enhance Database and application performance. Experience in managing large Oracle databases (VLDB) which includes OLTP as well as Data Warehouse databases.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle11g, Oracle 10g (RAC & Data Guard), Oracle 9i, Oracle 8i, Oracle 7.x., SQL Server 2008

ERP Applications: Oracle E-Business Suite 12.2.6/12.2.5/11.5. x, Primavera P6 EPPM

Reporting tools: Report Builder 12c, informatica powerbuilder, MSBI, PowerBI, Crystalreports 8.5/10/11

Languages: SQL, PL/SQL, Shell Programming, HTML, C#, ASP.NET

Utilities: SQL Loader, Export / Import, Data pump, TKPROF, Statspack.

Environment: UNIX (Sun Solaris, HP-UX AIX) WINDOWS 98/2000/2003/ XP, Linux (Red hat enterprise,Oracle), .Net

Tools: SQL*Plus, SQLDeveloper, SQL*Loader, TOAD 9/12, SVN, Filezilla, Mobaxtrem, WinScp.

Office Tool: Office 365, MS Project 2013, MS Visio 2013, MS OneNote

PROFESSIONAL EXPERIENCE:

Confidential, FL

Lead Oracle DBA

Responsibilities:

• Lead projects involving in deployment, used and enhancements of Oracle production applications.
• Assist Oracle programmers and developers with database design for maximum query optimization.
• Clone the Oracle production environment for test instances.
• Perform and strategize upgrades and patches according to client needs.
• Plan and apply critical Oracle patches and upgrades in a timely manner.
• Design, create and maintain the End User Layer to ensure the security of the Crash Information (CI).
• Control and monitor via audits all user access to the End User Layer.
• Manage all databases using Oracle Enterprise Manager Cloud Control.
• Manage system resources such as space allocation, memory structures, CPU utilization, etc.
• Migrate, develop, and maintain automated DBA maintenance scripts using OS agnostic scripting language
• Ensure the highest degree of system availability using industry best practices and available system resources.
• Ensure a rigorous security posture is maintained to protect CI data.
• Assist in resource planning and future database growth assessments.
• Perform and periodically test database backup and recovery procedures.
• Assist in design, enhancements, testing and maintenance of enterprise DR/BC infrastructure.
• Develop and maintain KPI’s and Dashboards leveraging Oracle Cloud Control and scripting. Perform any data and system analysis to support this function.
• Assist in the ongoing effort to develop and maintain policies and procedures for SOC Type 2 compliance. Ensure necessary policies, procedures and documentation requirements are followed.
• Coordinate DBA responsibility with backup DBA
• Support Corp. Informatics staff to optimize query performance using Business Objects.
• Coordinate system maintenance windows with other area department staff in an effort to minimize downtime.
• Architected Native to LDAP migration process.
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Informatica PowerCenter Grid implementation.
• Architected and designed end to end process automation for Informatica ID recertification to meet hsmv compliance goals.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Work on special projects assigned by Management.
• Worked on Exadata X6-2 Eighth Rack with upgrade memory and storage (DR aslo), 2x database server’s, 44 core databases with 109 TB mirror database disk storages production database. And 2x database server’s, 88 core database with 181 TB mirror database disk storage non production databases.
• Working with ZFS ZS5-2 Storage appliance rack, with advance gateway support.

Oracle General: RDBMS 11gR2, 12c, Cloud Control, ASSM / AWR, ASM, Cloning, OMF, RMAN, SQL, PL/SQL, Database Tuning, SQL tuning, Partitioning, Streams, Data Guard.

Oracle Migration / Installations / Integrations - RDBMS, Mid Tiers, Clients: Install, Upgrade, Patching, ODBC / JDBC, LDAP / AD, COTS applications.

Oracle Security: OID / SSO, Policies, Resources, Fine Grained Auditing, Advance Security - Redaction / Encryption, Subsetting / Masking.

Oracle Applications: ETL, Warehousing, Changed-Data Capture, GoldenGate

Confidential

Senior Oracle DBA

Responsibilities:

• Analyzed business requirements to design Entity relational Diagrams (ERD) and prepared.
• Participate in the preparation of project plan for upgrade system, including requirement, task, work assignments, resources, and inclusion of project milestones, review points and reporting.
• Create new and maintain existing SQL/PL-SQL Procedures for extracts and ETL used by internal and external customer and develop interface into oracle 12c database.
• Provided Database services to various clients. Planned and implemented the Database upgrade process from 8.1.5 to 9.2.0.1
• Performed extensive SQL/Database tuning Design to enhance the search functionality.
• Developed complex stored procedures using dynamic sql and Ref cursors in PL/SQL to support the website search engine.
• Served as a team lead and supported several developers.
• Improved database performance by configuring parameters for SGA, Shared Pool and performed Oracle query tuning & optimizations.
• Extensively worked on Informatica Mappings/Sessions/Workflows to load data from Oracle to TD and vice versa.
• Provide technical guidance and assistance to employees on SQL and database related issues.
• Closely working functional to resolve application related issues like performance tuning.
• Written script for automate the process, and create logs based on the process performed.
• Created automated script for role based access control for applications, which will assign role and responsibilities for employees in each assignment group.
• Planned and implemented the database upgrade from 11g database to 12c.
• Involving database upgrade the oracle 11g EBS upgrade from R12.0.3 to R12.1.3.
• Database capacity planning and performance tuning.
• Worked on SQL Tuning using Explain Plan.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Worked on logical and physical data modeling and created Materialized views.
• Responsible to load various table data, flat file data to populated and processed on daily basis ROM legacy to online production environment using SQL*LOADER.
• Worked on Pushdown Optimization to optimize Oracle loads.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Creation and maintenance of Informatica users and privileges.
• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Designed and documented ETL standards document.

Oracle General : Oracle 11g/12c, PL/SQL, PL/SQL, Mobaxtrem, Winscp, UNIX and Windows.

Reporting tools: oracle Reports 3.0,oracle Forms 5.0, informatica powerbuilder, MSBI

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle 11g databases. Upgraded database from 9i to 11g.
• Designed, planned and implemented Oracle backup/recovery solution using RMAN.
• Maintained multiple instance databases for cutting edge web based e-commerce applications.
• Created Oracle databases (single instance & RAC). Managing large Oracle databases (VLDB) which includes OLTP as well as Data Warehouse databases
• Implemented data models, database designs, database access, and maintenance
• Created Backup plans for production, Test and Development Databases. Configured and managed RMAN.
• Create data subsetting and data masking using TDM (CA Test Data management).
• Identified Top SQLs and tuned them using OEM (Diagnostic and Tuning Pack) and Spotlite.
• Monitored tablespace growth, reorganized objects, created and rebuilt indexes, partitioned tables, schema maintenance, analyzed schemas and space management.
• Wrote shell scripts for backups and provided alert notification through mail and text messages for database unavailability.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Deployment of Informatica Mappings/Sessions/Workflows into Production environment. Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Involved in basic administrative activities like starting/stopping test server, installing/uninstalling, and starting/stopping test and development enterprise applications.
• Performance tuning effort for the existing and future Application modules.
• Worked with development team in creating DBA best practice methodologies, creating uniform database development standards, guidelines, procedures, and processes.
• Monitored all database objects, including tables, clusters, indexes, views, sequences packages and procedures.
• Wrote SQL queries and PL/SQL procedures, functions, packages and triggers
• Controlled database changes and ensuring synchronization amongst different environments.
• Maintained database security and adhere to security policies designed by the corporate IT governance.
• Technical troubleshooting and consultation to database development teams.

Environment: Oracle 10g, HP-UX 11, Red Hat Linux 4.x, Toad, Spotlight, Foglight, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, RAC, RMAN, Import/Export, Forms 4.5/5.0, Reports 2.5/3.0, TDM

Confidential, MA

Oracle DBA

Responsibilities:

• Worked on Implementation of Oracle10g RAC (Real Application Cluster) on Linux.
• Oracle RAC Planning & Implementation including Servers, Storage, Network and Management tiers.
• Maintenance and support for RAC Infrastructure components and Database.
• Configured Physical Standby database (Data Guard) using RMAN backup.
• Used Oracle 10g Grid control for Monitoring and Managing at enterprise level.
• Installed, Configured and upgraded oracle server software.
• Worked extensively on Performance Tuning using AWR and ADDM Reports.
• Worked on database migration (10g-11i) Database Patching and Cloning.
• Manage ASM disk groups via ASMCMD and database control.
• Designed E-R Diagrams, logical and physical data modelling.
• Setting up of regular backup (Hot, Cold), recovery and regular testing of recovery in test environment.
• Customization and automation of regular DBA activities and operating system specific tasks using shell scripts.
• Expertise in Unix Korn Shell scripting, and good knowledge in Perl scripting.
• Experience in virtualization (VMS) with creating and managing virtual server pools running on different Operating systems.
• Used SQL*Loader for loading Data.
• Worked with SAS data sets.
• Experience in Oracle Streams.
• Worked with Golden Gate for providing a innovative product for unidirectional and bidirectional replication purpose.
• Worked with Oracle clusterware software for the node connections.
• Expert in device allocation and de-allocating commands and validation checks.
• A good knowledge of the way Oracle enforces data integrity.
• Installed Oracle Primavera P6 EPPM R8.3.2 and configured the LDAP authentication with the Enterprise AD.
• Experience in Data Conversion using Pl/Sql and XML.Transferred data using export/import and data pump utility.
• Familiarity with Oracle ASO.
• Worked with more complex database with analyzing, designing, creating and implementing.
• Supported development team by providing SQL statement tuning, optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL trace and TKPROF.
• Worked with data modeling by constructing data decomposition diagrams and creating data flow diagrams.
• Worked in Oracle embedded SQL environment Pro*C working with the scripts and executing.
• Good Knowledge in Transportable tablespaces.
• Partitioned very large database tables and indexes and placed them in separate tablespaces.
• Working as a member of production DBA team in perfect coordination with Managers and team members. Worked as a production DBA in 24 x 7 support environment.

Environment: Oracle 9i/10g, SQL, PLSQL Packages, Procedures, Functions and Triggers, Oracle Forms and Reports (6i,9i,10g) SQL*Loader, HTML, CSS, Java scripts, TOAD, Primavera P6 EPPM R8.3.2.

Confidential, New York, NY

Oracle DBA

Responsibilities:

• Provided database administration and 24*7 support for 1TB production and development Oracle 10g databases.
• Responsible for installation and creation of workstation databases for production development and user acceptance testing.
• Developed scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Implementing, configuring and testing RAC in test environment.
• Upgraded the database from 9.2.0.4 to 10.2.0.3 and applied patches when required.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Statspack, Explain plan and SQL*Trace.
• Populated staging tables with data using SQLLDR and PL/SQL.
• Created database objects, users, roles and profiles.Performed cloning using RMAN to set up development and test databases.
• Involved in database migration from single instance to RAC using database upgrade assistant and export/import.
• Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those. Performed daily health check of the databases by implementing above backup and recovery procedures.
• Start and stop database instances and listener. Responsible for automation of startup and shutdown on all production and development databases.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN and Data Guard. Installed and configured Recovery Manager.
• Configuration of Oracle streams for replication between two databases.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager. Hence responsible for setup and configuration of OEM. Involved in Data refresh from production to test and development.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Resolution of problems and issues coming up in the database according to predefined mutual service statutes.
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
• Experience in recovering the database in case of failure (Complete/Incomplete recovery)
• Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.
• Troubleshooting of Database replication issues.
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 11g, SQL* Plus, Erwin Data modeler, TOAD, Solaris 10, PLSQL Packages, Procedures, Functions and Triggers, TOAD, UNIX.

Confidential, CA

Junior Oracle DBA

Responsibilities:

• Perform database analysis, design, coding, testing and implementation of database structures.
• Create Schema objects (tables, indexes, views, sequences, synonyms, roles, packages), grant roles to users.
• Developed various packages, stored procedures for access checks in order to enforce security in application.
• Designed and developed daily refresh programs using PL SQL from SAP to PIX.
• Optimized daily database refreshes by using SQL Loader approach over scheduled jobs (stored programs).
• Fine-tuned SQL Loader performance using Direct-load mechanism.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader. Maintained and modified the Shell Scripts.

Environment: Oracle 9i/10g, Oracle Enterprise Manager, HP UX 11i, Toad 8, ER Studio 7.1.2, Rational Clear Case

Confidential

Oracle Developer

Responsibilities:

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Designed coding specification and documentation.
• Created public synonyms on the database links for easy reuse.
• Wrote complex SQL queries to generate views for the purpose of the administrative department.
• Monitored database performance using Explain plan and SQL trace.
• Managing tables and storage structures within a table.
• Created indexes for faster retrieval of data and better performance tuning.
• Generated crystal reports for billing information.
• Used various Joins techniques for data retrieval from multiple tables according to the requirement.
• Managed and resolved design issues during development.
• Wrote UNIX Shell scripts according to the requirement.
• Improved query performance using better joins appropriately.

Environment: Oracle 9i, Red Hat Enterprise Linux 3, Crystal reports, Toad, SQL Plus, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

• Analyzed business requirements to design Entity relational Diagrams (ERD) and prepared.
• HLD and LLD documents including impact analysis, requirements traceability matrix.
• Wrote DDL scripts for generating tables, views and indexes.
• Developed PL/SQL procedures, functions, packages and triggers.
• Prepared Unit Test Specifications and performed unit testing.
• Maintenance of Scheduler and adding new jobs.
• Converted Pro*C programs to PL/SQL procedures. Built packages for data storage and retrieval.
• Developed and modified reports using Forms and Reports 6i.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Worked on logical and physical data modeling and created Materialized views.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Participated in performance tuning, unit test case preparation and execution.
• Utilized tools like TOAD during development of the application
• Performed Unit Testing and data validation.
• Environment: Oracle 9i/8i, PL/SQL, Forms 5.0, Reports 3.0, PL/SQL, PRO*C, UNIX and Windows.