SUMMARY

• Over 16 years of experience in Software Industry includes development of business applications, administration of RDBMS such as Oracle & Oracle RAC, Oracle Exadata, IBM UDB DB2 LUW, PostgreSQL, MYSQL, Sybase ASE & MS SQL server. Develop PL/SQL packages, procedures.
• Experience in working on AWS cloud technologies. Migration Ofon - premiseDatabase's to AWS using DMS. Creation Of PostgreSQL RDS instances and databases, upgrades, administer and monitor. RDS database performance monitoring and analyze logs using Pgbadger. Setting up Read Replica and Contingency. Performed Multi-AZ environments failover testing and application auto reconnect. Migration of RDS instances across different VPC using Read Replica, pgdump and pgrestore. Snapshot backup's and restore.
• Oracle 12C certified Professional. IBM db2 10.1 Certified Database Administrator.
• Installation and upgrade of Oracle, Oracle RAC, Oracle On Exadata X4-2, UDB DB2 LUW, MS SQL Server, Sybase ASE and MYSQL database’s in VERITAS Active / Passive Cluster environment & standalone on UNIX, Linux, Solaris, AIX & windows operating systems. Experience in Creating Database’s on VERITAS Active /Passive Cluster in Solaris zones environment.
• Database performance monitoring and tuning. Use of advanced tuning capabilities to identify and fix SQL query performance regression.
• Implementation of partitioning strategies. Creation of effective indexes on partitioned tables for better performance and ease maintenance. Automation of purging old and unwanted partitions.
• Oracle Gloden Gate installation, Configuration, monitoring, troubleshooting & administration. Gloden Gate upgrades to 12.2 and applying patches.
• Maintain Oracle Exadata engineered system and databases, patch Exadata servers on time. Upgrading Oracle Exadata Machine components and setting up Active Data Guard . Migration of databases to Exadata Machine.
• Performed db2 UDB database migration to Oracle 11G, and Oracle Database cross-platform Migrations.
• Identifying and applying one-off patches, Quarterly PSU Patches for Oracle RAC & Standalone Databases. Identifying and Applying Fix Packs, inline or out of place upgrades of teh IBM UDB db2 databases.
• Experience in Oracle High Availability Techniques Including Log shipping, Switchover / Failover of Disaster Recovery Database’s. Setting up teh Disaster Recovery sites and building Physical Standby Database’s for Standalone and RAC databases. RAC graceful switchover or switchback using DG Broker for client Failover testing purpose. Experience in MSSQL server Log shipping, and Cluster Failover / Failback. Setting up and administration of db2 HADR high availability system.
• Oracle DBA support for Data warehouse, Oracle Apps, PeopleSoft and SAP applications. Expert in Managing SAP BR utility for backup and Recovery of Oracle Database’s using Computing Center Management System (CCMS) in SAP to monitor teh system and perform teh DBA activities using BRBACKUP, BRARCHIVE, BRCONNECT, and BRSPACE. Perform teh Database system check using BRCONNECT available in CCMS.
• Experience in Restore and Recovery of Corrupted blocks, Data Files, Tablespaces & Database’s of Oracle & db2. Recovery of Standby database’s using Primary incremental backups. DB2 backup and restore database’s in multi node / partitioning environment. Knowledge and experience of db2 DPF.
• Database Cloning using Storage Snaps, RMAN duplicate target database from active database or using RMAN online backups. Expert in Planning, Backup, Recovery Strategies in Oracle, UDB db2 & MYSQL using Enterprise backup utility.
• Experience in writing Shell scripts in automating various database activities, monitoring, backups, automatic Physical standby failover /activation, database health checks and etc.
• 24/7 Production Database support. Artistic background and strong design, Creative and problem solving skills. An adaptable and enthusiastic database administrator with good experience and technical skills.

TECHNICAL SKILLS

GUI: Visual Basic 6

Database: Oracle(11G,12C), IBM DB2 LUW (V9.7,V10.1), MYSQL(V5.0,V5.5), PeopleSoft, Exadata X4-2, Sybase ASE (V15.7) & MS SQL Server (2008,2012)

Ticketing Tools: My Services, BMC Remedy, CM Synergy, PeopleSoft CRM, Hobbit, BugZilla, Star Team& FileNet

DB Tools: Toad, PeopleSoft CRM, DBArtisan, Rapid SQL, PGAdmin, SQL Workbench

Development tools: Putty, Toad, Textpad, Eclipse

Migration Tools: SQL Portor, SQL Ways, AWS DMS, ORA2PG & SSMA

