MAYANK PANDEY

• Define and implement migration strategy to move applications to AWS, Oracle Cloud and 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.
• Guided and influenced existing partners on recommended upgrades and enhancements to integrated solutions.
• Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.

• 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.
• Exceeded customer requirements with accurate and deliverable solutions.
• Identified key areas in need of improvement and implemented plans to rectify issues.
• Maintained database systems to track and analyze operational data.
• Helped meet changing demands by recommending improvements to business systems or procedures.

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

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

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