Uploaded File
add photo
Farhanaz
farhanazmdb@gmail.com
908-219-6390
Columbus, OH 43235
Sr. MongoDB Developer/Administrator
12 years experience W2
0
Recommendations
Average rating
59
Profile views
Summary

Around 7+ years of IT experience in database development, design and implementations mainly working on MongoDB Administration (versions 2.x, 3.0.0, 3.0.5 and 3.2x), LINUX, Oracle and SQL Server Administrator.

  • Proficiency in multiple databases like MongoDB, MySQL, Linux and MS SQL Server.
  • Completed M102: MongoDB for DBAs Training, Nov 2014
  • Ensure the continuous availability of our mission critical MongoDB clusters.
  • Disaster recovery strategies and regular recoverability test
  • Tuning and optimizing access patterns (queries, query sequences, commands) for MongoDB. Created multi-stage aggregation pipelines for data processing and analysis.
  • Microsoft Azure multi-region replica set replication and Optimizing MongoDB CRUD Operations.
  • Automate routine tasks using Linux shell scripts and Capacity planning, tuning, authentication and authorization.
  • Strong experience in implementing Spring framework like Struts 2.0, Spring 3.x and ORM tools like Hibernate in J2EE architecture.
  • Expertise in implementing various J2EE design patterns like Singleton, Session Facade, Data Access Objects (DAO), Factory, Data Transfer Object (DTO) and Business
  • Ops Manager monitoring, alert, automation, backup and restore performance tuning and indexing strategies.
  • Extensive experience in design, development and implementation of Model
  • View
  • Controller using Struts, Spring framework.
  • Setup Replication and Sharding along with data modeling and Schema design.
  • Experience in Data Warehousing, ETL and Data Mining.
  • Experience in the analysis of the data modelling and data structures.
  • Strong Experience in all facets of Software Development Life Cycle (SDLC)
  • Planning, Analysis and Design.
  • Installation of Packages, Patch Management, and Upgrades.
  • Experienced in installation, support, configuration, performance tuning, troubleshooting, maintenance of RedHat Linux and Solaris using Kick start, Custom Jumpstart Server and Interactive installation.
  • Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS)
  • Experienced in automated Linux installations, software distribution, and production deployment using SystemImager tool with RedHat Network Satellite server.
  • Experience in evaluation, installation, initialization, parameterization, configuration, optimization, standardization and maintenance of high-speed networks for LAN, WANS, Intranet and Internet.
  • Supporting and managing software releases as it relates to the database environment and data access.
  • Install and run MongoDB with multiple instances in servers.
  • Tuning and optimizing access patterns (queries, query sequences, commands) for NoSql
  • Designed and implemented the MongoDB Schema and used document references to query data
  • Extensive knowledge in MongoDB concepts and good knowledge in Administration.
  • Experience in upgrading and migrating various versions of Mongo database on different platforms.
  • Familiar with MongoDB clusters, Java scripting to load unstructured data into Sharding environment.
  • Developed enhancements to MongoDB architecture to improve performance and scalability.
  • Tuned CRUD operation building appropriate indexes, Write Concerns, Read Concerns, Read Preferences.
  • Highly motivated, self-starter with the ability to learn modern technologies and methodologies. Target oriented and possess excellent communication and interpersonal skills. Follow best standard programming practices and ability to work both independently and in a team.
  • Experience in upgrading and migrating various versions of Mongo database on different platforms and provide solutions related to the migration to MongoDB.
  • Extensive experience in designing MongoDB multi-Sharded cluster and monitoring with MMS.

TECHNICAL SKILLS

  • Operating System : Windows, Mac OS-X, Unix, Linux
  • Databases : SQL Server 2012, 2008 R2, 2008, 2005, MongoDB 2.2, 2.4, 2.6 and 3.0, 3.4 Sybase 12.5 and 11.5
  • Programming Languages : C, SQL, PL/SQL, Oracle.
  • Scripting Languages : Python, Java Scripting, Ruby Scripting, Shell Scripting, Angular JS, .Net
  • Database Tools : Mongo Utilities, Export-Import, SQL Loader, ETL
  • Application & Web Servers : Apache Tomcat, Web Logic, IBM http Sphere and Java Web Sphere

