Rajesh Maktala ph:732-***-**** y5ga81@r.postjobfree.com, y5ga81@r.postjobfree.com

Career Summary

Mr. Rajesh has over eleven (11) years of professional experience working in the Information Technology Industry. He has worked at all levels of the systems development life cycle including analysis, design, development, testing, and implementation. As an Oracle DBA he has over 5 years of experience, performed all DBA related functions including database installation/upgrades, space allocation, performance tuning, backup and recovery, High Availability implementation using Oracle Parallel Server and disaster recovery using Oracle Standby implementation. In addition to Maktala’s top-notch technical abilities, he also possesses excellent interpersonal/communication skills making him an ideal addition to any Oracle project requiring his DBA or leadership skills.

Technical Skills

Hardware • Sun Enterprise Servers

• HP 9000

• IBM RS/6000

• Windows x.

Operating Systems • UNIX (HP-UX, AIX 6.0, Solaris 10)

• Windows NT • Novell NetWare

• MS DOS

• MS Windows

Software, Tools & Languages • SQL DBA

• SQL

• SQL Plus

• Server manager

• Oracle Enterprise Manager

• Oracle Grid Control

• Oracle Forms 6i/9i/10g

• Oracle Reports 6i/9i/10g

• MS Word

• MS Exchange • PL/SQL

• SQL Net

• KORN Shell

• Bourne Shell

• MS Excel

• RMAN

• C,

• Oracle Designer

• OAS, iAS

• Statspack

Databases • Oracle 7.1,8.1.x, 9.2.x, 10.2.x, 11 g

• SQLServer 2000/2005

• MS Access · Oracle Parallel Server

· Oracle Standby

Avmed Health Plans, Miami, FL

09/2008 to Till date, Oracle DBA

AvMed Health Plans is Florida's largest not-for-profit health plan, improving access to health care for members for more than 30 years, while serving Florida communities in the major metropolitan areas of the state. Through an extensive broker network, AvMed offers health care coverage on a fully insured and self-funded basis for employer groups in Florida. Additionally, AvMed offers health care product to Medicare beneficiaries in South Florida.

Responsibilities included

Oracle Installation, Physical Database layout, High Availability, Backup and Recovery configuration through Recovery Manager (RMAN).

Migration of the database from 9.2.0.5 to 10.2.0.3.

Creation of Disaster database at SB, incase of disaster.

Daily database administration including space management, user administration, creating, and assigning grants and roles, scheduling daily backups.

Tuning at Application level, Database tuning, enhancements of the physical database design.

Supported all the New apps Go-lives.

Supported SQLServer 2000 for Document imaging databases.

Lead functional and technical sessions to resolve issues and challenges

Marriott Vacation Club, Orlando

04/2007 to 08/2008, Oracle DBA

Marriot vacation club has various data warehouse projects to process timeshare hotel information. Summit is one among them; Summit database imports data from another database called prophecy. Summit eventually processes the data to generate reports which are useful for Business intelligence & corporate performance management software for better business decisions.

Oracle Installation, Physical Database layout through raw devices, Configuration of oracle in Oracle Parallel Server environment, High Availability and Transparent Application fail over through HACMP, Backup and Recovery configuration through Recovery Manager (RMAN) to backup 1 terabytes of data through Tivoli Storage Manager.

Involved in the Cerner Domain split into Main and Alpha domains.

Implemented HOT backups through RMAN recovery catalog, extensively tested for restore or the database, tuned the RMAN backup to increase the backup speed of the database, backup compression etc.

Daily database administration of OPS Cerner database including space management, user administration, creating, and assigning grants and roles, scheduling daily backups.

Automating backup schedules, alert mechanism to notify DBA of ob-normal errors in database and backup jobs.

Setup Disaster recovery using Oracle Standby databases.

Supported SQLServer 2000 for Document imaging databases.

Blue Cross Blue Shield., Florida, USA .

07/2006 to 03/2007, Oracle DBA

BCBS offer an array of choices designed to meet the diverse and ever-changing needs of Florida employers as well as individuals purchasing health care coverage. BCBS health plan choices include HMO plans, broad network PPO plans and Supplementary health coverage for Medicare recipients and traditional indemnity products. Through BCBS family of subsidiaries, BCBS also offer prescription drug coverage, dental plans, life insurance, long-term care, workers compensation, Away From Home Care and many other products.

Implemented HOT backups through RMAN recovery catalog.

Tested Application Fail over through HACMP

Daily database administration of OPS Cerner database including space management, user administration, creating, and assigning grants and roles, scheduling daily backups.

Tuning at Application level, Database tuning, enhancements of the physical database design.

Automating backup schedules, alert mechanism to notify DBA of ob-normal errors in database and backup jobs.

Setup Disaster recovery using Oracle Standby databases.

Responsible for updating the functional and technical specifications of the system

Publix Super Markets Inc., Florida, USA

12/2005 to 06/2006, Oracle DBA

Founded in 1930, Publix Super Markets is the largest and fastest-growing employee-owned supermarket chain in the United States. They are having Supply Chain Marketing system on Oracle Applications.

Oracle Installation, Database layout, configuration, maintenance of production and development and test databases.

Scheduling daily logical backups and weekly Cold backups.

Daily database administration including space management, user administration, creating and assigning grants and roles, scheduling daily backups.

Coding, tuning Application level stored procedures/functions through PL/SQL 8.0, Database tuning, enhancements of the physical database design.

Responsible for implementing new procedures/extracts for Data warehouse financial reports.

