SUMMARY OF QUALIFICATIONS:

• Over TWELVE years of experience as Oracle DBA over HP-UNIX / Solaris / Windows NT environment.
• Over FIVE years of experience as Oracle Developer using PL SQL, Visual basic 6, SQL Forms, Developer 2000.
• Deployed and supported development, Test and Production databases. This includes database design, application development support and database production support. Experience with installation, configuration and maintenance of Oracle 9iAS/10gAS environment.
• Experience in troubleshooting and solving complex problems working with Oracle support and outside consultants. Providing 24X7 on-call support to maintain all Databases up and running in Production environment. Capable of designing and performing database partition.
• Strong in depth Oracle database experience in Oracle DB tuning, SQL tuning, database migration, Backup and Recovery, RMAN, OEM and SQL/PLSQL.
• Successfully migrated Oracle 8i 9i 10G using DBUA, export Import utilities and copied data from an earlier version of Oracle to an Oracle 10G. Expert knowledge of Oracle 9i Database Architecture. Proficient in managing Oracle Instance, database storage structure, schema objects.
• Expert in writing DBA shell/PL SQL scripts for various backup and recovery techniques. Performing Backup/Recovery procedure for Oracle Database including Hot and Cold Backup and Performing Logical Backup Full, User, Table .
• Implementation of OEM tools for Database administration and monitoring. Proficient using Data Guard standby database for High availability of databases. Performance tuning of Oracle 10G/9i/8i database includes optimization of Oracle Init.Ora, Oracle SGA, I/O balancing and memory tuning.
• Experience in OLTP applications development and business process reengineering, application and systems programming full system life-cycle software design /specifications, development and maintenance.
• In depth knowledge in loading of data using Oracle SQL Loader and have done migration from MS-SQL Server/ MS-Access to Oracle using data transformation services. In depth knowledge in Dedicated and Shared Server configurations.
• Configuring standby database and database replication. Strong knowledge of SQL Tuning Application Tuning. Data modelling and business analysis use case scenarios requirements and functional spec object oriented design.
• As a Data Architect: Performed Disk layouts, capacity planning, sizing of Database objects and created Physical Database. Very good exposure in implementation of ERP Software Oracle APPS. Oracle applications 10.x with GL, AP, Fixed Asset, Inventory, Purchase modules.
• Executed total project from evaluating of various ERP software till implementing these Modules.
• Giving approval about AS-IS, TO-BE, Functional specifications, Test plans, GAP analysis. Selection of hardware and designing of network. Sound knowledge of software development life cycle, system development, design and coding.
• Oracle Certified Professional 9i DBA .
• Oracle Certified - Oracle 10G: New Features for administrator.

TECHNICAL SKILLS:

• Operating Systems: Win NT 4.0, Win 9x, Solaris 8/9, HP-UNIX/SCO UNIX.
• Databases: Oracle 10G, Oracle 9i/8i/7.3, MS SQL Server2000/7, MySQL.
• Tools: Oracle's OEM, Dataguard, Oracle Developer 2000, TOAD, MS-Access, SQL Loader. Tuning pack like Oracle expert, SQL analyze, DB Artisan.
• Languages: SQL, PL/SQL, C, UNIX Shell Programming, C , Java, Pro C, COBOL, PASCAL.
• GUI: VB 6.0, Forms 4.5, Crystal reports.
• Web Programs: HTML, DHTML, JavaScript, VB Script, ASP.

CONFIDENTAIL

Sr. Oracle DBA

CONFIDENTAIL is the investment banking business of JPMorgan Chase, a leading global financial services firm with assets of 713 billion and 100, 000 employees in over 50 countries. It also provides the integrated financial solutions for institutions and individuals worldwide. Risk Tech group supports many applications like Anchor, Globalnet, COAST, PFC etc. There are more than 20 Oracle database instances with Oracle replication clusters technology in development, UAT and production environments to support these activities. The total database size is about 10 TB. The DBA's team is a geographically distributed team spanning New York, Houston and Bangalore, to ensure that all applications function as efficiently. The enterprise database environment is having Oracle grid technology with RAC clusters.

Responsibilities:

• 24X7 production environment including installation, configuration, maintenance and performance tuning of Oracle instances on Oracle 10G. Installed, configured and tuned clustered high Availability database using Real Application Clusters RAC and Advanced Replication.
• Planned and implemented multiple RAC non-RAC instances. Implemented a five node 10g RAC cluster on Solaris platform with SAN storage. RAC setup, tuning and advanced administration.
• Disaster Recovery - Data Guard and RMAN, RAC Backup and recovery and two-pass recovery in RAC.
• Manage Data Guard configuration with Enterprise Manager Grid Control. Use Data Guard with Real Application Clusters. Set up cascaded standby configuration with > Primary --> Physical Standby --> Logical Standby.
• Database administration and troubleshooting and working with the Oracle support team. Providing 24X7 on-call support to maintain all Databases up and running in Production environment. Provide on call coverage to support production database problem determination/resolution.
• Resolutions of problems received through pager alerts/e-mails. Proactive database monitoring. Provide for efficient, reliable backup and recovery of all databases.
• Install, upgrade and maintain database backup and recovery software. This includes developing backup/recovery plans and enforcing retention policies, creating jobs, scheduling and monitoring.
• Developing and managing Oracle stored procedures, packages and triggers. Oracle RMAN/Backup Recovery using OEM tool. Used RMAN command line mode and the backup manager from within the storage manager tool.
• Created recovery catalog and registered the catalog performing a backup with OEM. Administer Users database security. Developed UNIX scripts for controlling various database operations.
• Installed and Upgraded Oracle 9i to Oracle 10.2.0.3 g for development, UAT and production servers.
• Database refresh from production to DEV/UAT environments. Designed and implemented performance enhancements like Materialized Views, partitions and sub-partitions, dimensions, parallel loads and reads, etc. Capacity planning distribution across tablespaces/drives sizing extents, partitioning, memory, growth, usage for all environments.
• Tuned SQL and SGA performance. Implemented DB parameters to improve database performance and application tuning. Supporting database components e.g. stored procedures, views, etc. working with the development team to optimize application where possible proactively.
• Helping QA and AD group with issues that arise during the testing. Database recovery and restore.
• Database objects release in Production environment. Migrated Sybase application into Oracle 10g platform.

Environment: Solaris 10.x, Oracle 9i/10g RAC environment, Enterprise Manager, RMAN, Sybase, DB Artisan 8.5, TOAD 9.2, PL/SQL and UNIX scripting. Autosys Jobs scheduler, SQL PLUS, Server control SRVCTL , ClusterVerificationUtility CVU , DBCA.

CONFIDENTAIL

Sr Oracle DBA

The Hartford Speciality has two production databases National accounts database NADB and web portal applications database venture. Five major applications Presale SNAPI and SNAQS, Postsale, TPA and venture access the NADB Production database. The NADB follows 3 tier architecture and the size of the NADB database is approximately 2.5 TB and it grows 200GB every year. The venture database follows n-tier architecture and the size of the database is approximately 600GB. The online users are around 1000. Apart from the production database, a development and test database are also installed for both databases.Oracle10g iAS installed on 2 development and 4 production servers running on True-64/Solaris o/s. as possible.

Responsibilities:

• Providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Responsible for support of job processing, scheduling, real-time management, troubleshooting, storage configuration. Resolutions of problems received through pager alerts/e-mails.
• Designed and implemented database monitoring alerts messages on pager. Automated space management for non-database tasks like non-Oracle files compress and move, non-Oracle purges etc.
• Database and application developers troubleshooting. Application and SQL query tuning. Improved standards and guidelines for database changes and application development. Designed new release management guidelines. Proactive /active database check up. Database performance and SQL tuning.
• Troubleshooting and solving complex problems working with Oracle support. Created TAR for Oracle: 7445 and other errors. Month end activities and database capacity planning and space management.
• Password security Oracle and UNIX. Assigning Box id and batch id and batch job no. Server Disks management and Database physical layout maintenance. Release management procedures for Development, Customer test and Production environment for database and non-database objects.
• Database backup schedule for legato backup. Database recovery and restore. Codes Version management through Intersolv PVCS. Writing shell scripts for hot backup for all servers and PL/SQL for code extractions from DBA Source and DBA Views for PVCS version management.
• Database maintenance, upgrades and patch releases. Supporting Data guard broker environment.

Environment: Compaq true64 UNIX v5.1B, Solaris 2.8/9, Oracle 10g/9I enterprise edition 9.2.0.4, Oracle 10g iAS, COMPAQ/ALPHA servers having 10cpu/12GB and SUN FIRE V880servers, Windows servers, Oracle tools: Oracle Enterprise Manager, SQL Navigator, PL/SQL, Export, Import, UNIX shell scripts and Perl.

CONFIDENTAIL

Sr Oracle DBA

