Sanjay Chandra

DevOps Engineer

Hyderabad, Telangana, India7 yrs experience

Highly Stable

Key Highlights

5 years of experience in MySQL and PostgreSQL administration.
Proficient in AWS services for database management.
Strong communication and team-building skills.

Stackforce AI infers this person is a Database Administrator with expertise in Telecom and Financial Services.

Contact

Skills

Core Skills

Mysql DbaPostgresql DbaMongodb Atlas

Other Skills

AWS RDSAmazon EC2Amazon Web Services (AWS)Cloud DBADatabase ConsultingDatabasesEC2LinuxMariaDBMySQLPMMPerconaPercona MySQLPercona Xtradb clusterPerformance Tuning

About

"If at first you don't succeed, try, try, try, try, try, try and try again" An IT Database Administrator/Engineer, Having 5 Years of Experience in the Telecom, Financial Services and retail industry. Primary Skill : MySQL DBA Secondary Skill : PostgreSQL DBA  5 years experienced MySQL Database Administrator with a demonstrated history of working in service based and the retail industry.  Strong communication, team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.  Strong information technology professional skilled in MySQL Database Administration, RDBMS, Database architecture, InnoDB, NDB Cluster, AWS, Aurora, RDS, Percona MySQL, Percona Tool kit, Xtrabackup, Percona XtraDB Cluster, PMM and Shell Scripting.  2 Year’s experience in PostgreSQL Database Administration, RDBMS, Database architecture, EDB PostgreSQL, AWS, Aurora, RDS, Shell Scripting.  Amazon Web Services : RDS, EC2, VPC, S3, Route 53, IAM, Chime, CloudWatch , about to learn new Services.  Had Worked on MongoDB Atlas.  Open to Learn New Technologies/Databases. Hobbies: Photography, Travelling, Running, Watching Movies.

Experience

Bristol myers squibb

Cloud Database Operations Engineer

Jul 2024 – Present · 1 yr 8 mos · Hyderabad, Telangana, India · Hybrid

Cloud DBA

Cloud DBAMySQL DBA

Wipro

MySQL/PostgreSQL Database Administrator

Apr 2021 – Jul 2024 · 3 yrs 3 mos · Bengaluru, Karnataka, India · Hybrid

MySQL & PostgreSQL & MariaDB DBA, AWS RDS, EC2, MongoDB Atlas.
MySQL :
Install, Configure and manage multiple MySQL instances
Upgradation from MySQL 5.6 to 5.7 and 5.7 to 8.0
Configuring MySQL Enterprise Backup
Configured Master and slave replication
Performed backups and restoration
Refreshing databases and tables from Production to DEV/QA/UAT
Setup and manage user privileges within the database
Managing more than 80 prod/non-prod database servers.
Applying Quarterly MySQL Database Patching on On-prem and AWS RDS.
Preparing database patching calendar and coordinating with different application teams for database patching.
Performing periodic BCP drill
Performing AWS RDS failover testing.
Managing and preparing database inventory every month.
Performing database archiving activity and Capacity Planning.
Preparing SOP for different DBA activities and updating it periodically.
Efficient handling of DB tools like Percona-toolkit, Xtrabackup, MySQL Utilities etc to perform various DBA Tasks.
Maintaining Resource Profiling & Index Management with respect to the MySQL database.
Migrating Database Servers from Traditional DC to AWS Cloud service.
PostgreSQL :
✓Implemented high-availability solution like Streaming Replication
✓ Install, configure, test, monitor, upgrade and tune new and existing PostgreSQL databases 9.6,10,11,12,13,14 & 15 Versions
✓ Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
✓ providing support for various projects and ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR solution.
✓ User Management
✓ Quarterly Patching on On-prem and AWS RDS Instances
MongoDB Atlas:
✓ User Management in MongoDB Atlas
✓Worked on Online Archive Configuration
✓Worked on Database Issues
✓ Mongo exports and Mongo dump.
✓ Upgraded MongoDB Atlas Cluster from 4.4 V to 6.0 V on Dev/Staging/Production Environment Clusters.

MySQLPostgreSQLMariaDBAWS RDSEC2MongoDB Atlas+2

Snovaspace information systems private limited

MySQL Database Administrator

Mar 2019 – Apr 2021 · 2 yrs 1 mo · Hyderabad, Telangana, India

Working on MYSQL installation(5.x) and upgrades on Linux
Administration and management of the entire development, QA and production environment
Created and deleted users and set up restrictive permissions
Created data extracts as part of data analysis and exchanged with internal staff
Working on MySQL Replication setup and administration on Master-Slave and Master-Master
Checking the scheduled maintenance job(backups) if they have run successfully or not and analyze errors in case they have failed
Checking the disk space, CPU utilization, memory utilization, long running queries inorder to find the bottleneck
Monitoring the alerts using OEM(Oracle Enterprise Manager) tool and configuring the new servers once they comes in to our inventory
Managing database clustering, recovering data using Point In Time recovery(Binary logs)
Handling performance issue and tuning the database for better performance.