Scripting Tools: Shell & Perl Scripting

Clustering Technologies: Oracle RAC, VERITAS Clustering & MYSQL Clustering

Replication Technologies: Oracle Gloden Gate, Oracle Streams & MYSQL Replication

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Database Administrator III

Responsibilities:

• Manage various Oracle RAC, PostgreSQL, Sybase ASE & MS SQL Server databases in large mission critical systems. A complete end-to-end support including maintenance, monitoring, patching, upgrades, migrations and backup and restore.
• Working on AWS RDS instances. Migration Ofon-premiseDatabase's to AWS using DMS and ORA2PG. Creation Of PostgreSQL RDS instances and databases, upgrades, administer and monitor. RDS database performance monitoring and analyze logs using Pgbadger.
• Creation of Read Replica environments, promote read replica, Multi-AZ failover. Setup PostgreSQL Database's, users, roles as per standard. Check In database scripts into Git repository. DB deployments via Flyway invoked thru Jenkins pipeline.
• Securing S3 resources with bucket policies and IAM like grant users S3 bucket permissions/cross account bucket permissions, bucket permissions to objects without ownership. Creating policies and Simple notification services through teh management console to receive notification when objects are uploaded to respective S3 buckets.
• Creation of dedicated security groups for each RDS to restrict/allow access to teh RDS from teh specific set of sources/hosts/IP addresses. setting up cloud watch alarms to collect and monitor metrics of various AWS services.
• Use of DataSunrise Database Security software to secure teh databases and data in real-time. Continuous control of all activity in databases and data warehouses.
• Analyze and resolve complex technical problems regarding teh integration of object-oriented applications and infrastructure with relational database technology.
• Monitor databases and performs tuning enhancements to optimize their performance. Develop and maintain utilities to automate problem determination, change implementation, and monitoring activities.
• Provide database change and release management support. Work with TS counterparts and coordinate server/instance and database builds, database refreshes and security implementations. Develops and CI/CD experience using Flyway.
• Converted Database Character set to AL32UTF8 from USASCII7 in 11g and upgraded database's to 12C in physical standby environment.
• Implement and maintain database security standards for Creation and maintaining database users, roles and assign privileges. Troubleshooting and problem analysis during development and testing phases.
• Oracle Gloden Gate s/w installation, Configure, maintain, troubleshoot, Error handling and provide production Support. Gloden Gate One way & Bidirectional replication configuration and support, and performance tuning of gloden gate configurations. Leveraging multiple features within teh Oracle Gloden Gate product suite.
• Code migration, database change management and data management through teh various stages of teh development life cycle. Provide SME support in Oracle, Sybase, MS SQL Server technologies to a large group of developers and testers.
• Implemented effective partition strategies and indexes for better manageability, scalability and availability of large critical objects. Developed a pl/sql procedure for identifying and dropping older partitions based on retention policy defined by application.
• Performs capacity planning of Oracle server environment and provide recommendations to management to sustain business growth. Troubleshoot and resolve issues in our dev, test and production environments.
• Installation and configuration of OEM agents. Register and monitor various OEM agents, target components through OEM cloud control, alerts and metric threshold Management. View and manage incidents generate from events associated with targets.
• Working closely with Development, QA, Product Management, and external IT teams to make sure teh database changes made effectively and minimize teh production database down time.
• Work with Continuous Integration/Configuration platforms and tools to automate infrastructure provisioning and deployment flow.
• Use of various services under service management tool like INC, IT support requests, change requests and etc for supporting enterprise wide applications/database's.
• Version control best practices based on SCM (source control management) systems, such as GIT and SVN. Integrate Flyway with Jenkins pipeline for automating database deployments across various environments

Confidential, Mc Lean, VA

Sr. Database Administrator

Responsibilities:

• Provide application DBA support in DB2 UDB, Sybase ASE and Oracle RDBMStechnologies.
• Management & Administration of development, SIT, QA and Production databases.
• Work with TS counterparts and coordinate server/instance and database builds, database refreshes and security implementations.
• Implement and maintain database security standards for Creation and maintaining database users, roles and assign privileges.
• Troubleshooting and problem analysis during development and testing phases.
• Provide SME support in DB2 UDB, Sybase ASE & Oracle technologies to a large group of developers and testers.
• Troubleshoot application/database issues during development/testing and deployment phases and provide solutions.
• Documentation around database procedures and maintain Database Issue Tracker.
• Support Database Migrations from DB2 to Oracle and Vice-Versa, Sybase ASE to MS SQL Server.
• Working on replication methods / tools for Heterogeneous Database Replication.
• Perform general technical trouble shooting and give consultation to development teams.
• Take care of teh Database design and implementation, and perform database tuning and performance monitoring.
• Coordinating with Change management teams for scheduling Change Requests with proper change steps with back-out plan to deploy DB related changes in critical Production Environments.
• Applying PSU and CPU Patches for Oracle Database’s, Applying Fix-Packs to UDB db2 databases.
• Migration of UDB DB2 Database’s From V9.7 to V10.1. Installation of UDB db2 Clients on App / Batch Servers to Connect Remote UDB db2 Database Servers. Install, Create and configure database’s for UDB 10.5 versions with Fix Pack 5.
• Developing Shell Scripts for automating teh DB related activities. Developed a Shell Script for generating a report for DML activity by Table from DB2 event Monitoring data.
• Provide teh On call DBA support, and involve in production deployments. Coordinate with Operation DBA teams as needed.

Confidential

SR DB Administrator TIER III

Responsibilities:

• Provide teh On call DBA support, and involve in production deployments. Coordinate with Operation DBA teams as needed.
• Installation, Administration of Oracle, RAC& UDB DB2 Databases on UNIX, Solaris and Linux boxes. Installation, Creation of 12C Database’s on Linux servers and applied teh one-off / scheduled PSU patches.
• Upgrade / Migration of Oracle & DB2 LUW database’s to teh newer & latest versions. Identifying and Applying Oracle Quarterly CPU / PSU patches. Upgraded Oracle Database’s from 11.2.0.3 to 12c &applied PSU patches.
• 11G 3node RAC or more nodes configuration with physical Standby database using real time Apply.
• Oracle Gloden Gate s/w installation, Configure, maintain, troubleshoot and provide production Support. Gloden Gate One way & Bidirectional replication configuration and support. Error handling, troubleshooting and Performance tuning of gloden gate configurations, Conflict detection and resolutions in active-active configurations. Gloden Gate monitoring through an integrated database monitoring tool and resolving teh alerts Received through ticketing tool.
• Configuration and maintenance of DG Broker.RAC graceful switchover or switchback using DG Broker for client Failover testing purpose. Upgrade ASM Libraries on all nodes in conjunction with Linux Kernel Upgrade.
• Work with Oracle Support to Manage and Addressing Exadata Hardware alerts, issues & patch Exadata components on time. Exadata Storage cell administration and Database Machine Fault Monitoring. Knowledge on Exadata features Hybrid Columnar Compression, Smart Flash Logging& Smart Flash Cache. Create and upgrade database in Exadata and setup Active Data guard on Exadata. Validate teh contents of CELLBOOT USB Flash Drive to ensure that storage server is being backed up. Performing DB backups on Exadata Machine.
• Identifying & fixing chronic issues by making recommendations to Client Technical Lead. Prepare SMOP’s and provide assistance to Confidential -2 DBA’s to perform changes in Prod Environment. Prepare MOP’s for various
• Configuration of VCS with Active / Passive cluster nodes for Oracle & DB2 LUW database’s on Solaris 10 with Zones.
• Recovery of Physical Standby Database’s with Primary Incremental Backup’s based last SCN Confidential standby database. Duplicate target for Physical Standby database using Active Database & Backup based methods.
• Adding a node to an Oracle 11G R2 RAC Cluster on NETAPP SAN on RHEL 5 and OCFS2 for Gloden Gate. Adding a Node to an Oracle 10G RAC on Linux RHEL4.Migrated Voting Disks& OCR to ASM storage.
• Given training to Confidential -2 DBA’s on Oracle and UDB db2 LUW for front ending some critical issues. Prepare Change Steps and educate Confidential -2 DBA for implementing in production environment.
• Support Customer Data Loads / deployments in production and pre-prod Environments for Oracle & DB2 LUW databases. Creation of Materialized views, administration and monitoring.
• Oracle 11G Data Guard setup from RAC to RAC. Refresh Dev / Staging db’s using RMAN duplicate database Feature from Active database or Backup based methods based volume of teh databases.
• Handling AOTs, CRM Case’s opened by NetCool and VizGems Monitoring tools. Handling teh FileNet & Remedy tickets
• Table Space and Active log space Management in DB2.Identifying & Fixing Corrupted or Bad Pages using db2dart in DB2. Managing DB2 Re-org &Run stats jobs.
• MS SQL Server 2008 Installation and Database creation and users privilege Management. Setup and monitoring log shipping in SQL Server, and clustering failover and failback operations in cluster of SQL server.
• Master Slave Replication configuration in MYSQL. MYSQL Enterprise backup setup and administration. Performing logical backups as needed for databases using utilities like Oracle Data pump Export / import, db2 export/import/load & BCP in/out for SQL server databases.
• Backup, Restore and recovery methods including point in time recovery of DB2 & Oracle. DB2 node directory / Catalog configuration. DB2 HADR implementation and Support. Create and manage Backup maintenance plans in SQL Server.
• Implemented and performing Incremental backups, and defined retention policies for Oracle & DB2 databases.
• Refresh of Staging, Dev database’s using production Incremental / Full backups. Providing on-call support for DB2, Oracle RAC on Exadata & Non Exadata, SQL Server & MySQL production databases.
• Maintain Oracle Exadata engineered systems and databases, and work with teh Oracle to patch Exadata components on time. Apply PSU / CPU Quarterly patches (Bundle Patches) for RAC databases in Exadata systems and as Patch Read me & Doc 888828.1 to identify and apply any pre-requisite patches to other Exadata components.
• Software and Firmware maintenance of teh Exadata storage / Cell servers & InfiniBand switchesin teh Database machine including upgrades and patching.
• Troubleshooting process startup failures, Configuration problems that cause startup failure, and troubleshooting replicate problems. Replicating Data using teh Oracle Streams and administration of oracle streams replication environment. Managing, monitoring & troubleshooting materialized view replication environment.
• Open PMR and work with IBM during critical outages. Open SR and work with Oracle Support for critical outages. Restore DB2 Database’s from Incremental Backups and roll forward with teh archive logs.
• Applying DB2 Fix packs in Production, Stage and DR Environments. DB2 In-Place Upgrade /Migrate Instances / Databases to teh next releases.
• Developed Shell script to automate teh various checks of build, configuration, backups and monitoring checks of UDB databases to determine they are eligible to become production operational database.

