SUMMARY:

• Senior Database administrator (DBA) with 16 years of extensive experience in Capacity Planning, designing, testing and supporting database solutions in Oracle, MSSQL and SQL Server.
• Technically proficient and a team player who can undertake responsibilities beyond job titles.
• Responsible for designing & implementing database solutions that improve business functionality.
• Encompassing installation, configuration, patch installation, backup and recovery, upgrades, cloning, migrations, EXADATA administration, performance tuning of oracle databases across 12c/11g/10g/9i versions on Linux, AIX and Solaris platforms with Oracle RAC,ASM, VCS and Sun cluster, Goldengate and Data Guard.

TECHNICAL SKILLS:

• Exadata Administration of X2,X3,X4,X5,X6
• Oracle 9i,10g, 11g and 12c,
• Data Guard
• Active Data Guard
• Fast Start Fail Over
• Real Application Clusters (RAC)
• ASM
• Oracle Grid Control
• Oracle Weblogic
• OBIEE
• Oracle Portal
• Peoplesoft Administration
• (OMS/OEM)
• (RMAN)
• NOSQL
• MYSQL administration
• SQL SERVER 2008
• Logminer
• Golden Gate
• Datapump
• Database Patching
• Database Cloning
• MySQL
• MS SQL
• Shell Scripting
• PLSQL
• Oracle Apex
• Python
• SQL Loader
• RHEL
• Oracle Linux
• Solaris
• AIX
• Sun Clusters
• Veritas Cluster Server VCS
• data dog
• service now
• Shareplex
• Remedy
• Delphix
• Star Schema
• 3NF data warehouse models
• ETL.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Responsibilities:

• Participation in the daily operational support and design of Oracle databases 12c, 11g and systems across the enterprise and troubleshooting the performance issues using OEM Grid control o n various databases across multiple platforms like MS SQL, Oracle on Windows, AIX, Linux. Intent is to consolidate and build next generation database platform on Oracle Exadata with 12c. Active Data Guard Administration. RAC administration of multiple nodes.
• Performance enhancement. database design, schema design, service design etc.
• Replication using Goldengate/Shareplex.
• Proficient in developing and maintaining of functions, procedures, triggers, indexes using MYSQL database programming language. converting all databases from MyISAM format to Innodb storage engine to improve referential integrity as well as to increase performance

Confidential, Atlanta, GA

Responsibilities:

• Cloning/Refreshing of databases using RMAN, HUR and export/import as a part of weekly/monthly release. GOLDNEN GATE administration to replicate changes on all nodes for policy release to make changes into policy required by clients. Also testing with Shareplex for Replication. database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware . Audit reporting for all production databases, CRS development work, closely working with developers. On call rotation and ticket handling as per users requests, Working on VLDBs for application testing for Data warehouse projects
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware. Managing heap tables etc.
• Using Delphix to take snapshots of databases, Data Guard for Confidential
• Taking snapshots of database using DELPHIX. DevOPS: framework that allows development, Quality assurance and operations that allows to meet customers needs.
• SQL SERVER database administration for small projects

Confidential, TN

Responsibilities:

• Day to day activities of Change requests, testing and closely working with developers and routine of opening Service request with ORACLE to get support to resolve issues..Table partitioning for archiving the old data based on years in data warehouse system, Day to day handling of tickets generated by users to troubleshoot, tuning or administration related tasks for databases.
• Refresh/clone of databases for testing and training, Validating backup using RMAN. Monitoring of databases. Performance and tuning in data warehouse environment, Schema design and EDW maintenance, tuning of sqls., Installation of OEM grid control agents on all servers for monitor and administration purposes.
• SQL SERVER and MYSQL support for basic administration and troubleshooting.

Confidential, Atlanta, GA

Responsibilities:

• Refresh /restore of databases for testing and training, Validating backup using RMAN. Monitoring of databases in OEM Grid control. Troubleshooting required for testing and implementation. Managing RAC environments using ASM Performance and Memory Utilization for Environment. Worked closely with developers to optimize queries. Set up of the Test Environment For two nodes RAC on 10g using ASM.
• Performance and Memory Utilization for Environment. Working closely with developers to optimize queries. Upgrades and validating CRs as a QA tester and replication of environment for Dev and QA testing. SQL SERVER database administration for small application like setup, monitoring and backup.

Confidential, Atlanta GA

Responsibilities:

• Administration of all batch and application servers of all three environments (DEV, QA and PROD) with help of performance monitor and OEM grid control for PeopleSoft, Portal and Banner Applications on operating, Table partitioning for archiving the old data based on years.
• Implemented Oracle 10g, 11g Streams and Active Data Guard for replication and high availability.
• Implementation of OWB, APEX in Data warehousing, OEM grid control for monitoring all databases. Worked on Oracle Portal and Weblogic.
• Worked on Quest stat software used for change management version control of schema objects in PeopleSoft financial databases and others Migration from Dev or QA environment to Production on Data warehouse. PeopleSoft and Banner databases. Working on Red dot Application with backend as SQL SERVER database. Administrating
• Tested secured listener, data encryption, RMAN backup encryption using Oracle Advanced security features. Worked on DSS project bases on data ware housing using OWB and Oracle Application Portal. Partitioning of big tables for archiving purpose.

Confidential, Scottsdale, Arizona

Responsibilities:

• Installation of 10g RAC on Linux for testing purpose and closely worked with Oracle to resolve RAC issues.
• On call rotation to provide 24/7 support & day to day change management implementation i.e. deploying database changes at schema and object levels like Function, Procedures etc through ticket system from DEV to QA and QA to production. Installation of OEM grid control Agent 10g on all servers to make it easy for monitoring them through OEM, Intensive monitoring of databases for all kind of alerts and warnings through OEM.
• Implementation of data guard setup for standby databases.
• Consolidation of Dev/Test Environment to release the unused hardware and using them for testing purpose.
• Restoration of databases using RMAN to validate the backups, Capacity planning for future growth and space requirement calculation done on basis of object growth report as per schedule.

Confidential, Orlando FL

Responsibilities:

• Planning of Disaster Recovery for critical 24x7 production databases. f 9i and 10g databases with day to day activities.
• Tools like TKPROF, 10g Tuning Advisor, segment advisor, ADDM like features of 10g for performance issues.
• Capacity Planning and sizing for future growth of objects in databases. Operating tickets to implement changes of code along with modification and creation of objects in development as well as production environment.

Confidential, TN

Responsibilities:

• Implementation and maintain Physical Database Design (Creating and maintaining Tables, Table Spaces, Indexes, Schemas, Views, and Packages etc) & Archive destinations
• Used RMAN backups and/or Export/Import to migrate data. Configured and scheduled RMAN jobs. Installed and scheduled STATSPACK for collecting database performance statistics.
• Responsible for Performance Tuning at system level, database level and application level. Changed Oracle Database parameters in SPFILE and init.ora file for better performance. Optimised SQL script. Used Oracle Enterprise Manager, Explain Plan, TKPROF. Setting up OEM alerts and e - mail notifications.