PROFESSIONAL SUMMARY:

• 12.5 years of experience in Database Administrator managing different environments on 24x7 PROD and DEV,TEST.
• Working as a Confidential CLOUD AWS and Oracle - DBA.
• Have Valid H1B Visa.
• 100% ITIL Process.
• Expertise in Oracle DB architecture, oracle database administration, Database design,
• Expertise in allocating system storage and planning for future storage requirement.
• Creating primary database structure (Tablesapce) and objects (tables, views and indexes).
• Patching, Upgradation.
• Data guard configuration
• RAC Installation and Configuration.
• Golden Gate Installation and Configuration in Oracle 12C R2 .
• Datacenter Migration RAC to Non-RAC,RAC to RAC with DATAGAURD.
• Migration cross platform window to Unix DB.
• Migration in Cloud.
• Worked in Exadata databases.
• Handled MongoDB
• Worked NoSQL Oracle.
• Good knowledge on golden gate technologies and excellent troubleshooting skills.
• Backing and restoring the database.
• Managing more than 500 databases with a consumed size more than TB.
• RMAN backup and Recovery.
• Cloning the database.
• Planning for application (SQL) and Performance Tuning using Statspack,AWR, Explain plan.
• Develop/write PL-SQL procedure,function,Triggers,Package.
• Experienced in tuning of ERP jobs, time, CPU consuming SQL queries.
• Resolving connectivity problems with Oracle database.
• Good command over Utilities like Export, Import.
• AWS Solutions Architect Associate/Professional Certified.
• Designing and deploying dynamically scalable, highly available, fault tolerant, and reliable applications on AWS.
• Selecting the appropriate AWS service based on data, compute, database, or security requirements.
• Migrating complex, multi-tier applications on AWS.
• Segregate defined roles and responsibilities of system users by creating user groups. Use groups to assign permissions to IAM users.
• Clearly define and grant only the minimum privileges to users, groups, and roles that are needed to accomplish business requirements.
• Use roles for applications that run on Amazon EC2 instances.
• Use access levels (list, read, and write and permissions management) to review IAM permissions.
• Creating S3 Bucket and managing data in S3 bucket with different Zone based.
• Responsible to create EC2 Instance and configure the Server clustering.
• Identifying appropriate use of AWS architectural best practices.
• Estimating AWS costs and identifying cost control mechanisms.
• Define and deploy monitoring, metrics, and logging systems on AWS.

TECHNICAL SKILLS:

RDBMS: Oracle 9i,10g,11g,12C, Confidential CLOUD DBA

Programming languages: SQL Developer,PL/SQL

Operating Systems: Windows/2003, Red Hat Enterprise Linux Advanced Server (RHEL AS 4) and (RHEL AS 5) Solaris, AIX, HP UX

Replication Tool: Cloud

Golden Gate: AWS Solutions Architect-Associate

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Environment: Red Hat Enterprise Linux Advanced Server 5, 4(RHEL AS5), Confidential AIX, Solaris.

Responsibilities:

• Oracle 10g, 11g, 12C database build and Configuration.
• Support CR for Prod /Pre prod.
• Migrate to Cloud database.
• Working NoSQL Oracle.
• MongoDB.
• Oracle Database designing, creation and configuration.
• Understand the business and requirements based on discussions with Client.
• Based on documentation and discussions, designing the Database.
• Datacenter Migration RAC to Non-RAC,RAC to RAC with DATAGAURD.
• Golden Gate Installation and Configuration in Oracle 12C R2 Uni-direction and Bi-directional .
• Migration cross platform window to Unix Oracle DB.
• Developing Database Backup/Recovery Architecture for production Database
• Creation of associated database objects including tables, indexes, views, etc.
• 4+4 RAC setup with Datagaurd 11g,12C.
• Upgradation.
• Datagaurd configuration.
• Refresh the database using Expdp/Impdp.
• Troubleshooting Golden Gate issues.
• Managing all Daily Database Maintenance Issues.
• Responsible for total back-end configuration for these projects.
• Oracle Software Installation/Oracle upgrades on client side.
• RMAN backup configuration and recovery for Route to Live.
• Cloning the database.
• Resolving connectivity problems with Oracle database.
• Tuning Sql Statements.
• Provide performance tuning solution to app team.
• Troubleshooting and Problem Solving.
• Setting up TNS connectivity between client workstation & Oracle Server.

