SUMMARY:

• 15 Years of IT experience with very strong relational database administration skills across all RDBMS including Oracle, MSSQL, IBM DB2 and Open source, NoSQL DBs. Authored infra monitoring scripts, process streamlined and automated many DBA tasks for error free, efficient and increased agility in operation maintenance support.
• Pioneered DB design, architected and implemented for various domain customers to meet their business RTO/RPO requirements.
• Having good experience in team management and project management on IT Infra projects. Strong knowledge in Datacenter migration, Database migration, Disaster recovery(DR - BCP) site preparation, Datacenter operation, Risk analysis, Risk mitigation and establishing & maintaining customer relationship.
• Diversified experience on all RDBMS and Open sources databases ORACLE, MS SQL SERVER, NOSQL-MongoDB, IBM DB2 UDB and MYSQL
• Worked for DB build projects (migrated ~1000 DBs from 9i, 10g to 11g & 12c)
• Migrating an existing on-premises application to AWS and Private cloud (Implementing and controlling the data flow to and from AWS, appropriate AWS service based on compute, data, or security requirements)
• Implementing appropriate best practices in AWS environment for database availability, stability and monitoring reports.
• Architected large scale SAP implementation projects on MSSQL 2008 with HA setup for more than 100 clusters.
• Driving RTO, RPO for application databases to meet critical business needs
• Have dictated best practices approaches to execute change, incident, and problem and brought better service improvements.
• Build DR setup across cities and did DR drill for mission critical applications.
• Well-versed in managing Oracle vendors for getting best support, training and quick fixes for DB issues.
• Implemented best practices for managing BMC, OEM grid agents and fixing monitoring issues
• Driven the database engagement to Top Quartile performance in the previous engagement
• Having good hands on experience in Oracle F lashback, A utomatic W orkload R epository, Grid OEM, RAC, ASM, DG broker, DR Standby build & Exadata administration.
• Installation, Configuration and upgradation of Oracle 9i, 10G, 11G R2 and 12c on different operating systems for OLTP & Data Warehouse environments for Very Large Databases (VLDB).
• Database platform migration from Unix to Linux and Cloud platforms.
• Excellent knowledge in implementing various High Availability systems like Real Application Clusters (RAC), Data Guard and Relational Wizards.
• Performed numerous Oracle Database and Tools migration from RDBMS version 7.x through 12G using oracle migration workbench and manual tools.
• Have performed enterprise wide backup strategic planning and implementation through RMAN, Shell scripts, VERITAS NetBackup, Netapps SNAP backup and Data domain de-duplicate tools.
• Tuning with Oracle Enterprise Manager TOAD, Foglight, QUEST central for oracle, Spotlight for oracle.
• Extensive experience in implementing automated jobs using Tivoli Work load scheduler, Korn shell scripts and crontab.
• Performed Installation and configuration of various operating systems like HP UNIX 11i, IBM-AIX UNIX 4.1 / 5 L, Red Hat Linux 2.1 AS/ES, Sun Solaris 8.0, Asianux 1.0, Windows NT & 2000.
• Good experience in handling Enterprise System Management tools like Remedy, Marimba, BMC patrol and IBM Tivoli database maintenance and fine tuning.
• Good in Architecting and solution designing for different dashboard portal developments for db operational monitoring.
• Experience in various monitoring and automation technologies to provide real time alerts and problem reporting.
• SLA preparation and Database Documentation. Disaster Recovery plan preparation, DRP site setup.
• 24x7 - Tier 2 Technical support for Production databases including remote database administration and monitoring, available on call for critical production issues.
• Expertise in various phases of software development life cycle (SDLC)
• Handled lots of No win situations like Recovery of database in noarchive mode, Recovery of Rollback segment corruption
• Experience in MSSQL 7 / 2000 / 2005/2008 Database administration, Clustering, DR site planning and implementation.
• Troubleshooting systems for operating system/software interactions.
• Basic support of database software; drafting reports and proposals of Data Center Management.
• Conducting diagnosing and performance tuning systems on an ongoing basis, maintaining, and implementing OS upgrades and security patches for a server.
• Implementing monitoring tools to maintain constant reports on the health of servers evaluates and/or recommends purchases.
• Installing Windows NT /2000 servers and Workstations.
• Installation of UNIX, Linux, Asianux Sun Solaris servers.
• Writing shell scripts and scheduling automated jobs for database backup and statistics gathering.
• Allocation of storage areas through Volume Manager, creating raw devices, mount points and attaching them to nodes.

TECHNICAL SKILLS:

Operating Systems: IBM-AIX-Unix 4.1/5L, RH Linux AS 2.1, Sco-Unix 5, HP Unix 11i, Sun solris, Win NT/2000.

Hardware: IBM RS-6000, IBM Netfinity 5000, IBM PSeries, Sun Sparc, EMC SAN, Dell Power edge, HP DAS