Confidential

Lead -Database Admin

Responsibilities:

• CSC Managed Hosting Services comprise a broad range of data center, network, security, server, and application services that, together with CSC’s managed operations, can be configured to provide a fully-managed hosted
• solution. CSC’s core hosting data centers are located in Cambridge, MA, Elmsford, NY, Newark, DE, Chantilly, VA, Chicago, IL and Sunnyvale, CA. Supported teh DB2 & Oracle Database’s for end Clients Confidential, Amerprise, Matson Navigation, Capital Group, Value America, Citizen Bank, AON, Excellus and etc.
• Installation, Administration of Oracle on UNIX, Solaris and Linux Up-gradation (Applying Patchsets: 9.2.0.4 9.2.0.6, 10.2.0.2, 10.2.0.3 and 10.2.0.4) of RAC and Non RAC Database’s.
• Migration of Oracle Instances to teh newer versions (8i to 10g, 9i to10g). Setup and Administration of
• Oracle RAC database’s on UNIX & LINUX boxes.
• Installation and Configuration of Oracle & db2 Database’s on VCS with Active / Passive Cluster environment
• On Solaris and Linux. DB2 node directory / catalog configuration. Database performance tuning using DB2dart, DB2 explain and db2top utilities.
• Identifying and Applying Oracle Quarterly Security Patches and DST patches during customer provided down time window by Global Change Activity Request System (GCARs) with teh necessary customer and tech Approvals.
• Identifying & Applying bug fixing patches in standalone, VCS Active/Passive Cluster & RAC Environments.
• Configuring and maintaining Physical Standby databases on VCS active / passive cluster. Performed Physical Standby graceful switchover for role reversal.
• Monitor and Trouble shoot RMAN Full and Incremental Backups. Identifying chronic issues and taking necessary
• Corrective actions to fix them. Handling Remedy Ticket Opened by Big Brother Monitoring.
• Front ending customer support and attending weekly customer calls. Act as Tech Lead / Primary Contact
• For multiple customer accounts. Provided basic Training on Oracle, DB2 &Oracle Exadata to theTier-1 operation DBA team.
• Support Customer Database Deployments in Production and Pre-Prod environments. Provide 24x7 supports for all teh Production, Pre-prod and DEV Environments.
• Designed Backup Strategies and Disaster recovery plans depending upon teh criticality of teh Databases.
• Performed DR database Failover to Primary Database role Confidential DR site, and built Physical Standby Database Confidential Primary site using RMAN online backup of New Primary Database and this test is teh simulation of real time Failover DR Scenario and test was done as a part of yearly customer scheduled DR test.
• Resolving issues and bugs related to Database’s thru change management system with necessary approvals.
• Open TAR with Oracle vendor support and PMR with IBM vendor support for any major issues and resolving them.
• Maintain Customer Run books to keep track of known issues, patches applied to teh databases, backup strategies and etc.
• Developed teh Shell script to automate teh Activation of Standby Database’s (Failover) to primary Role in teh event of real time disaster scenario.
• User and Roles management. Backup, Restore and recovery methods including point in time recovery.
• Implemented Incremental backup strategies, and defined retention policies. Refresh of Staging, Dev database’s using production backups.
• Provision of on-call support for database problems and off hour’s maintenance. Prepare, Document and implement Change Management Requests.
• Support Customer Releases and deploy teh code in to production environments.
• Restore Database’s from Incremental Backups and roll forward with archive logs.
• Installation, Administration of IBM UDB DB2 on Aix, Solaris and Linux. Applying Fix packs. In-Place Upgrade /Migrate Instances / Databases to teh next releases. Run time or Admin type client Installations.

