SUMMARY

• Over 15 years of extensive experience in ORACLE RDBMS including 10 years in Database Administration of Oracle 10g/9i/8i/7 versions on UNIX Sun Solaris, AIX, HP - UX, and SCO-Unix on Windows environments. Since worked for Database Strategic and Marketing Services, Telecom, Financial, Government, and Manufacturing Sugar, Steel Tube, Paper, and Pulp industries as Senior DBA, Systems Executive, Analyst, and Programmer
• Led Team for a Major ERP implementation of PeopleSoft HRMS and Financials with Oracle databases over IBM RS/6000 S80/S70/S7A models
• Specialized in Performance Tuning, Capacity Planning, Monitoring and Security Administration of databases on OLTP, Data Warehousing and Decision Support Systems
• Experienced in configuring databases in clustered environments with High Availability HA setup using VERITAS Cluster Server VCS . Migrated databases from OPS to RAC on Oracle 9i databases. Replicated databases using traditional snapshot logs, and OEM multi-master node methods.
• Commendable experience in conducting Feasibility Studies, Plan reviews, Implementation, and Post Implementation Surveys. Highly skilled in Design, Development, Implementation of database applications on QA/UAT/Stating and Production environments
• Expertise in evaluate, resolve database related issues and successful co-ordination between development groups in distributed environments. Proven abilities in establishing effective task priorities.

SKILLS SUMMARY

• Hardware Platforms: HP-9000/785/B2600, IBM RS/6000 S7A/S70/S80 Models, Sun E450, E10K, E220R, E420R, E3500R, Sun Fire V240, Linux i686 Servers
• Operating Systems: UNIX AIX, HP-UX, Sun Solaris, Linux, Windows XP/2000/NT
• RDBMS: ORACLE 10g/9i/8i, 9i AS, MS-SQL Server 2000/7/6.5, SYBASE
• Languages: PERL, C, SQL, PL/SQL, Pro C, COBOL, Java, VB, Crystal Reports
• Shell Scripting UNIX utilities: Bourne, C, Korn, bash, awk, sed and Perl programming
• Data Modeling Tools: ERwin, and Oracle Designer/2000
• Special Backup Software: COMMVALUT-Magnum for Oracle, BMC-SQL-BackTrack

Tools and Utilities: VERITAS, Oracle Enterprise Manager, DB Artisan, TOAD, SQL Navigator, I/Watch, Peoplesoft Financials 7 and HR 8, Shareplex 4.5 for Oracle, BMC Patrol, Business Objects

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

• EPSILON is a leading Database Strategic and Marketing Services, which provides Data Analysis, Multi-Channel Direct Communications and Database Marketing to Fortune 1000 companies.
• Roles and Responsibilities:
• Providing Operational support of Production/QA/UAT databases of Loyalty Services Platforms on IBM RS/6000 servers
• Working with cross functional Team of Business Systems Analysts for a successful implementations of PER Product Enhancement Request s
• Incorporated Monitoring processes on Production, QA, UAT and Development environments
• Implemented Backups of all databases of LSP using Commvault, for Magnum by worked closely with Enterprise Backup and Recovery EBR Team for DR set-up
• Automated a process of preparing production database to refresh UAT/QA/DEV environments following to the major releases
• Prepared a DB health check report s and scheduled as CRON jobs
• 24 x7 on-call support of LSP databases with Network Operations Control NOC
• Working with System Admin Group in moving database servers from Dallas Data Center to Irving location, as part of Data Center Move
• Software in Use: Oracle 10g/9i, Aix, Oracle Grid Control, OEM, SQL, PL/SQL, Oracle Forms, Cognos Reportnet, and ERwin Data Modeling Tool
• VERIZON WIRELESS, Southlake, TX Lead DBA

Role:

• Worked as Senior DBA in Operations Team of NSS, which also includes engineering tasks such as database design of large scale project initiatives, plan, test and lead implementation of physical database solutions of Network Equipment Center NEC . Ensured solutions meet business objectives and departmental database solutions. Troubleshoot various database related issues on production systems
• Mentored junior and intermediate DBAs in the process of preparing Method of Procedures MOP for enterprise installations and database migrations, installations of Oracle software on Sun, Linux Servers, Database Creations as per VZW standards for homegrown applications.
• Acted as Single point of contact SPOC for Major Applications such as Fusion Works Voice, and Data Systems, Element Manager System EMS -Metro Watch, a product of Tellabs, and Gulf Coast Monitoring Systems. Worked with Engineering Team of Tellabs for the successful installation of Metro Watch FP3.0
• Implemented Performance Monitoring Application for Gulf Coast Switches used by Field Engineers. Completed from the design phase through deployment, which includes installation of Oracle software and upgrade on Sun Servers
• Participated 24 x 7 On-call duty for all mission-critical applications including Fusion Works Data and Voice Systems on HA environment using VERITAS Cluster Server VCS
• Recommended policies and standards for databases. Performed security updates, patch installation and audits to meet established Service Level Agreements SLA . Worked closely with SAN Administrators to get storage allocations, while configuring new servers in Data Centers using Sun 9980 and HP XP1024 models
• Worked with vendors such as Lucent, Nortel and Motorola during release implementations of Prospect/ VALENT Systems.
• Supported NETRAC Application on SYBASE Databases as Secondary DBA
• Implemented RAC on Oracle 10gR2 with dual-node cluster set up on Linux RHEL and 3 node clusters environment using Symantec/VERITAS Storage foundation for Oracle 10g RAC
• Configured Oracle Data Guard between Southlake, TX and Bedminster, NJ Data Centers
• Software in Use: Oracle 10g/9i/8i, Oracle 10g RAC, Data Guard, Oracle AS, SYBASE, MySQL, MS-SQL Server 2000/7, Sun Solaris, HP, Linux, VERITAS Cluster Server, Net backup, BMC Patrol, Erwin Data Modeling tool
• 04/04 - 11/04 INTELLISOFT TECHNOLOGIES, IRVING, TX
• On assignment at VERIZON COMMUNICATIONS, Irving, TX
• 04/04 11/04 Senior Database Consultant
• Verizon Communications is a Telecom industry giant, which provides customers wire line, broadband and other telecommunications services such as FiOS TV.

Role:

• Led a Team size of 6 DB Architects. Administered VLDBs of Registration, Billing and Ordering which are core systems of a Major System eBiz eBusiness
• Implemented Broadband System -Encore Gateway on Development, UAT, and Production environments. Completed database design of Mass Targeted Marketing MASSTM and automated daily data loads from legacy systems using PL/SQL, SQL Loader and Perl scripts
• Written scripts to gather Hot Spots on physical disks which had Oracle 8i databases. Upgraded Production databases from 8i to 9i on Sun E10K Servers. Applied new features of 9i such a way it improves disk caching and reduces the disk I/O
• Developed procedure to automate code migration of SPs and Packages of Database Objects from development to UAT/SIT/PROD environments
• Implemented Database Replication on Active/Passive Cluster Servers using SHAREPLEX for Oracle
• Software Used: Oracle 9i/8i, MS-SQL Server 2000, Sun Solaris 5.8, Shareplex 4.5 for Oracle, ERwin, VERITAS Volume Manager
• 07/03 - 04/04 COGNIZANT TECHNOLOGY SOLUTIONS CORPORATION, NJ

Assistant Manager SYSTEMS

Cognizant Technology Solutions Corporation CMMi Level 5 Company is a provider of custom information technology IT design, development, integration, and maintenance services primarily for Fortune 1000 companies. Cognizant's core competencies include Web-centric applications, data warehousing, component-based development, legacy and client-server systems.

Confidential

Senior Database Consultant

