MAYANK PANDEY
Bangalore
Summary
14+ years experienced, Customer focused techno management professional, performed variety of roles in leadership,development,implementation, consulting and enablement services with high performance and security solutions.
Overview
14
14
years of professional experience
11
11
Certification
Work History
Solutions Architect
Tata Consultancy Services
Bangalore
06.2020 - Current
- Define and implement migration strategy to move applications to AWS, Google Cloud platforms
- Design/Deliver overall environments including VPC,subnets,SG,RDS,EC2,ECS,EKS,ELB etc
- With AWSCLI and terraform
- Develop required Cloud services architecture blueprints and documentation
- Design/Deliver HA/DR cloud solutions and execute migration plan
- Validate the environments to meet all security and compliance control with Qualys
- Setup AWS CW agents and application logs with json file
- Import Certificates for ELB,ECS procured from Venafi Cybersecurity with AWS CM
- Setup and provision of ELB, target groups with ec2
- AMI upgrade/rotation for AWS Clusters & EC2 with launch templates & ASG
- Automation of Vulnerability management with AWS system Manager.
- Designed, implemented, and managed cloud-based architectures using Amazon Web Services.
- Developed scripts and automation tools to improve operational efficiency.
- Provided technical leadership during the design, implementation, testing, and deployment phases of projects.
- Performed capacity planning, performance tuning, and system optimization activities.
- Coached team members on best practices for designing robust systems architecture.
- Optimized system architectures for performance, scalability, and cost-effectiveness.
- Coordinated cross-functional teams in the execution of technology projects.
- Evaluated operational processes and recommended cost-effective solutions.
Senior Consultant
Capgemini
Bangalore
12.2015 - 06.2020
- 12c Upgrade, Patching & Database performance Troubleshooting
- EBS 12.1 cloning ,Patching and migration on AWS Cloud
- Automation with AWSCLI,Jenkins,teraform, ansible and shell scripts
- Monitoring tool (Grafana) setup
- Access Management role provisioning and integration third party software
- Developed training material and conducted trainings for staff members on new technologies or processes via confluence.
- Provided strategic guidance to clients on best practices for business operations.
- Provided technical advice to support implementation of new initiatives or programs.
- Established strong working relationships with both internal teams as well as external vendors and clients.
- Identified needs of customers promptly and efficiently.
Senior Professional
IBM
Bangalore
03.2015 - 11.2015
- Involved in technical initiatives for automation and troubleshooting RAC/ASM, Data guard replication
- Worked on Oracle 12c database administration, troubleshooting procedures
- Troubleshooting database performance and query tuning, RMAN Backup and recovery
- Troubleshooting Goldengate 11g/12c replication and share plex for 11g
- Implement complex changes, install, upgrade and patch Oracle databases and Grid Infrastructure
- Troubleshooting database Corruption, Configure OEM and alerts.
- Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Coordinated with other teams such as network administrators and system admins for resolving complex issues.
- Implemented data replication between two different databases using DataGuard feature of Oracle Database Server.
- Managed database security, backup, and recovery procedures to safeguard information.
DBA/Software Engineer
Accenture
Bangalore
06.2011 - 03.2015
- Core & Apps DBA for multiple projects with oracle databases on hpux aix ,Linux,solaris and windows OS platforms
- Worked on 10g,11g Oracle RAC DB,OEM 10g,11g and Oracle EBS 11i
- Extensively worked on databases performance troubleshooting including Streams, Dataguard, Golden Gate replication
- Worked on creating databases and applying patches
- Troubleshooting oracle database internal errors with oracle support
- PL/Sql troubleshooting and variety of monitoring enablement with shell scripts.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Resolved customer queries related to database issues promptly and accurately.
- Provided technical support for developers by creating views and indexes as per their requirements.
- Created new tablespaces for applications to store their data in the database.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
Support Engineer
Resource Square Solutions
Gurgaon
12.2009 - 11.2010
- One of the leading players in HR/IT/Finance/Payroll Outsourcing
- Provide support with Advance Diagnostics & Troubleshooting
- Pre and Post Sale support for various electronics devices
- Provide remote repair service with client provided tools.
Education
Bachelor of Technology - B.Tech - Electrical and Electronics Engineering
Uttar Pradesh Technical University
06.2009
Skills
- AWS Well-Architected Framework
- Enterprise Architecture Foundation
- Cloud Infrastructure Automation
- Confluence
- Jira
- AWSCLI
- Terraform
- Hashicorp Vault
- Ansible Basics : Automation
- Oracle Core/Apps DBA
- SQL
- AWS RDS
- GitHub/Jenkins
- Lean Six Sigma
- Learning Agility
- Strategic Planning & Execution
- Continuous Process Improvement
- Team Leadership & development
- Agile Methodologies
- Customer Relationship Management
- DevOps Practices
- Python
- Microservices Architectures
Affiliations
National Skills Registry, Nasscom, India, ITPIN:881092424675
Certification
- AWS Certified Solutions Architect - Associate
- ITIL V3 FOUNDATION
- Six Sigma and the Organization (Advanced)
Accomplishments
- 300k+ Critical Cost Center AWS Service Tags
- Successfully implemented tagging with awscli automation scripts on variety of resources including Security Groups, S3 buckets, Lambda functions etc.
- MDM CDH and BIP Migration Projects
- Entire App & web Stack EC2 servers with custom AMI, EBS, EFS, Route 53, ELB, ACM, RDS build and provision have been automated and implemented successfully with terraform.
- AWS SSM Agent Automation
- Successfully implemented SSM Agent updates on 100+ EC2 instances with awscli and Jenkins
- AWS Monitoring Enablement
- Setup Cloudwatch alarms, logs on variety of aws services including ec2, rds, vpc, alb etc and integrated with SNS topics
- Oracle 19c Upgrade/Migrations
- Upgraded/Migrated 100+ DBs over RDS & EC2 including Grid infrastructure
- Cost Optimization Strategic Implementation
- Successfully automated stop & start of RDS instances during Weekends with AWS Systems manager and Jenkins
- Vulnerability Remediation
- Identified and remediated 80+ vulnerabilities on EC2 Spotfire servers including log4j with Qualys and system Manager
- Demo Presentations
- Successfully carried out multiple knowledge session and shared blueprint documents with client
- Cloud Security Report
- Successfully enabled notification report to monitor security agents health (Qualys, Fire eye, Tanium, Sentinel etc.) Status on 100+ EC2 servers with scripts
- RDS to S3 Intregation
- Successful integrated RDS and S3 bucket with IAM role and transferred dumps for long term storage for cost savings.
- Automation with Jenkins
- Successfully implemented Jenkins pipeline with github repos for Build & deployments
Languages
- Hindi, Native
- English, Native
Awards
Leadership: Training Program, 10/2020, Present, Tata Consultancy Services
Languages
Hindi
First Language
English
Proficient
C2
Timeline
Solutions Architect
Tata Consultancy Services
06.2020 - Current
Senior Consultant
Capgemini
12.2015 - 06.2020
Senior Professional
IBM
03.2015 - 11.2015
DBA/Software Engineer
Accenture
06.2011 - 03.2015
Support Engineer
Resource Square Solutions
12.2009 - 11.2010
Bachelor of Technology - B.Tech - Electrical and Electronics Engineering
Uttar Pradesh Technical University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Tania KhandakarTania Khandakar
GIS Consultant at Wipro LTDGIS Consultant at Wipro LTD