PROFESSIONAL SUMMARY:

• Overall 13 years of experience in the Information Technology field as an Oracle DBA.
• Around 3 years of experience as an AWS Cloud Solutions Architect and Oracle/AWS Cloud SysOps Admin.
• 5+ years of experience as an Oracle Exadata - Exalogic DMA/DBA.
• 7+ years of experience as MS SQL Server DBA.
• 4 years of experience as PostgreSQL DBA.
• AWS Cloud Solutions Architect/SysOps Admin
• Designed AWS and Oracle Cloud (SaaS) infrastructure to move on premise apps and databases to hybrid cloud.
• Installing, Configuring and Administrating the databases on Oracle Public Cloud (DaaS).
• Migrating the On Premises database to Oracle Public Cloud (DaaS) using RMAN and Data Pump.
• Established security policies for Oracle and SQL Server databases in the AWS cloud. Provided DR processes in the hybrid and Public cloud.
• Migrating databases from Datacenter to AWS cloud using Virtual Private Cloud(VPC) and Security Gateways.
• Migrating Amazon EC2 workload from EC2-Classic to EC2-VPC using AMI and CloudEndure.
• Written shell scripts to Export/Import database backups from RDS & keep the same in S3 (AWS Storage)
• Maintaining the monitoring profiles for AWS/Oracle Cloud (SaaS/PaaS) Services - EC2 Parameters (CPU, Memory, Disk, Response time, etc.).
• Worked on Amazon IAM, EC2, EBS, S3, Glacier, RDS, ELB, VPC, Route 53, Config, CloudWatch, Cloud trail, Redshift, Cloud Formation, AWS Cloud Front.
• Implementing EC2 backup strategies by creating EBS snapshots and attaching the volume to EC2 instance.
• Expertise in handling Build and Configuration management tools like Chef, Puppet, Terraform, Ansible etc.
• Hands-on experience in implementing DevOps to help developers in production environments.
• Oracle Exadata/Exalogic/ZFS/Super Cluster/ODA/ZDLRA/OVM
• Hands on experience to support Oracle Exalogic-Exadata V2/X2/X3/X6 and ODA machines of 11g/12c databases with 8-node RAC up to 130TB Size.
• Run One Command and generate OEDA configuration on Exadata/Exalogic Machines.
• Experienced to support Oracle Super Cluster T5 and S7 Mini Cluster series machines using ZFS Shared Storage Subsystem with ZS5-4, ZS5-2 Configurations.
• Administrating Oracle Database Backups and Recovery using Zero Data Loss Recovery X5/X6 appliance.
• Upgrading and Patching the Software and Firmware in Exadata Cell Nodes/Compute Nodes and Infiniband Switches.
• Configure the Exadata Database and Storage machines to meet internal Security requirements
• Configuring, Maintaining and troubleshooting Exadata Cell disk/Grid Disks for ASM storage.
• Troubleshooting Exadata Smart Scan/offloading issues.
• Troubleshooting the Infiniband Switches/RDS Ports, HCA ports on DB/CELL nodes and IB topology.
• Configuring IORM/DBRM and Implementing Exadata Flash Cache on Storage Server.
• Hands on experience to configure Database File System (DBFS) on Exadata Database Machines.
• Migrating non Exadata Databases to Exadata Machines using different methodologies, e.g. Transportable Tablespaces, Active Data Guard Physical Standby, Data Pump and Using Golden Gate.
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
• Core/RAC/ASM/Golden Gate
• Performing Backups, Cloning and Refresh with Delphix for Oracle Databases.
• Migrating non ASM databases to ASM storage.
• Good knowledge in Client, Database and RAC Cluster Upgradation, Migration and CPU & PSU Patching.
• Expertise on VMware Workstation to install different Operating systems, Software’s and Disk partitioning.
• Configured Bidirectional Oracle Golden Gate Replication Active/Active across various sites.
• Expertise in implementing Oracle Golden Gate and Oracle Data guard.
• Installing & Configuring Oracle Golden Gate 12c using Integrated Extracts & Replicats.
• Installing & Configuring OEM 10g/11g/12c/13c, Oracle Weblogic 12c, Golden Gate Monitor 12.1.3.0 and Golden Gate Veridata 12.1.3.0 and Configure Repository Database with Server/Agent configuration.
• Troubleshooting issue with Replication across sites and Performance Tuning on Oracle Golden Gate.
• Experience with different versions of databases like Oracle 8i/9i/10g/11g/12c using multiple OS environments like Windows, Linux, AIX, Oracle Solaris, HP-UX and VMware Environments.
• Expertise in Logical and Physical Backup schedules using Import/Export, Data Pump and RMAN.
• Experience in Oracle database Performance Tuning using AWR, ADDM, Explain Plan, SQL TRACE, STATSPACK, TKPROF, SQLTXPLAIN and different OEM utilities.
• Expertise in implementing Kerberos, Oracle Wallet, Database Vault, SSL, TLS and TDE authentications and Certifications for Oracle Databases.
• Strong knowledge on scripting languages like UNIX Shell Scripting, Perl Scripting and Windows Power Shell.
• MS SQL Server DBA
• Having good knowledge on Microsoft SQL Server 2005, 2008, 2008R2, 2012 Installation, Creation, Administration, and Maintenance of SQL Server Instances/Databases.
• Expertise in Configuring and Scheduling Backups, Recovery and Restoration using SQL Server Agent and LiteSpeed for SQL Server.
• Expertise in SQL Server Upgradation, Migration and applying Cumulative updates and Service Packs.
• Analyzing the performance using SQL Server Profiler and Monitoring using Activity Monitor, System Monitor.
• SQL Server Log Reviews (Windows Event Logs, SQL Server Error Logs and Agent Logs).
• Experience in Configuring High Availability & Disaster Recovery concepts like (Log shipping, Mirroring, Clustering and Replication).
• Installed and configured Active/Passive clusters on SQL Server 2008/2012 versions.
• Having basic knowledge about Microsoft Azure cloud services.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in SQL Server database Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency checks using DBCC Utilities.

