DASHARATH DIXIT

MongoDB

• Managed MongoDB Atlas clusters (multi-region, multi-cloud) with automation via Terraform.
• Designed and implemented secure, scalable MongoDB Atlas environments with VPC peering, access controls, and automated backups.
• Migrated self-hosted MongoDB workloads to Atlas using mongomirror and mongosync with minimal downtime.
• Performed relational to MongoDB migrations using MongoDB SQL Migrator, including schema transformation and data validation.
• Created and automated MongoDB App Services Triggers for scheduled aggregations and inter-collection updates.
• Replaced manual trigger setups with Terraform-based infrastructure as code for versioned, environment-specific deployments.
• Developed cron-based reporting and enrichment jobs targeting large collections in production clusters.
• Tuned performance using Atlas Query Profiler, Performance Advisor, and index optimization.
• Maintained cluster version upgrades, monitoring alerts, and PITR strategies without service interruption.
• Collaborated cross-functionally with DevOps, SRE, and app teams to deliver stable, high-performing MongoDB-backed services.

Kafka

• Deployed and maintained Kafka connectors for PostgreSQL, MongoDB, and Snowflake to enable seamless CDC (Change Data Capture) and analytics integration.
• Configured and managed Cartero outbox connector for reliable event publishing from transactional databases, aligning with the Transactional Outbox pattern.
• Designed and implemented Kafka topic structures with appropriate partitioning, retention policies, and compaction settings based on data lifecycle and throughput needs.
• Established producer and consumer best practices, including idempotent producers, consumer group coordination, offset management, and retry strategies.
• Led backfilling initiatives by replaying events from retained topics or restoring historical datasets into Kafka without disrupting downstream consumers.
• Tuned producer/consumer configurations (batch.size, linger.ms, max.poll.records, etc.) for low-latency and high-throughput messaging pipelines.
• Assisted backend teams in integrating Kafka clients with their services, offering guidance on schema evolution, serialization formats (Avro/JSON), and message versioning.
• Implemented dead-letter queues (DLQs) and monitoring for message processing failures to improve observability and recovery.
• Supported Kafka use cases like event sourcing, audit logging, and real-time data pipelines in microservices-based systems.

Redis

• Upgraded Redis from v6 to v7, enabling role-based access control (RBAC) and applying critical security patches with zero downtime.
• Used RIOT (Redis Input/Output Tool) for seamless cross-version data replication and validation during production upgrades.
• Supported backend teams in setting up and configuring Redis clusters with advanced features like replication, sharding, and AOF persistence.
• Performed detailed capacity planning based on application usage patterns, ensuring Redis instances were right-sized and scalable under peak load.
• Conducted performance benchmarking using redis-benchmark and workload-specific test suites to validate low-latency caching behavior and throughput.
• Tuned Redis config parameters (e.g., maxmemory-policy, client-output-buffer-limit, save intervals) for backend use cases requiring high availability and fast failover.
• Collaborated with developers to implement Redis-backed caching, session stores, and rate-limiting logic across stateless microservices.
• Monitored and optimized Redis under real-time load using observability tools like Prometheus, Grafana, and Redis slowlog insights.
• Automated Redis cluster setup and configuration using infrastructure-as-code practices and provided onboarding support to dev teams.

PostgreSQL

• Performed major and minor version upgrades of PostgreSQL clusters (e.g., from v12 to v14) using both in-place and dump/restore strategies, ensuring data integrity and minimal downtime.
• Set up and maintained streaming replication for high availability and read scalability, with regular lag monitoring and failover validation.
• Implemented table partitioning (range and list types) to improve query performance and manage large datasets efficiently across time-based and categorical dimensions.
• Troubleshot critical database issues such as long-running queries, lock contention, bloated indexes, and deadlocks using tools like pg_stat_activity, pg_locks, and EXPLAIN ANALYZE.
• Tuned PostgreSQL configurations (e.g., work_mem, shared_buffers, max_connections) based on workload patterns to improve performance and concurrency.
• Managed database backup and restore using pg_dump, pg_basebackup, and WAL archiving for disaster recovery and environment cloning.
• Collaborated with developers to optimize complex queries, enforce schema design best practices, and manage migrations in CI/CD workflows.
• Monitored replication lag, connection spikes, and I/O behavior with tools like pg_stat_replication, Prometheus + Grafana, and custom scripts.
• Automated health checks and maintenance tasks including VACUUM, ANALYZE, and reindexing for performance consistency.

