Purvi Patel

Skills

Employment History

Confidential

Oracle DBA Programmer

Description:

Confidential a Fortune 100 company, and it is one of the largest pharmacy benefit Management organizations in the The company processes pharmaceutical claims for members at network pharmacies and at their own mail order pharmacies. Express Scripts provides integrated pharmacy benefit management services including network-pharmacy claims processing, home delivery services, specialty benefit management, benefit-design consultation, drug-utilization review, formulary management, and medical and drug data analysis services to manage drug plans for government agencies both as administrator of employee benefits and public assistance programs ,corporations, and unions. One of their largest clients is the United States Department of Defense's TRICARE program.

Responsibilities

• Perform Backups and Recovery, maintain 24 hours uptime for the database
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment
• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases
• Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Table spaces, segments, extents, indexes and managing Undo Data.
• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM Oracle Enterprise Manager
• Install and configure Database as of Oracle's Optimal Flexible Architecture OFA .
• Knowledge of DATAGUARD.
• Requirement gathering, analysis, design, development, testing, implementation, production support, and change management.
• Mentored and provided oversight and backup for the production Databases.
• Maintained Test Database for testing and research work
• Used Flashback feature to recover a dropped table and also to recover a database.
• Knowledge of Oracle11g RAC on the Same Cluster Using CRS
• Visualizing future requirements of the resources based on the ongoing performance.
• Automating the daily routine activities backups using the DBMS JOBS, DBMS SCHEDULER.
• Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF, Auto trace.
• Used Automatic Workload Repository AWR for analyzing the database performance.
• Use TOAD to Optimize and test SQLs, PL/SQL statements developed by the Development Team.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Implemented Change Control for the Production Databases as and when required.
• Communicated with Oracle support via the Metal ink in order to troubleshoot important issues.
• Performed general technical troubleshooting and give consultation to development teams
• Provided support to ETL developers in loading data to data warehouse using ETL tool Informatica
• Planned the index rebuilding, analyze index and analyze table on periodical basis

Environment

• Oracle 11g, Sun OS 5.6, Exp/Imp, ERWIN 4.14, SQL Developer, OEM, SQL LOADER, Cute FTP, DB2 SQL, MVS Workload Manager,
• Performance software: BMC Main view for MVS/CICS/DB2, Strobe, SAS/MXG, SAS report code

Confidential

Oracle DBA Programmer

Description

Confidential is the prime franchisee holder of over 150 branches of KIFS securities along with Medical Billing. Confidential is in the business of shares and stocks brokership, investment advisory, financial services and portfolio management in stock markets, debt markets and derivatives markets providing dematerialized accounts services. Also, are corporate member of National Stock Exchange having equipped with sophisticated infrastructure in various cities in India.

Responsibilities

• Performed migration from Oracle 10g to Oracle 10g Release2 RAC database
• Responsible in Managing and optimizing transactional replication in OLTP and OLAP environments.
• Developed backup and recovery strategies for Oracle Server databases.
• Creation and configuration of Standby Database Dataguard
• Worked on monitoring and optimizing the database by performance tuning
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Developed UNIX shell scripts with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Responsible for taking logical backups of data using exp, Imp.
• Managed the file transfer interface from MAC computers running ORACLE FORMS
• Developed Oracle reports writing and Server Reporting Services interfaces.
• Designed and developed user interfaces for customers using Oracle forms 9i/10g Forms Builder.
• Responsible for taking HOT and COLD backups of the databases and also the individual table spaces
• Experience in Backup Recovery techniques and conducted disaster recovery drills.
• Extensively used Toad to create database objects, develop packages and statistics of all PL/SQL queries.
• Responsible for partitions on tables and indexes for managing large tables
• Requirement gathering, analysis, design, development, testing, implementation, preferably Subversion, production support, and change management.
• Maintenance modification of Shell Scripts
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Creation and maintenance of test schema
• Performed migration from Oracle 10g to Oracle 11g Release1 RAC database
• Physical and Logical Design of the database which includes Database creation, table space creation, table and index partitioning and also mapping of different objects with disks
• Performed ongoing capacity planning and expansion to meet requirements of database growth.

Environment:

Solaris, Oracle 10g, RAC, ASM, UNIX Shell scripting, VI Editor, RMAN, Data pump, OEM, Oracle Data Grid Control, Putty

Confidential

Oracle DBA Programmer

Description

Confidential operating businesses in three sectors: Retail, Allied Services and Finance. Leveraging a strong understanding and knowledge of Indian consumer preferences, habits and aspirations, we have built some of the most respected retail brands in the country. Our retail business across the value and lifestyle segments focuses on 4 key consumption verticals: food, fashion, general merchandise and home.

Responsibilities

• Performed migration from Oracle 10g to Oracle 11g Release1 RAC database
• Performed logical backup using export/import and data pump remote export utilities
• Configured the RMAN backup
• Configured the OEM for the database monitoring
• Carried out hot backup, cold backup and RMAN backup
• Carried out the Binary Installs in the Oracle 10g RAC environment
• Done the Migration Review required before the database migration and QA after the database is migrated.
• Developed many Stored Procedures, Packages, and Cursors and involved in the performance tuning of PL/SQL.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora
• Created schema tables, indexes, views, sequences, synonyms, roles, packages , grant roles to users
• Loaded flat file data into tables using SQL Loader
• Undergone the SOX Training
• Managed the file transfer interface from MAC computers running ORACLE FORMS
• Provided full technical support to various application teams before the databases go live
• Experience in interaction with the top management and escalations of the complex issues
• Attended the call conference meetings
• Requirement gathering, analysis, design, preferably Subversion, development, testing, implementation, production support, and change management.
• Performed the capacity planning required to create and maintain the databases
• Perform Backups and Recovery, maintain 24 hours uptime for the database
• Managed the databases of various sizes ranging from 50GB to 2.5TB

Environment:

Oracle 10g RAC, Quest Toad 8.5, SQL Loader, Windows 2003/XP, Sun Solaris 5.8, DBArtisan, Core FTP, F-Secure SSH Client, Oracle 9i

Confidential

Oracle Analyst/Programmer

Description

A full service firm, that provides turnkey solutions, may it be custom developed or own products. A comprehensive business solutions and outsourcing facilities provided to clients across the world in the fields of finance, healthcare, ecommerce, education and manufacturing activities.

Responsibilities

• Involved in requirement analysis and design documentation.
• Designed and developed database tables necessary along with the necessary constraints to enforce business rules.
• Created and modified several Database Triggers, especially for Audit and Security purposes.
• Developed many Stored Procedures, Packages, and Cursors and involved in the performance tuning of PL/SQL.
• Involve in Tuning, Performance, Optimization of queries and standardization of the code
• Resolved several hardcore business rules and issues at the client site.
• Have a good understanding on Service Management modules like Incident, Problem, preferably Subversion and Change Management.
• Created users, roles with privileges, grant the appropriate roles.

Environment:

Oracle Designer 2000, Oracle Developer 2000, Oracle Forms 4.5, Oracle Reports 3.0, PL SQL, SQL PLUS, SQL Loader, SQL Navigator, TOAD, Oracle 7.3.4, Oracle 10g, MS Access 2000, MS Word 2000, MS Excel 2000, MS PowerPoint 2000, Windows NT 4.5