At Tyco looking after every Oracle Database in all aspects starting with Design and Development based on business requirements to management of the same in each environment. Company is involved in undersea fiber optics lay down with Capacity sell STM1 through STM64 bandwidth across the world to provide 99.999 uptime to any corporate in the whole world. Responsible for complete Development, administration and management of suit of Production Databases having HA clusters. The suit includes tens of production Databases including Clarify as CRM package, Objectel as Inventory control System, OMS as Order Management System, Performance PM , Fault/Alarms monitoring suites and many other suits, Vitria Business ware is being used as middleware. As a Development DBA, possess extensive technical knowledge base of Telecom Industry business.

Responsibilities:

• Providing 24X7 support to maintain all Databases up and running in Production environment. Design and develop Database and database objects like Table, Index, View, Stored Procedure etc. for customization/new application.
• Monitored command center database for managing multiple databases. Support in Testing business requirement developed in house and from outside. Also, to maintain the OSS Suit in Test environment.
• Migration of COBOL system to Oracle RDBMS System. Installation and configuring Oracle 8/8I and 9i on Sun and HP boxes. Analysis and Design of Oracle DB with its total Storage and fault tolerance.
• Creation and migration of DB and other related Objects including schema objects in it. Optimizing size of SGA and defining other Initialization params based on variety of facts. Setting up JDBC connectivity for Java code to talk to DB from Application server.
• Sizing all the objects of DB including Schema objects. Defining the strategies for Backup and Recovery at physical level including Export and Import utility usage.
• Used the Data Guard Manager to create Data Guard physical standby configurations, failover to a standby after a disaster, switchover between standby databases and monitor the performance of a Data Guard configuration.
• Oracle RMAN/Backup Recovery using OEM tool. Used RMAN command line mode and the backup manager from within the storage manager tool. Created recovery catalog and registered the catalog performing a backup with OEM. Tuning the SQL for faster execution better performance.
• Upgraded 8i 9i databases using DBUA, export Import utilities and copied data from an earlier version of Oracle to Oracle 9i. Developed UNIX shell script, SQL for automating database refresh, backup monitoring.

Environment: Oracle 9.2/8.x, HP-UNIX, Solaris 2.9, HP-k class servers, Sun Sparc R6000.

CONFIDENTAIL

Sr. Oracle DBA

Responsibilities:

• Accountable for Database Administration in 9i/8i, System administration Windows NT/ Windows 2000. Installation and configuring Oracle 8/8i/9i/10g on HP 9000 k-class servers/ Windows NT/ Windows 2000 servers.
• Upgraded 8i 9i 10g databases using DBUA, export Import utilities and copied data from an earlier version of Oracle to Oracle 9i. Installed/Configured Oracle 8i/9i on Windows NT/2000 and created customized database.
• Managing Oracle Instance, database storage structure, schema objects. Implemented new features of Oracle 9i like Log Miner, Transportable Tablespaces, Locally Managed Tablespaces, Hot Standby Databases for fail-over situations, Multiple Archive-Log Destinations that support Hot Standby Databases etc.
• Performance tuning of Oracle 9i/8i database includes optimization of Oracle init.ora, Oracle SGA, I/O balancing and memory tuning. Recovery/Restore using RMAN and recovered data file from MIS tablespace using RMAN.
• Used Oracle Expert to collect data and provide analyses that will help optimize the performance of the database environments. Configuration of Oracle Enterprise Manager and client machine for Oracle.
• Creation of several packages, Stored Procedures, database triggers and functions. Monitoring the Database Space, Memory using Oracle Enterprise Manager and maintenance of archive redo log files. Used external table for displaying jewellery design specifications for more than 25000 designs.
• Implemented TCP/IP based network on Oracle Database Server with NET9 option. Configured Multi-Threaded Server MTS architecture, dedicated/shared servers for optimum usage of system resources.
• Designed developed database structures Tables, Indexes, Views, Triggers to implement Business Rules, Procedures etc .
• Used SQL Analyze to identify poorly performing SQL statements, automatically detect statements that can be rewritten for better performance, evaluate index requirements and otherwise investigate SQL statement performance bottlenecks.
• Did tuning in Database/Tablespace level by Splitting Table Data and Index in different tablespaces that belong to different DataFiles and different disks to avoid resource contention in disk I/O.
• De-fragmentation of the Table spaces and tables also was involved in partitioning of tables and creating indexes for them.
• Converted very slow and complicated views to tables and implemented database triggers to update them automatically. Implemented end of day backup routines, which include database exports, tape backup and copying database files to the development server for precautionary measures.
• Implemented hot standby database for fail over situations. Performing Backup/Recovery procedure for Oracle Database including Hot and Cold Backup and Performing Logical Backup Full, User, Table . Creating Stored Procedure, Triggers and Packages using PL/SQL.
• Administer Users security, Monitoring Performance tuning the databases. Customized the SGA two Init.Ora files for different types of requirements during the days nights. Installation and configuration of new servers.
• Responsible for support, maintenance and administration of development and production databases.
• Creation of Development database, Sizing the SGA and Creation of Tablespace. Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users.
• Setting storage and usage parameters for database objects and in conjunction with programmer, define new object or modification to existing objects.