Terraform

• Built scalable and reusable Terraform modules for MongoDB Atlas, automating creation of projects, clusters, users, backup policies, and cloud integrations across multiple organizations.
• Integrated Terraform with CI/CD pipelines to enable seamless deployment of resources configurations, ensuring version control and repeatability across environments.
• Maintained provider configurations for MongoDB Atlas, cloud providers, and GitHub integrations, with custom logic to map organizational/project IDs dynamically via inputs.

Kubernetes

• Collaborated with SRE and DevOps teams to configure resource limits, readiness probes, and auto-scaling policies for database workloads in Kubernetes clusters.

• Resolved critical backup and restore issues in Cassandra clusters, ensuring data consistency and recoverability across environments.
• Worked with nodetool and snapshot-based strategies to manage backups and validate restores in distributed AWS-hosted Cassandra deployments.
• Monitored and optimized replication factor, compaction strategies, and hinted handoff settings to improve cluster reliability and fault tolerance.
• Collaborated with platform teams to troubleshoot node failures, read/write latency, and repair operations using nodetool repair and log analysis.
• Ensured consistent schema versioning and configuration management across multi-node clusters during application releases and cluster scaling.
• Upgraded Exasol to the latest version and handled backup-restore workflows for analytics workloads in AWS cloud.

Oracle DBA Expertise

• Experience managing Oracle 9i, 10g, 11g, and 12c in large OLTP and OLAP environments.
• Strong expertise in RAC (Real Application Clusters), Data Guard (Physical and Active Standby), RMAN, and partitioning for high availability and performance.
• Led major version upgrades (9i → 10g → 11g → 12c) and performed OEM13c configuration across production and non-prod environments.
• Completed critical Oracle-to-cloud migration projects, ensuring seamless cutovers and complete validation.
• Conducted Oracle License Auditing for client infrastructure to ensure compliance and cost optimization.
• Extensive experience in GoldenGate implementation for heterogeneous and homogeneous replication environments.
• Skilled in patching using OPatch, tuning with AWR/ADDM/OEM, and resolving complex performance and production issues.
• Built and maintained shell scripts to automate routine Oracle DBA tasks and troubleshooting processes.

SQL Server DB

• Experience in SQL Server administration including installation, configuration, upgrades, and patching (2008–2019).
• Implemented and supported high availability solutions: Always-On Availability Groups, Log Shipping, Database Mirroring, Replication, and Clustering.
• Administered AWS RDS SQL Server instances and led multiple on-prem to cloud migration projects.
• Developed PowerShell scripts for automating backup-restore, log shipping, drive usage checks, and standard SQL Server installations (named & default instances).
• Migrated SSRS reports, SSAS packages, and handled associated configurations during server transitions.
• Resolved database performance issues including deadlocks, blocking, index tuning, and system resource bottlenecks.
• Applied service packs and cumulative updates as part of proactive maintenance and compliance.

Oracle DBA Expertise

• Extensive experience managing Oracle 9i, 10g, 11g, and 12c (both RAC and Standalone) in high-volume OLTP and OLAP environments.
• Deep knowledge of core Oracle RDBMS technologies including Real Application Clusters (RAC), RMAN, Data Guard, and partitioning features.
• Strong hands-on experience in Data Guard configuration, including setup, implementation, and maintenance of both Physical and Active Standby databases.
• Proven track record supporting mission-critical Oracle systems with high availability, scalability, and disaster recovery needs.

SQL Server DBA Expertise

• Proficient in designing, implementing, and upgrading Microsoft SQL Server infrastructure across standalone and clustered environments.
• Hands-on experience with SQL Server high availability solutions, including Log Shipping, Mirroring, Always-On Availability Groups, Clustering, and Replication.
• Led successful SQL Server database migrations, including version upgrades and cloud transitions.
• Extensive experience managing and optimizing AWS RDS SQL Server instances for scalable, cloud-based database solutions.

• Worked as a SQL Developer in an ASP.NET environment, writing and optimizing complex queries, stored procedures, triggers, and views to support application features and reporting logic.
• Designed efficient JOIN queries, nested SELECTs, and dynamic SQL to interact with normalized relational data structures.
• Collaborated closely with .NET developers to ensure seamless data access layer integration and improved query performance across application modules.
• Supported backend logic through T-SQL enhancements, ensuring data integrity, performance, and scalability in transactional systems.