Responsible for automating all batch jobs process through shell scripts.

Reverse engineered the data model through Oracle Designer 6.0.

Lead Junior DBA/Developers to diagnose and resolve problems.

West Gate Resorts, CFI Florida, USA

8/2004 to 11/2005 Oracle DBA

West Gate Resort uses an application SAM (Sales and Marketing) developed in Oracle Forms 9i, Reports 9i. This application is used to sell the time share, arrange tour on time share for customers. Tour attended customer can get attraction tickets (e.g., Disney, Sea World) hotel or rental car discounts. Each tour will be in different scheduled time. Sales representative will explain about the time share, terms and conditions to buy a vacation package. The time share can be sold by telemarketing people, owner referral, on property customer or dialer system.

Responsibilities included:

Oracle Installation, Database layout, configuration, maintenance of production and development databases.

Responsible for migrating CSMS database and Designer repository from HP UX 10.2 to AIX 4.3

Scheduling daily logical backups and weekly Cold backups through Tivoli storage Manager.

Loading purchasing activity data and vendor and item information, contracts data from business units.

OAS administration 4.0.7, development, maintenance and customization of web forms through Oracle Forms 6i and Oracle Reports 6i

Daily database administration including space management, user administration, creating and assigning grants and roles, scheduling daily backups.

Coding, tuning Application level stored procedures/functions through PL/SQL 8.0, Database tuning, enhancements of the physical database design.

Implementing new procedures/extracts from Data warehouse.

Automating all batch jobs process through shell scripts.

Reverse engineered the data model through Oracle Designer 5.0.

Responsible for updating the functional and technical specifications of the system

Lead Junior DBA/Developers to diagnose and resolve problems.

Lead and Organize technical and functional sessions to resolve issues and challenges

Priority Health Care - Florida, USA

02/2003 to 7/2004 Oracle Applications Developer

CRM, ERP 11i (CRM, Order Management, Inventory)

Priority Health Care uses Oracle Applications as the major software application to run their medical distribution and pharmacy business. Priority has their own pharmacies in all different states to supply drugs to the patients; specific drugs are for fertility, hepatitis. Custom Pharmacy application is linked to Oracle Applications 11i, which supports pharmacists to provide drugs to patients and adjudicate the medical bill.

Major Responsibilities

Involved in migration/conversion of the application. All the drug (items), payer (party)data from legacy systems with RPG files has been converted to Oracle Applications 11i database.

Developed PL/SQL packages for converting legacy data into 11i database data.

Designed, created and maintained Web-enabled Oracle Forms & Reports.

Designed and Developed HTML, C, Shell Script, Java JSP programs to call Oracle Forms and Reports from Web as Apps 10.7 was not web based.

Developed a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to download and manipulate files.

Environment:

Oracle Applications 11i, Oracle 9i, PL/SQL, Unix, Shell Scripting, Forms 6i, Reports 6i, HTML,

Merck - New Jersey, USA

05/2001 to 01/2003 Senior Programmer/Analyst

Project: Automated Expense Reporting (AER) System

Writing API interfaces to Financial Application. Writing Shell script batch jobs to migrate, massage/convert data from JD Edwards database (RPG format files) to Ez-Expense (Oracle Database)

Used SQL*Loader, C, Pro*C to extract, transform, import, export data from Oracle tables to flat files, developed reports using C programming. Forms 6i, Java, JSP, Oracle Reports 6i, are used to develop Web screens, Web validation, Connecting Oracle from JSP, Java Programs. Used PL/SQL standard packages (DBMS_SQL, UTL_FILE), procedures and triggers for various application needs.

Environment:

Oracle 8.i, PL/SQL, Unix, Shell Scripting, SQL*Loader, C, Pro*C, XML, Forms 6i, Java, JSP, Oracle Forms6i,Reports6i.

Bristol Myers Squibb - New Jersey, USA

05/1999 to 04/2001 Programmer/Analyst

Project: BRIQTone Application

Developed Interface programs to transfer data from Clinical Application to IVR application by Quintile vendor. Highly involved on extraction, migration of the databases. Developed Web based Screens and Reports in HTML, Java Script, and Oracle Reports. Developed reports for Randomized Co-Coordinators. Used PL/SQL standard packages, procedures and triggers for various applications needs Created triggers, batch jobs for background processes

Worked extensively on Pro*C in developing various reports of the system and batch processing programs which helps to update data weekly and monthly.

Worked on Oracle DBA tasks, compiling schemas, query tuning, userid/password creations, creating indexes, schemas.

Environment:

Oracle 8.0, PL/SQL, PL/SQL Cartridges, Pro*C, HTML, XML, JAVA, Visual Studio, SQL*Loader, Reports 6

Unix, Shell Scripting, OAS - Oracle Application Server

National Exchange Carrier Association Inc. - New Jersey, USA

03/98 to 04/99 Programmer/Analyst

Project: TARIFF

The front-end GUI screens were developed using Developer 2000 Worked on Template forms to lay the foundation for the application. Controls like Tabs, Drop down list box, list of values and Spin control were used. Made extensive use of Procedures, Function and Cursors Responsible for application tuning and testing on different environments Also involved in unit testing of the system

Environment:

Oracle Forms 4.5, Reports 3.0, Designer 2000, Oracle 7.3, PL/SQL, SQL Navigator, Windows NT 4.0, Unix AIX, Shell Scripting

EDUCATION:

Bachelors in Computer Science Engineering

Contact this candidate