Backup & File Management: Tivoli Storage Manager, Fast-T, Veritas Storage for RAC, DD Data domain, Netapp Snapshot, shell scripts to take export backups, online/offshore file system backups.

Database: Oracle 11G/10G/9i/8i/8.0/7.x, DB2 7.x, 8.x and SQL Server 7 - 2008.

Database Tools: DBArtisan, Toad, Data pump, SQL*Loader, OEM, RMAN, Foglight, QUEST central, Spotlight, Dgmgr, crsctl, svrmgr, emctl etc

Development Tools: Visual Basic 6.0, Visual Inter Dev6.0

Case Tools: Designer/2000/6i/9i, Erwin 4.x.x, ER Studio

Scripting: C, Korn Shell Script, SQL, and PL/SQL, HTML, VBScript.

Reporting Tools: Crystal reports 7.0

PROFESSIONAL EXPERIENCE:

Confidential

Database Consultant

Responsibilities:

• Developing migration strategy from P2P, P2V and P2Cloud
• Migrating an existing on-premises application to cloud (Implementing and controlling the data flow to and from cloud, appropriate cloud service based on compute, data, or security requirements)
• Implementing appropriate best practices in cloud environment for database availability, stability and monitoring reports.
• Installing and configuring MongoDB
• Monitoring, Backup and recovery of MongoDB and working with Dev team for tuning MongoDB queries
• Preparation of new instances/schemas for the new projects and for go-live projects, creation of the users, roles and schema objects and maintaining them.
• Debugging application-db issues with development teams, Implementing availability, scalability and security from app side
• Infrastructure designing, benchmarking and estimating current and future capacity
• Introducing cost optimization techniques through innovation and automation, best practices.
• Developing monitoring and job automation using shell scripts and scheduled with using cronjob for the database backups and old archive log deletion.
• Worked on various backup and recovery strategies VTL,Data domain snapshot, storage replications etc.

Confidential

Database Manager

Responsibilities:

• KT planning from incumbent vendor (IBM)
• Secondary and primary support preparation
• Standard operation procedure (SOPs) preparation for primary support
• Inventory validation and gap analysis
• Backup validation and restore validation through RMAN restore validate
• ITSM tickets analysis
• Technology gap analysis and service improvement plan
• Risks identified and mitigation plan preparation
• Performance baseline preparation
• Team build and project management

Confidential

Senior Database Administrator (Oracle, MS SQL, DB2, MySQL Production Support)

Responsibilities:

• Providing the 24x7 production on-call support which includes Incident management, Incident resolution.
• Wrote scripts for creating the general database according to Lexmark standard.
• Responsible for developing and executing contingency plans with Incident management.
• Wrote several unix scripts for backup, auditing, recovery of oracle databases.
• Scheduling jobs using OS crontab, Netback up and TWS software and setting the escalation group.
• Tested various security, merge, upgrade patches and recommended for production rollout.
• Responsible for writing, testing the Disaster Recovery scripts and report the issues to management.
• Implemented the audit requirements given by Enterprise Security Management.
• Worked out many commissioning, de-commissioning activities of databases.
• Prepared the initial requirements for production database and worked with capacity planning group to set performance benchmark.
• Setup oracle Names server, Oracle Internet Directory for database global naming.
• Responsible for creating software depot for new oracle software and patches.
• Installed oracle software and setting up users, tablespaces, patrol monitoring, health check and uptime.
• Created centralized information repository for all the production databases.
• Responsible for maintaining, approving the database changes through HP Service Desk.
• Scheduling hot backup using Veritas NetBackup.
• Managing RMAN backup and Catalog
• Physical support to all production, Development and Test databases in Lexmark.
• Recovery of databases based on the situation and requirement.
• Capacity planning, DR and BCP.

Confidential

Senior Oracle Database Administrator (Production Support)

Responsibilities:

• Providing the 24X7 Production support for all the production applications and involved in oracle database setup, performance tuning, backup, and recovery.
• Wrote the shell scripts and scheduled with using cronjob for the database backups and old archive log deletion. Also done the logical backup of the development instances every day using shell script.
• Wrote the shell script to check the “alert.log” file for every 5 minutes for the error messages and wrote the sql*plus scripts to generate database space statistics and called from cron jobs and sending the e-mail to the DBA group.
• Worked on backup and recovery strategies using the on line disk backups and well with off line tape backups.
• Preparation of new instances/schemas for the new projects and for go-live projects, creation of the users, roles and schema objects and maintaining them.
• Organized the tables, indexes, high volume tables in an individual table spaces under different mount points.
• Converted the dictionary managed table spaces to the locally managed tables spaces using dbms space admin package to gain the maximum performance. (Rebuild the objects in those table spaces for the relocation of extents).
• Doing the coordination with end users for the query optimization on the long running queries.
• Schedules the snap of the “STATSPACK" execution for every one-hour using the “dbms job” package.
• Planned the index rebuilding to avoid the row fragmentation, index analyze and table analyze on periodical basis.
• Refreshing the development and test instances with the production data whenever required by business users.
• Migration of the applications, which involves the new database creation from existing database (database cloning) and applying the additional changes on the database required by new version of the application.
• Monitoring the database and managing the space usage, table fragmentation, index fragmentation, etc.
• Implemented new data loading technique using Oracle External tables.
• Worked with RMAN for the backup and recovery of the 9i Application Server infrastructure database.
• Prepared the installation, maintenance and trouble shooting documents for all the database instances.
• Worked with the tools like DBArtesian, PL/SQL Developer, Foglight, QUEST central for oracle, Spotlight for oracle
• Testing. Performance Tuning & technical analysis of SQL queries, Integration Plan and detailed design document for data model.
• Converted Functional specification to Data Design and forward engineered for creating schema objects.
• Performed migration of oracle server from version 9.x. to 10G.
• Install and configure Data Guard in 9i and 10g.
• Configured UNIX kernel parameters for optimal semaphore, shared memory allocation.
• Developing and implementing monitoring scripts (SQL, Korne shell) for the database.
• Porting of static data required by the application to Production environment.
• Configured shell scripts using UNIX crontab for automatic CPU, memory monitoring and sending alert mails to DBA.
• Configuration management involves database sizing, Creating Server Layout using Optimal Flexible Architecture, file placement and specification of storage media.
• Implemented Oracle SQL * NET security using ip filtering mechanisms.
• Converting Functional specifications requirements to Data Model and Forward engineering to create required schemas
• Configured UTL FILE package for cheque printing and auditing reports.
• Configured Data Guard Broker between the primary and standby databases.

Environment: Oracle 8i/9i/10G, Sun Solaris 8, HP Unix 11, Veritas Storage Foundation for RAC, Shell Script, Export, Import, Erwin 4.x.x, ER Studio, DBA Studio, PL//SQL Developer, DBArtesian, Foglight, QUEST central for oracle, Spotlight for oracle, TOAD, PL/SQL.

Confidential

Database Administrator (Production Support / Development / Report Designer)

Responsibilities:

• Preparation of DBA work plans, perform daily, weekly and monthly tasks of the DBA.
• Worked on providing the backend support for the developers, stored procedures and functions, reporting, SQL query tuning and optimization, performance monitoring, resource usage and profiles.
• Oracle Installation, patch application, migration of databases to newer releases of Oracle. Creation of new database, deciding the location of data, index, rollback, redo log and control files on the disks.
• Physical design of oracle databases and configure them with Tivoli Storage Manager.
• Coded the stored procedures for House keeping services, Packages ad function. And well tuned the SQL in the application.
• Extensively worked on Oracle backup and recovery strategies (Hot backup, cold backup and Logical backups)
• Worked on setting up user profiles and roles as per the access level of user for the data and application security.
• Worked on data storage management, memory usage estimation for the existing and future expansion requirements.
• Migration of databases from one version to the other versions and applying patches.
• Configured the archive log for oracle databases and shipping them to standby site.
• Troubleshooting and providing support on 24X7 basis for the production environment. Involved in troubleshooting the database during the backup/recovery issues.
• Identifying the row chaining and row migration and de-fragmentation of the table spaces.
• Data modeling, database design and creation of database using data modeling tools (Creation of Data Flow diagrams and Entity Relation Diagrams using Erwin, ER Studio).
• Implemented best joining techniques to reduce I/O, implemented KEEP buffer pool for frequently used tables.
• Configured Automated Undo segments using undo tablespace for supporting different transaction volume.
• Measured Hit ratio for buffer cache, shared pool and adjust SGA size for various workload.
• Provided support for SQL Server development and production databases.
• Involved in the application tuning of database by identifying the suitable indexes.
• Creation of additional table spaces in these databases, Creation of schema owners and other database users.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Designing Reports for auditing transactions through Crystal Reports.
• Automation of the procedures to copy the data from the production servers to the test servers on weekly basis.
• Took the advantage of Oracle global temporary tables to store intermediate results in all the report generation for the quick response.
• Developed the operator periodic reports and batch detail reports using cursors, Java Script, Oracle temporary tables, PL/SQL and Exception handling.
• Performance tuning with V$ views, UTLBSTAT, UTLESTAT, STATSPACK, Automatic Workload Repository, Toad, Spotlight, Quest central.
• Configured Multi master replication for Business continuity plan using oracle Advanced Replication and written procedures for data conflicts.
• Used ORADEBUG for diagnosing database problems and submitted to oracle support.
• Configured and implemented Real Application Clusters with 2 nodes
• Prepared Service Level Agreement and database documentation.
• Disaster Recovery Plan preparation and testing fail over.
• Framing Processes to ensure smooth database change management activities.
• Configured and setup LOGMNR for auditing transactions and recovery of transactions using undo SQL.