Experience
Sr. MongoDB Developer/Administrator
Information Technology
Jan 2016 - present
Dayton, OH
Responsibilities:
  • Ensure the continuous availability of our mission critical NoSQL clusters.
  • Worked on Disaster recovery strategies and regular recoverability test
  • Microsoft Azure multi-region replica set replication and Architect the MongoDB collections and documents for Oracle to MongoDB Migration.
  • Performed day-to
  • day Database Maintenance tasks including Database Monitoring.
  • Demonstrated success in Database migration and upgradation of 100+ SQL servers.
  • Administered SQL Server Cluster and stand-alone instance databases to new hardware.
  • Backups, Space, and Resource Utilization.
  • Ops Manager monitoring, alert, automation, backup and restore and performance tuning indexing strategies.
  • Responsible for performance tuning of the ETL process as well as reporting runtime and Coded/Designed/Automated ETL process.
  • Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.
  • Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.
  • Deployed Mongo Ops manager 1.8/1.6 and MongoDB Compass.
  • Created and maintained mapping files and transaction control in Hibernate.
  • Configuration and installation of MongoDB Ops Manager in Test, QA and Prod including setup of alerts, authorization and backup processes
  • Educate and guide staff about the MongoDB best practices
  • Global Collateral Database System (SQL, DB2).
  • Experience involves working with Spring Framework and Hibernate O/R Mapping tool.
  • Analyze business requirements, design specifications, coded and tested data results
  • Responsible to the development of subsystems that will accept and process trades from domestic and international sources.
  • Strong QA skills, including implementation of Test Plans and Test Cases Posses system development life cycle experience with Scrum, Agile, Kanban & Waterfall.
  • Responsible for data analysis and reporting using SQL queries and BASE SAS.
  • Worked on multiple BSON type objects and used based on requirement.
  • Potentially long running index building operations performed by creating Index in background. Migrated changes from test to production with Quality Assurance team.
  • Resolving the issues on priority basis. Analyzed, documented and resolved outstanding issues including Bug Fixes.
  • Developed database objects including tables, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems
  • Testing, Evaluation and troubleshooting of different NoSQL database systems and cluster Configurations to ensure high-availability in various Crash Scenarios. Worked on creating documents in Mongo database.
  • Working on MongoDB database design and Indexing Techniques. Good Knowledge on MongoDB write concern Majority.
  • Migrate Oracle tables to MongoDB collections. Oracle Forms & reports related development and changes for the Assignment Desk and Transmissions team.
  • Configuring high availability using geographical MongoDB replica sets across multiple data centers. Enabled Tag Aware Sharding by tag specific ranges of the shard key and associate those tags with a shard.
  • Familiar with MongoDB write concern to avoid loss of data during system failures. Environment: MongoDB 2.0, 3.0, 3.2,3.4, Oracle, RoboMongo, MongoDB Compass v3.0, NodeJS, BSON, JSON, Arbiter, Balancer, Mongo Shell, ExpressJS, Shell Scripting, Aggregation, Scrum, Agile, Waterfall, Spring Framework and Hibernate, Backup Scheduler, MMAP v1, Replication, Sharding, Balancer, Wiredtiger, Linux/Unix.
Agile Methodology Data Analysis Disaster Recovery ETL Hibernate JSON Linux MongoDB MS Azure node.js Oracle Python Ruby Scrum Shell Scripts Spring SQL SQL Server Triggers Database Design Database Maintenance Database Backups Quality Assurance
Remove Skill
MongoDB Administrator
Mar 2015 - Dec 2015
Responsibilities:
  • Provided 24x7 productions on call support for SQL Server and NoSQL databases.
  • Client Statements (MongoDB, Linux, Teradata)
  • Implemented the loading of Monthly Statements to MongoDB. Developer and administrative tasks includes Data Modeling and Schema Design development using testing configuration, installation and deployment to Dev, QA and Prod aggregate functions.
  • Design and implement Replication and Sharding.
  • Performance tuning and indexing strategies and MMS Monitoring, Alert, Backup and Restore. Sizing of Oplog based on Workloads and to maintain replication properly across all the nodes.
  • Knowledge on Sizing, Tuning, Authentication, Authorization
  • Disaster recovery and rolling maintenance, Backup, Restore and Production support.
  • Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.
  • Run the Oracle Statspack on the Oracle Instances to find out the System Performance statistics during the peak load times.
  • Responsible for supporting and maintaining transmission and processing of ratings information coming from the outside vendor to a Linux platform using Java and Python.
  • File transmission to mainframe and into Teradata for the consumption of Statements and and Designed and helped develop ETL process using IBM DataStage to process large volumes of data.
  • Database spaces execute and monitor sending Statements print files to Broad ridge to generate printouts and pdf copies of clients Statement accounts.
  • Setup, support and maintain APIs that access the DB2 tables from several
  • Applications. Ensuring data integrity during the flow of data going to and out of EDB MSD. Coordinated the production moves with front-end application programmers
  • Responsible in all facets of Software Development Life Cycle (SDLC), including requirements gathering, establish technical specifications, set deadlines and milestones, Designing, Coding, Testing, Quality Assurance and Production Deployment.
  • Utilized MEAN stack, REST design pattern, MVC framework and SPA (Single Page Application) framework based on Angular JS
  • Experience in design and developing Application leveraging MongoDB.
  • Experience with creating script for data modeling and Data Import and Export.
  • Extensive experience in Deploying, Managing and Developing MongoDB clusters.
  • Used MongoDB third party tools (ROBO MONGO, MONGOOWL, MONGOVUE) and mongo-built in binaries to monitor and analyze the performance of MONGODB.
  • Installation of MongoDB on Physical machines, Virtual machines as well as AWS.
  • Performance tuning and stress-testing of NoSQL database environments to ensure acceptable database performance in production mode.
  • Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios.
  • Upgraded Mongo systems and involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
  • Executed unit and system testing for batch and Online Modifications validated and documented the results. Environment: NodeJS, MongoDB, MYSQL, Angular JS, JSON, BSON, Bootstrap, Gulp, Cassandra, MMS, Linux/Unix, Backup Scheduler, Sharding, Replication, Mongo Shell, Arbiter, Wiredtiger, MMAP v1.
