Prabhat Kumar

Experience

• 

  National Informatics Center, Kolkatta

  Jan 2006 - May 2006

  Internship Trainee

  On .Net Technologies as Developer

• 

  Great Media Technologies Pvt Ltd.

  Jun 2006 - Jul 2009

  Server Administrator

  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. Show less

• 

  Datavail

  Jul 2009 - Jan 2011

  MySQL DBA

  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. Show less

• 

  HCLTech

  Jan 2011 - Jun 2012

  Senior Specialist

  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. Show less

• 

  One97 Communications Limited

  Jul 2012 - Sept 2014

  Senior Associate - DBA

  ● Responsible for managing operations of MySQL Databases ( having more than 1800 severs) and working as Technical leader.Job Description and Responsibilities:➢ Database Management ● Standard DB Installations ● Optimal DB Configurations ● Setting up best Backup/Recovery system ● Doing best DB Performance Tuning ● Setting up HA (Replication - MM,M-S etc..) , DR & Troubleshooting ● Identifying capacity limitations & bottlenecks and process problems and improvements in the same.➢ Team Management – DBA● Personally coach, train and mentor direct subordinates and provide career development opportunities through training and quality management activities● Determining training needs of team; conducting suitable training programs to enhance their operational efficiency leading to increase productivity.● Resource Management, To make necessary changes in staffing based on work volume,plan activities and other anticipated events● Managing & monitoring the performance of teams, maintaining Shift Statistics to ensure efficiency in process operations and meeting of individual & group targets.➢ Process Automation● DBA Process Automation ● DBA Task Automation● DB backup and health check Automation ● DB server Fail-Over Automation➢ SLA Compliance & 24*7 Support ● Supporting DBA Team on urgent issues & escalation (including off hours/ off days)● SLA Compliance (Prompt action on any issue related to DBA ➢ Technical, Functional and Process Documents● Creating Technical,Functional and Process Documents for process enhancement● Maintain Centralize document repository. Show less

• 

  HomeShop18

  Oct 2014 - Dec 2016

  Senior Database Administrator

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

• 

  EZMALL

  Dec 2016 - May 2019

  Senior Manager Database Architect

  • Take accountability for the database design within E-Commerce domain ensuring the delivery of technical specifications and architectures adhering to the non-functional attributes required ensuring successful delivery into and reliability and performance in operation of our solutions.• Plan, design, and monitor these key characteristics to help ensure that the proposed solutions perform adequately and comply with enterprise standards ensuring technical readiness at each stage gate.• Work closely with other areas in Solutions Delivery and their respective vendors partners to support with 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 technical design of new products and ideas.• Leverages industry and organizational standards, patterns, frameworks, and best practices to develop architectures that enable 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, replication across all data platform.• Install, Upgrade, Administer, Monitor and Maintenance of all MySQL, SQL server, NoSQL, AWS Redshift database instances.• Troubleshoot daily operations problems, and work with various teams to resolve the issues.• Ability to identify performance problem queries, tune SQL queries, databases to improve performance and understanding of how it interacts with applications functions.• Work with system administrators, architects, development teams, and business application owners to ensure database changes are in-line with operational standards and the strategies needed to scale.• Lead, conduct status update and review meetings with business stakeholders consists of Users, Managers, Directors. Show less

• 

  BlueJeans by Verizon

  Jun 2019 - now

  Working as a SME for databases like MySQL and AWS Cloud databases like RDS & Aurora. Support for other databases, such as PostgreSQL, Cassandra, MongoDB, AWS Keypace, and cache, is also provided. Working together with the system architect, business directors, and product manager to establish the requirements and system design. Part of the DevOPS SRE team responsible for providing of building HA, failover, and providing support for production database setups & 24/7 DBA support. Also focusing on AWS infrastructure security, database security, and AWS cost optimisation. Show less

  • Distinguished Engineer - Databases

    Jul 2022 - now

  • Principal Engineer - Database

    Jun 2019 - Jun 2022