Environment: Oracle 8i/9i, DB2 UDB 7.x / 8.x, WebLogic, Websphere, IBM AIX 4.1, Red Hat Linux AS 2.1, Linux Clusters RAC, Korn Shell Script, Export, Import, Erwin 4.x.x, DBArtesian, Foglight, QUEST central for oracle, Spotlight for oracle, ER Studio, TOAD, command center, control center.

Confidential

Database Administrator (Production Support) / Customer support DBA

Responsibilities:

• Planning, Installation and Configuration the in-house Oracle database on IBM UNIX AIX 4.1 / 5L.
• Configured RMAN with Tivoli Storage Manager and cloned database for standby database setup.
• Setting off initialization parameters, creating rollback segments for different nodes, monitoring of the rollback segments and configuring online redo logs.
• Creation of schema objects through ER Diagrams (Erwin),
• Maintaining the database security by granting of roles and privileges to the users.
• Setting up logical / physical backups for these databases. Depending upon the nature of the database, setup of either full export, partial export or export of just structure of schema objects and cold or hot backups.
• Managed the disk space, data blocks, extents, data segments, index segments, temporary segments and rollback segments.
• Monitoring the data fragmentation on data files, rollback segments and performed the periodic export and import to avoid fragmentation.
• Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Monitoring the tablespaces growth, fragmentation and tuning.
• Writing of Unix shell scripts to manage the health of the database proactively like scripts to log on to various servers to determine the table space in different databases where free space is less than 15% of 100Mb.
• Implemented the multi master replication between global data centers and store sites.
• To kill all the run-away queries on the database both at Unix level and database level.
• Developed & Maintained Crontab Shell Scripts To Schedule the Daily Oracle Hot Backups.
• Monitoring the database by using tools like oracle enterprise manager, server manager and third party tools like spotlight, I / Watch and SQLab from quest soft.
• Setting up Data warehouse database and configuration of oracle jobs for ETL
• Prepared post failure documentation in case of database failures.
• Reorganization of existing database to standardize the placement of various database related files, addition of table space to those databases and creation of schema owners and other database users
• Configured Data Guard in Maximum availability mode for maximum data protection from failures.
• Created support documentation for implementation and administration of the application, database monitoring, Discoverer, sysadmin tasks, etc. Developed and implemented monitoring scripts for the application and database.
• Writing shell scripts for automated backup, automated recovery of standby database, Archive log shipping at specified interval.
• Configuration of DB2 databases for persisting images and scheduling backup on daily basis.
• Preparing weekly dashboard of all DB issues and ongoing activities.
• Testing standby database connectivity and fail over.

Environment: Oracle 8i/9i, DB2 UDB 7.x, 8.x, Microsoft Transaction Servers, Websphere, Oracle 9i Application server, IBM Unix AIX, HP-UNIX 11, Tivoli Storage Manager, SAN, Fast - T, Shell Script, Export, Import, ErWin, DBArtesian, SQL, TOAD, PL/SQL, Cognos.

Confidential

Oracle / MSSQL Database Administrator Training & Customer support DBA

Responsibilities:

• Installation and Configuration the in-house Oracle database on UNIX and Windows NT.
• Establishing client and server communication.
• Monitoring the database performance.
• Planning and implementing backup and recovery strategy.
• Preparing customer presentations and RFPs.
• Vendor co-ordination.
• Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Monitoring the tablespaces growth, fragmentation and tuning.
• Writing of Unix shell scripts to manage the health of the database proactively like scripts to log on to various servers to determine the table space in different databases where free space is less than 15% of 100Mb.
• Implemented the multi master replication between SSI data centers and sites.
• To kill all the run-away queries on the database both at Unix level and database level.
• Developed & Maintained Crontab Shell Scripts To Schedule the Daily Oracle Hot Backups.
• Monitoring the database by using tools like oracle enterprise manager, server manager and third party tools like spotlight, I / Watch and SQLab from quest soft.
• Setting up Data warehouse database and configuration of oracle jobs for ETL
• Prepared post failure documentation in case of database failures.
• Reorganization of existing database to standardize the placement of various database related files, addition of table space to those databases and creation of schema owners and other database users
• Configured Data Guard in Maximum availability mode for maximum data protection from failures.
• Preparing weekly dashboard of all DB issues and ongoing activities.
• Testing standby database connectivity and fail over.

Environment: Oracle 7/8i/9i, MSSQL 7/2000, Shell Script, Export, Import, Erwin, DB Artesian, SQL, TOAD, PL/SQL