Abhishek Kumar

Highly analytical and performance-driven MongoDB ETL Engineer with 15 years of IT experience, specializing in large-scale cloud migrations and NoSQL data modeling. Proficient in executing heterogeneous Oracle-to-MongoDB migrations using AWS Glue, AWS DMS, PySpark, and Python. Expert in transforming complex relational models into optimized, event-driven MongoDB document structures aligned with TMF Open APIs & SID standards.

Proven track record in designing high-velocity, cost-effective ETL pipelines, building sophisticated aggregation frameworks, and structuring embedded document schemas to optimize read/write performance.

MongoDB Migration Engineer - Publicis Sapient - Hyderabad

(2024-04 - 2026-04)

• End-to-End Cloud Migration: Spearheaded large-scale, enterprise-grade cloud transformation initiatives, executing complex heterogeneous migrations from Oracle relational databases to MongoDB cloud platforms.
• ETL Pipeline Development: Designed and deployed robust, scalable ETL pipelines utilizing AWS Glue, AWS DMS, PySpark, and Python to handle high-velocity data ingestion and migration.
• NoSQL Data Modeling: Developed optimized MongoDB document-based data models, converting traditional relational structures into flexible, schema-evolved JSON documents using advanced embedded and referencing strategies.
• Standards & Architecture Alignment: Aligned data architectures with TMF Open APIs & SID standards to seamlessly support event-driven, API-first downstream integrations within the Telecom OSS/BSS ecosystem.
• Performance Optimization: Maximized read/write throughput and minimized costly join operations by implementing strategic indexing, sharding, and complex aggregation pipelines in MongoDB.
• Data Quality & Reconciliation: Built rigorous automated data reconciliation and audit frameworks across ingestion pipelines to guarantee 100% data integrity, quality, and strict compliance during migration phases.
• Cost & Scalability Management: Engineered data pipelines adhering to AWS best practices, drastically optimizing ETL performance, system scalability, and cloud infrastructure cost-efficiency.
• Cross-Functional Collaboration: Partnered closely with AWS Architecture, API development, and DBA teams to ensure seamless data delivery and robust downstream microservices connectivity.
• Migration Strategy Formulation: Defined and executed phased cutover and zero-downtime migration strategies for critical production systems moving from on-premise environments to multi-cloud platforms.
• Technical Mentorship & Governance: Maintained high coding and architecture standards by establishing governance guidelines for flexible schema evolution, pipeline monitoring, and error-handling workflows.

MongoDB ETL Engineer - Aligned Automation Services Private Limited - Pune

(2024-02 - 2024-04)

• Provided optimized Mongo queries to application developers. No-SQL data modeling.
• Created indexes and model collections to align with business needs.
• Developed SQL to no-SQL data migration tools. Performed data modeling and data migration.
• Created roles and users and set their permissions. Maintained and configured MongoDB instances.
• Configured, monitored, and deployed replica sets. Created aggregation pipeline and complex queries.
• Kept clear documentation of the database setup and architecture.
• Ensured high availability and stability of the MongoDB cluster.
• Upgraded databases through patches. Written procedures for backup and disaster recovery.
• Ensured that the databases achieve maximum performance and availability. MongoDB integration with Python applications.

Database Developer (MongoDB) - Pericius Technologies Private Limited - Bangalore

(2023-08 - 2024-02)

• Configured and maintained MongoDB instances. Written down procedures for disaster and backup recovery. Ensured all the databases achieve maximum availability and performance.
• Upgraded databases through patches. Created users and roles and set up their permissions.
• Removed, edited and created data required by a particular application. Evaluated network architecture and executed diagnostic tests. Upgraded all the information security systems for navigation and maximum performance.
• Documented code, conducted peer feedback and code reviews and made progress updates.
• Tested out the code for errors and apply all the right fixes. Made well-informed selections to technologies eg. Node.js, Python, Java, JavaScript & database languages that are compatible.
• MongoDB installation and administration in Red Hat and AWS.
• Worked with MongoDB security, backups and restores, manually and using MongoDB and other tools, created users, managed roles and permissions.
• Worked with MongoDB Shell, Atlas, Compass, Cloud manager, Studio3T, configured Grafana dashboards and tables.
• Deployed, monitored, configured replica sets and Sharded Clusters. Removed, edited, and created data required by application. Designed & developed indexing, aggregation pipelines.
• Data migration to different environment, report generation. Implemented bulk changes and development in the database. Tested out the code for errors and applied all the right fixes.
• Written down procedures for disaster and backup recovery. Written complex MongoDB queries, reports creation, coding & scripting using Java & Python.

