Sathvik Reddy

• Designed and deployed a highly available, scalable, and secure MongoDB cluster on both Cloud and on-prem environments, utilizing a range of automation tools
• Designed, implemented, and optimized high-availability solutions for SQL Server environments, including Always-On Availability Groups, Database Mirroring, Log Shipping, and Transactional Replication, to ensure business continuity and data integrity
• Developed and executed disaster recovery plans, ensuring minimal downtime and data loss in the event of system failure, and regularly tested failover and failback procedures to validate recovery strategies
• Troubleshot production issues to ensure high availability and data integrity, responding to incidents as required by the team
• Participated in an on-call rotation with team members to ensure system availability during scheduled hours
• Automated SQL Server management tasks using PowerShell scripts, including database backups, restore operations, index maintenance, and system health checks, reducing manual overhead and increasing operational efficiency
• Part of the team in the migration of MongoDB data from on-prem infrastructure to AWS cloud environment
• Managed SQL Server agent jobs and automated processes for routine maintenance tasks such as index rebuilds, statistics updates, and transaction log backups, ensuring optimal database health and performance
• Automated MongoDB log rotation and other management tasks using shell scripts
• Created an operational dashboard and alerting system with CloudWatch, Kibana, Beats, and Logstash
• Contributed to the design of NoSQL schemas (JSON), as well as logical/physical dimensional data models, ERDs, and indexing strategies to enhance real-time analytics and transactional performance
• Investigated data-related issues, proposing and implementing a framework for improving data quality
• Regularly audited and reviewed SQL Server security settings, permissions, and user activity to detect and mitigate potential security risks and ensure compliance with internal and external audits
• Ensured that technical documentation, including architecture and integration diagrams, was consistently updated
• Gained expertise in configuring read preferences on a per-connection or per-operation basis
• Conducted query optimization by analyzing query plans and plan cache filters to improve performance
• Evaluated the performance of current database operations and recommended solutions to optimize read and write performance
• Set up monitoring tools to forward MongoDB logs to Elasticsearch using Fluentbit and created Kibana visualizations
• Configured Metricbeat to push MongoDB metrics to Elasticsearch
• Analyzed Elasticsearch mappings, shard configurations, and storage requirements for optimal performance
• Implemented SQL Server 2012 features including Always-On Availability Groups, Database Auditing, and User-defined Server Roles, ensuring high availability and security across all instances
• Configured and maintained maintenance plans for backups, history clean-up tasks, index rebuilds, and automated processes for various servers
• Managed disaster recovery solutions using clustering, database mirroring, Log Shipping, and Always-On Availability Groups
• Administered 2-node SQL Server clusters and provided high availability through Database Mirroring, Transactional Replication, and Log Shipping
• Installed and configured SQL Server on Windows Server 2012 and implemented Transactional and Merge Replication for cross-data center availability
• Utilized SQL Server Profiler and the Database Tuning Advisor for troubleshooting slow-running queries, performance tuning, and index optimization
• Regularly performed query optimization to improve database performance across all environments

Environment: MongoDB 3.4, 4.0, 4.2, 4.4, MongoDB 5.0, MongoDB 6.0, Robomongo, Mongo Compass, Mongostat, Mongotop, Ansible, Python, AWS, CloudWatch, Elasticsearch, Kibana, Logstash, Filebeat, MetricBeat, OP5, Shell Scripting, Fluentbit, SQL Server 2017/2016/2014/2012, Windows Server, SSIS, SSAS, SSRS, PowerShell, SQL Server Profiler, Database Tuning Advisor, Query Store, Always-On Availability Groups, Database Mirroring, Log Shipping, Transactional Replication

