Prabhat Kumar Email & Phone Number

Karnataka, India

I work as a Subject Matter Expert (SME) for databases like MySQL and AWS Cloud databases such as RDS & Aurora, providing support for other databases like PostgreSQL, Cassandra, MongoDB, AWS Keyspace, Redshift, Elastic Cache. I collaborate with system architects, business directors, and product managers to establish requirements and system design. As part of the DevOps SRE team, my responsibilities include building HA, failover solutions, and providing support for production database setups & 24/7 DBA support. I also focus on AWS infrastructure security, database security, and AWS cost optimization.Key Accomplishments: - Migrated from On-Prem MySQL to AWS Aurora MySQL managed service. - Upgraded On-Prem MongoDB and migrated it to AWS EC2-based MongoDB. - Migrated On-Prem Cassandra to AWS Keyspace managed service. - Data Migration from Aurora MySQL to Aurora PostgreSQL. - Automated database management and infrastructure using Terraform. - Enhanced database security (storage encryption, connection encryption) and other AWS infrastructure security (TLS upgrades, EBS encryption) using the Prisma tool. - Optimized costs for AWS cloud databases and other AWS services, including storage (GP, GP2, migrating EC2 instances to Graviton-based instances), S3, CloudWatch, and other storage optimizations. - Implemented Multi-region database high availability (HA) and disaster recovery (DR) strategies. Onboarded NOC for L1 database support, including training sessions, runbooks, and access. - Aligned DevOps for L2 support, deployment & automations. - Developed a framework for DB changes code review during development. - Actively involved in sprint (Jira), Architectural Review Board (for Architectural changes), Change Management System (operation changes CHG), Retrospection (for INC’s), POC’s.

Bengaluru Area, India

Noida Area, India

• Responsible for database design within the E-Commerce domain, ensuring technical specifications and architectures meet non-functional requirements for successful delivery, reliability, and performance of solutions.• Plan, design, and monitor key characteristics to ensure proposed solutions perform adequately and comply with enterprise standards, ensuring technical readiness at each stage gate.• Collaborate with other areas in Solutions Delivery and vendor partners to provide technical knowledge, standards, templates, tools, and methodologies for building and running solutions that integrate with and support enterprise standards.• Prototype new solutions to test and confirm the technical design of new products and ideas.• Use industry and organizational standards, patterns, frameworks, and best practices to develop architectures that enable the fulfillment of business strategies.• Architect, plan, design, and implement robust database administration solutions, including automation, performance monitoring, coding, tuning and optimizations, patching, resource management, capacity planning, and replication across all data platforms.• Install, upgrade, administer, monitor, and maintain all MySQL, SQL Server, NoSQL, and AWS Redshift database instances.• Troubleshoot daily operational problems and work with various teams to resolve issues.• Identify performance problem queries, tune SQL queries, databases to improve performance, and understand how they interact with application functions.• Collaborate with system administrators, architects, development teams, and business application owners to ensure database changes align with operational standards and scalability strategies.• Lead and conduct status update and review meetings with business stakeholders, including users, managers, and directors.

Noida Area, India

• Responsible for managing operations of all database activities, Primarily MySQL Databases, along with MS SQL & Oracle.• Job Description and Responsibilities:DBA activities:- such as installation & configuration; backup , recovery planning and implementation ; database sizing ; user account management ; MySQL Replication ; performance monitoring ; schema management for development projects ; Database security ; Data Purging ; Automating DBA tasks ; DR solutions.

Noida Area, India

As the Technical Leader responsible for managing operations of over 1800 MySQL Databases, my role involves::- Database Management & Process Automation: - Standard & Optimal DB Installations - Setting up best Backup/Recovery system - DB Performance Tuning - Setting up HA (Replication - MM, M-S, etc.) - DR & Troubleshooting -Identifying capacity limitations, bottlenecks, and process problems for improvements:- Team Management – DBA: - Personally coaching, training, and mentoring direct subordinates Providing career development opportunities through training and quality management activities - Determining training needs of the team and conducting suitable training programs to enhance their operational efficiency leading to increased productivity - Resource Management, making necessary changes in staffing based on work volume, planning activities, and other anticipated events - Managing & monitoring the performance of teams, maintaining Shift Statistics to ensure efficiency in process operations and meeting individual & group targets.

Noida

Job Description and Responsibilities:➢ Providing 24X7 supports for MySQL databases (Install, configure and support).➢ Participating with other members of the Technical Services management team in long-range and strategic planning for Technical Services.➢ Troubleshoot performance issues.➢ Performing database capacity planning.➢ Ensuring that disaster recovery plans.➢ Created numerous scripts for routine database administrative duties.➢ Defining and maintaining database security strategies and ensuring that confidential information is secured.

Job Description and Responsibilities:✓ Database modifications and enhancements based on best practices.✓ Perform capacity planning and systems-level architecture.✓ Perform database creation and configuration.✓ Apply appropriate database patching.✓ Upgrade current database platforms from version X to version X+Y.✓ Perform database security implementation, checks and audits (incl. changing database passwords) ✓ Monitor all appropriate databases and related hardware environments.✓ Perform database maintenance (proactive, reactive and automated).✓ Perform database backups.✓ Perform data refreshes across environments (production to dev/test environments).✓ Perform log-file reviews.✓ Trouble-shoot and repair existing database environments.✓ Perform general health checks and process accuracy.✓ Report on current state of databases.✓ Perform database tuning.✓ Perform database recovery.✓ Monitor database scheduled jobs.✓ General Q&A / expertise sharing.✓ Provide appropriate documentation related to “Systems DBA” support areas.✓ Knowledge transfer between Client in-house employees.

Job Description and Responsibilities:● Involved in all most all technical parts in the company and work directly under CEO at technical level, making decision and responsible for keeping all the hardware and software facilities up-to-date.● Dealing with Internet service provider, domain name registrar, hosting company and data center companies which include data center services, domain registrations, uploading website in production, creating databases and other related things.● Installation, monitoring and maintenance of local/remote Linux remote Linux servers (using Remote Power Control Unit, IP-KVM).● Network administration, server configuration (SSH, Apache, Samba, DHCP, Bind DNS, MySQL), troubleshooting, Upgrading & Installing Packages on Alpha, Beta, Backup & Production server.● Installing, analyzing, monitoring & optimizing of MySQL Database.

On .Net Technologies as Developer

Master In Computer Application, Computer Science

Bachelor In Computer Application, Computers

12Th, Science

10Th, English, Maths, Science