Akhand Singh

Experience

• 

  Mphasis

  Oct 2009 - Aug 2012

  Oracle DBA

  Production Support 24X7Preparing daily task - list and distributing task to team. Monitoring & configuring RMAN backup.Editing & applying the cronjob for RMAN backup.Monitor the jobs using EMBARQ Datapoint Tool.Unix scripting and automation work (include data file path change used in DB refresh)Database Refresh from Production Database to Development and Test environments.Performing Schema, Table and full database Refresh.Working and managing the RAC instances.Performing Database Migration from one server to another server.Performing Database decommissioning (After migrating DBs to New Server and upgrade to RAC).Performing Database refresh using the SQL BACKTRACK tool.Performing SQL BACKTRACK License key upgrade.Creating Tickets for Production DB activities and following up with change Management for Approval. ( USD ticketing tool of computer Associates )Upgrading RAC databases from 10g to 11g, 9i to 10g. & Version upgrade on Production databases.Converting single node DB to RAC DB.Applying PSU/CPU patches based on requirment/recommendation from ORACLE.Creating & following SR - Service Request for Oracle Support.Cloning database using RMAN controlfile backup.Handling ASM, GRID & RAC databases running on 5+ nodes.Mangaing Physical standby databases.Alert monitoring and Tablespace/User/Role/Privilege Management. Show less

• 

  Cybage Software

  Aug 2012 - May 2014

  Oracle Database Administrator

  Deployed various Amdocs products like ABP (Amdocs Billing Product), OMS ( Ordering Management System) & CRM on customer site successfully.Maintaining TEST,DEV,SIT,UAT environments.Applying changes to customer PROD databases in time to time Product Releases without affecting existing customer data.Handled ASM, GRID & RAC database setup & installation, RMAN backup/recovery, Flashback, RMAN cloning, Standby creation, Performance Tuning, Database Refresh, Database Migration, User management, Table/Schema refresh. Show less

• 

  Cerillion Technologies

  May 2014 - Jan 2015

  Senior Database Administrator

  Responsible for handling all customer databases & make sure to run client jobs/reports smoothly without any delay because of Database Performance issue.

• 

  Amdocs

  Feb 2015 - now

  Conceptualise and implement Kubernetes based Site Reliability Engineering (SRE) platform - on premise (Red Hat OpenShift Containerized Platform - OCP) as well as cloud( AWS, Azure, GCP)Lead & Manage DevOps implementation team serving as professional guide.The technology stack included leading products from the Cloud Native technologies including Kubernetes, Docker, Elasticsearch, Prometheus, Kafka, Rookout, Gatling, KibanaSRE platform stack: Kubernetes, Dockers, ,ElasticSearch, Kafka, Python, couchbaseMonitoring and Observability stack: Prometheus, Rookout, Grafana, Kibana Show less Consulting and leading the CI/CD implementation for customer right from Dev env to Prod from Infrastructure end. Consulting Dev team for new product enhancements and providing best optimal technical solution suitable to Amdocs billing system.Leading the Infrastructure Team for customers and ensuring errorless prod deployments by optimising the deployment package to ensure min downtime.Designing and implementation POC for new development/ changes and taking the same to Prod after passing all testing phases and shorting till stabilisationManaging and supporting the data migration from customer legacy system to Amdocs new billing system.Implement best practices for Database installation, Support and maintenance Support OLTP databases and Batch processing in 24x7 Production environments Production database support involving schema management, database storage management, RAC administration, Backup and recovery.Work with AWR, ADDM, ASH & Tuning advisor tools for the purpose of advance levelSchema design Continuous research in leveraging new features of oracle and bringing them under day to day DBA activitiesLead Root Cause Analysis for critical production performance issueCapacity analysis and future growth reporting Show less

  • DevOps Specialist

    Oct 2022 - now

  • DevOps Manager

    Dec 2020 - Oct 2022

  • Database Specialist

    Jan 2017 - Dec 2020

  • DB Administrator

    Feb 2015 - Dec 2016