Your Name
Summary
Highly qualified MongoDB DBA and MS SQL/BI consultant with over 7 years of experience in implementing end-to-end BI solutions using the Microsoft BI Stack (SSIS, SSRS and SSRAS) within several industries viz. Health, Banking, Financial Services and Insurance.
*Over 1+ years of experience in MongoDB large scale database systems.
*Extensive experience in designing MongoDB replica sets and multi-sharded 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.
*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, Mtools, Analysis of data usage for proper index creation and data modeling.
*Participate in scalability testing to ensure Mongodb high performance
*Experience in Mongo utilitie (mongostat, mongotop, mongoperf, mongodump and mongorestore).
*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.
Overview
7
7
years of professional experience
1
1
Certification
Work History
MongoDB Database Administrator (DBA)
Accenture Contractor Jobs
Austin, TX
12.2015 - 02.2017
- Implementation of MongoDB security mechanism with various Authentications.
- 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.
- Optimized T SQL Scripts by analyzing Execution Plans as well as using Microsoft Tools like SQL Profiler and Database Tuning Advisor.
- Experience in creating efficient ETL Strategy for initial load in to the databases as well as incremental load.
- Experience in Importing/Exporting Data from various data sources like Excel, XML, Oracle and Flat file using BCP, Bulk Insert & SSIS package.
- Experience using many of the SSIS transformations like Slowly Changing Dimension, Audit, Aggregate, Lookup, Fuzzy Lookup, Conditional Split, Derived Column, and Multicast.
- Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
- Good understanding of OLAP data warehouse design practices to include the design of cube objects, the design of optimal and efficient cube processing strategies based on infrastructure as well as cube size.
- Well versed in creating Parameterized Reports, drill down, linked, sub cascading Reports and Reports using SQL server Reporting Services.
- Developed Report Models based in Relational databases and created Ad Hoc reports to the specific users in the requested formats Using Report Builder.
- Proficient in using Report Manager for setting up roles, security on the reports and creating Standard and Data Driven Subscriptions in Delivery of Reports.
SQL / BI Developer
The Furniture Mart
Dubuque, IA
08.2015 - 12.2015
- Created and optimized objects such as
Data Architect
Deloitte
City, STATE
03.2015 - 08.2015
- 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 SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
- Maintaining and Automating SQLServer 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
SQL BI Developer
Stellar Technology
City, STATE
04.2013 - 03.2015
- Key Responsibilities
DBA / SQL Developer
Ethiopia Airline Addis
City, Ethiopia
09.2009 - 04.2013
- 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
Education
Bachelor of Science - Electrical Engineering
Jijiga Universiity
2008
Skills
- Management Studio, ER-Win, MS Visio
- RDBMS : MS SQL 2008/2008R2/2012, NoSql(MongoDB), Oracle 10g, MySQL
- Business Intelligence : BIDS/SSDT, SSIS, SSAS, SSRS, SharePoint 2010
- Programming Languages : JavaScript, Ruby, nodejs, AngularJS
- Operating Systems : Windows Server 2003/2008/R2, 7/8
- Code reviews
- Agile
- HTML and XML
- Ruby
- Linux
- Javascript
- Python
- MS Access
- Visual Basic
- MS SQL Server 2000
- Database management software
- Agile
- HTML and XML
- Ruby
- Linux
- MS Access
- MS Access
Certification
MongoDB Certified DBA. License # 125-014-548 and 659-748-811
MongoDB Certified Developer. License # 447-310-440
Microsoft Certified - 2012. Certification ID: 10737151
Accomplishments
Certification:
MongoDB Certified DBA. License # 125-014-548 and 659-748-811
MongoDB Certified Developer. License # 447-310-440
Microsoft Certified – 2012. Certification ID: 10737151
Timeline
MongoDB Database Administrator (DBA)
Accenture Contractor Jobs
12.2015 - 02.2017
SQL / BI Developer
The Furniture Mart
08.2015 - 12.2015
Data Architect
Deloitte
03.2015 - 08.2015
SQL BI Developer
Stellar Technology
04.2013 - 03.2015
DBA / SQL Developer
Ethiopia Airline Addis
09.2009 - 04.2013
Bachelor of Science - Electrical Engineering
Jijiga Universiity
MongoDB Certified DBA. License # 125-014-548 and 659-748-811
MongoDB Certified Developer. License # 447-310-440
Microsoft Certified - 2012. Certification ID: 10737151
Similar Profiles
null null
Salesforce Lightning Developer at Accenture Contractor JobsSalesforce Lightning Developer at Accenture Contractor Jobs
Ravikant ManiRavikant Mani
AWS Data Engineer at Accenture Contractor JobsAWS Data Engineer at Accenture Contractor Jobs
null null
SAP QM Consultant at Accenture Contractor JobsSAP QM Consultant at Accenture Contractor Jobs
Venkata PaletyVenkata Palety
Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems IncSr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems Inc
Ubaid MehrajUbaid Mehraj
Software Developer/Engineer, Network Administrator, Systems Administrator, Database Administrator (DBA), IT Security Analyst, DevOps Engineer, IT Support Specialist, Executive Assistant, Administrative Assistant, Paralegal Assistant, Office Clerk, Admin Coordinator, Office Manager, Program Manager, Business Analyst, System Analyst at Think Next Private LTDSoftware Developer/Engineer, Network Administrator, Systems Administrator, Database Administrator (DBA), IT Security Analyst, DevOps Engineer, IT Support Specialist, Executive Assistant, Administrative Assistant, Paralegal Assistant, Office Clerk, Admin Coordinator, Office Manager, Program Manager, Business Analyst, System Analyst at Think Next Private LTD