MVC SQL Linux MongoDB MySQL node.js Java AngularJS Bootstrap Cassandra Python Quality Assurance REST Data Integrity Disaster Recovery ETL JSON Oracle Database Maintenance
Remove Skill
MongoDB Administrator
Sep 2013 - Feb 2015
Responsibilities:
  • Installed and upgraded MongoDB clusters on physical and virtual machines including SSL.
  • Performed deployment, management, configuration, monitoring of production Replica sets, Shard sets and MongoDB clusters.
  • Implemented features of MongoDB to fit the requirements of the clients and the data according to the need of consistency, availability, sensitivity, redundancy, scalability, security.
  • Improved and optimized CRUD operations performance for read and write operations.
  • Tuned CRUD operation by building appropriate indexes, write concerns, read concerns, read preferences.
  • Created multi-stage aggregation pipelines for data processing and analysis.
  • Implemented MongoDB replication and Sharding.
  • Configured replication with replica set factors, arbiters, voting, priority, server distribution, slave delays.
  • Performed Sharding by choosing shard keys, Sharded server distribution, shard tags, manual chunk splitting and migration, balancer timing, config server setup, Mongos router setup.
  • Set up safe, fast and reliable manual or automatic backups using snapshots, Mongo dumps, and Ops Manager.
  • Monitored deployments for capacity and performance.
  • Implemented and monitored Ops Manager (management, automation and backup service)
  • Implemented and monitored deployments on MongoDB Cloud Manager and MongoDB Atlas.
  • Monitored the usage of journals and Oplogs.
  • Implemented security features, user roles, authentication and authorization, LDAP, SSL, and Kerberos.
  • Worked on different storage engines, analyzed their performances and effects on memory, concurrency control, data compression, encryption, backup.
  • Implemented GridFS and Mongo files for large chunks of data.
  • Developed and documented best practices for MongoDB.
  • Implemented operational automation using scripts Environment: MongoDB, Linux RedHat, Ubuntu, Windows Server 2008, SSL, Azure
