SUMMARY

• Highly qualified with over 8+ years of experience worked on, as a MongoDB DBA/Developer and MS SQL/BI consultant in implementing end - to-end Business solutions using the NoSQL ( MongoDB) and Microsoft BI Stack (SSIS, SSRS and SSRAS) within several industries.
• Installed and configured OPS manager automation agent, monitoring agent and backup agent for Maintaining Sharded cluster, High availability and security across all nodes.
• Configuring Shard cluster with replica sets across multiple AWS Availability Zone.
• Experience in MongoDB large scale database systems.
• Implementation of MongoDB security mechanism with various Authentications.
• Experience in designing MongoDB multi-shaded cluster and monitoring with Ops Manager.
• Extensive experience in designing MongoDB replica sets and multi-shared cluster.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting NoSQL databases like Mongo and Cassandra databases.
• Designed and developed load balancing Mongo applications. create Single, Compound and Multi key indexes on any field or embedded field within a document or embedded document and array document.
• Worked on mongo db data model design, use Embedded data models and Normalized data models ( References)
• Worked on MongoDB join ($ lookup) on sharded and non-sharded clusters. experience on advanced queries, query conditionals and aggregation framework.
• SSL encryption, Analysis of data usage for proper index creation and data modeling.
• Experience migrating from Oracle SQL and Microsoft SQL to MongoDB
• Participate in scalability testing to ensure MONGODB High Performance
• Implemented TTL and indexing based on collection data time duration.
• Experience in Mongo utilities (MONGOSTAT, MONGOTOP, MONGOPERF, MONGODUMP and MONGORESTORE)
• Worked on JSON Schema validation on different collections.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and non-functional requirements.
• Extensive experience in deploying, managing and developing with MongoDB clusters.
• Familiar with MongoDB Clusters, performance tuning, backup and recovery.
• Manage run-time configuration, processes, scaling, backup and recovery, monitoring, and performance tuning for production MongoDB Instances.
• Well versed with Software Development Life Cycle (SDLC) process and familiar with RUP, Spiral, XP and Agile and Scrum Models. Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema. Hands on experience with Erwin to forward and reverse engineer data models.
• Extensively created and debugged large T-SQL database scripts and batches to facilitate effective database management. Highly Proficient in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2005/2008/2008 R2 and 2012 Servers. Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.

PROFESSIONAL EXPERIENCE

MongoDB Specialist

Confidential - Honolulu, HI

Responsibilities:

• Configuration and installation of MongoDB Servers and Ops Manager in Integration, Test and Prod Environment.
• Worked on Installation and configure MongoDB Cluster nodes on different AWS EC2 instances.
• AWS EC2 stress-testing of MongoDB database environments to ensure acceptable database performance in production mode.
• Deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS Available Zone.
• Configure MONGODB Sharded cluster with Replica Set (HA) on Different AWS regions.
• Use Ops Manager for upgrading 3.4 version to 3.6 version.
• Worked on schema validation roles to get clean data from integration (MuleSoft) server.
• Worked on mongodb data model design based on application needs, and use Embedded data models and Normalized data models ( references)
• Secured MongoDB Database using MongoDB-CR and SCRAM-SHA authentications. create Single, Compound and Multikey indexes on any field or embedded field within a document or embedded document and array document.
• Create grants access to data and commands through role-based authorization and create user-defined roles.
• Configure MongoDB to support TLS/SSL use to encrypt connections to mongod and mongos instances.
• Configure MongoDB to use TLS/SSL for all incoming and outgoing connections.
• Configure LDAP and active directory (AD) and create custom roles.
• Configure sharded cluster that consists of a mongos, the config server replica set, and three shard replica sets.
• Worked on JSON Schema validation on different collections.

Environment: MongoDB, Sharding, Replication, Shell Scripting, AWS, Java Script, MS SQL, MuleSoft SSIS, SSRS.

MongoDB DBA

Confidential, MD

Responsibilities:

• Installed, setup and configure MongoDB Server on AWS Cloud.
• Experience in deploying, managing and developing MongoDB clusters.
• Familiar with Clusters, Performance tuning, backup and recovery.
• Configured to read data from secondary server to reduce load on primary in replica set environment.
• Created collections and performed CRUD operations on MongoDB using Mongo Driver and mongo Repository.
• Considering storage optimization for small documents.
• Used document references to query data from multiple collections.
• Experienced in performing Backup and recovery using Ops manager.
• Performed Data Migration between multiple environments using MONGORESTORE and MONGODUMP
• Evaluating the Indexing strategies to support queries and sort documents using index keys.
• Enabled Journaling across all mongo instances for auto recovery of data after unexpected shutdown.
• Used MongoDB internal tools like Mongo Compass, Mongo Atlas Manager & Ops Manager, and Cloud Manager Etc.
• Worked on MongoDB database concepts such as locking, transactions, indexes, sharing, replication and schema design.
• Worked with huge reporting collections to wipe out aged data based on requirements.
• Performed CRUD operations like Update, Insert and Delete data in MongoDB.
• Worked on creating different type of indexes based on different collections to get good performance in MongoDB.
• Configured delayed secondary's to avoid human failures in coding and development.
• Responsible for Ops Manager monitoring, performance tuning and troubleshooting tasks
• Experience in creating JavaScript for using DML operation with MongoDB.
• Created multiple databases with shared collections and choosing shard key based on the requirements.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Experienced in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB, Sharding, Replication, Shell Scripting, AWS, Java Script, PostGre SQL.

MongoDB Database Developer

Confidential

Responsibilities:

• Created and monitored database objects like Indexes, Views, Users, and DB Links.
• Created Partition's estimated stats on one partition and copied the stats to remaining partitions using DBMS STATS.
• Performed CRUD operations like Update, Insert and Delete data in MongoDB.
• Experience migrating from Oracle SQL and Microsoft SQL to MongoDB
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design, etc.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Worked on creating documents in Mongo database.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using MONGODUMP and MONGORESTORE.
• Worked with capped collections to wipe out aged data based on requirements.
• Administered multiple environments (up to25 TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• Implemented read preferences in MongoDB replica set.
• Configured delayed secondary's to avoid human failures in coding and development.
• Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Skilled in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB, Cassandra, Ruby, MMS, Linux/Unix, LVM Snapshots, Backup Scheduler, Data guard, Sharding, Replication, Python, Shell scripting, Perl, JavaScript

SQL / BI Developer

Confidential - Scottsdale, AZ

Responsibilities:

• Created and optimized objects such as: Stored Procedures, Triggers, User define functions, Indexes, Views, and Index views.
• Designed a database optimization plan involving the creation of Table Partitions and the use of appropriate Indexes as recommended by Microsoft's Index Guidelines.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2008 Server target staging database.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Implemented Error Handling during ETL load in SSIS packages to identify dimensions and facts that were not properly populated.
• Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
• Monitored all the packages that were scheduled. Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Produced and Documented test summary information and signed-off testing to facilitate implementation in production environment.
• Used SQL 2008 Server Analysis Services to design cubes with dimensions and facts and created different cube objects like KPIs, Drill through Actions, Perspectives, Aggregations, and Translations.
• Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports.
• Created reports with bookmark and document map inside them to navigate the items inside the reports.
• Hands-on experience in managing Reporting Server and creating ad-hoc reports from OLTP and OLAP including its delivery using push and pull delivery methods.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Create caching report, snapshot to reduce the burden of report server. Along with creating snapshot, both standard subscription and data-driven subscription.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.

Environment: MS SQL Server 2008R2/08, T-SQL, MS VISIO, Windows 2003/2008 Server, SSIS, SSAS, SSRS

Data Architect

Confidential, Phoenix, AZ

Responsibilities:

• Providing On-Call Support for all SQL Server based Applications on rotation basis, comprising 162 SQL Server Instances.
• Analyzing and designing and implementing different types of Replication Models.
• Configuring 3rd Party Tools like Quest Foglight and Oracle Client Tools on SQL Servers and Working with Oracle DBA team for TNS Issues or any other Oracle Issues for our Linked Servers.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Maintaining and Automating SQL Server like, Configuring Database Mail, creating an Operators, Creating Jobs, Alerts, Database Maintenance plans.
• Took the lead in many occasions to Analyze/Fix Performance Issues of Applications.
• To Lead, mentor and/or provide guidance to less experienced database analysts, where applicable, including guidance for troubleshooting escalated issues.
• Designed SQL SSIS Packages in Business Intelligence Development
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views

Environment: MS SQL Server 2008R2/08, T-SQL, BIDS, SSIS, SSAS, SSRS, Access, Excel, SQL Agent, Profiler, TFS

SQL BI Developer

Confidential

Responsibilities:

• Gathered business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse for reporting.
• Conducted JAD sessions with different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
• Developed and created logical and physical database architecture using Erwin.
• Created stored procedure for auditing purposes as well as triggers for data consistency checks.
• Dramatically increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Examined and evaluated the data structures in the source and destination databases / staging Tables.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle into the SQL 2008R2/2012 Server target staging database.
• Developed complex ETL Packages using SQL Server 2008R2/12 Integration Services to load data from various sources like Oracle/SQL Server/DB2 to Staging Database and then to Data Warehouse.

DBA / SQL Developer

Confidential 

Responsibilities:

• Troubleshoot and diagnose customer issues, documenting recreation steps.
• Trouble shooting issues related to SQL, SSIS and SSRS.
• Managing customer issues in On Time, customer issue status communications.
• Designed and developed various reports such as Tabular, Matrix, Drill-down, Drill Through, and Parameterized Reports using SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Created SSIS Package for uploads and schedule them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Handled Initial and Delta loads and also used Error Handling, Logging and Checkpoints and made use of Configuration files.
• Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
• Created/Updated Stored Procedures and User Defined Functions with extensive use of T-SQL.
• Responsible for creating database objects (table, views, store procedure, triggers etc.) to provide structure to store data and to maintain database efficiently.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Responsible for creating the tables, views, stored procedures.
• Involved in designing conceptual, logical and physical model of the relational databases (OLTP and OLAP)
• Supported the existing BI platform for populating data warehouses.
• Designed complex stored procedures to perform data profiling in the pre-staging database.
• Analyzed different heterogeneous sources like Excel, Oracle, Flat Files, and SQL Server 2005 for ETL strategy that needs to be implemented with the help of SSIS packages.
• Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Implemented Data conversion and data migration techniques at necessary times through the project life cycle.
• Implemented Master/Child Package Models to ensure that only the Master Package is scheduled which will in turn fire the other packages.
• Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
• Written test scripts in T-SQL to validate data on staging tables and data warehouse tables to validate the data results.
• Pre-Calculated the Aggregation Objects based on required performance gains so that reports can be generated within a window of time as described in the business requirement document
• Participated in the monitoring of the SQL server performance using tools like SQL profiler, database engine tuning advisor and command line tools.
• Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications.
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistics information according to business requirements.
• Generated various reporting services RDLs using reporting services for Account Aggregation reports.
• Created Ad-hoc Reports using Report Builder and Report Models using Business Intelligence Development Studio to provide a template for end-users to create reports by themselves with a preselected group of relational tables.
• Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.

Environment: MS SQL Server 2008R2/08, T-SQL, BIDS, SSIS, SSAS, SSRS, Access, Excel, SQL Agent, Profiler, TFS