SUMMARY

• Over 14 years of IT experience wif Database Administration/Application Support, Oracle Developer, System Administration, Linux, Sun Solaris, AIX and Windows environment wifin several industries: Telecom, Finance, Manufacturing, Engineering, Oil and Gas and Safety Industry
• Gathering client’s application requirements, upgrading, patching and fixing bugs wif a variety of databases such as Exadata 8i, 9i, 10g, 11g(could and non cloud) and 12c.
• Worked as Technology Architect for various Golden Gate Projects for replication, Consiliation to Dataware house
• Proficient knowledge and execution in Oracle Golden Gate, REAL APPLICATION CLUSTER (Solaris/Linux) on Oracle 10g and 11gr2, SDLC (PRODUCTION, USER ACCEPTANCE TEST, DEVELOPMENT), Performance Tuning, backup and recovery through Datapump/RMAN, Cloning Database, Loading Data, Creating database objects, Fusion middleware(Weblogic, RCU, Form & Report, OSSO, OID)
• Proficiency in creating and managing user, roles, privileges, profile, schemas
• Manage day - to-day database administration tasks like Database creation, User creation, Performance tuning, Tablespace usage, Monitoring alert log, trace file, monitoring disk usage, database backup logs etc.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 10 SPRAC, Red Hat Linux, HP-UX, AIX, Windows NT/ 2000/2003/2005 Server, Windows 7/Vista/XP/2000/98

RDBMS: Exadata, Cloud base Oracle databases 12c, 11gr2, 11gr1&2/10gr2/ 9i/8i, OEM 12c SQL Server 2008, MySQL 4.1, Cassandra

Programming Language: SQL, PL/SQL, C, Java

Scripting Languages: Linux/Solaris/AIX Bash Shell Scripting, HTML, CSS, JavaScript, VBscript, Java, C, C++

Tools: AWS, Devops, Actifio, Oracle Golden Gate, Jenkins, Fusion middleware(Weblogic, RCU, Form & Report, OSSO, OID), Oracle SQL Developer, OBIEE, Oracle Streams, Data modeling using Erwin or SQL developer, Toad, Informatica (ETL), Blade Logic, Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: OLTP, OLAP, SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import, Statspack, AWR, SQL tuning, TKPROF extensively, Oracle Golden Gate

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Senior Oracle DBA

Responsibilities:

• Gather client requirements.
• Actifio installation and configuration
• Deploy scripts using Jenkins
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Resolve day today Golden gate issue
• Oracle OEM 12c/ OEM 13c server and client
• Involved in installation and configuration of Oracle 11gr2/12c database on Prod and non-prod
• Involved in resolving high CPU% utilization issue
• Database patching
• Configure Oracle ASM
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Installation, configuration of Golden Gate.
• Plan database scalability as per growth on all database environments.
• Deploying scripts using Jenkins/Gits.
• Handle user management and storage management.
• Database performance and tuning
• SQL query optimization
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot Active Data Guard issue
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c/13c Agent into prod and non-prod server.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Develop, test and run Shell scripting for automation database activities.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Prepare engineering documents

Confidential, Alpharetta, GA

Senior Oracle DBA

Responsibilities:

• Gather client requirements.
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Resolve day today Golden gate issue
• Oracle OEM 12c/ OEM 13c server and client
• Involved in installation and configuration of Oracle 11gr2 database on Prod and non-prod and in Cloud environment.
• Involved in high CPU% utilization issue
• Database patching
• Configure Oracle ASM
• Upgrade 11g to 12c OEM.
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Upgrade 11gr2 database to 12c in Dev environment.
• Plan database scalability as per growth on all database environments.
• Handle user management and storage management.
• Database performance and tuning
• SQL query optimization
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot high CPU utilization
• Trouble shoot Active Data Guard issue
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c Agent into prod and non-prod server.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Prepare engineering documents

Confidential, Alpharetta, GA

Senior Database DBA

Responsibilities:

• Gather client requirements.
• Develop Database object like Procedure, function, Packages etc.
• Support Indigo, EBDR, EProgesa database OLTP applications.
• Provide Golden Gate support to replicate data from Oracle to MS SQL server
• Install Oracle database in SAN/NAS
• Database performance
• Database patching
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Analyze Data
• Prepare Business report as per client need
• Data modeling using Toad/SQL Developer
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot high CPU utilization
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c Agent into prod and non-prod server.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Prepare engineering documents

Confidential

Senior Oracle DBA

Responsibilities:

• Gather client requirements.
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Resolve day today Golden gate issue
• Involved in Migration from Solaris to Linux database in 12c cloud environment on Prod and non-prod.
• Oracle OEM 12c server and client
• Installing and configure Informatica and perform Data extraction, Transformation and Loading into Target side
• Involved in installation and configuration of Oracle 11gr2 database on Prod and non-prod and in Cloud environment.
• Involved in high CPU% utilization issue
• Database patching
• Configure Oracle ASM
• Upgrade 11g to 12c OEM.
• Managing Oracle Streams
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Upgrade 11gr2 database to 12c in Dev environment.
• Plan database scalability as per growth on all database environments.
• Standardization of Database environment in all databases.
• Handle user management and storage management.
• Database performance and tuning
• SQL query optimization
• Upgrade databases from 10g to 11g
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot high CPU utilization
• Trouble shoot Active Data Guard issue
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c Agent into prod and non-prod server.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Manage MySql database backups.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Able to work on ITIL Framework
• Prepare engineering documents

Confidential, Buffalo, NY

Senior Oracle DBA

Responsibilities:

• Gather client requirements.
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Involved in Migration from DB2 on Mainframe Database object into Oracle on Linux Database Objects.
• Involved in RE-Data Modeling of Database Objects.
• Educate and guide DB2 developers to develop programs in Oracle environment.
• Installing and configure Informatica and perform Data extraction, Transformation and Loading into Target side
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Install and Configured Oracle 11gr2 database on Physical and Virtual servers.
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Plan database scalability as per growth on all database environments.
• Standardization of Database environment in all database environments.
• Handle user management and storage management.
• Manage RAC using Oracle Cluster ware, Grid Control
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Involved in Configuration of 2 nodes RAC on Sun Solaris 10 SPARC 64 bit wif Oracle 11gr2 Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 wif Oracle 11gr2 and ASM
• Install and setup Oracle Enterprise Manager 12c on Linux environment.
• Account holder of all Database servers as environment.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to database performance
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Scheduling jobs using Crontab.
• Involved in database replication using Golden Gate
• Develop, edit, test of Shell scripts
• Involved in setting up and maintain Dataguard.
• Addressed any issues raised in Alert logs and trace files.
• Document all installation and configuration steps

Confidential

Senior Oracle DBA

Responsibilities:

• Gather client requirement to provide database for Qfund application.
• Involved in Configuration of 4 nodes RAC on Red Hat Enterprise Linux Server release 5.8 wif Oracle 11gr2 on ASM LUN on EMC Power Path/Multipath/DMV.
• Exadata interaction
• Provide support to Data Center as when needed
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Installing and configure Informatica and perform Data extraction, Transformation and Loading into Target side
• Focal point for creating and managing databases 11g for all new projects in Validation environment (Linux, Windows, Exsi VMware) where application is based on J2EE.
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Install and configure MySql server.
• Install and Configured Oracle 11gr2 database on Physical and Virtual servers.
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Plan database scalability as per growth on all database environments.
• Standardization of Database environment in all database environments.
• Handle user management and storage management.
• Manage RAC using Oracle Cluster ware, Grid Control
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Involved in Configuration of 2 nodes RAC on Sun Solaris 10 SPARC 64 bit wif Oracle 11gr2 Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 wif Oracle 11gr2 and ASM
• Install and setup Oracle Enterprise Manager 12c on Linux environment.
• Account holder of all Database servers as environment.
• Migrate Sql server data to Oracle database using T-SQL and PL/SQL.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to database performance
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Scheduling jobs using Crontab.
• Involved in database replication using Golden Gate
• Develop, edit, test of Shell scripts
• Involved in setting up and maintain Dataguard.
• Addressed any issues raised in Alert logs and trace files.
• Document all installation and configuration steps

Confidential

Senior Oracle DBA

Responsibilities:

• Oracle Golden Gate Team Lead for Balance Manager and Mediation
• Manage OLAP and OLTP applications
• Reviewing Database failover settings of RAC databases.
• Design and develop Oracle Golden Gate for Balance Manager Mediation
• Create and maintain Data Dictionary of specific Balance Manager and Mediation Databases.
• Involved in configuring Oracle Golden Gate on Solaris and Linux
• Involved in Data Domaining project
• Install Oracle database in SAN/NAS
• Using Informatica ETL
• Data Modeling
• Create Database Dictionary
• Create engineering documentation for Oracle Golden Gate
• Monitoring RAC environments
• Involved in designing Oracle RAC 11gr2 for ATT applications on Solaris and Linux
• Involved in installing Oracle 11gr2 RAC Solaris and Linux
• Create engineering documentation for Oracle RAC 11gr2
• Involved in configuring Oracle 11gr2 RAC Solaris and Linux
• Design, develop and test Failover of databases
• Capacity planning
• Resolving daily Database issues
• Provide database solutions to ATT’s ADBA and PDBA groups.