We provide IT Staff Augmentation Services!

Mongodb Database (dba) Resume

3.00/5 (Submit Your Rating)

DenveR

SUMMARY

  • Experience in MongoDB large scale database systems.
  • Experience in designing MongoDB multi - sharded cluster and monitoring with Ops Manager.
  • Experience in designing MongoDB replica sets and multi-sharded cluster.
  • Experience in upgrading and migrating various versions of Mongo database on different platforms.
  • Designed and developed load balancing Mongo applications.
  • 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, SSAS, Power Bi) with in several industries
  • Good experience on advanced queries, query conditionals and aggregation framework.
  • Good experience on MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.
  • SSL encryption, Analysis of data usage for proper index creation and data modeling.
  • Experience migrating from Microsoft SQL to MongoDB
  • Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and non-functional requirements.
  • Experience in deploying, managing and developing withMongoDBclusters.
  • Familiar withMongoDBclusters, performance tuning, backup and recovery.
  • Participate in scalability testing to ensureMongo dBhigh performance
  • Experience in Mongo utilities (mongo stat, mongo top, mongoperf, mongo dump and mongo restore).
  • Manage run-time configuration, processes, scaling, backup and recovery, monitoring, and performance tuning for productionMongoDBinstances.
  • Implementation ofMongoDBsecurity mechanism with various Authentications.
  • Experience on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
  • Experience in creating and debugging large T-SQL database scripts and batches to facilitate effective database management.
  • Experience in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2005/2008/2008 R2, 2012 and 2014 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.
  • Hands on experience in aviation operation, customer relation, weight and balance and airport operations.
  • DevelopedPowerBImodel used for financial reporting.
  • Experience in writing complex DAX functions inPower BI.
  • Used various sources to pull data intoPower BI such as Sql Server, Oracle, SQL Azure etc.
  • Installed and configured Enterprise gateway and Personal gateway in Power bi service.
  • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Worked on all types of transformations that are available in Power bi query editor
  • Created stored procedures, Views and SQL queries to pull data intopowerBI model.
  • Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
  • Transformed complex business logic into Database design and maintaining it by using SQL objects likeStored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
  • Creating and Modifying Tables,Stored Procedures, Views,Indexes, User-defined Functions, andTriggersas required.
  • Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
  • Created Datasets in T-SQL, stored procedures for SSRS.
  • CreatedSSISpackages to import data fromAccess,Excel, XML, OLE DB Source and Flat files.
  • Filtered bad data usingDerived column, Lookups, Fuzzy Lookups,Conditional split.
  • DesignedSSISpackages to import and transform data between databases and external data sources using various transformations likeData conversion,File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
  • Debugging SSIS packages, Performance tuning onslowly running SSIS Packages.
  • Created Reports usingCharts,Gauges,Tables and matrix.
  • Created Parameterized Report,Dashboard Report,Linked reportandSub Report by Year, Quarter, Month, and Week.
  • Created Drill Down,Drill Through Reportby Region

TECHNICAL SKILLS

Database Tools: Management Studio, MS Visio

RDBMS: MS SQL 2008/2008R2/2012/2014, NoSQL (MongoDB), MySQL

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, Power Bi

Programming Languages: JavaScript, MSQL

Operating Systems: Windows Server 2003/2008/R2, 7/8

PROFESSIONAL EXPERIENCE

Confidential, Denver

MongoDB Database (DBA)