TECHNICAL EXPERTISE:

Languages: C, C++, SQL, PL/SQL, TSQL, Java.

Operating Systems: Windows Server 2003/2008/R2/2012/R2/XP/Vista/7, Red Hat Linux AS 4/5/6, IBM AIX 5x/6x, HP-UX, Oracle Solaris 5x/6x/7x, Oracle Linux 5x/6x/7x.

Oracle Appliances: Exalogic-Exadata V2/X2/X3/X5/X6, ODA 2.3, SPARC T4/T5, SPARC S7, ZFS ZS3-ES, ZS5-4, ZS5-2, ZDLRA X5/X6.

Databases/Cloud Platforms: Oracle 8i/9i/10g/11g/12c, PostgreSQL, MS SQL Server 2005/08/08R2/12, AWS, Oracle Cloud(SaaS/PaaS/IaaS/DaaS).

Utilities: SQL *LOADER, DATA PUMP, IMP/EXP, DBVERIFY, DBCA, DATA GUARD, RMAN, RAC, ORACLE GOLDEN GATE, ASM, TKPROF, AWR, ADDM, SQL TRACE, SQLTXPLAIN, STATSPACK, ORADEBUG, LSNRCTL, CRSCTL, SRVCTL, DGMGRL, IORM, ORACHK, EXACHK, CELLCLI, CELLSRVSTAT, DCLI, ILOM, RASTAT.

Servers: Apache Tomcat, Web logic Server.

Virtual Machines: VMware Workstation ACE Edition 6.0/7/8/9/10, VMware Server 1x/2x, Oracle Virtual Box, OVM 2x/3x.

Scripting Languages: Shell Scripting, Perl Scripting, Windows Power Shell, Java Script, HTML, XML.

