SUMMARY

• Proven ability to lead and coordinate project team resources
• Exceptionally good communication and technical skills to implement business and management solutions
• Extensive experience in Client/Server Environment

TECHNICAL SKILLS

DBMS: Oracle 9i/10g/11g/12c, MS SQL Server 2012/2016, MySQL5.0

Operating System: Linux, Windows 2008/2012/2016, Sun Solaris 10/5.9, VMS

Hardware: Sun Enterprise 5, 20, ULTRA, E4500, 3800, HP - 9000, Sun4u Sparc, SUNW, Sun-Fire-440, DEC ALPHA

Tools: OEM Grid 13c, CyberArk, Toad, GIT, SQL Developer, Nagios, Splunk

Software: SQL*LOADER, SQL*NET, Outlook, MS Office, MS Project

Languages: SQL, PL/SQL, Perl, Python

PROFESSIONAL EXPERIENCE

Confidential, MA

Responsibilities:

• Provide Production, Development, Testing and Maintenance support for Oracle 11g/12c/18c Databases on Linux VM, Unix (Sun Solaris 5.9), MS SQL Server /2016 on Windows 2008/2012/2016, MySQL on Linux VM for various University Web based applications for grants management, student registration/courses/Billing, Jobs Hiring, Library, Financial etc.
• Project management and co-ordinate design develop and provision ec2/RDS cloud infrastructure on AWS platform using Cloud Formation. Migrated on-premises databases to AWS cloud. Set up cloud watch and monitoring and alerts of databases using Nagios.
• Design, install and configure Oracle 11g/12c/18c, RDS, MS SQL Server and MySQL Databases on-premises and AWS cloud for university web applications used by students and faculty. Design and configure SQL Server Mirroring and MySQL replication.
• Configured RMAN backup and recovery strategy for Oracle databases and DR purposes to validate backups.
• Installation, configuration of Oracle Real Application Custer (RAC) 10g/11g.
• Upgrade databases on-premises and AWS from Oracle 10g to 11g to 12c.
• Migration of Oracle databases from on premises physical servers to AWS Cloud and to VMWare.
• Design, Install and configure Active Data guard and Physical/Logical standby Databases on-premises and AWS Cloud for Web based critical applications like Remedy, Isites, and Weblogic applications and for Report generation. Performed Data guard Switchover and Failover for maintenance and periodic testing.
• Installed and configured Oracle Enterprise Manager 13c Grid and configured Monitoring of all databases on-premises and AWS ec2 and RDS instances using central OEM 13c grid.
• Installed and configured Gloden Gate between several Databases at Schema/Database level. Used Gloden Gate for migration from on-premises to AWS Cloud. Configured Gloden Gate between Databases in AWS Cloud. Automate Gloden Gate monitoring and performance.
• Install periodic Security Patches as necessary. Perform regular Releases to Applications and Databases as scheduled by Release management.
• Performed Performance monitoring, tuning, troubleshooting Databases using OEM 13c/AWR and ADDM reports to view/analyze and fix performance issues.
• Create and maintain users, roles and grant permissions.
• Performed Export/Import using Data pump to refresh Database schemas.
• Performed Cloning/Refresh/Recovery of OLTP and DWH Databases for Development/Testing/Stage.
• Provide ON CALL PRODUCTION SUPPORT for Oracle/MS SQLSERVERS/MySQL Databases and Applications.

Confidential, MA

Database Administrator

Responsibilities:

• Provide database production support and maintenance of Oracle 9i/8i/805 databases on UNIX (Sun Solaris 5.7)/NT (4.0) Servers for Automated Toll Revenue Collection System (ARCS) Application 24x7 Production Support. Implemented proactive procedures for databases health monitoring and optimal production database performance. Design, develop and configure HOT STANDBY database for graceful switch over to STANDBY in teh event of Production database failure
• Developed database backup procedures, using Recovery Manager (RMAN) and Recovery Catalog to perform Backup and Recovery of databases. Performed database recovery using RMAN and recovered sql statements using logminor utility. Performed database and application tuning to enhance performance. Implemented even distribution of I/O incorporating storage arrays
• Designed, configured, and installed production, development, and test database environments on Solaris/NT platforms, including design, security, capacity planning, disaster recovery, upgrade, migration, and maintenance of system. Design, Develop and Configure 9i database structures for Transaction History database wif Partition tables, materialized view. Supported developers in tuning Database and Application for optimal performance, monitor Database growth and provide Database capacity planning for future expansion

Confidential, MA

Database Administrator

Responsibilities:

• Provide database consulting in design and development of GALAXY Marketing promotion DATA MART system comprising (CMS, CAS, PTS) databases for Confidential using Valex application. Involved in Star Data modeling, design, creation and maintenance of large relational database Warehouse. Configured multiple databases on Oracle 806 Instances on HP-UX 9000
• Performed Schema design using Power Designer for logical/Physical model. Analyzed technical requirements and implemented source extraction, transformation and automated data loading to refresh and update database using SQL* LOADER. Implemented backup recovery strategy, monitoring database growth and performance enhancement. Providing development support for staff developers
• Developed and Implemented HOTBACKUP and RECOVERY strategy and STANDBY database for high availability. Configured and Installed Oracle Enterprise Manager 204 and Implemented SNMP configuration for database monitoring from central management station. Performed database Tuning and PARTITIONED TABLES for performance enhancement and improved response time