Responsibilities:

  • Creating and monitoring database objects like Indexes, Views, Users, and DB Links.
  • Performing CRUD operations like Read, Update, Insert and Delete records in MongoDB.
  • Working on MongoDB database concepts such as locking, indexes, Sharding, replication, schema design, etc.
  • Working on creating various types of indexes on different collections to boost performance in Mongo database.
  • Experience in managing MongoDB environment from availability, performance and scalability perspectives.
  • Configuring high availability using geographical MongoDB replica sets across multiple data centers.
  • Migrating Mongo database systems from No-SSL authentication to SSL authentication using certificates.
  • Migrating Mongo database from MMAPV1 storage engine to Wired Tiger storage engine.
  • Managing Mongo databases using MMS monitoring tool.
  • Performing ad-hoc backups using Mongodump and Mongorestore.
  • Implementing write concern and read preferences in MongoDB replica set.
  • Configuring delayed secondaries to avoid data loss due to human errors.
  • Experience in analyzing chunk migrations, splitting and balancing across the cluster.
  • Troubleshooting server and database issues and bugs
  • Experience in writing complex DAX functions inPower BI.
  • Used various sources to pull data intoPower BI such as Sql Server, Oracle, SQL Azure,
  • Installed and configured Enterprise gateway and Personal gateway in Power bi service.
  • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Worked on all types of transformations that are available in Power bi query editor
  • Created stored procedures, Views and SQL queries to pull data intopowerBI model.
  • Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
  • Transformed complex business logic into Database design and maintaining it by using SQL objects likeStored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
  • Creating and Modifying Tables,Stored Procedures, Views,Indexes, User-defined Functions, andTriggersas required.
  • Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.
  • Created Datasets in T-SQL, stored procedures for SSRS.
  • CreatedSSISpackages to import data fromAccess,Excel, XML, OLE DB Source and Flat files.
  • Filtered bad data usingDerived column, Lookups, Fuzzy Lookups,Conditional split.
  • DesignedSSISpackages to import and transform data between databases and external data sources using various transformations likeData conversion,File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
  • Debugging SSIS packages, Performance tuning onslowly running SSIS Packages.
  • Created Reports usingCharts,Gauges,Tables and matrix.
  • CreatedParameterized Report,Dashboard Report,Linked reportandSub Report by Year, Quarter, Month, and Week.
  • CreatedDrill Down Reports, Drill Through Reportby Region

Environment: MongoDB, MMS, Linux/Unix, LVM Snapshots, Backup, Sharding, Replication, JavaScript

Confidential, Denver

SQL / BI Developer

Responsibilities:

  • Creating and optimizing objects such as: Stored Procedures, Triggers, User define functions, Indexes and Views.
  • Developing ETL solutions to support key business data flows
  • Deploying, securing and automating SSIS packages.
  • Verifying accuracy and consistency of data and supporting the Data base.
  • Designing ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
  • Developing SSIS packages to transform and load data from various sources.
  • Implementing data security and integrity strategies.
  • Developing cubes with dimension and fact table to facilitate speedy aggregation and delivery of data.
  • 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,2012, T-SQL, MS VISIO, Windows 2003/2008, SSIS, SSRS, SSAS

Confidential, Denver

Database/Bi Developer

Responsibilities:

  • Loading data to the interface tables from multiple data sources using OLEDB, ODBC, ADO.NET connections.
  • Developing T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.
  • Writing TSQL code and complex stored procedures for different tasks.
  • MSSQLServer installation, configuration.
  • Designed SSIS Packages to transfer data between servers.
  • Optimizing the performance of slow executing SSIS packages.
  • Designing and developing SSIS Package templates for speedy future development.
  • Creating Quality Assurance scripts to assure data integrity.
  • Developing OLAP cubes for speedy aggregation and delivery of data.
  • Importing or exporting data from heterogeneous sources like SQL Server, Excel, CSV and archive data files
  • DesigningSQLSSIS Packages in Business Intelligence Development

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

Confidential, Addis Ababa, Ethiopia

SQL BI Developer

Responsibilities:

  • Gathering business requirements.
  • Developed interactive and static reports, sub reports, drill through, drill-down reports using Various features like Matrix, Table, Charts, Graphs and Dashboard.
  • Developing and creating logical and physical database architecture.
  • Creating stored procedures, Functions, triggers for reporting, ETL and data consistency checks.
  • Enhancing and deploying SSIS Packages from development server to production server.
  • Monitoring, tuning indexes to increase query performance,
  • Examining and evaluating data structures to fill gap between source and destination databases.
  • Developing complex SSIS packages to extract, transform and load data from heterogeneous sources
  • Optimizing the performance of slow executing SSIS packages.
  • Designing and developing SSIS Package templates for speedy future development.
  • Creating Quality Assurance scripts to assure data integrity.
  • Developing OLAP cubes for speedy aggregation and delivery of data.
  • Developing complex reports, ad-hoc reports, dashboards and KPIs.
  • Generating different scheduled reports delivery to e-mails, shared directories and subscriptions;

Environment: MS SQL Server 2008 R2, SSIS, SSAS, SSRS, Excel, Windows server, Power Pivot

We'd love your feedback!