SUMMARY OF QUALIFICATIONS

• Sixteen years of IT experience in various industries that support Service, Production Information Technology.
• Ten years of experience as Oracle DBA Including work of Database Management, Backup Recovery, Performance Tuning, Configuration of Database, Tablespace administration, User management, Index management and managing data dictionary objects.
• Extensive experience in installations of Oracle Software, Configuration for database and day to day routine works for database administration, System User administration, Index organization, Cluster creation. V Views checking for daily performance Tuning of database.
• Experience with Installation of SQL Server 2k or 2k5 or 2k8 in cluster and non-cluster environment as per company policy and maintaining documents for configuration.
• Hands-on experience in RDBMS Oracle 8, 9, 10g, 11g, MS Access, MS SQL Server 6.5/7.0/2000, 2005, 2008 .
• Experience with Oracle Enterprise Manager OEM for configuration and monitoring multiple instances.
• Experience in Data Migration from SQL Server 2005 to Oracle10g, SQL Server2005 to SQL Server2008.
• Experience in writing Shell Script in VI Editor, Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Fine-Tuned and optimized SQL queries and performed code debugging using TOAD, SQL Profiler.
• Worked on Database size up to 4TB.

Technical Skills

Database: Oracle versions 7.3, 8.0, 8i, 9i, 10g, 11g , SQL Server 2k, 2k5, 2k8, Microsoft Access,

Software: Developer 2000 2.1 Oracle Forms 3.0, 4.5, 5.0, Reports 1.1, 2.5, 3.0 , Pro C 1.5, 2.2, Visual Basic 5.0.

SAP: SAP R/3 Basis Administration in V 3.x, 4.x, NW, BW.

Languages: C, C , SQL, PL/SQL, Basic, and COBOL.

Networks: TCP/IP, MS Windows NT, MS Cluster.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Work on Production support for Oracle and SQL Server environment on cluster RAC and non-cluster environment.
• Database backup Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Worked on Flashback Database for restore to point in time with SCN and restore point.
• Work with Oracle Enterprise Manager 12c for monitoring production and non production system in addition to Exadata environment.
• Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keep all databases up to date at current patch level.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working on Creating Commands script for daily monitoring and maintaining production and non-production environment.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working on 24/7 database support environment.

Environment: Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installation of Oracle 11g and SQL Server 2008 software with cluster RAC and non-cluster environment. Configuration of Database, User Creation, Role Profile Assignment.
• Database backup Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Work on Disaster Recovery Project high availability and successfully configured and tested in Oracle production database.
• Work with DB Artisan Toad for monitoring and managing in Oracle and SQL servers.
• Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keep all databases up to date at current patch level.
• Create script for resolution gap between replication and successfully tested in production and non-production replication environment.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working on Creating Commands script for daily monitoring and maintaining production and non-production environment.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working on 24/7 database support environment.

Environment: Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Confidential

Sr. Oracle / SQL Server DBA

Responsibilities:

• Installation of Oracle 11.2 on Standalone and Cluster environment with DMA Database Middleware Automation . Create workflow for User Creation, Role Profile Assignment for database users in DMA in Linux and AIX environment.
• Successfully implemented workflow for Database backup Recovery on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Create Patching workflow for DMA to apply on standalone and cluster environment.
• Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keeping all databases with up to date patch level.
• Install DMA services on servers and configure with DMA environment for creating new workflow and installed HP workflows for Database automation.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working with 11g XML Database configuration, storage model, DB repository and creating XML Indexes for better performance.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job.

Environment: Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Confidential

Sr. Oracle SQL DBA

Responsibilities:

• Installation of Oracle and SQL Server software with cluster RAC and non-cluster environment. Configuration of Database, User Creation, Role Profile Assignment in SAP and Non-SAP environment.
• Database backup Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Work on Disaster Recovery Project high availability and successfully configured Oracle and SQL production database.
• Configure and manage Data warehouse system on Baan Application environment.
• Perform Daily check for all SAP System with Global SOLMAN and working with BRTOOLs for database maintenance. Daily checks Using Tcodes ST04, DB02, DB13, DB12, SM20, SM21, SM35, BD87, SM37, ST22 etc. And perform Oracle and SQL database according to company policy.
• DBA support on 24X7 environment, Supporting Central Administration Service Desk for Database related issue and work on Ticket to resolve the identified issues.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.
• Working with Database Refresh, Migration from Oracle 7 to 9i and Datacenter Move from one location to another.
• Domain migration for Database servers.
• Hands on work experience with 11g new features like High availability, RMAN archive log management for streams and data guard, optimize undo backup, Data Pump to use for compression and encryption of backup, transportable partitions, Manageability with memory target parameter for auto memory management, auto SQL turning, and more.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job.

Environment: Oracle 9i, 10g, 11g, SQL Server 2k, 2k5, 2k8, SAP NW, SAP R/3, BI, XI, Vertex, Oracle E-Business Apps, Oracle Golden Gate, Linux, IBM Unix, SUSE, HP-Unix, Windows Server 2003.

Confidential

Sr. Oracle / SQL Server DBA

Responsibilities:

• Installation of Oracle software. User Creation under client as per specific Role Assignment, Profile Assignment.
• Database backup Recovery with Data Pump Utilities dpexp and dpimp for offline non archive database and online backup and Recovery for Archive database with RMAN.
• Work with Oracle Enterprise Manager for managing Database. Administration of Database, Adding Tablespace, Datafile, Rollback Segment, Redo Log, Startup Shutdown of your database instance, Managing Sessions, Releasing Locks, Backup and Recovery through backup management and much more.
• Database administration on basis 24X7, Ticketing for problem resolution.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization.
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases at the same version and patch level.
• Working with SQL Server Management Studio for SQL Server 2005 and made some maintenance plan for Backup, Rebuilding Index and Reorganizing Index. Check the SQL Server Logs for error and backup status.
• Database monitoring and maintaining in TOAD Software.
• Working with PUTTY, PSFTP for transferring backup file from remote location to local.

Environment: Oracle 8i, 10g, 11g, SQL Server 2k5, Sun Unix, Windows Server 2003

Confidential

Oracle DBA

Responsibilities:

• Data Migration from SQL Server2005 to Oracle10g.
• SQL Job scheduling in TOAD 8.6.1 for migration.
• Performance Tuning, Index management, Database configuration for database on the day-to-day basis analyses or weekly or monthly.
• Fine-Tuned and optimized SQL queries and performed code debugging using TOAD.
• Database backup Recovery with Data Pump Utilities dpexp and dpimp for offline non archive database and online backup and Recovery for Archive database with RMAN.
• Working with Oracle Enterprise Manager OEM for database administration.
• Remote work for database administration on basis 24X7, Ticketing for problem resolution.
• User administration, Profile Creation, Role Assignment.
• Database tuning, using STATSPACK, Oracle trace, Partitioning, re-indexing.
• Maintain the contractual agreement with Oracle Corporation, which covers licensing and support.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes
• Created Shell scripts to access and set-up runtime environment, and to run Oracle Stored Procedures, Packages
• Working with PuTTY, PSFTP for transferring backup file from remote location to local.

Environment: Oracle 9i, 10g, SQL Server 2k5, Windows Server 2003, UNIX Solaris .

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle software 10g and configure Physical Standby Database for Disaster Recovery. Like User Creation under client as per specific Role Assignment, Profile Assignment.
• Work on Installation and configuration for 10G RAC for Production system. Administration of RAC environment for production and non- production servers.
• Performance Tuning, Index management, Database configuration for database on the day-to-day basis analyses or weekly or monthly. Some times tuning is necessary for long process with assignment of big rollback segment.
• Performing Daily checks with TCodes and managing database with BRTOOLS.
• Database backup Recovery with Data Pump Utilities dpexp and dpimp for offline non archive database and online backup and Recovery for Archive database with RMAN.
• Scheduling Database Backup for performing daily database Backups and Restores. Handled, Configured and Maintenance of Batch Scheduler for database daily backup or weekly backup or monthly backup.
• Troubleshooting system problems by analyzing system log update monitoring and lock entries and configured Alert Monitor for System monitoring.
• Used ERWIN Tool for data modeling to implementation of new SAP Database environment.
• Performance Tuning of Database with SQL Tuning, Instance Tuning using Statspack.