Other Tools: Delphix, ERwin, TOAD, PuTTY, SQL Developer, OEM Cloud & Grid, ODI, Perfmon, Activity Monitor, SQL Profiler, SQL Server Management Studio, IBM IMPACT, BMC Remedy, Tortoise SVN, LiteSpeed for SQL Server, CA Automation, Golden Gate Veridata.

PROFESSIONAL EXPERIENCE:

Confidential, Carson City, NV

Lead Oracle Exadata

Environment: Oracle Exadata X5-2, Oracle Exalogic X6-2, Oracle Server X6-2, Oracle OVM, Oracle ZFS, ODA, OEMCC 12c/13c, Oracle 12c, RAC, ASM, Oracle AVDF, Oracle IDAM, Linux, WebLogic Server, Web Center.

Responsibilities:

• Migrating databases from IBM Mainframes to Oracle Engineered systems.
• Storage design for Prod and Non Prod databases in Oracle Exadata.
• Creating Virtual Machines using OVM to accommodate all Middleware infrastructure.
• Installing and Configuring all middleware software like WebLogic server, Web Center, IDAM on X6-2 server.
• Design Backup & Recovery policies using ZFS storage for Prod and Non Prod databases RMAN backups.
• Designing and Implementing the HA & DR between data centers using Oracle Active Data Guard Far Sync feature.
• Create OEDA reports and involved with Oracle team to run one command on Exadata Machines to Configure Grid & RDBMS Software.
• Installing, Configuring and Monitoring all databases health check using OEMCC 12c.
• Involved in Network infrastructure design and VLAN IDs allocation between data centers.
• Implementing replication between data centers using Oracle Active Data Guard and ODA.
• Building and Create Non Prod (QA, Dev, SIT, Training) environments for developers.
• Setup weekly meetings with Nevada State Confidential and EITS team to discuss about the current status of the Confidential System.
• Installing and Configuring Oracle Audit Vault and Database Firewall (OAVDF) for all databases.

Confidential, Pittsburgh, PA

Lead Oracle Exadata

Environment: Oracle Exadata X2-2, Oracle Exalogic X6-2, SPARC T5/S7, ZFS, ZDLRA X6, Oracle Public Cloud(DaaS), OEMCC 12c/13c, AWS Cloud EC2/RDS, Oracle 11g/12c, RAC, MS SQL 2008R2/2012, Linux, AIX, Windows Server 2008/2008R2/2012.

Responsibilities:

• Deployed DevOps Solutions that will support business objectives and developer communities such as: Configuration Management, Continuous Integration/Deployment, Cloud, IaaS, PaaS, and Self-Service deployment automation platforms.
• Upgrading and Patching the Software and Firmware in Exadata Database Machines, Exadata Storage Servers, and InfiniBand Switches.
• Migrating the databases from Exadata X2-2 boxes to Exalogic X6-2 boxes.
• Designed highly available and scalable architecture using Amazon Web Services to sustain heavy and sudden workloads with zero down time.
• Synchronize Physical standby database with Primary database on Exadata Machine using Data Guard.
• Migrating databases from premises storage to ZFS storage using ZS5-4 and ZS5-2 configurations.
• Handling Production database backups and recoveries using ZDLR (Zero Data Loss Recovery) appliance.
• Handling and administrating the databases on SPARC T5-8 and S7-2 Super/Mini clusters using ZFS storage.
• Migrating the databases from on premises servers to SPARC T5-8 and S7-2 Super and Mini clusters.
• Develop shell scripts for automation of the build and release process, developed Custom Scripts to monitor repositories, server storage.
• Integrate into development teams to provide security expertise on systems, network, encryption, authentication, security specific code, and governance, etc.
• Provide senior architectural leadership for all phases of the enterprises cloud and operational objectives including the ongoing integration of Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and cloud application and service driven architecture programs and efforts.
• Securing all Production databases using Database vault, Wallet and by enabling TDE encryption.
• Configuring, Maintaining and troubleshooting Exadata Cell disk/Grid Disks.
• Troubleshooting the InfiniBand Switches/RDS Ports, HCA ports on DB/CELL nodes and IB topology.
• Upgrading/Migrating and applying Cumulative Patches of MS SQL Server databases from 2008R2 to 2012 using in-place and side-by-side methods.
• Handling user management, memory management for all SQL server environments.
• Monitoring and handling the daily backups of SQL Server Production databases using Lite Speed tool.
• Configuring and monitoring SQL Server Log shipping and mirroring for most of the Production databases.
• Involved in major SQL Server database migrations across data centers.
• Monitoring SQL Server database performance using Database Tuning Advisor and SQL Profiler.
• Handling DevOps to work with developers on production needs and help support the application in production.