Confidential

Sr. Oracle DBA

Responsibilities:

• Multiplexing control files and spreading them in to different disk controllers.
• Implementation of OFA to minimize contention and minimize disk I/O. Relocate teh DB files as per teh Characteristics of stored objects.
• Designed teh RMAN backup and recovery strategy. Developed teh RMAN full Backup Scripts to backup teh Database Confidential Tablespaces Level.
• Analyze teh Backup logs. Monitor DB performance during teh Backups. Implemented teh RMAN Parallelism to speed up teh backup with multiple backup processes without Effecting server performance.
• Determined teh backup frequency to meet client business requirements.
• Prepared teh recovery scenarios for various media failures. Creation of Recovery Catalog in DB Different from Production DB.
• Rebuilding indexes. Perform Database Backup, Restore & Recovery. Upgrading / Refreshing of Schema’s / databases.
• Release management, Release script review, and deploy teh release code in Dev, Test, PRE-PROD and Production environments through teh CM Synergy.
• Code review and approval for teh production release. Creating New Development environments on Solaris, HP, RedHat Linux and etc.
• Define and Develop scripts to implement RMAN Incremental Backup strategy to reduce backup time as Well as reduce time as required restoring and recovering teh files in teh event of media failure.

Confidential

Oracle DBA / Database Programmer

Responsibilities:

• Administration of Multiple Database server’s such as Development, Testing and Deployment Confidential H.Q for teh Clients Praveen Masale, Formica India Division and Pudumjee (Bombay Burmah Trading corporation, LTD).
• Involved in project called Formica India Division for teh development of Purchase, Inventory modules as a DB Programmer to write stored procedures and functions for teh both transaction and Reports development, Administration of Database.
• Administration of Client Databases: Formica India Division, Praveen Masale, Pudumjee pulp & Paper Mills Ltd.
• Establish and maintain sound backup and recovery policies for teh Client databases. Database Backup and Recovery.
• Maintain relevant release scripts for Create, Delete, Alter table, Database and Schema’s.
• Manage User Roles and Privileges. Tuning Memory and SQL queries for better performance.
• Installation, Maintenance of Oracle Confidential client Site. Code Review with regards to SQL effective Enhancement. Writing Packages - Simple, Medium and complex.
• Consultation and Database support Confidential client site. Gather performance statistics using Statspack utility and perform tuning.
• Prepare Packages as per teh requirement / functionality. Work with QA team to test teh functionality from backend. Developed PL/SQL Packages / Functions in HRMS module.
• Participate in all activities related to code deployment and synchronization Confidential client site. Participate in executing actual data migration Confidential client site from teh existing system.

Confidential

Database Administrator

Responsibilities:

• Installation &configuration of Oracle server software and relatedproducts to support Parking system.
• Establish and maintain sound backup and recovery policies and procedures and perform backups.
• Implement and maintain database security (Create & Maintain Users and Roles, and assign privileges).
• Do database tuning and performance monitoring. Setting storage parameters for tables to avoid fragmentation.
• Performed teh Online Backups (Hot), Cold &logical backups (using Exports /imports utilities).
• Performance tuning was done by taking necessary steps like increasing shared pool size, db block Buffers.
• Space management in table spaces i.e. Resizing, Addition or Deletion of data files in Tablespaces.
• Up-gradation of Parking Software and components along with Oracle database.
• Remote maintenance of client databases using Remote server located Confidential HQ.
• Work as part of a team and provide 7x24 support when required.