SUMMARY

• Over Nine years of IT experience in Database Management, Architecture, ETL data management and Administration.
• Experience in Oracle 8i/9i/10g/11g Database management on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN).
• Preparing Clustered Environment including hardware and software installation, configuration of RHEL 3.0/4.0 & Windows 2003 Server for Oracle 9i/10g/11g RAC (Real application clusters). Expert level SQL, stored procedure programming and Performance tuning expertise.
• Expertise in Installing, Configuring, Creating & Cloning Oracle 8i/9i/10g/11g databases on Sun Solaris, Linux, UNIX and Windows platforms. Expertise in upgrading, migrating & patching Oracle 8i/9i/10g/11g database using Oracle migration utilities and conventional export/import and expdp / impdp.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS (Data Warehousing) using customized shell scripts. Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
• Extensive experience with Informatica Power center 8.x/7.x/6.x, Data Stage 7.5.
• Developed ETL mappings, transformations using Informatica Power center 8.6.
• Created Mappings in Informatica Designer to extract data from data sources like Oracle, COBOL files, MS SQL Server, MS Access & Excel
• Familiar with SAP Business suite and SAP applications.
• 24x7 production database support to developers & end - users. Have implemented ORACLE STREAMS and DATAGUARD (logical standby and physical standby databases). Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. Have worked on large-scale databases with size of more than 5TB in large system environments. Good knowledge of EMC recover point for continuous backup and remote replication.
• Worked on Sybase database including providing day to day DBA support and database management.
• Expertise in Designing, implementing and managing Backup strategy using Oracle Utilities RMAN, Export/Import and Data Pump. Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP. Expertise in Operating System, Database and Application (SQL, PL/SQL) tuning.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Used EMC recover point as a tool for replicating data and data refresh as an alternative to RMAN across different environments. Installation and Configuration of Oracle Grid Control. Administering & Managing Oracle Users, roles, privileges & creating Database objects. Performed database modeling, design, sizing, tuning, capacity planning.
• Worked with Peoplesoft Human Resource management system(HRMS), Financial Management Solutions (FMS),Customer Relationship Management(CRM), andEnterprise performance management(EPM) software.
• Worked on installing and managing sql server 2003,2005,2008 and 2012 databases on windows server.
• Knowledge of TSQL used for SQL server databases.
• Database replication using snapshots, materialized views and advanced replication methods. Management of schemas, objects, tables & indexes partitioning. Worked with third party tools like TOAD, Erwin for quick diagnosis and end results.
• Worked on different types of storage structures (SAN/NAS). Experience as On-Call 24x7 production DBA support and development DBA. Excellent communication and interpersonal skills together with a positive approach to undertaking challenges.
• Worked as an Oracle DBA as well as a Sybase DBA.
• Trained Jr. Staff and developers. Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris 7/8/9, HPUX, IBM AIX 5.x/6, x), Linux (Red Hat Enterprise Linux 3.0/4.0, SLES/SUSE), Windows 2000/2003/NT Server, Windows 98/XP.

Database tools: RMAN, TOAD, ERWIN, SQL Developer.

High Availability: Oracle 9i/10g/11g/12c RAC, Data Guard/Standby Replication, Oracle Streams, Symmetric Replication, Oracle golden gate, VERITAS Cluster,Exadata.

Utilities: Oracle Import/export utility, SQL * Loader, SVRMGRL and SQL*PLUS, OEM. TKPROF, SQL Trace, EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBCA, SQL Adviser, Oracle Data Pump, SQL diagnostics,AUTOTRACE, Informatica Power Center 9.x/8.x/7.x/6.x, Grid Control, Opatch, SVRCTL, CRSCTL, UTLBSTAT/UTLESTAT.

Network: SQL*Net 2.0, Net 8 and Oracle Net.

Virtual Technology: VMware Server, VM Player.

Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting.

MS components: MS Office 2003/2007, MS FrontPage.

Certification: Oracle certified professional

PROFESSIONAL EXPERIENCE

Confidential, Weehawken, NJ

Sr. Oracle DBA

Responsibilities:

• Responsible for migrating and upgrading clients from 10g/SunOS to 11g/Linux platforms. Have successfully migrated and upgraded more than 100 Production clients since January 2014 including their corresponding UAT clients.
• Installed and configured new 12c databases on AIX and upgraded high processing OLTP databases from 11g to 12c using Oracle database upgrade assistant.
• Installed and configured 12c OEM for DB monitoring and performance management.
• Provide day to day DBA support including but not limited to schema creation and management, table-space management, database performance monitoring and managing backup jobs.
• Provide support against JIRAs raised by application and Business teams as per testing and business requirements.
• Provide support during production issues and work closely with Application teams and Business teams for same.
• Extensively analyzed AWR and ADDM reports to identify performance bottlenecks and performance metrics to improve overall performance of production database.
• Worked on SAP NetWeaver ECC 6 Installation (ABAP+J2EE), Unix (HP, Solaris) and Oracle 10g and daily SAP Administration.
• Worked on SAP Export/ import (SYSCOPY) SAP system refresh.
• Worked with SAP BR* tools like BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT and BRTOOLS to manage data in in the databases.
• Involved in SAP supervision via Solution Manager and BR*TOOLS. Support to users and incidents resolution.
• Provided day to day DBA support to SAP applications including performance tuning, supporting regular releases and troubleshooting any application issues.
• Involved in taking database backups as requested by Application and Business teams and database refresh using export import and data-pump export import.
• Worked as a peoplesoft admin and DBA.
• Developed and modified interfaces for PeopleSoft HRMS and financial databases.
• Implemented GoldenGate to achieve Unidirectional and bidirectional replication between heterogeneous databases.
• Performed POC for testing DDL and DML goldengate replication across Databases.
• Estimated SAN Storage needed for goldengate Replication across multiple sites for Goldengate.
• Prepared GoldenGate parameter files for Extraction and Replication.
• Installed GoldenGate software in Test,UAT and PROD in sequence along with application and system testing.
• Investigated and troubleshooted Goldengate Replication failures using LogDump utility.
• Setup GoldenGate Database Users with necessary privileges.
• Cross-Trained other DBAs on goldengate replication concepts.
• Troubleshooted goldengate replication issues/lags/replication errors.
• Set up goldengate on remote databases for DR purposes.
• Set up alerting jobs for any goldengate replication issues.
• Involved in Set up, monitoring, tuning and administration of PeopleSoft environment systems.
• Involved in maintenance of PeopleSoft Pure Internet Architecture, including WebLogic/Wintel, Tuxedo, Reports, and Process Servers.
• Implemented and configured business front end for Peoplesoft FMS (Financial Management Solutions) to be used by investment bank division.
• Provided 24x7 technical support to SAP and peoplesoft applications on databases.
• Involved in managing and updating SunOS and Linux server files to facilitate database migrations and upgrades from 10g SunOS to 11g Linux.
• Involved inversion upgrades of Peoplesoft applications and deployimg application on new environments.
• Work closely with business on a regular basis to identify business requirements and provide strategic technical database solutions to application teams to meet overall business requirements.
• Worked on installing and configuring RAC databases on HP Unix and IBM AIX environments.
• Involved in Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Troubleshooted RAC issues including Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) and issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Worked with DB refresh and application data refresh for SAP and Peoplesoft applications on databases.
• Involved in Upgrade of 10g R2 RAC to 11g R2 RAC
• Involved in Webadmin and Cognos set up to point the application to the required database during database upgrade process.
• Supported SAP financials application on 11g used by investment business front end on daily basis.
• Involved in DDL and DML changes to both UAT and PROD databases for database upgrade process.
• Involved in schemas password management and ensuring standard passwords are securely maintained across all databases.
• Involved in providing grants, revoking grants, creating roles, providing file permissions, creating database directories as per tickets raised by application teams.
• Extensively use DBA utilities including TOAD, SQLDBX and OEM for day to day DBA tasks.

Confidential, Jacksonville, FL

Sr. Oracle DB Administrator

Responsibilities:

• Responsible for installing, maintaining, performance tuning and monitoring of Oracle databases version 10g/11g in different Environments like development and production, Responsible for testing and debugging the application day to day issues.
• Management of table-spaces based on App requirements and adjusting table-space sizes as per data needs. Creating users and managing their roles and privileges as required by Application. Creating Database objects including but not limited to Tables, procedures, functions, packages, materialized views etc.
• Created UNIX shell scripts to automate batch jobs through Cron Extraction of data from different flat files into Oracle Database using SQL*Loader. Utilized SQL*loader and data pump import to load data into tables.
• Developed and supported ETL (Extract, Transformation and Loading) mappings to extract the data from source environments like Oracle, SQL server and Flat files and loaded into Oracle.
• Worked in installing, configuring and managing databases on Exadata.
• Assisted in migration of several systems to Exadata and Exalogic -- setup ASM and RAC.
• Installed and Integrated OBIEE 11g on Exadata X2 and X3 and Exalogic for data warehousing and ETL processing.
• Configured and set up OEM/Grid for Monitoring Exadata X2 for performance tuning purposes.
• Worked on setting up and Configuration of Exadata V2 cluster with Goldengate replication.
• Installed Oracle 11g on Exadata X2 using manual installation processes.
• Installed,configured and supported Peoplesoft application FMS to be used by credit cards front end.
• Involved in peoplesoft application support,regular releases and upgrading.
• Tuned backend queries for slow running pages for Peoplesoft applications.
• Worked with Informatica to develop ETL workflows and Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Informatica ETL to extract data from flat files including fixed-length as well as delimited files to load on Oracle database.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM.
• Worked on Installation of RAC and Managing RAC Environment efficiently.
• Proficient in RAC Performance Tuning
• Experienced in Installation, Configuration,Administration and support of Informatica Power Center 8.x/7.x.
• Performed performance tuning to improve Data Extraction, Data process and Load time.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Migrated databases from unix environment to Exadata environment.
• Troubleshooted several performance issues to ensure that we were able to migrate to Exadata within very tight timescales.
• Installed Informatica Power Center Server manager & Power Center client.
• Performed design of ETL components in this project. Creation of Design documents, Development and testing were my primary responsibilities.
• Upgraded SAP - ISU (SAP R/3) instance to ECC6 and database upgraded from oracle 10g to oracle 11g;
• Upgraded SAP CRM 4.0 to CRM7.0 (ABAP+JAVA) and database upgraded from oracle 10g to oracle 11g;
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Exadata storage servers to configure and optimize storage requirements for oracle databases inckuding DEV,UAT and PROD.
• Configured backup and recovery for Oracle databases running on Exadata platform.
• Involved in Audit and improving performance for SAP systems
• Created the warehouse tables using Informatica Power Mart Warehouse designer.
• Extensively involved in writing ETL Specifications for Development and implementation.
• Designed and developed business rules to generate consolidated data using Informatica ETL tool on Exadata.
• Performed performance evaluation of the ETL for full load cycle.
• Involved in upgrading from Informatica Power Center 6.1 to Informatica Power Center 7.1 which is used as ETL tool for loading data into EDW from transactional databases.
• Installed and configured RAC clusters on Exadata environments.
• Designed Informatica architecture and data flows.
• Gather Business Requirements and translate into Technical Specifications for Informatica ETL team.
• Provide technical strategies and directions to onshore and offshore Informatica developers.
• Knowledge of extracting heterogeneous and homogeneous sources (XML, Flat Files, Tables, CSV)
• Developed, tested and migrated Informatica ETL mappings for OLTP AND OLAP systems.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas and perform day to day performance tuning. Database Administration and Planning including logical design, physical design, backup & recovery.
• Oracle MTS Configuration, Password management, Disaster recovery using Data Guard on Exadata. Ensuring security of the data in the database by monitoring environment to identify improper access.
• Accomplished quality, stability and efficiency of the database across the projects by undertaking initiation and coming up with several proposals. Design and implement backup and recovery system. Responsible for backups and recovery of the database using RMAN.
• Implemented security of the database by creating profiles for each group of users. Extensively involved with the Export and Import utilities to backup and recover the database. Constantly checking the availability of the database 24x7.
• Involved in applying Oracle security patches on Exadata. Developed UNIX Shell Scripts for monitoring Oracle database and to gather performance statistics. Installation, Implementation and maintenance the Oracle database.
• Supported Sybase applications and provided Sybase DBA support including but not limited to application management, application deployments and database maintenance and updates.
• Upgraded Instance SAP from Oracle 9i to Oracle 10g, upgraded kernel and reconfigured environment;
• Involved in user creation, user access control, Schema creation and management. Creating and managing the database storage structures which include data table spaces, index table spaces, rollback table spaces and rollback segments. Maintain the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation. Created Logical and Physical standby Databases to ascertain high availability of database during system crashes using Data Guard.
• Involved in backup and recovery of Sybase databases and oracle databases on Exadata.
• Worked on Sybase 12.x and 15.x and Sybase IQ. Worked with Sybase design, performance and replication.
• Hands on experience with Sybase technology including ASE,REP,IQ.
• Involved in session management and monitored the critical wait events in the database. Improved the performance by Using the Hints, Indexes, Explain Plan, SQL Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Involved in query optimization and using rule based optimizers and cost based optimizers. Performed the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints.
• Involved in installing, configuring, maintaining, upgrading and performance management of SQL server databases.
• Worked on writing and editing Scripts for Sybase related batch jobs.
• Resolved database performance issues, capacity issues, replication and other distributed data issues on SQL server databases.
• Kept SQL server databases up to date with required patches recommended by Microsoft licensed support.
• Database maintaining including backups, recovery, imports/exports. Installed and configured Oracle RDBMS on UNIX and Windows environments. Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery.
• Responsible for Operating System Installation and updates including UNIX/LINUX and Exadata. Responsible for updating the database with the information received from various vendors. Analyzed the structures using Analyze command on regular basis. Created primary database storage structures (tablespaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required. Developed hot, cold and logical backup scripts to automate the backup procedures. Took Backups on scheduled time and Monitoring Scheduled Backups.
• Ensured proper online and offline backup. Periodical reading and checking of backups taken. Planned for storage spaces requirements and placing them for optimum I/O performance. Cloned Environments to create Test, Development and QA Environments.
• Installed Sybase servers version 10x 11x 12x on UNIX and also applied follow up patches as and when required.
• Migrated databases from Sybase to Oracle on unix and Exadata.
• Wrote and tuned T-SQL scripts to be deployed during performance releases and application releases on Sybase databases.
• Managed and provided DBA support during weekly and monthly Sybase application releases.
• Partitioned large tables to increase the performance. Participated in Disaster Recovery Annual test, documented database and application validation steps. Performed all daily Maintenance tasks. Interacted with Oracle Customer service as and when required.
• Creating and dropping of users, granting and revoking rights as and when required. Used TKPROF, EXPLAIN PLAN for the Better performance. Monitored Growth of tables and undertaking necessary re-organization of database as and when required. Resolved technical issues and Troubleshooting.

Environment: Windows 98/XP/NT, UNIX, Oracle 10g/11g, SQL*Net, RMAN, Data Guard, CRONJOB, UTLBSTAT/UTLESTAT, TKPROF, EXPLAIN PLAN, MS Access, Exadata X3-8,X3-2,X2-2,X2-8 MS Office, SUN Solaris, IBM AIX 6.0.

Confidential, Augusta, Maine

Sr. Oracle DB Architect

Responsibilities:

• Worked on maintenance, monitoring and application level redesigning of production, test and development databases including performance monitoring, error troubleshooting, instance analysis and query modifications in an OLTP environment.
• Identified critical instances day-to-day basis and interpreted issues using ADDM and AWR reports and performed hang analysis. Also opened tickets with DHHS Oracle customer team (CTS) to kill sessions if needed in case of any low-priority session causing longer than usual hangs.
• Used DDL and DML for generating PL/SQL codes. Validated PL/SQL codes and used tools like Oracle SQL developer/loader to generate related PL/SQL queries.
• Configured Oracle Enterprise Manager and grid control and generated graphical snapshots and top sessions history in the event of instance trouble shooting for analytical purposes.
• Performed SQL tuning by using tools like STATSPACK, EXPLAIN PLAN, AWR, ADDM and SQL optimizer hints.
• Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.
• Configured and used the ETL Debugger to troubleshoot the Informatica mappings.
• Experience using Informatica workflow manager, workflow monitor, pmcmd to create, schedule and control workflows, tasks, and sessions.
• Performance tuning for ETL data cycle using informatica.
• Involved in upgrading from Informatica Power Center 6.1 to Informatica Power Center 7.1
• Performed fine tuning by creating indexes, triggers, foreign key constraints based on explain plan to improve query efficiency and reduce cost and runtime with same cardinality. Redefined table structures, rollback segments, undo tablespaces and other parameters minimizing ora errors.
• Redesigned database objects such as tables, tablespaces, indexes, triggers and optimizer statistics to improve overall efficiency. Extensively Involved in query optimization and using rule based optimizers and cost based optimizers to reduce user i/o load and cpu usage.
• Increased performance by using the hints, Explain Plan utility, SQL Trace and TKPROF for improving query efficiency in extracting transforming and loading production data. Partitioned large tables to limit/increase growth of tables and involved in re-organization of database.
• Extracted critical data from flat files into prod Database using SQL*Loader. Also used SQL*loader and data pump import to load data into tables. Migrated database schemas from dev to test to prod databases and related movements back and forth.
• Worked on Oracle Data Pump (data export/import) and managing databases across multiple environments.
• Performed High priority data fixes, data bug removals that were opened as tickets by business users and eligibility specialists which they were not able to do at the db front end. Developed related SQL’s validated them on dev and committed on prod.
• Closed high priority tickets on daily basis committing data on production after due validation. Performed expert level SQL tuning and targeted PL/SQL packages that are high on resources.
• Worked hands-in-hands with business users that use to run queries on daily basis to fetch critical data from prod. Identified the report queries and high impacting queries and tuned them increasing query performance.
• Improved query performance as high as 32 times its original on a particular query that ran in prod every two hours to generate notice of decision and letters to be sent out to the health program applicants that were critical and had to be performed regularly thus boosting system performance.
• Tuned PL/SQL packages that ran as batch jobs daily reducing impact time and cpu loads. Performed capacity planning for DHHS production database Troubleshooted 4-5 application failures including row lock contentions, instance peaking and data hangs.
• Provided expert analysis of DB with its total Storage, fault tolerance and memory parameters. Worked on the latest version of TOAD 10.6 extensively including using TOAD functionalities like schema browser, session browser, optimizer, data migration tools, database partioning, database links, Explain plan utility and database sga and memory parameters inspection.
• Worked extensively on Oracle Enterprise manager grid control. Worked on Oracle developer suite 10g including Oracle forms, Oracle reports, Oracle designer and Oracle jdeveloper suite. Worked on TOAD data modeler to generate data models and identify relationships between various objects and entities.
• Ran SQL advisors and SQL repair advisors in grid control and implied positive results. Accomplished quality improvements in overall system efficiency of the database across the projects by undertaking initiation and coming up with several proposals and expert analytical skills that lead DB to an enhanced level of application functionality.

Environment: Sun solaris, Windows xp, Oracle10gdb, Grid, OEM, AWR, Forms, SQL*Plus, OLTP, OLAP, Grid Control, Oracle TOAD 10.6, TOAD data modeler, PL/SQL, Oracle designer and developer suite 10g.

Confidential, Dallas, TX

Sr. Oracle DB Architect/Administrator

Responsibilities:

• Responsible for 24 X 7 Production database administrations, support and monitoring. Performed Performance tuning for Oracle 11g to provide Real time Query capability of physical standby database.
• Performed Performance Tuning in Oracle 11g using database design methodology consisting of selective Denormalization, Selecting the right data access path and proper data partitioning.
• Using Oracle 11g provided fast start failover for maximum performance mode in data guard configuration. Experience in Development, QA and Production environment and database design, development and support.
• Used TOAD from for development and administration of various relational databases using SQL TOAD on 32 bit windows platforms including windows 95,98,NT,2000,XP and Vista. Configured and installed Oracle 10g with two nodes RAC in ASM storage with normal redundancy on Linux (RHEL4).
• Experience on OLTP (On Line Transaction Processing) in an Oracle RAC environment. Migrated Oracle databases from Windows to Linux and vice versa.
• Upgrading SAP instance from Oracle 9i to Oracle 10g, upgrading kernel and reconfiguring all environment;
• Migration SAP from SAP R/3 4.6C to ECC6
• Migration SAP ECC6 instances from non-Unicode to Unicode version;
• Extensive experience with PL/SQL programming and scripts development that can be read into the database using the Oracle SQL PLUS tool. Used DDL (Data definition language) and DML (Data manipulation language) for generating PL/SQL codes.
• Used EMC recoverpoint 3.3 for point recovery strategies used for 2 of our OLTP production databases for continuous backups as the databases could not be shutdown anytime and instant data was being required.
• Designed and customized SAP applications and deployed sap applications. Working experience with SAP enterprise resource planning and SAP business objects.
• Worked on the SAP business suite and used applications including customer relationships management, product lifecycle management as well as supply chain management. Extensively involved in data warehousing and managing DW processes including staging, integration and access.
• Performed replication of distributed consistency groups using a single recover point alliance (hardware platform for Recoverpoint). Used Recoverpoint vcenter site recovery manager tool for fail back purposes.
• Involved extensively in ETL processes to facilitate raw data processing and loading in homogeneous and non-homogeneous environments. Involved in data mining procedures and managing data dictionaries.
• Worked on ETL tools including cognos and business intelligence tool including BI publisher for data reporting and warehousing purposes. Extensive experience with ASM for managing storage for Oracle datafiles, control files and logfiles.
• Managed and administered SAP applications for increasing overall business efficiency. Worked on MS SQL 2005, express and 2008 and administered related database design as well. Supported different OLTP/OLAP Databases like Production, Development, Testing, and Training.
• Used Oracle Enterprise Pack for Eclipse with technologies including Database, Java SE, Java EE, Web Services, XML, and the Spring Framework. Experience with Oracle Data Pump (data export/import) and managing databases across multiple environments.
• Experience in Oracle Designer, Oracle Developer and Oracle Enterprise Management (OEM) including Oracle Enterprise Manager Database Control. Oracle Enterprise Manager Application Server Control and Oracle Enterprise Manager Grid Control.
• Experience with Database performance tuning including application tuning, memory tuning, I/O tuning and operating system tuning.
• Used Oracle E-Business suite (EBS) including but not limited to Oracle customer relationship management (CRM), Oracle financials, Oracle project portfolio management as well as Oracle mobile supply chain applications.
• Worked on DB engines including teradata and Netezza. Involved with installation and upgrades of RDBMS in clustered and non-clustered environments. Involved in database security management and data security procedures including but not limited to data masking, data encryption and data integration.
• Worked on ADDM and AWR (Automatic workload repository). Used continuous backup strategies when backup schedules could not be determined and data had to be written on disks at remote locations.
• Experience with Sybase and PeopleSoft. Performed Data load on different databases using SQL*Loader. Experience with Data Modeling and worked with DB Artisan, ER Studio, Erwin, TOAD, Power Designer.
• Used EMC recoverpoint tool for disaster recovery and continous data buildup and replication at remote disk storage sites. Involved in logical and physical databases design. Proactive database monitoring and management using 10g grid control tool.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Used dataguard for establishing and maintaining secondary physical and logical standby databases for high availability of the database as well as disaster recovery ("failover") purposes.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER, AWR and SQL tuning advisor. Performed database cloning to setup test and development database.
• Conducted sizing & capacity planning for Oracle databases. Upgraded development and production databases to Oracle 10g. Applied patches to Oracle Databases. Provided support to Application Database Administrators in designing the database.
• Planned, tested and implemented backup strategies using RMAN, Oracle Utilities (Export/Import) and OS methods. Used RMAN for backup and restore purposes to facilitate block-level corruption detection and file multiplexing during backups.
• Implemented Hot, Cold and Logical backup plans. Recovered critical databases from failures with minimum downtime. Responsible for setting and managing user accounts, Granting required privileges to users.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files. Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Involved in Design and implementation of Oracle 10g Data Guard both physical/logical standby databases. Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations/Upgrade/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, and Oracle Standby.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Red Hat Enterprise Linux 4.0, Windows 2003, Sun Solaris, AIX, Oracle 9i/10g RAC, Grid, OEM, AWR, ASM, Streams, SQL*Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning.

Confidential, Plano, TX

Jr. Database Architect/Developer

Responsibilities:

• Responsible for management and supporting Oracle 10g and 11g databases. 24 x 7 production support for several mission critical systems which utilize multiple Oracle databases.
• Work with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• Used Java and J2EE to develop database Web deployed applications in Web logic environments for server as well as end user uses. Extensive experience with PL/SQL programming and scripts development that can be read into the database using the Oracle SQLPLUS tool.
• Used DDL (Data definition language) and DML (Data manipulation language) for generating PL/SQL codes. Troubleshooting application failures including performance and database connectivity problems and job failures.
• Involved in performing migration from Oracle 9i and10g to Oracle 11gR2 RAC database. Upgrade databases and apply security patches both server and Client. Migrated database schemas from Development to Integration Test and Production environments.
• Database Cloning from Production to test database to identify the problems. Set up backup and recovery procedure using RMAN for both OLTP/OLAP databases. Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.
• Used SAP business solutions including SAP business objects suite and SAP business intelligence. Created duplicate databases using RMAN duplicate. Worked on import/export, import/export Data Pump and SQL- loader.
• Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group. Worked on SAP applications including SAP supply chain management to manage organization financials by application integration.
• Set up, configured and maintained Oracle Data Guard (primary and standby databases) to ensure disaster recovery, high availability and data protection. Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Installation of Grid Control Server and Management Server. UNIX Shell scripting for automating startup/shutdown of databases, getting system alerts etc. Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, and EXPLAIN PLAN, AWR, and optimizer hints. Created custom Stats pack scripts and implementation documentation for corporate-wide roll-out to all databases for automatic periodic statistics gathering and reporting.
• Performed production system problem analysis and recommend corrective measures in a timely manner.Worked with other vendors to support their applications.

Environment: Windows NT / 2000, HP-UX, AIX and Linux, Oracle 9i and 10g, TOAD 9.0.1, Erwin, Oracle Enterprise Manager, RMAN, RAC, ASM, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, OLTP, OLAP.

Confidential, Austin, TX

Jr. Oracle DBA/Developer

Responsibilities:

• Provided 24x7 support to maintain all Databases up and running in Production environment. Regular Instance Level Performance Tuning for the critical Production database servers Worked with the SQL Developers, to create logical and physical database design.
• Analysis and Design of Oracle DB with its total Storage and fault tolerance. Creation and migration of Database and other related Objects. Implementing Database Security, Management of role-based security and database auditing.
• Managed Data Guard Database and Staging Database. Participated in disaster recovery testing. Data Migration as part of enterprise data warehouse project. Database Restore using RMAN, Cold Backup and Export.
• Applied Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database. Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, NetBackup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data Guard. Managing and configuring database user accounts and permissions. Identifying and implementing standard operating procedures for large size db files.
• Performed fine tuning by creating indexes, TKPROF, EXPLAIN PLAN and TRACE events. Setting and troubleshooting of Oracle listener, network connection, user security and administration. Tuning for optimum performance.
• Analyzing, designing and implementing fault tolerance system and automated error tracking system, which sends any error, occurred to concerned personnel by email. Actions to Critical Alerts. Defining the strategies for Backup and Recovery at physical level using RMAN and Export/ Import utilities.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Environment: RHEL 3.0, Windows XP/NT/2000/2003, Sun Solaris 8.0/9.0/10.0 , Oracle 8i/9i/10gR1, OEM, Data Guard, RMAN, SQL* Plus, SQL*Loader, Oracle TOAD, Oracle Replication, MS Office.