GDW- Global Data Warehouse of HR Information Technology is a single data source that captures Global HR employee details for Reporting Analysis including headcount Snapshots, Attrition and Demographic Data. GDW is primarily sourced from PeopleSoft production database and being refreshed daily in the Data Warehouse. The VLDB in ORACLE RDBMS has 100,000 Employee data of JP Morgan and CHASE. Business Objects was used to create detailed Analytical Reports.

Role:

• Provided high degree of coordination between Development Team and User Groups to ensure effective Database Management. Developed various methods and procedures to migrate tables of query database to Load/UAT/PROD environments. Installed, configured Quest's Shareplex Replication Tool in DEV/UAT Servers.
• Written Shell scripts to improvise Special Delta process, and mapping steps of weekly ETL processes. Prepared Meta scripts to reorganize tables and indexes online using Oracle 8i features. Incorporated INIT parameters to enable Star Schema levels in UAT and SIT environments. Upgraded 32 bit Oracle to 64 bit version Sun Solaris E10K Server
• Created Profiles, and associated Resource Plans for users on UAT and Production databases using Oracle resource manager to limit the number of sessions. Implemented D/R procedures for Development and UAT databases using TRASNPORTABLE Tablespaces. Prepared Meta scripts to recompile all materialized views in query database.
• Developed method of procedures to monitor, and wrote scripts to prioritize AUTOSYS batch jobs such as Payroll, MyRewards and Performance Appraisals in GDW environment.
• Evaluated multiple sites for Disaster Recovery purpose. Implemented various types of methodologies using RMAN. Documented Oracle Standards, Naming Conventions for Users, Tablespaces, Data Files, and Database Objects. Developed codes to fix data corruptions and trouble shoot various database related issues.
• Software Used: Oracle 9i/8i, Sun Solaris 5.8, PeopleSoft HR 8.3, ETL Tool- Informatica Power Center 5.x, Autosys, Business Objects 5.0, Shareplex 4.5 for Oracle, PL/SQL Developer, DBArtisan
• 6/1999 - 6/2003 NOVASOFT INFORMATION TECHNOLOGY CORP., NJ

Senior Database Administrator

Confidential

First Data/ CONCORD, a leading Credit Card processing division provides network services including ATM driving, gateway services, and debit card processing to the financial services industry, plus coast-to-coast network access under the STARsm brand. Provided support of a Major Application provides Credit/Debit/ Check cards authorization, and EBT processing services to the supermarkets, gas stations, restaurants, and other selected retail segments.

Role:

• Administered more than 25 production databases across multiple servers. Provided technical support to the core development team in the development of architectural components. Tuned Production databases on both OLTP and DSS environments
• Prepared trend charts of all physical volumes and mounted points of the Production Server. Based on the collected information, completed re-distribution of data and index tablespaces on different disks, so that it can use all processors efficiently
• Configured database for data mart application. Applied Transportable Tablespaces usage, a new feature of Oracle 8i to speed up daily load of production database into data mart database
• Created HOT STANDBY database to the Data Center over Wilmington, DE. Written various level scripts using PERL to move archived logs to the DR site via VPN
• Conducted Performance Analysis on Production databases of OLTP System. Allocated database resources to achieve optimum database performance. Installed Oracle STATSPACK on 9i/8i databases over Sun E10K Server, and monitored production and UAT databases using OEM 2.2.
• Designed physical and logical models using ERwin Tool. Wrote stored packages, procedures, and triggers to automate jobs on production database
• Created scripts to monitor OS performance and prepare reports such as SAR System Activity Reports, and Memory Usage of databases on Production Server. Scheduled scripts using Unix CRON utility
• Performed capacity planning on production databases, and System/Stress testing on databases
• Performed daily HOT backups on production database using KORN shell. Cloned Production Database on OLTP environment. Replicated production databases using Enterprise Manager with Multi Master Replication set up
• Software Used: Oracle 9i/8i, 9iAS, Sun Solaris 5.8, Windows 2000/XP, OEM 2.2, Quest Software tool- SQL Navigator, SPOTLIGHT, Shareplex 3.x for Oracle, ERwin, and Veritas Cluster
• On assignment at IT Services Department of FRESNO COUNTY, CA
• 3/1998 - 9/2002 Lead DBA / Database Consultant
• ITSD of County of Fresno has state-of-the-art technology to maintain all its databases. The set up has ORACLE RDBMS on IBM RS/6000 Machines, and NT Servers. The Primary application of ITSD is PeopleSoft HR and Financials and other critical applications are SCT-Banner's COURTS, which maintains Civil, Criminal and Justice Systems of the Court House, and SMART-Service Management And Resource Tracking System, a product of EDS Corporation.

