SUMMARY

• About 8 years of experience in Information Technology wif expertise in Database Development, Database Administration, Implementation, Maintenance and Support.
• Have noledge in all aspects SDLC methods including architecture, analysis, design, development, testing, implementation and maintenance of application software in client/server and Multi - tiered environments.
• Proficient in DBA tasks dat includes installation, configuration, administration, monitoring, database tuning, creating objects, implementing backup strategies, crash recovery, space management and database security.
• Expertise on Oracle 10g/11g RAC, Data Guard/streams installation and upgrade.
• Experience wif Tuning Database for availability, RAC Setup and configuration, Database Administration in a RAC Environment, Utility computing.
• Experience in doing backups and recovery using RMAN, Cold/Hot Backups, export/import.
• Experience in using Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance Tuning, capacity planning, script development and documentation.
• Experience wif cloning Test and Development environments from Production Oracle Applications environment (AutoConfig, Rapid Clone).
• Experience in interacting wif users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Experience in using SQL*Loader and External Tables.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK etc.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Experience in application testing and support, version control, object management, code and design review, production staging and implementation planning, overseeing development efforts.
• Good experience in gathering requirements, data modeling and database design.
• Excellent Analytical and Problem solving skills.
• Ability to perform well as a Team member and as an Individual, wif dexterity to blend well in any situation and environment.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, PA

Responsibilities:

• Design and implementation of backup and recovery strategy using RMAN.
• Administration of 11g Data Guard for high availability.
• Involved wif installation and maintenance of ORACLE 11g RAC database for high availability.
• Worked wif Business Objects for reporting, data clusters (RAC).
• Disaster recovery using Standby database and Database cloning.
• Configured ASM file system and administered ASM Instances and Disk Groups in RAC.
• Use SQL profile and system monitor to monitor the server and the databases.
• Expert skills in database and stored procedure tuning for better performance.
• Worked in Replication Server, including installation and configuring replication between servers concentrating on Primary model and the warm standby model.
• Created adhoc reports using sql queries as per the requirements.
• Extensively used Partition Exchanging and dropping for the Data Archiving process.
• Created tables, indexes, constraints, triggers, synonyms and database links wherever needed.
• Made use of the PL/SQL WRAP utility for encrypting the codes for security purpose and to make it portable across platforms.
• Wrote Test Plans and Test Cases for the verification of the code changes, jobs enhancements.
• Wrote Shell scripts for handling the calling pl/sql code.
• Worked wif the Business Analyst and the Business Users to coordinate the User Acceptance Testing.
• Participated in the weekly status meetings, code reviews and requirements gathering meetings.

Environment: Oracle 10g/11g, RAC, RMAN, Dataguard, ASM, SQL*Loader, SQL Developer, Export, Import, UNIX Shell Scripting, OEM grid Control

Oracle DBA

Confidential, PA

Responsibilities:

• Create, maintain and refresh required Oracle instances/databases for development, test and production environments.
• Cloning of databases for Testing and Development teams and supporting for testing, development teams.
• Perform capacity planning, performance monitoring and tuning, backup/recovery techniques, and problem determination and resolution, RMAN, OEM, Grid Control.
• Worked wif Oracle Real Application clusters (RAC) on AIX and Solaris platforms.
• Active participation on designing, implementing and supporting physical and logical standby databases in Oracle.
• Involved extensively in Troubleshooting, optimization query tracing and tuning.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL file to read and write from database, DBMS SQL to write dynamic SQL etc.
• Responsible for application testing and support, version control, object management, code and design review, production staging and implementation planning, overseeing development efforts.
• Produced Design Documents and Test plans.
• Developed wrapper scripts to invoke batch jobs using ControlM command line utility.
• Developed shell scripts to send auto emails based on pre defined events.
• Worked wif External Tables, sql * loader and creation of control files.
• Scheduled and Monitored Daily, Weekly and Monthly jobs using BMC Citrix.
• Used SQL Loader to load files received everyday from Trade Agents.
• Responded to the user queries and weekend production support calls.
• Coordinated wif the Business Analyst in filling out the Business Unit Approval forms during turnovers.
• Maintained the versions of files for the source code using Serena PVCS.
• Created Change Requests for the turnover of codes.
• Created tickets for notifying job failures using the HP Service Center.
• Wrote Test Plans and Test Cases for the verification of the code changes, jobs enhancements.
• Worked wif the Business Analyst and the Business Users to coordinate the User Acceptance Testing.

Environment: Oracle 9i/10g, PL/SQL, XML, HTML, SQL*Loader, TOAD, Export, Import, UNIX (Solaris, AIX, HP/UX), UNIX Shell Scripting, BMC Citrix.

Oracle DBA

Confidential,TX

Responsibilities:

• Installation, up gradation and Maintenances of Oracle RDBMS on Linux & Windows platforms.
• Worked wif senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux.
• Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely wif Oracle to make Application environment up to date.
• Created users and grant privileges according to the requirements.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.
• Disaster recovery using Standby database and Database cloning.
• Monitoring database health by scheduling shell scripts thru cron jobs.
• Creation of Database, Tablespaces and Schemas, Data Loading.
• Managing data security and user access.
• Created the indexes to optimize the performance of the data retrieval process.
• Tuned stored procedures and triggers identified for better performance.
• Responsible for writing test plan documents and unit testing for the application modules.
• Wrote Shell Scripts, control files to load data into DW tables.
• TEMPEffective Interaction wif Support and other Application groups through on call for high priority issues.
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue, setup issue, functional issue or an RDBMS issue.
• Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.

Oracle DBA

Confidential, IL

Responsibilities:

• Involved wif Client engagement, Business Requirements elicitation, Business & Data Analysis, software configuration and customization.
• Attended regular walkthroughs wif Clients and Developers.
• Built triggers to log the information about users and the operations they perform in their session. Developed procedures to load data from staging tables to target tables.
• Extensively worked on performance tuning of the load process using Explain Plan and DBMS STATS package.
• Use of Import-Export utilities and SQL * LOADER, Data Migration.
• Implemented Oracle Partitioning features for large tables.
• Analyzed requirements and prepared system flows, specifications, and database designs.
• Implemented and maintained database through DBA activities include database backup (Cold, Hot, Import/Export), database recovery, tuning, installation, database creation, logical and physical databases design.
• Creation of application users and granting privileges to them.
• Experienced in using utilities like Export/Import and SQL Loader.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Coordinated wif other team members in establishing tasks and deadlines.
• Provided 24*7 System support.

Oracle DBA

Confidential

Responsibilities:

• Creating, checking, extending table space.
• Administered database security, created users, granted/revoked roles & privileges.
• Extended databases storage capacity, monitored and reduced database fragmentation.
• Managed data files, rollback segments, extents, segments, and indexes.
• Implemented sound backup, recover and restore policies.
• Extensively used SQL Loader to load data from flat files to the Oracle Database.
• Knowledge of data warehousing methodologies and techniques using star schemas, DB loads, indexing, Physical and Logical data modeling etc.
• Involved in dumping data from international data warehouse to domestic data warehouse.
• Involved in writing and executing stored procedures, functions, and packages for products, bookings, invoices, customers and Sales men in PL/SQL and database triggers.
• Created packages, functions and procedures using Dynamic SQL.
• Used SQL Navigator to develop and debug PL/SQL and create, execute and optimize SQL queries.
• Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation.
• Used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc for performance tuning.
• Created and build the shell scripts to run the batch processes and scheduling the jobs at nightly, weekly and monthly base..