Data Replication Linux MongoDB MS Azure Windows Server
Remove Skill
Sr Linux Administrator
Jan 2013 - Aug 2013
Vienna, VA
Responsibilities:
  • Installed/Configured/Managed/Administrated all Unix/Linux servers, includes the design and selection of relevant hardware to support the installation/upgrades of Red Hat (5/6/7), Solaris 8/9/10 operating systems Importing Backup Database and Restoring the table.
  • Extensive experience in configuring and building RHEL 5/6 /7 servers using Kickstart
  • Extensive experience in User Administration with creating users, groups, and giving permissions.
  • Installing and managing packages using command line utility using RPM and YUM.
  • Performing Servers consolidation and virtualization using VMware virtual infrastructure, VMware ESX, up gradation of VMware tools.
  • Scanning the newly assigned LUNs to the serves and assigning them to volume group and creating file systems using Logical Volume Manager (LVM)
  • Adding storage to the cluster disks and increasing/ decreasing the filesystem in RHEL.
  • Upgrading HP ILO & BIOS Firmware as HP recommendation regularly on HP servers.
  • Administration and support of Homogeneous production and development server infrastructure of multiple flavors of Linux and Solaris.
  • Experience in Solaris 10 zones, ZFS, and installation of packages and patching the servers
  • Responsible in building servers from scratch, deployment activities, and environment support including installation, configuration diagnostics, planning and upgrades.
  • Developed Shell Scripts (Shell, Python) for automating administration tasks like file system management, process management, backup and restore.
  • Maintained Load balancing, High availability, Failover functionality, and Disaster recovery included changing IP address of the web and app server machines, which caused change in the virtual host and http transport configurations.
  • Monitoring of space availability on each file system using the Shell Scripts.
  • Responsible for installing, configuring, maintaining, upgrading, and troubleshooting EMC powerpath on RedHat Linux and Solaris
  • Experience in handling ticketing tool SBM Team Track to manage the build flow of the servers.
  • Working with backup team for the TSM backup & Restore in the RedHat Linux server.
  • Installation of third party tools like security tool Symantec CSP, Splunk Agent, IBM License Metric Tool Environment: RHEL 5.x/6.x/7.x, VMware vSphere, HP ProLiant Servers DL series, Tivoli Monitoring, TSM Backup, EMC Powerpath, SBM TeamTrack, Splunk, SCSP, ILMT.
Disaster Recovery Kickstart Linux OpenShift Python RedHat RHEL Shell Scripts Solaris Splunk UNIX VMWare vSphere Database Upgrades Virtualization
Remove Skill
Oracle Database/Linux Administrator
Information Technology
Feb 2011 - Nov 2012
Responsibilities:
  • Physical and Virtual Machines build in Red Hat.
  • Installation of Oracle 11.1.0.7 on Oracle Linux.
  • IBM AIX, Oracle Solaris installation and configuration, design and implementation.
  • User Management, ACL's, handling permissions/ownerships as per the client request.
  • Maintenance, Performance tuning, disk mirroring using LVM, backup, disaster recovery, trouble shooting and user management.
  • Handling system maintenance and file management with shell scripting.
  • Worked as Red Hat Linux/Unix System Administrator for UNIX Engineering Group.
  • Handling 150 Servers. Deployed My SQL database platforms on various production environments.
  • Installation and configurations SQL, PLSQL, Oracle.
  • Worked with Backup team in resolving issues related to Tivoli storage (TSM).
  • Day to Day activities included Handling Security issues like stale UNIX account Cleanups, 90-day password changes, setting max age and min age, creating a list of unmask permission for various users.
  • Carry general administration tasks using tools like OEM and Toad.
  • Working experience on VG3, VG4 and web logic and Experience on web-Logic Works
  • VG4
  • about 135 Linux environments.
  • Experience with Ecommerce web site administration and platforms such as IBM Web Sphere Commerce, and Tomcat. Strong skills in OPENSTACK installation as an open-source cloud-software, we managed large pools of compute, storage, and networking resources throughout a datacenter. Responsible for installation, troubleshooting and maintenance of 1800 Red hat/SUSE servers and 1000 servers running Solaris 10/11 on x86 and SPARC.
  • Experience in setting up an Open stack for Amazon Cloud service in IT organizations as to Infrastructure-as-a-Service (IaaS) in Red Hat servers.
  • Experience supporting SUSE servers in Production and Development environments.
  • We also used open stack for dashboard that gives administrators control while empowering their users to provision resources through a Web Interface.
  • Managing Swap Space, Memory and CPU issues.
  • Experience on middleware infrastructure that is designed and tuned to meet the needs of applications.
  • Used command line and advanced commands options in Red Hat Linux. The work also included updating patches in all the Linux servers and doing Performance Tuning. Also, used various tools to monitor the server's health in a production environment.
  • Disk group creation, file system creation and mounting in LVM/SVM.
  • Firmware upgrade on Linux and Solaris and Servers Installed, configured and maintained VIO server.
  • Performing O/S upgrades and Maintenance level upgrades.
  • Troubleshoot hardware, software and Operating system and network related errors on Red Hat Linux and AIX.
  • Install Multipathing software such as EMC power path, HDLM.
  • Experience in working with Red hat software cases/Oracle SR's / Symantec cases on root cause for reoccurring issues.
  • Manage and troubleshoot printer issues and Installed SUSE Linux through Autoyast via NFS and HTTP on Dell Servers.
  • Installed and worked on VMware Workstation 5.0.0 & Installed VMware tools. Environment: Oracle 11g/10g, Cisco Blade server Oracle Enterprise Linux, RMAN/10g Enterprise manager, Cisco Load balancer