Confidential, Woonsocket, RI

Sr. Oracle Exadata DMA

Environment: Oracle Exadata X2-2/X3-2, AWS Cloud EC2/RDS, Oracle 11g/12c, RAC, MS SQL 2008R2/2012, Linux, SPARC T4/S7, AIX, Windows Server 2008/2008R2/2012, Oracle Golden Gate 12c, Golden Gate Veridata 12.1.3.0.

Responsibilities:

• Executing One Command scripts to configure Exadata.
• Upgrading and Patching the Software and Firmware in Exadata Database Machines, Exadata Storage Servers, and Infiniband Switches.
• Configuring, Maintaining and troubleshooting Exadata Cell disk/Grid Disks.
• Planning and documenting to managing databases on Hadoop and Big data storage.
• Configuring IORM/DBRM and Implementing Exadata Flash Cache on Storage Server.
• Configuring backups using Zero Data Loss recovery appliance.
• Generate and monitor statistics of ZDLR using RASTAT utility.
• Migrating non Exadata Databases to Exadata Machines using Transportable tablespace method and Setting up Monitoring Exadata using EM12c.
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
• Securing database listeners using SSL, TLS authentication and certificates.
• Creating and maintaining security for databases using database vault and TDE.
• Established security policies for Oracle and SQL Server databases in the AWS cloud.
• Written shell scripts to Export/Import database backups from RDS & keep the same in S3 (AWS Storage)
• Worked on Amazon IAM to create and grant security policies and roles.
• Migrating many Oracle 11G/12C and SQL Server 2008/12/14 databases from traditional storage to AWS cloud EC2 instance.
• Taking and storing backups in/out using Amazon S3, EBS and Glacier.
• Worked closely on RDS, ELB, VPC and Route 53.
• SQL Server Backups, Restoration, User Management and Memory Management.
• Install/Upgrade SQL Server software for standalone and Active-Passive Cluster.
• Configuring SQL Server Log shipping and mirroring for all Production databases.
• Configure Bidirectional-Oracle Golden Gate Replication Active/Active across various site.
• Install/Configure Oracle Golden Gate 12c using Integrated Extracts & Replicats.
• Involved with DevOps team to implement automation of jobs and wrote scripts for the same.

Confidential, Houston, TX

Oracle Exadata DMA

Environment: Oracle 10g/11g/12c, Oracle Exadata X2-2/X3-2, ZFS, ZDLR, RAC, MS SQL 2008/2008R2/2012, Delphix, Linux, Sparc, Windows Server 2008/2008R2/2012, Oracle Golden Gate 11g, AWS Cloud.

Responsibilities:

• Upgrading the databases from 11gR1 to 11gR2.
• Configure the Exadata Database and Storage machines to meet internal security requirements
• Troubleshooting Exadata Smart Scan/offloading issues.
• Migrating non Exadata Databases to Exadata Machines.
• Assess the needs of a customer and leverage DevOps methodologies to architect and design a wide range of DevOps solutions which ultimately enable customers to deliver high quality software faster.
• Configuring IORM/DBRM and Implementing Exadata Flash Cache on Storage Server.
• Configuring Production database backups to tape using ZDLR appliance.
• Configuring NAS storage for databases using ZFS storage subsystem.
• Configuring database vault and enabling TDE encryption for Tablespaces.
• SQL Server Backups, Restoration, User Management and Memory Management.
• Configuring SQL Server Log shipping and mirroring for all Production databases.
• SQL Server databases Upgradation from 2005 to 2008 and 2008 R2 to 2012
• SQL Server databases migration from 2008 to 2008 R2 and 2008 R2 to 2012 from Windows Server 2003 to 2008 and Windows Server 2008 to 2012.

