Oracle Aws

Kamal

Mobile : +1-469-***-****

E-mail : **********@*****.***

Professional Summary:

Having Total 15 Years IT experience as Sr. Oracle, PostgreSQL DBA, Team Lead Database Administrator and AWS, Hybrid Cloud DBA Architect in Production and Non-Production environment support for DBA Operations.

Experience on AWS/Hybrid Cloud and Oracle-DBA for more than 500 Prod Db’s.

Working on Data migration On-premises to AWS Cloud.

Experience on Amazon EC2, Amazon S3,I RDS, Amazon Elastic Load Balancing and other services of the AWS family.

Design and Implementation of DBaaS strategy - Database as a Service.

Kubernetes deployment for stateful Applications (MongoDB, Postgres, Casandra)

Hardening of Kubernetes POD, Nodes, Containers (Security), Ensuring Tiller Security

Golden Gate Installation and Configuration in Oracle 12C R2.

Experience on POSTGRES DB.

Database migrated from on-premises to AWS cloud RDS (Oracle 12C,19C, SQL Server, postgresDB).

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 (Tablespace) and objects (tables, views and indexes).

Experience on Patching, Upgradation.

Experience on Exadata machines.

Experience on RAC Installation and Configuration and Data guard configuration.

Datacenter Migration RAC to Non-RAC, RAC to RAC with DATAGAURD.

Migrated cross platform window to Unix DB.

Setup 13c OEM OMS Server Installation and configuration for database monitoring.

Applied WLS/PSU patch in 13c OEM OMS.

13C OEM agent Installation and discovery the target for database monitoring.

Configured ruleset for monitoring region wise.

Managing more than 500 databases with a consumed size more than TB.

Experience on RMAN backup and Recovery and Cloning the database.

Planning for application (SQL) and Performance Tuning using Stats pack, AWR, and Explain plan.

Installed and Configured SolarWinds DPA tool for MSSQL, Oracle, Postgres-DB.

Develop/write PL-SQL procedure, function, Triggers, Package.

Experienced in tuning of ERP jobs, time, and CPU consuming SQL queries.

Resolving connectivity problems with Oracle database.

Good command over Utilities like Export, Import.

100% ITIL Process.

Strong teamwork, decision-making, documentation and analytical skills

Project Efficiency & Lead Effective Teams with Agile Methodology.

AWS Services Experience

Database migration DMS, EC2 Instance creation, S3 bucket creation for project requirement,VPC,RDS.

Creating and using an IAM Policy for IAM Database Access.

Create an IAM policy and role then attached DB access users.

DMS (Database Migration Services)

Database migration using Data Pump and RDS (Oracle, MSSQL).

Oracle database migrated On-promises to AWS, Azure.

Oracle database migrated On-promises to ORAAS and Oracle to PostgresDB.

PostgreSQL DB

Install and configure PG database in window/Linux.

Patching and upgrade the DB.

Migrated the DB On-promises to AWS Cloud.

Configured the replication

Backup and restore (All, fulldmp, tables etc.).

Resolved performance issue query.

Certifications

Oracle certified professional (OCP) Database Administrator DBA),

AWS Certified Solutions Architect-Associate,

AWS Certified Solutions Architect-Professional.

Education

B.E (Electronics and communication Engineering) from Japiaar MIT in Chennai Affiliated Anna University with First Class.

Technical Skills:

• Database

:

Oracle (10g,11g,12c,19c) MS SQL Server 2019, PostgresDB, MongoDB

• Operating System

:

RHEL6.7, Windows 2012 R2,2016

• HA & DR

:

Dataguard, RAC, Replication Golden Gate

• Language/Scripting

:

PLSQL, Python, shell

• Backup Tools

:

Rman, Expdp

• Monitoring Tools

:

OEM 12C,13C,19C, Solar winds and Tivoli

• Ticketing Tools

• Cloud

:

:

BMC Remedy, HP Service Center, TSRM, ConnectWise, ITSM& JIRA

AWS, AZURE, Hybrid

Professional Experience

WIPRO Technologies, as an Oracle DBA (Teach Lead) from April 2013 to till date.

IBM, as an Oracle DBA from May 2011 to April 2013.

Capgemini, as an Oracle DBA from August 2009 to May 2011.

Firstline InfoTech, as an Associate Consultant (DBA) from Oct 2006 to Aug 2009

Projects:

Project

Citi Bank US (Jan 2018 to Till Date).

Role

Database Administrator (Prod, Pre-prod & Dev) and AWS, CITI CLOUD DBA For 11g,12C,19C.

Environment

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