Role:

• Led a Team size of 8 Database Administrators and maintained more than 50 databases across multiple servers. Installed, upgraded ORACLE Software on IBM RS/6000 Servers. Created, and Administered databases on both OLTP and DSS environments. Installed Oracle Enterprise Manager on UNIX server and configured multi node set up
• Implemented Database Security and Administration Standards to comply County Standards. Migrated 7.3.4 databases to 8.0.5. Upgraded production databases from 8i to 9i. Configured Oracle Parallel Server OPS on OLTP database in HP-UX environment. Implemented EMC Symmetix/2 TB/SAN technology on S70 Server. Worked closely with System Administrators. Also completed successfully the High Availability Clustered Multi Protocol HACMP on RS/6000 Machines
• Provided historical and real time performance monitoring on 9i/8i databases using Oracle Parallel Query option. Performed System Performance Tuning on all Production Servers. Prepared Trend analysis, and Database Charts for mission critical databases
• Supported EDS IT Team for the successful implementation of Service Management Resource Tracking SMART System, the first client with Oracle databases on IBM RS/6000 machines. Used Star Schema approach in database design of the Data Warehouse. Used Erwin, Data Modeling tool to complete Dimensional Data Modeling
• Coded Packages, Stored Procedures, and Functions to validate daily Data Loads from legacy systems. Written Pro C programs to populate data into database tables from ASCII/flat files. Incorporated Additional Database Standards during the integration of SMART and CDS-Case Data System of Health Services Department of Fresno County
• Used Systems Investigation Reports SIR based on requests from PeopleSoft Administration Group, Change Management Tools for all changes and code drops. Resolved request from end users, tuned SQL Statements from SQR/ Crystal Reports using SQL Trace and TKPROF utilities
• Installed, configured and maintained SQL-BackTrack, Bacukp software of BMC Tools Inc. Benchmarking of Magnum for Oracle a product of COMMVALUT, and GALAXY Backup Software
• Replicated production database using traditional Snapshot logs method. Written scripts to monitor master domain, and daily alert logs using Shell Scripts, and to alert Database Administrators during DB Outage by sending alarms
• Mentored Junior DBA s and Knowledge Transfer by providing on-the-job trainings
• Installed PeopleSoft HR and Financials on IBM RS/6000 machines. Worked closely with PeopleSoft System Administrators for a successful upgrade of PeopleSoft HR from 7.3.4 to 8.0.5
• Software used: Oracle 9i/8i/8/7, Aix 4.x, Sun Solaris 5.6, HP-UX 11, Linux, SQL Server 7/2000, Windows NT/2000, PeopleSoft Financials 7.x and HR 8.x, OEM, Oracle Forms and Reports, ERwin, PERL, CommVault's Magnum for Oracle, BMC Tools' SQL-BackTrack, and SCT-BANNER COURTS
• 08/1997 to 5/1999 ENVITEC CORPORATION, MASSACHUSETTS

Database Administrator