Environment: Oracle 9i, 10g, SAP NW with BI and ECC 6.0, OLTP, SUSE, IBM UNIX, Windows 2003

Confidential

Oracle DBA

Responsibilities:

• Lead 4 Developer Programmer and 1 Database Admin person.
• Installation of Oracle software in 9i 10g. User Creation under client as per specific Role Assignment, Profile Assignment.
• Performed Transport between Development server to QAS and QAS server to Production server using Transport Manager including Transport domain Controller, Transport route, RFC Connection Test, Transport directory check, Transport control check.
• Involved in Backup/Restore and Archiving, recovery batch jobs on day-to-day basis. Month end job monitoring and checklist preparation and co-ordination.
• Work with Oracle Enterprise Manager for managing Database. Administration of Database, Adding Tablespace, Datafile, Rollback Segment, Redo Log, Startup Shutdown of your database instance, Managing Sessions, Releasing Locks, Backup and Recovery through backup management, Creating Users, Roles and much more.
• Work with RAC Real Application Cluster .

Environment: SAP 4.7B, Oracle 9i and Windows 2003 Server.

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle software in new server and upgradation for existence server.
• Perform Daily Monitoring of Oracle Instances using Oracle Enterprise Manager, monitor users and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Database Creation for UNIX Server Parameter Assignment in init file or session level assignment, database startup and shutdown process. Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas.
• Database backup Recovery with export and import for non-archive and archive database with RMAN commands.
• Archive weekly all production database exports to CD in encrypted form , stored both onsite and offsite.
• Administer all databases in the areas of: maintenance, tuning, performance and troubleshooting.
• Research and apply Oracle-supplied patches to the databases of each OS. Keep all databases at the same version and patch level. Create and improve database administrative programs, which are both written in Perl and/or UNIX bash shell. Database tuning, using STATSPACK, Oracle trace, Partitioning, re-indexing.
• Maintain the contractual agreement with Oracle Corporation, which covers licensing and support.
• Fine-Tuned and optimised SQL queries and performed code debugging using TOAD.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization. Undo tablespace management for rollback segment Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Month end job monitoring and checklist preparation and co-ordination.

Environment: Oracle 9i, SQL Server 2000 and SCO UNIX Server, SAP 4.7B, Windows 2000 Server

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle software in new server and upgradation for existence server.
• Perform Daily Monitoring of Oracle Instances using Oracle Enterprise Manager, monitor users and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Database Creation for UNIX Server Parameter Assignment in init file or session level assignment, database startup and shutdown process. Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas.
• Database backup Recovery with export and import for non-archive and archive database with RMAN commands.
• Archive weekly all production database exports to CD in encrypted form , stored both onsite and offsite.
• Administer all databases in the areas of: maintenance, tuning, performance and troubleshooting.
• Maintain the contractual agreement with Oracle Corporation, which covers licensing and support.
• Fine-Tuned and optimised SQL queries and performed code debugging using TOAD.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization. Undo tablespace management for rollback segment Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Month end job monitoring and checklist preparation and co-ordination.

Environment: Oracle 9i, SQL Server 2000 and SCO UNIX Server, SAP 4.7B, Windows 2000 Server

Confidential

Database Administrator/EDP

Responsibilities:

• Database Administration with System or Sys users. User Administration like Creating new Users and Responsibilities as per requirement. Backup/Recovery using RMAN Backing up of database physical/logical and automation of backup.
• Also export/Import is using for offline backup. i.e. user level, table level. Efficient in using the Oracle Tools like Server Manager, OEM, SQL Plus, SQL Loader, SQL Net, Import/Export, Performance Manager and RMAN.
• Using SQL Loader and interface tools for loading data flat file from external Legacy Systems into the Oracle Database.
• Performance tuning and monitoring the database using diagnostic tools Like OEM performance pack including Oracle Expert, Lock Manager, Performance Manager, Top Session, Oracle Trace, Table space Manager and V Views.
• Performed general troubleshooting and tuning input/output to reduce the disk contention and enhance the database performance.
• Extensively involved in Performance Tuning Memory structures and application tuning Database for better Memory, Background Process, I/O, Operating system performance and Application Tuning.
• Reverse engineering of the complete application using ERWin.
• Efficient in Optimization, Disk Space management, performance analysis, capacity planning, sizing, analyzing performance statistics and Data modeling.
• Writing Stored Procedures/Functions/Database Triggers/SQL and PL/SQL/UNIX.
• Created Shell scripts to access and set-up runtime environment, and to run Oracle Stored Procedures, Packages
• Installed NLS language to the instance using the Translation Synchronization Patches feature.

Environment: PCL Server, UNIX OS, Compaq Alpha Server, Oracle 8.0, 8.1.7, Pro C.

Confidential

Responsibilities:

• Configured Mail server for 50 clients.
• Installed and customized mail clients Outlook Express and Postmaster on the users desktop.
• Software installation and hardware maintenance as well as Networking architecture for the client.
• Website development and hosting at ISP provider site.

Environment: Windows NT Server, Postmaster Software, Outlook express.

Confidential

Oracle DBA

Responsibilities:

• Creation and maintenance of database entities included managing Tablespace, managing data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Assigned Authorization and profile using profile generator, Profile creation, Profile Generation, Profile assignment Maintained profile parameters.
• Define operation modes and distributed workload among available application servers.
• Worked to set size of System Global Area SGA . Shared pool constituents like cache, checkpoints, storage parameters of application objects like indexes, tables and clusters.
• Operating System Monitoring and set the operating system parameter for tuning the system.
• Performed user and security administration activities, such as enrolling users, granting privileges to users and maintaining system security.
• Performing Daily checks on SAP systems with TCodes and managing Database with SAP DBA tools.
• Using OEM tool for increasing table space. Performing online backups. Tables space Administration. Monitoring the objects and extents through.
• Created table spaces using raw devices. Configured the Standby database Data Guard in manual and auto recovery mode.
• Daily administrative tasks include monitoring system logs, Work processes, locks and updates.
• Created and managed database storage structures, which include table spaces and Rollback Segments.
• Used Export/Import to perform the migration of data in database. Modified and altered the database storage parameters as needed. Manage internal/external resources and project time schedules.
• Routinely participating in project meetings accustomed to working with management, co-workers and branch offices, updating management and on the status of enhancements, releases.

Environment: SAP 4.0B, Oracle 8.1.7 9i and Windows NT, IBM AIX Version 5.1.

Confidential

Executive Information Technologist

Responsibilities:

• Led ten persons team for developing the Transportation System.
• Engaged in functional responsibilities of Business Application Development Cargo Services FAS, Payroll, Planning and Tracking at a leading ISO 9001 Service Industries. Performed Database Administration, User Administration, Backup/Recovery, Database performance Tuning.
• User Administration includes user creation, user authorization, user copy, and user deletion.
• Maintaining Index organized data in database with table lever index, Partitioning Index creation.
• Master data maintenance for system and always check the availability of master data for daily user transaction. Also maintaining triggers for all system modules like page-up, page-down, post, after, key-up, key-down etc. Testing the system changes before giving to end-user.
• Utilized the TCP/IP, UDP platforms and for inter-domain talk among the various client and server configurations.

Environment: Novell 4.x, Windows NT and Sun Solaris UNIX, Oracle 7.3, 8.0.

Confidential

Junior Systems Programmer

Responsibilities:

• Worked as Systems Programmer having functional responsibilities of Business Application Development in CUI/GUI Application. Server centric as well as Client centric Software Development.
• Office Automation Product Maintenance. Engaged in Installation, testing and maintaining of Software System. Release management procedures for Development, Customer test and Production environment for database and non-database objects.
• Hands on in Implementing complete Backup and recovery on Hot/Cold Back, Logical Import/Export Utility .

Environment: Windows NT on IBM Server.