AIX Cisco Database Upgrades Linux NFS OpenShift Oracle Solaris SuSE VMWare Database Maintenance Dell Servers Dell Oracle Hr
Remove Skill
SQL Server DBA
Information Technology
Nov 2009 - Jan 2011
Responsibilities:
  • Installed SQL server 2005 on the servers according the requirements and Performed Upgrade of SQL server 2005 to SQL Server 2008.
  • Performed Side by Side Installation of SQL Server 2008 and 2008R2.
  • Configured SQL server 2005 according the requirement.
  • Performed the hardening on the SQL server2005.
  • Changed SQL directories owner to the Administrator account.
  • Implemented Audit policy in the system registry for SQL Server 2005
  • Performed Full backup and Restored on the SQL 2005.
  • Transferred the logins, jobs, linked servers.
  • Upgraded DTS packages to SSIS packages.
  • Created SQL admin accounts and dropped the Built-in
  • Admin.
  • Changed all jobs owner from SA account to administrator account.
  • Created maintenance plan for user databases and system databases.
  • Implemented data base mail and Created operator and assigned the operator to the jobs.
  • Implemented database mirroring and Fail over Clustering for Instance -I and added Instance-II (Active/Passive).
  • Implemented Log Shipping and Replication (Snapshot/Transactional/Merge).
  • Performed the Full backup & restore operations in Full Recovery mode and Supported on call on rotational basis and supported the data bases 24\7.
  • Created the script to find all SQL server version, license type, service pack.
  • Monitored the Performance of SQL Server using PERFMON, ranTraces using SQL Profiler, used Query Execution Plan (Table scan / Statistics). Identified the slow running queries and tuned the long running queries/SPs. Database Engine Tuning Advisor is used and tuned the indexes of the Tables to make more efficient. DB comparison Tool is used for comparing the Objects available in two Servers.
  • Created the script to monitor the all server's logical disk free spaces.
  • Transferred the data base objects from dev to QA to prod.
  • Revoked the public role object level permissions and Changed the SQL and SQL Agent account to domain accounts.
  • Integration Services, Analysis Services & Reporting Services are performed using SSIS, SSAS& SSRS for different Requirements of the Client.
  • Developed several SSIS Packages, extracted data from multiple Data Sources like Oracle, DB2, Excel-Flat Files, MS Access, Teradata, Cleansed//transformed data using control flow task/data flow task elements and loaded on to SQL server Databases by configuring the Connections and Deployment of Packages.
Data Replication Database Backups DB2 DBA Microsoft Excel Oracle Project Management SQL SQL Server SSIS SSRS Database Maintenance Quality Assurance
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
Andhra University
Skills
Linux
2021
8
Database Maintenance
2021
7
Oracle
2021
7
MongoDB
2021
6
Quality Assurance
2021
6
SQL
2021
6
Database Backups
2021
5
Disaster Recovery
2021
5
MS Azure
2021
5
Python
2021
5
SQL Server
2021
5
Agile Methodology
2021
4
Data Analysis
2021
4
Database Design
2021
4
ETL
2021
4
Hibernate
2021
4
JSON
2021
4
node.js
2021
4
Ruby
2021
4
Scrum
2021
4
Shell Scripts
2021
4
Spring
2021
4
Triggers
2021
4
Data Replication
2015
2
Database Upgrades
2013
2
OpenShift
2013
2
Solaris
2013
2
VMWare
2013
2
AIX
2012
1
Cisco
2012
1
DB2
2011
1
DBA
2011
1
Dell
2012
1
Dell Servers
2012
1
Microsoft Excel
2011
1
NFS
2012
1
Oracle Hr
2012
1
Project Management
2011
1
SSIS
2011
1
SSRS
2011
1
SuSE
2012
1
Windows Server
2015
1
.NET
0
1
AngularJS
2015
1
Apache
0
1
Apache Tomcat
0
1
BEA WebLogic
0
1
Bootstrap
2015
1
C
0
1
Cassandra
2015
1
Data Access
0
1
Data Integrity
2015
1
Data Mining
0
1
Data Modeling
0
1
Data Warehousing
0
1
Design Patterns
0
1
IBM WebSphere
0
1
J2EE
0
1
Java
2015
1
Kickstart
2013
1
MVC
2015
1
MySQL
2015
1
Patch Management
0
1
RedHat
2013
1
REST
2015
1
RHEL
2013
1
Splunk
2013
1
SQL Loader
0
1
Struts
0
1
UNIX
2013
1
Virtualization
2013
1
vSphere
2013
1