Database

Oracle 11g, 12C,19C, PostgreSQL 11,12

Domain

Banking.

Responsibilities:

Design and Implementation of DBaaS strategy - Database as a Service on Cloud and On-Premises data center.

Oracle 12C,19C database build and Configuration.

Oracle DB migration on promises to AWS.

Working on Postgres DB with AWS for few applications.

Supporting to MSSQL DB on Azure cloud.

Install and configured PostgreSQL.

Patch/upgrade PostgreSQL in a HA architecture.

Migrated DB Ora to PostgreSQL.

Analyze and resolve performance issues for PostgreSQL DB’s.

Database migrated from on-premises to AWS cloud RDS (Oracle, PostgreSQL, SQL Server).

Extensive experience on Single Click Oracle Instance provisioning model.

Support service now, JIRA, CR for Prod /Pre-prod.

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.

Provided Support for golden gate related issues.

Closely working with the CITI DevOps central team to integrate DBaaS solution using python automation script.

Setup 13c OEM OMS Server Installation and configuration for database monitoring.

13C OEM agent Installation and discovery the target for database monitoring.

Migrated OEM 12c to 13c OEM.

Applied OMS patch on 13c and 12c OMS.

Installed and Configured SolarWinds DPA tool for MSSQL, Oracle, PostgresDB.

Implemented SolarWinds Monitoring for Oracle, MSSQL, SYBASE, PostgresDB.

Kubernetes deployment for stateful (MongoDB, Postgres, Casandra)

Design and Implementation of Kubernetes infrastructure to onboard various Microservices and Database Applications in On-Prem Kubernetes

Build and Promotion of various flavors of PostgreSQL, MongoDB

Implementation of vulnerability assessment mechanism for Containers

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.

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.

Project

LLOYDS BANKING GROUP UK (April 2013 to Dec 2017).

Role

Database Administrator (Prod, Pre_prod, Test & Dev) ) For 10g, 11g,12C.

Environment

Azure, Red Hat Enterprise Linux Advanced Server 5, 4(RHEL AS5), IBM AIX, Solaris.

Database

Oracle 10g, 11g, 12C.

Domain

Cloud

Banking.

Google Cloud

Responsibilities:

Oracle 10g, 11g, 12C database build and Configuration.

Support service now CR for Prod /Pre_prod.

Tested and supported Oracle DB migration on promises to AWS Cloud.

Datacenter Migration RAC to Non-RAC, RAC to RAC with DATAGAURD.

Golden Gate replication 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.

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.

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 for customer.

Setting up TNS connectivity between client workstation & Oracle Server.

Company

IBM (May 2011 to Apr 2013).

Project

SPRINT US.

Role

Database Administrator (Prod, Test & Dev).

Environment

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

Database

Oracle 10g, 11g.

Domain

Finance, Telecom.

Responsibilities:

Support Prod and Test.

Oracle Software Installation/Oracle upgrades on client side.

Up gradation 9i, 10g to 11g R2.

Patching.

Golden Gate Setup 10g, 11g Uni-direction and Bi-directional.

Refresh the database using Expdp/Impdp.

Install and configure the GG and Troubleshooting Golden Gate issues.

Managing all Daily Database Maintenance Issues.

Responsible for total back-end configuration for these projects.

RMAN backup configuration and clone the db.

Company

Capgemini (Aug 2009 to May 2011).

Projects

HMRC -CHIEF-STE UK, Coke US.

Role

Database Administrator (Prod & Dev).

Environment

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

Database

Oracle 10g, 11g.

Domain

Banking, Finance, Retail.

Responsibilities:

RAC Installation and Configuration.

Data gaud setup for HMRC application (reporting).

Worked as an Oracle Core and Apps -DBA.

Oracle Database designing, creation and configuration.

Developing Database Backup/Recovery Architecture for production Database

Creation of associated database objects including tables, indexes, views, etc.

Tuning Sql Statements.

Setting up TNS connectivity between client workstation & Oracle Server.

Monitored and troubleshoot for Coke Applications.

Member of interview panel.

Company

Firstline InfoTech (Oct2006 to Aug2009).

Projects

Vodafone India, Pune

Role

Oracle Developer and Associate Database Administrator (Prod, Pre-Prod, Dev & Test).

Environment

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

Database

Oracle 9i,10g, 11g.

Domain

Telecom, Finance.

Duration

Oct2006- Aug2009

Role and Responsibilities:

Understand the business and requirements based on discussions with Client.

Creating Users and Granting Privileges.

Provided support based on application team remedy ticket.

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.

Contact this candidate