Confidential

Database Administrator

Environment: Red Hat Enterprise Linux Advanced Server 5, 4(RHEL AS5), Confidential AIX, Solaris.

Responsibilities:

• Oracle 10g, 11g, 12C database build and Configuration.
• Support CR for Prod /Pre prod.
• Oracle Database designing, creation and configuration.
• Understand the business and requirements based on discussions with Client.
• Based on documentation and discussions, designing the Database.
• Datacenter Migration RAC to Non-RAC,RAC to RAC with DATAGAURD.
• Golden Gate Installation and Configuration in Oracle 12C R2 Uni-direction and Bi-directional .
• Migration cross platform window to Unix Oracle DB.
• Developing Database Backup/Recovery Architecture for production Database
• Creation of associated database objects including tables, indexes, views, etc.
• 4+4 RAC setup with Datagaurd 11g,12C.
• Upgradation.
• Datagaurd configuration.
• Refresh the database using Expdp/Impdp.
• Troubleshooting Golden Gate issues.
• Managing all Daily Database Maintenance Issues.
• Responsible for total back-end configuration for these projects.
• Oracle Software Installation/Oracle upgrades on client side.
• RMAN backup configuration and recovery for Route to Live.
• Cloning the database.
• Resolving connectivity problems with Oracle database.
• Tuning Sql Statements.
• Provide performance tuning solution to app team.
• Troubleshooting and Problem Solving.
• Setting up TNS connectivity between client workstation & Oracle Server.

Confidential

Database Administrator

Environment: Red Hat Enterprise Linux Advanced Server 5, 4(RHEL AS5), Confidential AIX, Solaris.

Responsibilities:

• Support Prod and Dev,Test.
• Oracle Database designing, creation and configuration.
• Understand the business and requirements based on discussions with Client.
• Based on documentation and discussions, designing the Database.
• Developing Database Backup/Recovery Architecture for production Database
• Creation of associated database objects including tables, indexes, views, etc.
• Develop/write PL-SQL procedure,function,Triggers,Package.
• Creating & adding data files to table spaces.
• Creating Users and Granting Privileges.
• Up gradation 9i,10g to 11g R2.
• Patching.
• Golden Gate Setup 10g,11gUni-direction and Bi-directional .
• Refresh the database using Expdp/Impdp.
• Troubleshooting Golden Gate issues.
• Troubleshot golden gate.
• Managing all Daily Database Maintenance Issues.
• Responsible for total back-end configuration for these projects.
• Oracle Software Installation/Oracle upgrades on client side.
• RMAN backup configuration.
• Rman DB Cloning the database.

Confidential

Database Administrator

Environment: Red Hat Enterprise Linux Advanced Server 5, 4(RHEL AS5), Confidential AIX, Solaris.

Responsibilities:

• RAC Installation and Configuration.
• Data gaud setup.
• Worked as a Oracle Core and Apps -DBA.
• Oracle Database designing, creation and configuration.
• Understand the business and requirements based on discussions with Client.
• Based on documentation and discussions, designing the Database.
• Developing Database Backup/Recovery Architecture for production Database
• Creation of associated database objects including tables, indexes, views, etc.
• Creating & adding data files to table spaces.
• Creating Users and Granting Privileges.
• Worked in Exadata(X3,X4 Machines).
• Managing all Daily Database Maintenance Issues.
• Responsible for total back-end configuration for these projects.
• Oracle Software Installation/Oracle upgrades on client side.
• RMAN backup configuration.
• Cloning the database.
• Worked as an Sql Server- DBA
• Resolving connectivity problems with Oracle database.
• Tuning Sql Statements.
• Setting up TNS connectivity between client workstation & Oracle Server.
• Monitored and troubleshoot for Coke Applications.
• Member of interview panel.

Confidential

Oracle Developer and Associate Database Administrator

Environment: Red Hat Enterprise Linux Advanced Server 5, 4(RHEL AS5), Confidential AIX, Solaris.

Responsibilities:

• Understand the business and requirements based on discussions with Client.
• Creating Users and Granting Privileges.
• Writing Function, Stored procedure, Trigger, Body packages.
• Managing all Daily Database Maintenance Issues.
• Responsible for total back-end configuration for these projects.
• Based on documentation and discussions, designing the Database.
• RMAN backup.
• Resolving connectivity problems with Oracle database.
• Supported Application development team.