Aws Cloud,oracle Dba,cockroach dba, postgres,Mongo Dba
Resume:
Kamalakkannan D
**********@*****.***
www.linkedin.com/in/kamal-duraimanickam-22559745
Professional Summary:
Over 17 years of IT experience as a Senior Oracle DBA, with 8 years of expertise in PostgreSQL, MongoDB Cockroach DB, and AWS/Hybrid Cloud as a DBA.
Have 13 years of experience in the banking domain, having worked with some of the world's leading financial institutions, including Lloyds Bank (UK), Citi Bank (US), and Goldman Sachs (US).
Experienced in supporting production and non-production environments, leading DBA operations teams.
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, and other services of the AWS family.
Based on business requirement analysis, provides comprehensive CAPEX and OPEX estimates to the business team for maintaining the dB’s operations across on-premises and cloud environments.
Design and Implementation of DBaaS strategy - Database as a Service.
Golden Gate Installation and Configuration in Oracle 12C R2,19c.
Database migrated from on-premises to AWS cloud RDS (Oracle 12C,19C, MYSQL, Postgres DB).
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.
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).
Experienced on Postgres DB (Installation and configuration, Replication, backup and recovery).
Configured ruleset for monitoring region wise.
Performance tuning – Identifying and resolve bottlenecks in database performance.
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.
Effectively collaborates and communicates with stakeholders to ensure client satisfaction.
Project Efficiency & Lead Effective Teams with Agile Methodology. 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), Postgres DB, Mysql, MongoDB, Cockroach DB. Operating System : RHEL6.7,8.
HA & DR : Data guard, RAC, Golden Gate, repmgr, Rep. Language/Scripting : PLSQL, Python, shell
Security Standards : SSL/TLS, data encryption
Backup Tools : Rman, Expdp, Base backup, Logical, mongo dump, etc. Monitoring Tools : OEM 12C,13C,19C, Solar winds, Tivoli, Splunk and Nagios Ticketing
Tools Cloud
DevOps
: BMC Remedy, HP Service Center, TSRM, ConnectWise, ITSM& JIRA
: AWS, AZURE, Citi Hybrid and OCI.
: CI/CD Pipelines, Terraform, Ansible.
Professional Experience:
Lead database Engineer (Oracle/Postgres/Mongo/Cockroach) Goldman Sachs Bank (March 2022 --Present).
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.
Based on business requirement analysis, provides comprehensive CAPEX and OPEX estimates to the business team for maintaining operations across on-premises and cloud environments.
Collaborate on System Architecture with peers and partner with Business Analysts, Project and Product Managers to meet business requirements.
Participate in capacity planning and execution of database operations
Design and Implementation of DBaaS strategy - Database as a Service on Cloud and On-Premise’s data center.
Oracle 12C,19C, Postgres, Mongo, Cockroach databases build and Configuration.
Managed Snowflake account-level security by implementing Role-Based Access Control (RBAC), user provisioning, and network policies to ensure secure and compliant access control.
Monitored and optimized Snowflake virtual warehouses for performance and cost efficiency, including configuring auto-suspend/resume, analyzing query performance, and tuning resource usage.
Used ServiceNow, JIRA ticketing tools and confluency for documenting.
Provided Support for golden gate related 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.
Participate in the delivery of proactive tasks to improve the stability, performance, and fault tolerance of live environments
Resolving technical issues of projects/app and explore alternate designs.
Tuning SQL Statements and Provide performance tuning solution to app team.
Troubleshooting and Problem Solving (Rep Sync, HA issue, PHV change). Tech Lead (Oracle/Postgres/Mongo)
Citi Bank-US (Jan2018—Mar 2022).
Responsibilities:
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.
Tech Lead database Engineer (Oracle/Postgres)
LLOYDS Bank -US (Apr2013—Dec 2017).
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.
Provided support for Mssql Db’s for trading applications
Resolving connectivity problems with Oracle database.
Tuning Sql Statements and Provide performance tuning solution to app team. Database Engineer (Oracle)
AT&T-US -IBM (May 2011—Apr 2013).
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 & Bi-directional and support.
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.
Consultant-DBA (Oracle)
Coke-US Capgemini (Aug 2009—May 2011).
Responsibilities:
RAC Installation and Configuration for Coke 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.
Contact this candidate