• The National Rural Telecommunications Cooperative NRTC represents the advanced telecommunications and information technology interests of more than 1200 rural utilities and affiliates in 47 states. More than 1.7 Million subscribers of all DIRECTV customers are served by NRTC.
• Role:
• Installed Oracle Software on Sequent/Dynix. Created Development, and Test databases. Created users and required roles along with profiles to secure database from unauthorized access.
• Coded Stored Procedures to perform edits of DIRECT TV subscribers, to prepare status of the connections and information about the opted out /disconnected customers. Prepared various levels of MIS reports using Pro C programming language. Also wrote a main module which process data and sends report to the data centers of DIRECTV based on the qualifiers using RCP feature
• Software Used: Oracle V 8, Sequent/Dynix, Windows NT/98, SQL, PL/SQL and Pro C

Confidential

Manufacturing Execution System MES is the Core System of ABB which maintains the Process Control of the Paper, and Pulp manufacturing industries located cities such as Cleveland, Cincinnati, and Ohio.

Role:

• Ensured data recovery and space requirements for Physical Databases. Conducted capacity planning, workload modeling and prediction, long-term strategic planning on all databases.
• Provided database support for the In-house Development Team. Completed System Performance Tuning on Production database. Wrote scripts to monitor database and OS to gather Hot Spots on the Server. Prepared Database Trends and File System Usage Charts for production system.
• Provided 24 x 7operational support for all production databases
• Software Used: Oracle 7.3.4, HP-UX 10, Windows NT/98, PERL, SQL, PL/SQL and Pro C
• 2/1996 - 7/1997 TUBE PRODUCTS OF INDIA, INDIA
• SYSTEMS EXECUTIVE / DATABASE ADMINISTRATOR
• Tube products of India ISO 9002 certified company was set up in 1955 in collaboration with Tube Products Oldbury Ltd., U.K. to produce Electric Resistance Welded ERW and Cold Drawn Welded CDW Steel Tubes.

Role:

• Lead and Manage database design of PPCS- Production, Planning and Control System for Export Oriented Unit. Installed Oracle Software on HP-9000 machine. Created databases for Development, UAT and Production environments. Wrote Stored Procedures to enable Problem Detection and Avoidance method on Material Management System.
• Conducted Performance Monitoring on Production database and Tuned INIT Parameters for better performance.
• Provided 24 x 7 on-call support for all production databases
• Software Used: Oracle 8/7, AIX, HP-UX 10, Windows NT/98, and Oracle Enterprise Manager
• 6/1992 - 1/1996 ARUNA SUGARS ENTERPRISES LIMITED, INDIA
• DATABASE ADMINISTRATOR / SYSTEMS ANALYST / PROGRAMMER
• ARUNA SUGARS, One of the leading Sugar Manufacturers in India with crushing capacity of 9000TCD, which has VLDB in ORACLE RDBMS on UNIX environment. The SYSTEMS Department also supported the Distilleries division of Aruna Sugars.

Role:

• Administered Development, Test and Production databases on Oracle RDBMS versions 7 and 6.
• Installed Oracle software ver. 6 on WIPRO machines with OS as SCO-UNIX. Created databases and required DB objects. Coded Stored Procedures and Triggers to support In-House development.
• Designed, Developed and Implemented the following applications:
• CAMAS Cane Management and Accounting System PMS- Purchase Management System MMS- Materials Management System IMMS Integrated Maintenance Management System SEMS Stores and Excise Management System
• Used Rapid Application Development RAD approach to design databases
• Developed various MIS level reports using PL/SQL, Pro C and SQL Reportwriter
• Written Unix Shell scripts to automate jobs like diagnostics, gathering system statistics, and daily backups. Performed data loads using SQL Loader
• Provided 24 x 7 DBA support to the production databases
• Evaluated, and recommended software, and hardware purchases
• Software Used: Oracle 7/6, PL/SQL, Pro C, SQL Forms, SQL Reportwriter, Oracle Forms, HP-UX, UNIX SVR3 and Novell Netware