Senior Data Analyst / Administrator

• Mar 2022 - Present

SQL DBA

• Jun 2018 - Sep 2022

Installed and configured MongoDB 2.6,3.0,3.2,3.4 instances.Handson Experience with MongoDB CRUD operations.Implement and maintain MongoDB OPS Manager, MongoManagement Studio, Atlas,Mongo shell.Troubleshoot issues related to performance and replication in MongoSharded Cluster.Hands on experience with MongoDB schema design andperformance tuning.Installed and configured Cassandra DataStax Enterprise additionalong with OpsCenter monitoring.Hands on experience in configuring snapshot and incrementalbackups on Cassandra databases.Setting up and supporting Cassandra 3.9 for POC and prodenvironments using industry's best practices.24 X 7 Production Database on Call Support.Migrated SQL Server databases to RDS in AWS.Migrated databases between different accounts in AWS using S3buckets. (AWS Configure)Expanded and Shrinked root volume size of a Windows EC2 instanceusing console and AWS CLI.Monitored RDS instances using AWS Cloudwatch.Modified RDS instance configuration in AWS.Deployed and executed SSIS packages in Azure using Azure DataFactory.Implemented stretch database feature in Azure to comply with dataSkillsMonitoring & Backup ToolsSummaryWork Histroyretention policy.Enabled transactional replication for with Publisher on perm and endclient in Azure.Implemented Always on high availability groups between Azure virtualmachines.Scaled up a Cassandra cluster horizontally by adding nodes in AWS. Show less