SHANKAR KOTAMARTY
Sanjose,CA
Summary
• Overall, 17 plus years of concrete experience in the field of Database Administration & Data Engineering
• Having 13 plus years of experience working on PostgreSQL Database Administration & Development.
• Having 8 plus years of experience working on Oracle Database Administration
• Certified in MongoDB as a DBA Associate.
• Experience in usage of Github for CI/CD
• Hands on working experience on Amazon Cloud Computing Technology.
• Has Knowledge in Programming Languages like C, Java, Python
• Experience in writing shell scripts.
• Has Knowledge in Big Data platforms like Apache Spark.
• Experience in configuration management using Ansible.
Overview
18
18
years of professional experience
4
4
years of post-secondary education
Work History
Financial Information Accelerator Technology (FIAT) - CISCO
Project 1
10.2018 - Current
- Developed data transformation ETL’s using SQL for reporting
- Developed Data pipelines using python to fetch data from source systems like Teradata
- Automated installation of Postgresql using Ansible
- Migrated Aurora Oracle database to Aurora Postgresql
- Designed and developed data model in Aurora Postgresql for reporting
- Migrated on prem PostgreSQL to AWS RDS
- Updated PostgreSQL from version 11 to 12 for on prem database of size 150 TB
- Performance tuning of large SQL queries used for reporting using cloud watch and performance insights
- Migrated Redis on EC2 to Amazon Elastic Cache
- Configured MongoDB 5 Node Replication
- User and Role Management in Mongo DB
- Installed and Configured Jenkins on AWS EC2
- Scheduled ETL jobs using job schedulers like Tidal, Control M
- Optimized index usage
- Implemented monitoring of database severs using Grafana
- Successfully Migrated Aurora Oracle database to Aurora Postgresql
- Designed and developed data model in Aurora Postgresql for reporting.
- Created financial dashboards to provide insights into key performance indicators
- Complied with established internal controls and policies
- Established and checked coding procedures, monitored reports and updated internal files
Lqx Platform Support & Maintenance - Capgemini
Project 2
05.2014 - 08.2018
- Migrated all PostgreSQL production servers from ubuntu to Linux
- Designed backup policy for larger databases and implemented it
- Replaced existing log shipping replication with streaming replication
- Created triggers in production databases
- Created unique replication solution where master and slave1 are in streaming replication and master and slave2 are in pglogical replication
- Optimized large running queries to decrease query retrieval time
- Tuned database performance by tweaking configuration parameters
- Installed and Configured MongoDB
- Experienced in performance Tuning Using EXPLAIN PLAN, TKPROF, STATSPACK
- Implemented Backup & Recovery through RMAN and SQL Scripts
- Proficiency in using Logminer, SQL
- Loader and Export/Import Utilities
- Experience in Oracle to Postgresql Migration
- Successfully Updated postgresql database server from version 9.2 to 9.4 with minimum downtime
- Configued MongoDB 3 Node Replication.
- Developed and implemented strategies to improve maintenance processes
Statefarm (IPsoft)
Project 3
05.2013 - 04.2014
- Installation and configuration of Postgresql database software on new servers
- Creating databases and other associated database objects
- Coding monitoring checks for database servers
- Configuring replication between PostgreSQL database servers
- Trained team members on Postgresql
- Optimizing long running queries.
- Worked effectively in fast-paced environments
- Demonstrated strong organizational and time management skills while managing multiple projects
QuickKlix (Bharata Media Forte)
Project 4
07.2010 - 05.2013
- Designing database as per application requirement
- Verifying data collected from different sources and formatting it to format
- Creating scripts for bulk loading of data into PostgreSQL databases
- Designing Backup & Recovery Policy and implementing it
- Installation and configuration of Postgresql database software on new servers
- Vacuuming of database server depending upon usage
- Coordinating with development team on database issues
- Successfully Installed and Configured PostgreSQL-Community Edition 9.0.
- Identified issues, analyzed information and provided solutions to problems
e-Prognosys.
Project 5
06.2006 - 07.2010
- Designing database as per application requirement
- Verifying data collected from different sources and formatting it to customized format
- Creating scripts for bulk loading of data into Oracle databases
- Designing Backup & Recovery Policy and implementing it through RMAN & SQL Scripts
- Installation and configuration of Oracle database software on new servers
- Vacuuming of database server depending upon usage
- Coordinating with development team on database issues.
Education
Post Graduate Program in Cloud Computing - Cloud Computing
The University of Texas At Dallas
Richardson, TX 02.2021 - 10.2021
Bachelor of Science - Computer Science And Programming
Jawaharlal Nehru Technological University
Hyderabad India 08.2001 - 06.2005
Skills
Postgresql,Oracle
undefinedProfessional Certifications Trainings
Certified Mongo DB DBA Associate
Educational Qualification
Computer Sciences and Information Technology - 2005, Cloud Computing - University of Texas - 2021
Skills Summary
PostgreSQL, Oracle, C, Java, Python, Ubuntu, Windows, RHEL, Shell scripting, MongoDB, Citus, Kubernetes, Tidal, Control M, Ansible, Github, S3, EC2, RDS, Aurora, Cloud Watch SNS, Dynamo DB, Redshift
Timeline
Post Graduate Program in Cloud Computing - Cloud Computing
The University of Texas At Dallas
02.2021 - 10.2021
Financial Information Accelerator Technology (FIAT) - CISCO
Project 1
10.2018 - Current
Lqx Platform Support & Maintenance - Capgemini
Project 2
05.2014 - 08.2018
Statefarm (IPsoft)
Project 3
05.2013 - 04.2014
QuickKlix (Bharata Media Forte)
Project 4
07.2010 - 05.2013
e-Prognosys.
Project 5
06.2006 - 07.2010
Bachelor of Science - Computer Science And Programming
Jawaharlal Nehru Technological University
08.2001 - 06.2005
Similar Profiles
Marzetta CravenMarzetta Craven
Community Outreach Volunteer at Project 1:1Community Outreach Volunteer at Project 1:1
Kameswara Rama Kumar BulusuKameswara Rama Kumar Bulusu
Accounting Assistant Manager at Project 1:Suport ProjectAccounting Assistant Manager at Project 1:Suport Project
SRI GANESH SSRI GANESH S
Recruitment Coordinator at Project 1:- BLACKLINE (ZINNOV MANAGEMENT CONSULTING Ltd)Recruitment Coordinator at Project 1:- BLACKLINE (ZINNOV MANAGEMENT CONSULTING Ltd)