SUMMARY:

Surya has total IT experience of 17 years as Database Architect/Database Administrator in Production Support, Upgrading, Installing, Data Analysis, Data Integration, Data Migration & Data Modelling, Configuring and Maintaining VLDBs and Production databases. Oracle Certified Professional (OCP) Oracle Database Administration. Extensive experience on RAC Installation on windows/Linux, Backup & Recovery Setup, DataGuard Configuration, Replication using GOLDEN GATE, Database creation & Production Support on EXADATA.

• Developed implemented database designs to meet business requirements
• Good knowledge of AWS concepts
• Applied data modelling concepts to develop logical and physical data models
• Upgraded 10g/11g databases to 12c on AIX/Linux/EXADATA on ASM/NON - ASM environments
• Performed replication on RAC/NON-RAC using Golden Gate
• Implemented Database replication using HITACHI storage replication
• Supported BIFS using Oracle Business Intelligence 12c for Financial Institutions
• Performed OS/DB/CPU/Application patching and any infrastructure changes including refreshes
• Performed replication using MVs and Golden Gate to replicate data from PROD
• Design, implement and test strategies for backup and recovery
• Manage End-to-End Integration process, Coordinate ITO vendor/hosting vendor/business
• Enhanced Security at Server level, Database level and Application level using - Roles & Privileges, Auditing, Fine-grained Auditing, Virtual Private Database (VPD) & Label Security
• Used Data Stage ETL tool - Created Logical/Physical Designs, Unit Testing, Performance Tuning, Job Reports, Backups, Job Sequencing
• Provided High Availability for 24*7 applications using - Perf & Diag Pack, AWR, ADDM
• Setup and Configured DATAGUARD on Test & PROD servers

TECHNICAL SKILLS:

Oracle Database Administration: Shell Scripting, ORACLE 12.1.02/11.2.0.3/10.2.0.4 , Awk, Sed, Bash, RAC

Clusterware: 11gR1/R2, ASM 11gR1/R2, DB 11gR1/R2

OS: Linux 5.0, HP-UX, WINDOWS 2008/2003 Server

Replication: ETL

Datawarehouse: Golden Gate (Oracle - Oracle, Oracle - Sybase, Oracle - SQL Server), Informatica, Talend, Datastage, ODI, DB Artisan, Teradata

DBA Tools: OEM Grid Control (Performance Tuning + Diagnostic Pack) & StatPack, RMAN, Export/Import, TOAD 12.8, Erwin 9.6, SQL Developer Data Modeller, DB Artisan 9.7.1, Rapid SQL 8.6.0,  SQL server 2012,

Oracle New Features: Golden Gate, Exadata, CDB/PDB 12c

Third Party Tools: Putty, VNC, FSecure, SM9, COSIMA, SOM@SAP, Secure CRT 7.1, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, IRVINE CA

Database Architect / Snr. Database Administrator

Responsibilities:

• Daily deployments of critical applications to QA/PROD environments in ORACLE/SQL SERVER/SYBASE environments
• Trouble shooting production issues with Third Party vendors and with Oracle/MS/Sybase support teams on 24*7 basis
• Used extensively SAP Adaptive Server Enterprise for Sybase database administration and maintenance/deployments
• Supported critical business applications on day-to-day basis by organising meetings with Team Managers/Lead Developers/Project Team
• Performed Replication using Golden Gate for Non-RAC -> RAC, RAC-> RAC and also ORACLE -> SQL Server env (both uni-directional & Bi-directional)
• Co-ordinated with offshore teams on daily basis to meet the deadlines.
• Setup backup strategy for the customer and written scripts for Database Installations/ Automation of deployments/ Backup & Restore Operations/Performance Checks

Environment:

Database Administration: OEM 12c, TOAD 12.8, SSMS 2012, DB Artisan 9.7.1, Rapid SQL

Replication: Golden Gate 11g/12c

OS: Putty, Secure CRT 7.1

Performance: Splunk, Oracle Performance Tools - SPA/SPM/RAT,SQLT

Confidential, SAN RAMON, CA

Database Architect

Responsibilities:

• Migration of 10g Oracle DBs running on SUN SPARC to 12c Linux on ODA boxes
• Created of 12c RAC/NON-RAC DBs on ODA boxes
• Customized New 12c DBs to meet the application needs - data sync, compare oracle parameters, configure custom scripts/DB objects
• Provided security for the critical applications using Database Vault 12c and FGA
• Developed audit scripts to log the DB changes and Application Changes on Audit tables
• Replicated 10g data to 12c DBs using 11g/12c Golden Gate version
• Supported Development/Testing Teams during Unit Test/Smoke Test/Performance testing
• Provided ProjectTraining for Application/Development/DBA teams regarding new env
• Ensured meeting dead lines by coordinating with vendors & Oracle Support on 24*7 basis
• Maintained excellent communication with Network/Storage/DBA team and played as bridge between Management and other teams

Environment:

Database Administration: OEM 12c, TOAD 12.6, SQL Developer

Replication: Golden Gate 11g/12c

OS: Putty, Pagent, Puttygen, Xming, X2Go

Performance: Splunk, Oracle Performance Tools - SPA/SPM/RAT,SQLT

Confidential, NYC, NY

Database Architect

Responsibilites:

• Performed Data Analysis with End Users, Development Team, Business Analysts and DBA team Integrated GFE/PMC/IP systems to Base Database Management (BDM) system to support
• HYBRIS/OMS and many critical reports
• Designed/Installed/Configured 12c databases to support the new system on Linux environment Participated in data mapping discussions to finalyse the data received from many systems Created LDM/PDM using ERwin 9.6 & SQL Server Data Modellers and made changes as needed Executed Data loading to Oracle Database received in .xls, ascii, exp dumps using TOAD 12.6
• custom scripts, SQL Loader, SQL Developer
• Written Scripts to automate data loading, schema creation, audit and security

Environment:

Database Administration : OEM 12c, TOAD 12.6, SQL Developer

ETL : Informatica/Talend

Data Modelling : ERwin 9.6, SQL Developer Data Modeller

FTP : FSecure, WinSCP, FileZilla, Putty

OS : Putty, Pagent, Puttygen

Confidential, Houston TX

Database Architect / Snr.Database Administrator

Responsibilites :

• Implemented & Maintained Disaster Recovery for TEST/DEV/STAGE & PROD Environments Replicated Oracle Databases(11g/12c) using Golden Gate to ORACLE 11g/12c versions Resolved critical Golden Gate issues during replication on 24*7 with Oracle Support Performed Schema/DB level replications from prod to non-prod env using Golden Gat from RAC - RAC & RAC - NONRAC on AIX/Linux operating systems
• Developed complex queries for ODW (Oracle Data Warehouse) Application to run reports on database of size 22TB
• - Supported storage issues/Backup Strategies/Recovery Issues/Performance Issues with ODW application to support day-to-day jobs
• - Knowledge of Teradata – Writing SQL Queries / Indexing / Partitiong / Export-Import
• Written shell scripts for Golden Gate to determine status, reporting, daily summary reports Supported Critical Applications used by 1000+ users on 24*7 basis Implemented Backup & Recover strategy on Prod Environments using RMAN / FLASHBACK / SNAPSHOT / SHADOW-THIN IMAGE REFRESH technologies Provided Support during critical migrations - data migration / database migration / OS migration Performed CPU & one-off patches on Prod / Non-Prod environments new versions are released Trained Jnr. DBAs / End-users / Business Analyst regarding new database features Co-ordinated with Storage / Network / Unix / Application Teams across the globe during support
• Worked on EXADATA machines : create databases / performance tuning / setup backups Upgraded oracle databases from 11.2.0.4 to 12.1.0.2 and resolved post upgrade issues Written shell scripts for DB Adminstration, RMAN backups, Performance, Day-to-Day Checks Exibited excellent communication skills with end-users/technical teams/management

Environment :

Databases : Oracle 10g / 11g / 12c

Hardware: Linux 5.0 / AIX 7.1 / EXADATA

Tools: OEM 10g/12c, TOAD, SQL Developer, DB Artisan, PL/SQL, Shell Script, AWK, SID

Misc: COSIMA / SOM@SAP / SM9 / F-Secure / Putty / WinSCP

Confidential, Ridgeland, MS

Snr. Database Administrator/Architect

• Cellular South Inc. d.b.a. C Spire Wireless, headquartered in Ridgeland, Mississippi, is the eighth
• largest wireless provider in the United States is a provider of broadband internet and phone services.
• Day-to-day tasks
• Supported production oracle DB 10.2.0.4 on Linux platforms Supported development team of size 20 in enhancing project of the existing prod system Used Sybase power designer for data modelling, applying db changes & reverse engineering
• existing systems for documentation
• Tuned resource consuming querires on prod and dev systems using performance tuning tools - SQLT, AWR, EXPLAIN PLAN, ASH & ADDM Monitored changes using DB ADMIN tools - EMBARCARDERO DB Artisan & DB Change
• Manager, SQL Server DB Admin
• Participated in Partitions decision making, capacity planning & development analysis meetings Raised SRs to Oracle Support as-and-when required for analysing prod issues Support monthly maintenance tasks and resolved/supported critical issues on PROD

Environment:

Oracle DB : 10.2.0.4/11.2.0.1/11.2.0.3 SQL Server : 2005/2008/2012

OS : WINDOWS 7.0/LINUX-SUSE 11/SOLARIS 10/AIX 6.1

DB Admin : Putty, Win SCP, VNC Viewer, OEM 11g/12c, TOAD 11.6.0, SQL Developer 3.2.20, RMAN

Performance: AWR, SQLT, EXPLAIN PLAN, TRCANLYZR

Replication : Data Guard, IDR (Informatica Data Replication), MVs

Confidential, Colorado Springs, CO

Database Administrator / Architect

• Supported production oracle DB 10.2.0.4 on Linux platforms Supported development team of size 20 in enhancing project of the existing prod system Used Sybase power designer for data modelling, applying db changes & reverse engineering existing systems for documentation
• Tuned resource consuming querires on prod and dev systems using performance tuning tools - SQLT, AWR, EXPLAIN PLAN, ASH & ADDM Monitored changes using DB ADMIN tools - EMBARCARDERO DB Artisan & DB Change
• Manager, SQL Server DB Admin
• Participated in Partitions decision making, capacity planning & development analysis meetings Raised SRs to Oracle Support as-and-when required for analysing prod issues Support monthly maintenance tasks and resolved/supported critical issues on PROD

Environment : Databases : Oracle 10.2.0.4/11.2.03 on Linux 5.0, Data Modelling : Sybase Power Designer 15.2.0, OS Tools : Putty, WinSCP, TELSA, Tight VNC2.0.4, Performance : SQLT, TRCA, EXPLAIN PLAN, SQL Profiling, Development : SQL developer 3.1.07, SQL, PL/SQL,

DB Admin : OEM Grid Control, EMBARCADERO-DB Artisan, DB Change Manager