Deputy General Manager (MongoDB) - Litmus World Marketing Technologies Pvt. Ltd - Bangalore

(2023-01 - 2023-07)

• Responsible to support deployment and Litmus Implementation on client side.
• Taken ownership of technical issues, data modeling, query & performance optimization, indexing, worked with the support & development team to debug and resolve technical issues.
• Performed MongoDB design, development, administration & deployment.
• Understood client requirements and mapped same to the LitmusWorld solution and troubleshot errors arising from the customizations. Upgraded databases, developed aggregation pipelines.
• Managed, hired resources, assisted and trained support team and developers.
• Got Engaged in clients, module leads, management, operations & business related calls.
• Handled MongoDB architecture, maintained and configured MongoDB instances, created user roles and set their permissions, API integration, creating & monitoring Cron tables & Cron jobs.
• Resolved client issues using JS, Java, AWS, MongoDB, Python, Unix, Bash & Shell Scripting.
• Implementation of large database-driven applications, script writing, data migration.
• Managed the ticket ownership process & provided tier 3 level support.
• Authored MongoDB queries, aggregation pipelines, CRUD operations, configured schemas, tables, created views, functions, indexes.

L2 Consultant (MongoDB) - ASZ Technologies Private Limited - Bangalore

(2021-09 - 2022-12)

• Cloud Infrastructure Monitoring: Orchestrated health checks and service delivery monitoring for Load Balancers, Admin & Web Servers using AWS CloudWatch, Lambda, and Cron Jobs; implemented composite alarms for proactive incident detection.
• Database Administration: Managed MongoDB collections and high-frequency CRUD operations; designed indexing strategies and developed complex aggregation pipelines to optimize query performance and document models.
• Incident & Service Management: Resolved mission-critical production incidents and service requests for global clients (including gaming and financial sectors) using ServiceNow, Jira, BMC Remedy, and Zendesk.
• Application Deployment: Facilitated seamless application deployments and revert processes on Amazon EC2; managed high-volume data scaling and image storage utilizing AWS S3 buckets.
• Technical Troubleshooting: Conducted deep-dive log analysis, UNIX administration and debugging using Bash and Python scripts/commands to resolve API integration issues and production bottlenecks.
• Quality & Governance: Performed manual and regression testing to ensure software stability; managed enterprise-level user access, account security, and MIS reporting via admin consoles and CRM platforms.
• Knowledge Management: Documented technical bugs and root-cause analyses in Confluence and Jira to streamline future troubleshooting and team onboarding.

Database Engineer (MongoDB) - DXC Technology - Bangalore

(2020-01 - 2021-07)

• Designed and implemented MongoDB data models, schemas, and queries for scalable applications.
• Developed, tested and optimized queries and aggregation pipelines.
• Implemented best practices for schema design, indexing, and query optimization.
• Review data movement between Mongo databases. Examined Configured, Setup, Structured, Queried, Storage, etc.
• Handled database upgrades, migrations, and patching.
• Ensured high availability, security, and performance tuning of MongoDB instances.

MongoDB Consultant - Flock Services - Patna

(2017-01 - 2019-01)

• Created and managed backup and recovery policies. Data migration and report generation.
• Assisted the Cloud team with migration and supporting infrastructure on AWS.
• Collaborated with developers to integrate database structures with applications.
• Backup and restore the organization's data files and systems.
• Managed AWS network architecture, network connectivity, AWS AMI Creation, snapshot and snapshot life cycle manager, implemented Linux on Virtual Machines.
• Worked remotely and collaborated in a virtual environment using Python & UNIX scripts.
• DB scripting on MongoDB, troubleshot, diagnosed and resolved complex issues.
• Identified opportunities for optimizing business and system effectiveness. Supported formal testing & resolved test defects. Written complex aggregation queries.

MongoDB Developer - SB3 Software Solutions Private Limited - Kolkata

(2011-07 - 2016-12)

• Designed, developed, and maintained MongoDB databases for high availability and performance.
• Implemented data models, indexing strategies, and schema design best practices.
• Optimized database performance through query tuning and monitoring.
• Managed MongoDB deployments on AWS cloud platform.
• Implemented replica sets, sharding, backup, and recovery strategies.
• Ensured database security, access control, and compliance.
• Collaborated with application developers, DevOps, and architecture teams.
• Troubleshot production issues and provided root cause analysis.
• Automated database operations using scripts and CI/CD pipelines.

MCA - GITAM University