Aws Cloud Hybrid

Kamalakkannan D

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

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

Professional Summary:

Having 17+ Years IT experience as Sr. Oracle, PostgreSQL, Mongo DBA and AWS, Hybrid Cloud DBA in Production and Non- Production environment support for DBA Operations as team lead.

Experience on AWS/Hybrid Cloud and Oracle-DBA for more than 500 Prod DB’s (>1T in size).

Working on Data migration On-premises to AWS Cloud.

Experience on Amazon EC2, Amazon S3, 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, Cassandra)

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

Golden Gate Installation and Configuration in Oracle 12C R2,19c.

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 Oracle across window to Unix DB.

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

Applied WLS/PSU patch in 13c OEM OMS.

Experienced on Mongo DB (Installation and configuration, Replication, sharding, backup and recovery).

Configured ruleset for monitoring region wise.

Experience on RMAN backup 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 etc...

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.

Patch and upgrade the DB.

Migrated the DB On-promises to AWS Cloud.

Configured the replication (Repmgr)

Backup and restore (Basebackup, Logical).

Performance tuning and implementation of best practice.

Install, configure and maintain YUGABYTE database. 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 Anna University Chennai 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, Tivoli, Splunk and Nagios Ticketing Tools

Cloud

:

:

BMC Remedy, HP Service Center, TSRM, ConnectWise, ITSM& JIRA AWS, AZURE, Citi Hybrid

Professional Experience:

Goldman Sachs LLC as a Vice president (Oracle, PG DBA) from March 7th, 2022, to till date. WIPRO Technologies, as an Oracle DBA (Teach Lead) from April 2013 to March 4th, 2022. IBM, as an Oracle DBA from May 2011 to April 2013. Capgemini, as a Consultant (Oracle DBA) from August 2009 to May 2011. Firstline InfoTech, as an Associate Consultant (DBA) from Oct 2006 to Aug 2009 Project Goldman Sachs US (March 2022 to till date). Role Database Administrator (Prod, Pre-prod & Dev). Environment RHEL 6,7,8.

Database Oracle 11g, 12C,19C, Postgres.

Responsibilities:

Develop database automation solution to help customers develop, test and operate software more effectively, with use of automation.

Provide subject-matter expert (SME) level operational support for development and production database systems.

Collaborate on System Architecture with peers and partner with Business Analysts, Project and Product Managers to meet business requirements.

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

Oracle 12C,19C, Postgres database build and Configuration.

Upgrade the databases from lower version to higher.

Extensive experience on Single Click Oracle Instance provisioning model.

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

Datacenter Migration using DB mobility for DATAGAURD.

Provided Support for golden gate related issues.

Closely working with the GS MESA team to integrate DB solution using python automation script.

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 and Provide performance tuning solution to app team.

Troubleshooting and Problem Solving.

Project Citi Bank US (Jan 2018 to Mar 2022).

Role Database Administrator (For 10g, 11g,12C,19C, Postgres). Environment Azure, RHEL AS 5, 4,6(RHEL AS5), IBM AIX, Solaris.

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

Oracle 12C,19C database build and Configuration.

Upgrade the databases from lower version to higher.

Extensive experience on Single Click Oracle Instance provisioning model.

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

Datacenter Migration for Oracle database (RAC with DG).

Provided Support for golden gate related issues.

Implementation of vulnerability assessment mechanism for Containers

Managing all Daily Database Maintenance Issues.

Responsible for total back-end configuration for these projects.

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.

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

Refresh the database using Expdp/Impdp.

Troubleshooting Golden Gate issues.

Project

Database

LLOYDS Bank (April 2013 to Dec 2017)

Oracle 10g, 11g, 12C,19C.

Domain

Cloud

Banking.

Google Cloud,AWS

Domain

Cloud

Banking.

Google Cloud,AWS

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.

Install and configured PostgreSQL and Patch/upgrade PostgreSQL in a HA architecture.

Migrated DB Ora to PostgreSQL.

Analyze and resolve performance issues for PostgreSQL DB’s

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 and Provide performance tuning solution to app team. 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:

Oracle Software Installation/Oracle upgrades on client side.

Upgradation 9i, 10g to 11g R2.

Apply quarterly oracle recommended patches

Supported Exadata project.

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 for Coke (CPOS ) application.

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

Domain Telecom, Finance.

Duration Oct2006- Aug2009

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