OBJECTIVE:

• To obtain a challenging role as Sr. Oracle DBA / Technical Lead.

PROFESSIONAL SUMMARY:

• More than 17 years of IT experience which includes 5 years of experience as a Data Warehouse design and development in large scale data industry with all phases of the Software Development Life Cycle (SDLC), specialized in Data Warehousing methodologies, ETL tools, OLAP tools and client / server applications.
• Sr. DBA, Team Lead and Lead developer are some of the roles performed. Implemented projects utilizing Enterprise Client/Server Methodology, 3 - tier Web-based Applications, On Line Transaction Processing (OLTP) system, Batch Processing System, Decision Support System (DSS), Data Warehousing System, Distributed database systems and Very Large Database (VLDB) system.
• Database Administration, Performance Tuning (Application Tuning, Database Tuning, OS Tuning), Application Support DBA, Capacity Planning and Optimization, Disaster Recovery Planning and Implementation, Change Control/ Change Management, Distributed Databases, High Availability, Replication, Real Application Clusters (RAC), DataPump, ASM, ADDM, ASM, ASH, Materialized Views, Data Guard, Oracle Streams, Data Warehouse, Installation, upgrade and Migration, Backup and Recovery, 24x7 production database support both on-site and remote. Security & Auditing, Sarbanes Oxley SOX compliance, Support of validated databases, Inter-platform upgrade and migration, Application Design, Development and Implementation.
• Expertise in OLTP / OLAP system design, analysis and ER Modeling, developing database schema like Star Schema, Snowflake schema used in dimensional and multidimensional modeling.
• Database installations, N Tier Architecture Installation and Configuration Database Upgrades, database and application patch installations, Designing and architecting the database.
• Database Administration, System Analysis, Application Design and Extensive programming experience.
• Performance monitoring and fine tuning of the system for optimal performance.
• Strong testing and debugging skills with knowledge of ETL procedures and strategies to extract data from different source systems.
• Experience in performance tuning of source, mapping, targets and sessions.
• Advanced knowledge of Oracle 10g/9i/8i, SQL, and PL/SQL.
• Proficient in database design, entity relationship diagrams (ERD).
• Familiarity with Oracle's advanced features such as Partition tables/indexes, Function Based indexes, and bulk loading with SQL*Loader.
• Proficient in tuning SQL queries using Explain Plan, Trace (TKPROF)
• Proficient with EDI (Electronic Data Interchange) implementation and translators.
• Expertise in Database Triggers, Procedures, and Packages.
• Proficient in UNIX Shell Scripting.
• Proficient in XML Manipulation from PL/SQL.
• Expertise understanding of Software Engineering, Software Analysis, Design & Modeling Principles used in SDLC.
• Experience in dealing with customer especially in Business Analysis and Production Support Phase.
• Strong communication, presentation, documentation, strategic planning and, interpretational and problem solving skills.
• Worked independently in critical situations and strong team player and leadership skills.

TECHNICAL SKILLS:

Database: Oracle 10g /11g /12c (RAC), 10g, 9i, 8i, 7xAdministration Tools:ASM,OEM, GRID CONTROL, RMAN, GOLDEN GATE, Export/Import, data-pump, Performance Manager, Tuning Pack, Password Manager, TOAD, VPD, TDE, Data Guard, Oracle Automatic Workload Repository (AWR), Streams, Disaster Recovery Plans (DRP), Enterprise Manager (EM), Activity Session History (ASH) Database Control Console, Enterprise Manager Grid Control, Partitioning, Virtual Private Database (VPDB), Oracle Advance Security

Operating System: UNIX (HP / Sun Solaris), Linux RedHat 9, Windows XP, 2003, NT, zLinux

Backup Tools/Utilities: Export/Import, Datapump, RMAN

Data Modeling Tools: Erwin, Oracle Designer 2000, Visio

Programming Languages: PL/SQL, C, Shell Scripting, Perl Scripting

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. Oracle Database Administrator (DBA)

Technology:Oracle 11/10G, Data Guard, ASM, Oracle Enterprise Manager Grid Control 10g, 12c, Golden Gate,RMAN, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris

Responsibilities:

• 24/7 Support to the Production databases.
• Installing PSU for Oracle RDBMS and GRID.
• Cloning, duplicating, restoring databases via RMAN to ASM disks.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN
• Periodically check the health status of the database using the proactive analytical tools provided by OEM.
• Worked on performance analysis with application team.
• Used custom queries and tools like AWR report, SQL Monitoring Report, and custom queries to analyze poor performing queries.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Installed and configured RAC databases on Solaris and zLinux environment
• Moved non ASM databases to ASM.
• Migrated database on Solaris from Global to local zone.
• Installation of Oracle 11.2.0.4, 12.1.0.2 on Solaris and zLinux.
• Prepared project document for various project plans.
• Prepared technical document and planning for Installation, database patching and upgrade, password change activities, security and compliance.
• Worked on installation of Oracle Enterprise Manager 12c
• Worked on upgrading Oracle Enterprise Manager 12c ( 12.1.0.2 to 12.1.0.4)
• Installed EMCLI and scripted script using EMCLI for various operation.
• Golden Gate installation and setup for integrated downstream replication.
• Configuring and monitoring Data Guard Active - Passive setup.
• Helped team and junior DBA’s with .

Confidential, WI

Oracle Database Administrator (DBA)

Technology:Oracle 11/10, Data Guard, ASM, Oracle Enterprise Manager Grid Control 10g Rel. 5, RMAN, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, OBIEE 11g

Responsibilities:

• 24/7 Support to the Production database, which includes off-hour support also.
• Performed patch installation at the OS level and database level.
• RMAN catalog, duplicating databases via RMAN to ASM disks.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN
• Periodically check the health status of the database using the proactive analytical tools provided by Enterprise Manager.
• Used Tkprof and sqltrace to analyze query performance and provide feedback to the development team.
• Detected bad performance SQL statements through ADDM, AWR
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Prepared test environment for QA team to test the developed application from end-end.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Performance tuned DB queries.
• Configured ASM storage on an SAN environment. This ASM environment was used as a shared storage
• Used AWR and ADDM tools to monitor the performance of instances.
• Installation of Oracle 11.2.0.1 on RedHat Linux 6.

Confidential, MI

Oracle Database Administrator (DBA)

Technology:Oracle 11/10/9, HP, Data Guard, ADDM, ASM, Oracle Enterprise Manager Grid Control 10g Rel. 5, RMAN SQL*LOADER, SQL PLUS, PL/SQL, Toad 9.5, HP UNIX, LINUX, OBIEE 11g

Responsibilities:

• Analyses and discuss the business requirements with the clients.
• 24/7 Support to the Production database, which includes off-hour support also.
• Performed patch installation at the OS level and database level.
• RMAN catalog, duplicating databases via RMAN to ASM disks.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN
• Periodically check the health status of the database using the proactive analytical tools provided by Enterprise Manager.
• Configured Data Guard
• Used Tkprof and sqltrace to analyze query performance and provide feedback to the development team.
• Optimized and modified the complex store functions, procedures, user base datatype etc.
• Wrote UNIX shell scripts run SQL*Loader and validate data load from flat files to Staging Tables.
• Wrote Pl/SQL Procedures to Load Data into Several Lookup and aggregation tables from staging tables.
• Developed stored procedures and complex packages using PL/SQL.
• Detected bad performance SQL statements through ADDM, AWR
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Prepared test environment for QA team to test the developed application from end-end.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Performance tuned DB queries.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Configured ASM storage on an SAN environment. This ASM environment was used as a shared storage
• Used AWR and ADDM tools to monitor the performance of instances.

Confidential, Indianapolis, IN

Lead Data Architect / Oracle Database Administrator (DBA)

Technology:Oracle 11.1.0.6.0, HP, SQL*LOADER, SQL PLUS, Data Guard, ADDM, ASM, Oracle Enterprise Manager Grid Control 10g Rel. 5, RMAN, ExplainPlan, StatsPack, TkProf, SqlTrace, Toad 9.5, Erwin7.1, PL/SQL, OBIEE 10g/11g

Responsibilities:

• Analyses and discuss the business requirements with the clients.
• Setup infrastructure for Oracle Data warehouse.
• Performed patch installation at the OS level.
• RMAN catalog, duplicating databases via RMAN to ASM disks.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN
• Configured Oracle Enterprise Manager Grid Control 11g for dev and QA instances. Configured database, ASM, host monitoring targets and alerts. Created custom metrics and alerts.
• Periodically check the health status of the database using the proactive analytical tools provided by Enterprise Manager.
• Prepared strategy to Configure Data Guard for Disaster recovery.
• Used Tkprof and sqltrace to analyze query performance and provide feedback to the development team.
• Optimized and modified the triggers, complex store functions, procedures, user base datatype etc.
• Troubleshoot and implemented bug fixes and enhancements within tight deadlines.
• Used SQL*Loader to load data from flat files to Staging Tables.
• Wrote UNIX shell scripts run SQL*Loader and validate data load from flat files to Staging Tables.
• Wrote Pl/SQL Procedures to Load Data into Several Lookup and aggregation tables from staging tables.
• Developed stored procedures and complex packages using PL/SQL.
• Detected bad performance SQL statements through ADDM.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Prepared test environment for QA team to test the developed application from end-end.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Performance tuned DB queries.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Configured ASM storage on an SAN environment. This ASM environment was used as a shared storage
• Used AWR and ADDM tools to monitor the performance of instances.
• Installed and managed OBIEE.