Environment: Oracle 10g, Oracle 9i/8.x, MS-SQL Server, MS Access, HP 9000 k-class servers, Windows-NT/2000 servers.

CONFIDENTAIL

Sr. Oracle DBA

Responsibilities:

• Installed Oracle 8 on HP-UX k-class servers. Created Development, Test Production Database. Data Architect: Performed Disk layouts, RAID Configurations, capacity planning, sizing of Database objects and created Physical Database.
• Development: Written Pl/SQL Packages, Procedures, Functions to implement Business Rules and Triggers for Audit. Developed SQL Loader Scripts for loading data from legacy system to Oracle DB.
• Guiding Developers in tuning SQL, suggesting the proper method of coding and explaining the Database design. Mentoring Junior DBA/Developers. Creating primary database objects tables, views, indexes .
• Modifying the database structure, as necessary, from information given by application developers.
• Enrolling users and maintaining system security. Allocating system storage and planning future storage requirements for the database.
• Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information. Maintaining archived data on appropriate storage devices. Backing and restoring the database. Controlling and monitoring user access to the database.
• Migration of billing system from COBOL to Oracle RDBMS System. Supporting role in implementing Oracle APPS - AR Module. System administration and installation of a database server under HP-UX 11.x K-class and Compaq - Proliant 5500 as an application server under Windows NT.

Environment: Oracle 8.x/7.3, HP-UNIX, HP-k class servers.

CONFIDENTAIL

Sr. Oracle DBA

The company is engaged in the generation and distribution of POWER in its licensee area of Surat City serving more than 400, 000 consumers and having turnover more than RS. 600 crores.

Responsibilities:

• IT Manager, Senior project leader/ project manager, database administrator, solutions architect, Senior business analyst, systems analyst. Head of the IT Department and Supervised a S/W development team of about 25, 6 Network Engineers and total staff of 65 in the section.
• Installation and configuration of Oracle 7.3. Administration and performance tuning of the databases.
• Data extraction, migration from Flat files to Oracle. SQL tuning using Explain Plan. Progressively worked on database triggers to enhance the performance of Database security, efficiency and to impose complex business rules. Wrote Stored Procedures, Database Triggers using PL/SQL.
• Developed Billing calculation program using Pro C. Administered Multiple LAN sites having more than 150 workstations and single LAN site over 100 workstations.
• Redesigned office procedures and methods of communication, employing superior organizational skills conforming to the Corporate objectives and contributed in reducing commercial loss, improved manpower productivity, better control of business processes.
• Implemented innovative ideas improved process, through efficiency and controls and outflanked many traditional concepts and created inclination towards computer culture among users.
• IT scenario reshaped totally by switching to Client Server Architecture. Motivated comprehensively trained team on adoption of new technology, new environment and concepts of IT and to keep up to date on technology advancement.
• The data center processing more than 700000 consumers bills per month and about 275000 students result processing in multiple disciplines per annum.
• On-line improved Consumer Enquiry system thereby deriving high level of consumer satisfaction. Set up the department organization Plans and strategies in accordance with Corporate Priorities.
• Designed, implemented and maintained LAN site having more than 125 work stations and 4 database/ application servers and established intranet between various offices in the city. Improved Technical standard and strengthen up Enterprise Network.
• Introduced ERP solution: Oracle applications 10.x with five modules GL, AP, Fixed Asset, Inventory, Purchase.
• Executed total project from evaluating of various ERP software, Negotiating with vendor, Finalization of order, project manager for implementing these Modules, Giving approval to Price Water House Consultants about AS-IS, TO-BE, Functional specifications, Test plans, GAP analysis Customization etc., selection of hardware and designing of network.
• Integrated billing solution developed for energy billing system having more than 4 lakhs customers and helped to provide promptly various consumer services.
• MIS reports, transmission loss reporting system designed and integrated energy meter accounting introduced to assure about 100 energy meters are billed correctly. Installed, configured and managed in-house Novell Netware, UNIX o/s, Oracle RDBMS, Developer 2000, FoxPro 2.6.
• Successfully migrated from legacy COBOL system to Oracle RDBMS Billing system overcoming deficiencies in all respects and established better-automated controls. Generation of Reports about salary, loans, advances.

Environment: Oracle 8.x, Oracle 7.3, HP-UNIX E/K class servers.

CONFIDENTAIL