• Designed and executed backup strategies and disaster recovery plans, ensuring reliable backup and restoration of databases and transaction logs across various environments
• Managed database security by monitoring and controlling access, granting appropriate permissions to users, roles, and objects
• Provided database-side support for applications like OpenText LiveLink, ReadSoft, and Business Objects
• Migrated SQL Server instances and websites to the AWS cloud environment
• Experience on automation of routine database operations using Shell and PowerShell scripts
• Developed and maintained SSRS reports to track daily, weekly, and monthly statistics for various investors
• Experienced in integrating Microsoft Active Directory Services for enhanced security and user management
• Proficient in backup and disaster recovery operations using MongoDB Management Service (MMS) and Ops Manager, ensuring data durability and rapid recovery
• Configured various read concern levels to guarantee appropriate isolation for read operations, providing consistency based on application requirements
• Applied strategies to optimize storage for small documents, minimizing overhead and enhancing storage efficiency
• Enabled journaling across MongoDB instances to ensure data integrity and automatic recovery following unexpected system shutdowns
• Experienced with MongoDB’s internal tools such as MongoDB Compass, Mongo Atlas Manager, Ops Manager, and Cloud Manager for database management, monitoring, and troubleshooting
• Worked on deploying, managing, and developing highly available MongoDB clusters, ensuring optimal performance, scalability, and reliability
• Worked on creating different type of indexes based on different collections to get good performance in MongoDB
• Led the installation and configuration of a multi-node MongoDB sharded cluster and replica sets across Linux and Windows platforms
• Worked on performance tuning of MongoDB clusters, including fine-tuning memory usage, query performance, and system resources for enhanced efficiency
• Directed the development team in implementing MongoDB best practices for document/schema design, query optimization, indexing, and overall database performance
• Collaborated with MongoDB and AWS vendors to stay updated on best practices, new features, and troubleshooting techniques
• Worked alongside the security team to implement SSL/TLS, user management, key management, and VPC configurations using AWS KMS, in accordance with corporate security standards
• Provided ongoing documentation and training to engineering teams to support design implementation
• Led the DevOps team in automating various processes with Ansible and Terraform for MongoDB installation, configuration, and upgrades
• Designed and deployed sharded databases, carefully selecting shard keys to ensure efficient data distribution and balancing across the cluster
• Led chunk migration, splitting, and balancing within sharded clusters to optimize data distribution, reduce hot spots, and improve query performance
• Configured geographically distributed MongoDB replica sets across multiple data centers, ensuring high availability and disaster recovery across regions
• Responsible for setting up and managing Ops Manager for continuous database monitoring, performance tuning, and troubleshooting tasks, ensuring optimal operation of MongoDB clusters
• Developed JavaScript-based scripts for performing data manipulation operations (DML) within MongoDB, automating database tasks and workflows
• Installed and configured SQL Server based on client specifications
• Managed migration of databases from SQL Server 2008 to 2014
• Conducted production changes outside of regular hours to minimize disruption, following thorough testing
• Resolved database corruption or consistency issues through weekly maintenance plans
• Deployed reports using Microsoft Reporting Services (SSRS)
• Managed database refreshes for development teams and scheduled them based on ongoing needs
• Implemented and tested a two-node SQL Server failover cluster, optimizing resource utilization
• Implemented high-availability solutions, including Log Shipping and Replication
• Provided support for Active/Passive clustering environments
• Applied service packs to SQL Server installations (2012/2014)
• Worked with Always on Availability Groups and implemented In-Memory Optimization in SQL Server 2014
• Monitored data loads related to rate changes, billing registers, meter readings, and payments using bulk loads
• Configured fill factors based on index structure and fragmentation
• Resolved TEMPDB contention in a failover cluster by creating multiple TempDB files on a local drive
• Maintaining custom vacuum strategies at table and db level
• Experience in optimizing database performance through exhaustive pro-active testing

Environment: MongoDB 3.4, 4.0, 4.2, 4.4, 5.0, 6.0, Mongo Compass, Replication, Sharding, Ops Manager, Mongo Shell, AWS, Bash, JavaScript, SQL Server 2017/2016/2014/2012, Windows Server, SSIS, SSRS, Red Gate, Spotlight, Ansible, Terraform, Cloud Manager, MongoDB Atlas, SQL Server Always-On Availability Groups, Log Shipping, Transactional Replication, Database Mirroring, SQL Server Profiler