Confidential, Miami, FL

Oracle DBA

Technology:Oracle 10g, Sun Solaris, Toad 9.5, Erwin7.1, PL/SQL, SQL*LOADER, SQL PLUS, UNIX Shell Script, ExplainPlan, TkProf, SqlTrace

Responsibilities:

• Tested the production environment of several Oracle Database versions
• Configured the Data Warehouse used for a customer.
• Periodically tested the performance of the production environments, detected low performance applications and reported them to the development team.
• Reconfigured the oracle listener to provide a better performance for Java applications in the middleware.
• 24/7 Support to the Production database, which includes off-hour support also.
• Provided support to the development team.
• Clone of the production environment against the development environment.
• Defined a Disaster Recovery Plan to support the operation of the production environment.
• Perform installation and configuration of Oracle 10g and on Sun Solaris 10 Servers.
• Design database in accordance to the Optimal Flexible Architecture (OFA).
• Create procedures for Media Recovery.
• Establish database security by enrolling users, creating profiles for optimal use of resources, and maintaining system security via roles and privileges.
• Used Explain Plan, TKPROF, and SQL Trace to tune database applications.
• Improve performance by selectively reorganizing and defragmenting databases objects.
• Create and maintain the standby database to minimize damages caused by the downtime of the production database.
• Write shell scripts to implement strategies for backup.
• Database monitoring using the Enterprise Manager metrics.
• Run Capacity Planning procedures to forecast application and system growth.
• Run security procedures to detect and prevent security breaches.
• Created routines that automatically detect, prevent and report abnormal behavior, i.e. unusual connection time, sessions logged in for an unusual period of time, CPU intensive sessions, unauthorized data modifications, unauthorized client software attempting to login.
• Encryption of highly sensitive Data

Confidential, Rosemount, IL

Sr. Oracle Database Administrator (DBA)

Technology:Oracle 11.1.0.6.0, HP, Oracle Enterprise Manager (OEM) Toad 9.5, Erwin7.1, PL/SQLSQL*LOADER, SQL PLUS, UNIX Shell Script, Data Guard, ADDM, ASM, Oracle Enterprise Manager Grid Control 10g Rel. 5, Enterprise manager Database Control, RMAN, ExplainPlan, StatsPack, TkProf, SqlTrace

Responsibilities:

• Analyses and discuss the business requirements with the clients.
• Performed patch installation at the OS level.
• RMAN catalog, duplicating databases via RMAN to ASM disks.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN
• Configured Oracle Enterprise Manager Grid Control 11g for dev and QA instances. Configured database, ASM, host monitoring targets and alerts. Created custom metrics and alerts.
• Periodically check the health status of the database using the proactive analytical tools provided by Enterprise Manager.
• Configured Data Guard
• Used Tkprof and sqltrace to analyze query performance and provide feedback to the development team.
• Optimized and modified the triggers, complex store functions, procedures, user base datatype etc.
• Troubleshoot and implemented bug fixes and enhancements within tight deadlines.
• Used SQL*Loader to load data from flat files to Staging Tables.
• Wrote UNIX shell scripts run SQL*Loader and validate data load from flat files to Staging Tables.
• Wrote Pl/SQL Procedures to Load Data into Several Lookup and aggregation tables from staging tables.
• Developed stored procedures and complex packages using PL/SQL.
• Detected bad performance SQL statements through ADDM.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Prepared test environment for QA team to test the developed application from end-end.
• Developed shell scripts to alert users in the event of failures and also to automate jobs.
• Performance tuned DB queries.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Configured ASM storage on an SAN environment. This ASM environment was used as a shared storage
• Used AWR and ADDM tools to monitor the performance of instances.

Confidential, Chicago, IL

Lead Data Architect / Oracle Database Administrator (DBA)

Technology:Oracle 11.1.0.6.0 RAC, Virtual Private Database, TDE, AIX, Oracle Enterprise Manager (OEM) Toad 9.5, ASM, RMAN, Erwin 7.1

Responsibilities:

• Preparing strategy document for Oracle 11g Real Application Clusters (RAC) Implementing 2-6 node RAC’s on AIX server.
• Extensively involved in Data Modeling Logical and Physical model for the new application
• Setting up Oracle 11g RAC Environment for the development and QA team
• Performed switchover tasks to be able to provide proactive maintenance to the hardware.
• Configured security options at the production environment to comply with the security baseline standard procedures of the bank.
• Implemented Oracle VPD security
• Produced automatic auditing reports for the security manager.
• Supporting Development and QA team for their day-to-day need
• Involved in creation Organizational Hierarchy
• Involved in preparing strategy for Database Archiving
• Setup Oracle Database, users, roles, security access
• Detected bad performance SQL statements through ADDM.
• Configured a stream based environment to create a reporting database able to receive the changes of the production database.
• Configured ASM storage on an SAN environment. This ASM environment was used as a shared storage for the RAC 11g environment.
• Configured application connection descriptor to enter the database to provide server-side load balancing.
• Used AWR and ADDM tools to monitor the performance of instances on RAC systems
• Cloned database to set up parallel TEST instances
• Used Tkprof and sqltrace to analyze query performance and provide feedback to the development team.
• Performed patch installation at the OS level.
• Configured a RAC/Dataguard environment to support the production environment with minimum downtime.
• Performed Sizing, indexing and system parameter setup for optimum performance
• Was involved in assisting data modeling team for the design of Physical model
• Used Ervin for designing Physical model, partitioning of tables and indexes
• Establishes and recommends changes to policies which effect their direct teams
• Responsible for the technical development and management of a single complex project
• Responsible for implementing operational and strategic policies and directives
• Interfaces with senior management to report on project and program milestones and to present project needs
• Installed and configured Oracle Enterprise Manager Grid Control. Created users with special privileges to access enterprise reports as well as users from the infrastructure department to be able to access the hardware and software inventory.
• Routinely evaluate and apply the Critical Patch Update (CPU) issued by Oracle on a quarterly basis to meet the business security policies.
• Applied patches and patch set to the production environment according to the Oracle support services direction.

Confidential, Laurel, MD

Project Manager

Technology:Linux Redhat 9, Win XP, Oracle10g, ERWin, Toad, etc.

Responsibilities:

• Oracle design and programming
• Designing database for a large DW Oracle application (Automobile)
• Complex module re-design and performance tuning of the ETL system (Oracle 10g)
• Implementation and integration issues with Oracle 10g, DW and OLTP environments
• Diagramming, DB design, ETL design functional and technical specifications, documentation
• Settling parameters for Oracle database.
• Installed quarterly security and application specific patches
• Configured RMAN for hot backups. Cloned database for application development purposes. Utilized export / data pump for various backups.
• Setup STATPACK utility for performance tuning
• Resized all the tablespaces to better utilize the file system by avoiding fragmentation
• Ran TKPROF and explain plan for long running queries
• Tuned all long running queries and added required hints like (USE HASH, USE NL, INDEX etc) for versions below 10g.
• Optimized and tuned queries
• Debugged the Packages and procedures using Toad, traced sessions using Oracle Tracing
• Analyzed tables and indexes
• Oracle Data Pump, ADDM and SQL Tuning Advisor, Flashback Versions Query.
• Cloning database out of the backup to provide a fresh environment to developers and have the backups tested.
• Wrote scripts for regular extents check, I/O performances and tablespace sizes for the maximum limit
• Altered materialize views and indexes for optimized performance
• Created users, roles, setup security, and periodic security review.
• Configure table partitioning (range partitioning) to improve query performance, data availability and manageability.
• Developed a “best Practice” document for the DBA and the development team for best implementation of data warehouse concepts.
• Ensured that the development team is following a defined development process throughout the product lifecycle to achieve delivery dates.
• Created detailed development plans, prioritizes work assignments and assigns projects based on available resources.
• Sets clear objectives for direct reports and compares deliverables against objectives.
• Managed day-to-day decisions of project teams, including bug priorities, work assignments and work sequencing.
• Responsible for the technical development and management of a single complex project.
• Establishes and recommends changes to policies which affect their direct teams.

Confidential, Irvine, CA

DBA

Technology:Oracle 10.2.0.2, SQL*Loader, Oracle Warehouse Builder, Windows XP, IBM-AIX 5.3, 4.3Oracle Enterprise Manager (OEM) 10g R2/9.2.0.7, SQL Server, Developer 2000 and Erwin.

Responsibilities:

• Data manipulation, maintenance and administration of the large OLTP database
• 24x7 large database support of 3 production instances
• Data modeling and analysis, migration, performance analysis, tuning of a midsized data warehouse
• Designing and implementing high-scale ETL process for Oracle 9i databases, mid- to large-sized
• Designing OLAP processing layer for the environment above
• Backup and recovery management, troubleshooting
• Application design, scheduling, resource management
• Database design and programming: code design and testing SQL, PL/SQL, shell script
• Related documentation work: diagramming, reporting, functional, technical specifications, technical project planning, technical project lead, product and project evaluation, etc.
• Involved in Analysis of the business process, gathering needs for the Business Intelligence Applications and transforming the suite of business requirements into the logical data model.
• Involved in the Star schema design, which included several Fact Tables, Conformed Dimensions and Degenerate Dimensions utilizing ERWin 3.5.2.
• Developed mapping to load data in slowly changing dimension. The unconnected stored procedure for lookup on target table. Used aggregate, expression, lookup, update strategy, router and rank transformation.
• Prepared technical specifications for the development of Extraction, Transformation, and Loading (ETL) mappings to load data into various tables in data marts and defined ETL standards.
• Assigned daily / weekly task to the Development team.
• Reviewed the codes from time to time.
• Conducted technical discussions on bi-weekly basis.
• Migrated data using import/export, Oracle Data Pump, and transport tablespaces during ETL Process.
• Extensively used SQL*Loader to load flat files into staging tables.
• Troubleshoot the codes / queries.
• Created materialized views for commonly accessed data.
• Wrote the control files.
• Extracted data from SQL Server and DB2 to load into staging area in Oracle.
• Wrote codes for the specific Procedures, Functions & Triggers.
• Developed PL/SQL packages for data scrubbing for ETL Process.
• Developed UNIX shell scripts to automate and schedule processes.
• Tuned Oracle SQL queries using Explain Plan and TKPROF.
• Participated in database design and development of DDL scripts.
• Designed the table sizing and partitioning parameters.
• Used Oracle Warehouse Builder to extract the data from DB2 to load it to Oracle 10G for an ETL Process.
• Prepared 5 user reports in MS Excel.
• Developed a few Forms module for basic system administration functions.
• Developed views for user reports using Discoverer.
• Used Erwin tool to create the logical model and then created the physical schema.
• Lead the team of 8 developers and actively involved in meeting with Fidelity, R.R Donnelly, Confidential, group meeting, and user interaction.
• Held internal team meeting every week to make sure every one on the same page.

Confidential

Data Architect

Technology:Oracle 9i, SQL * Plus, SQL * Loader, ERWin 3.5, Shell scripts, Windows 2000, Sun Solaris.

Responsibilities:

• Used ERWin 3.5.2 to reverse engineer OLTP and enhance existing OLAP database in accordance with the client’s business process and rules.
• Utilized Informatica 6.2 in extracting data from multiple sources that included different Databases including DB2, Oracle, Informix, SQL Server and legacy systems Flat Files, cleansed the Data and loaded into the target Star Schema.
• Worked extensively with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.
• Worked on existing mapping for the performance tuning to reduce the total ETL process time.
• Involved in design of ETL process, extraction, loading and maintaining hierarchical nature of Slowly Changing Dimensions.
• Utilized Normalize Transformation to extract data from Cobol Sources and created multiple rows with the data.
• Wrote codes for specific Procedures, Functions and Triggers.
• Prepared Reports in MS Excel.
• Developed UNIX shell scripts to automate and schedule processes.

Confidential

Sr. Database Developer

Technology:Oracle 8i, PL/SQL, WINDOWS NT Workstation, SQL Loader, Erwin, OracleEnterprise Manager

Responsibilities:

• Involved in client requirement gathering and analysis.
• Designed and developed the database design and DDL scripts.
• Developed PL/SQL packages to extract data for an ETL Process.
• Wrote triggers and functions as per business logic.
• Automated jobs using dbms job package.
• Troubleshoot performance issues and bugs in SQL queries and packages using Explain Plan.
• Used Erwin tool to create the logical model.
• Involved in development, testing, support and maintenance activities like bug fixing, enhancement, new features and performance testing and tuning.
• Used Oracle Warehouse Builder to extract the data for an ETL process.

Confidential

Sr. Database Developer

Technology:Oracle 8i, PL/SQL, WINDOWS NT Workstation, SQL Loader, Erwin

Responsibilities:

• Wrote PL/SQL Procedures and Functions.
• Worked with catalogue (Meta data) which had information about database.
• Developed necessary reports using Reports 6i.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Developed ad hoc reports using SQL*Plus.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values.
• Wrote Technical Documentation using Robo Help.

Confidential

Database Developer

Responsibilities:

• Created database schema and DDL scripts.
• Developed Stored Procedures, Packages, Functions and Triggers.
• Developed packages to validate and populated data to interface tables.
• Developed forms for user interface using Forms 6i.
• Troubleshoots with problems regarding the databases, applications and development tools.