Confidential, NY

Oracle Exadata DMA

Environment: Oracle Exadata V2/X2-2/X3-8, Oracle 10g/11g/12c, RAC, Delphix, Oracle Golden Gate 11g, MS SQL 2005/2008/2008 R2/2012, Linux, Sparc, Windows Server 2003/2008/2012.

Responsibilities:

• Supporting Oracle Exadata X2-2/X3-8 machines, 11g databases with 8-node RAC.
• Configuring Golden Gate Unidirectional Replication.
• Perform One Command scripts execution to configure Oracle Exadata.
• Upgrading and Patching the Software and Firmware in Exadata Database Machines, Exadata Storage Servers.
• Configuring, Maintaining and troubleshooting Exadata Cell disk/Grid Disks.
• Configuring IORM/DBRM and Implementing Exadata Flash Cache on Storage Server.
• Standby database Maintenance and Configuration data guard.
• Configuring, Maintaining and troubleshooting Exadata Cell disk/Grid Disks.
• SQL Server database Upgradation from 2005 to 2008.
• SQL Server cross platform migration from Windows Server 2008 to 2012.
• Design database Backup and Restoration Strategy using SQL Server Agent.
• Performance monitoring and tuning using AWR, ADDM, SQL Profiler and Activity monitor etc.
• Performing Cloning and Refresh databases with Delphix.

Confidential, Rochester, NY

Oracle DBA

Environment: Oracle 11g/10g/9i, RAC, MS SQL Server 2005/2008/2008 R2, Linux, Solaris, Windows Server 2003/2005/2008.

Responsibilities:

• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Standby database Maintenance and Configuring Data guard.
• Creating/Resizing of Tablespaces, Tables, and Users for custom applications.
• Weekend on call support, Payroll support and bundle upgrade support for PeopleSoft applications.
• Physical database design, Table, Column mapping with existing requirement.
• Creating/Dropping Databases, Users, Table spaces, Tables & Database Objects.
• Oracle 10g Real Application Cluster Implementation and Production support.
• Stats Gather at Database, Schema, Table and Index level.
• Applying quarterly CPU patch to all Databases.

Confidential, San Jose, CA

Oracle DBA

Environment: Oracle 10g, 9i, 8i MS SQL Server 2005/2008, Linux, AIX, Windows Server 2003/2008.

Responsibilities:

• SQL Server Backups, Recovery, Restoration, User Management and Memory Management.
• Configuring SQL Server Log shipping and mirroring for all Production databases.
• Creating new users and assigning required privileges using SQL Server management studio.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.
• Building and Monitoring Disaster Recovery (DR) databases for all Production.
• Query Tuning using ADDM, AWR and Stats Pack Reports.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Oracle 10g Real Application Cluster Implementation for Production databases.
• Analyzing the ADDM, Stats Pack reports and Explain plan output and Gather stats at Database, Schema, Table and Index level.

Confidential

Oracle DBA

Environment: Oracle 10g, 9i, 8i, PostgreSQL, Linux.

Responsibilities:

• Data transfer from External files to Database using SQL Loader.
• Monitoring and Managing database backups and when needed restoring big loads to databases.
• Prepared Database level and table level backups in PostgreSQL.
• Created database Triggers, Stored Procedures and Functions for the validation of input data and implementing business rules.
• Wrote UNIX shell scripts to monitor and maintain the Oracle database.
• Refresh/Cloning of Database for Development and QA.
• Created new Databases, Users and Table spaces.
• Developed database Tables, Views and Indexes using primary keys and foreign keys.
• Database backups and recovery using RMAN.