SUMMARY:

• 11+ years of IT experience, including extensive knowledge and proficiency in NoSQL, Mongo, Couchbase, Cassandra, Oracle, MySQL and SQL database administration and development, test and production environments.

TECHNICAL SKILLS:

Databases: RDBMS MySQL, Oracle, Postgres. NoSQL MongoDB, Cassandra, Couchbase.

Cloud service: AWS, Azure

Scripting & Automation: Bash Scripting, JavaScript, Perl

Programming: Java, Python

Opensource tools: Git, Nagios, and JMeter.

Containers: Dockers.

OS: CentOS/Redhat, Windows, Mac.

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Sr. NoSQL DBA/ MongoDB Admin/Couchbase DBA

Responsibilities:

• Install, monitor and upgrade NoSQL (Couchbase and MongoDB) Databases on all environments (DEV, SIT, UAT, PRODFIX, PROD).
• Expertise in setting up MongoDB clusters in Azure and AWS cloud Environments.
• Configuring SSL and Kerberos (Security) to Mongo Clusters. Creating Users and User defined roles in Mongo Database.
• Working and fixing issues related to DBA. Working on MongoDB Ops Manager configuration.
• Integrate Active Directory to Ops Manager.
• Installation of NoSQL MongoDB on physical machines, Virtual machines as well as AWS
• Setting up MongoDB clusters for Automation, monitoring, backup & restore through Ops Manager.
• Providing knowledge transfer to other teams on MongoDB technology & tools. Help other teams in troubleshooting and fixing MongoDB issues.
• Automating manual effort by writing Shell or Java Scripts.
• Couchbase cluster Tuning and Configuration. Operationalization and Runbook Creation. Review & Provide Subject Matter Expertise during the course of the project kickoff.
• Enabled SSL, PEMKeyFile, CAFile and coordinated with Devops team and Linux Admins regards to Root Certificate.
• Assist with N1QL tuning.
• Manual Backups and Restore are done using Mongodump, mongoexport and mongoimport depending on the needs.
• Good knowledge in implementing SQL database in SQL Azure/AWS cloud computing platform
• Assist with Performance Testing and Optimization
• Assist with incident resolution by working with Couchbase engineering Support team Assist app teams during stress testing application with Couchbase .
• Assist with design Couchbase high availability and failover capabilities, to meet application requirement.
• Test and provide feedback on new version Features and functionalities Assist with design of XDCR and High availability setup to meet application requirements.

Environment: MongoDB 4.0/3.6, Couchbase, AWS, Azurem SQL, Java, Kerberos, Git, Nagios, Dockers, Google Cloud Platform, Cavisson, Jira, Automata, mongostat, mongotop and UNIX/Linux.

Confidential, Chicago, IL

Infra Architect (NoSQL and Open Source databases)

Responsibilities:

• Lead technical MongoDB architecture analysis requirement gathering and due diligence activities.
• Lead the team in formulating, articulating and prioritizing key mile stones for MongoDB project.
• Installation, Configuration, Administration and monitoring of MongoDB clusters.
• Enabling security features like authentication, encryption, network - based authentication and auditing of the nodes.
• Configuring Ops Manager and backup services with necessary alerting enabled for the cluster.
• Provide business development support by assisting in RFP/ RFI response drafting, presentations, collateral creation and formulating recommendations.
• Create and review business development artifacts like case studies. Migration of existing applications to MongoDB.
• Configuring Replication to achieve high availability and Sharding to achieve scalability of cluster.
• Participate in client engagements and own the Solution from a technical point of view.
• Identify and develop areas of automation in areas like deployment & upgradation using Bash scripting and Perl scripts.
• Continuous monitoring and evaluate performance of the system and participation in performance tuning activities.
• Providing 24*7 support in managing complex production environments. Ensure deliverables are in line with client expectation/standards.
• Proactively identify technical risks in immediate area of responsibility.

Environment: MongoDB 3.6/3.2, RFP/ RFI, Couchbase, AWS, Azurem SQL, Java, Kerberos, Git, Nagios, Dockers, Google Cloud Platform, Cavisson, Jira, Automata, mongostat, mongotop and UNIX/Linux.

Confidential, San Jose, CA

Database Administrator (MogoDB, NoSQL)

Responsibilities:

• Testing, Benchmarking & Certifying of MongoDB technology for all application teams. This is an on-going project implemented with every new release of the product.
• Working with Security teams for implementing security patches, setup alerting system and other monitoring features necessary.
• Testing & certifying MongoDB features (OnPrem MMS Monitoring, Backup & Restore, Caching Tier, PubSub mechanism, Search capabilities etc.), drivers (C, Java & .Net applications) for internal teams.
• Testing integration with Hadoop.
• Evaluating ODBC drivers (Simba, Progress Direct) & other third party vendor products (RoboMonogo, Actifio) for MongoDB.
• Working with MongoDB Tech teams in doing POC, fixing bugs, adhoc requests etc.
• Working with Dev teams in handling issues with MongoDB Installation, configuration and issues.
• Providing training on MongoDB to internal teams.
• Produce and maintain RPM packages to automate driver, database installation & security tasks.
• Develop tools and services for self-service and self-healing capabilities of Database as a Service.
• Provide best practices and guidance to operational teams on execution of workflows.
• Evaluating NoSQL products like Couchbase.
• Attended training on Neo4j graph database.
• Identifying the common features, advantages and disadvantages when compared to MongoDB.
• Testing standalone and clustered architecture.
• Creating reference documents necessary for evaluation.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

• Handling a team working on providing Global support for Couchbase Database Technology. Identify problems early and work them to resolution with customer and internal teams.
• Work closely with development team to escalate issues for further analysis and fix. Responsible for the improvements needed in terms of the team, SLA's, product features etc.
• Consistently ensure a reliable support to Couchbase customers worldwide.
• Participating in the semi-development activities, Automation, Testing and launching of new features of the technology.
• Responsible for generating Daily/Weekly/Monthly/Quarterly reports and tracking the progress of the team.
• Hire, train, maintain and mentor new joiners.
• Work with development teams on design, modeling, and database architecture and operations supporting applications through development and deployment.
• Priority is ensuring the platforms remain stable, reliable, and available.
• 24 x 7 support and management of NoSQL database Install, configure, administer, and support multiple NoSQL instances Perform database maintenance and troubleshooting.
• Key participant in capacity planning and growth projections
• Support application deployments to production including performance and functional testing.
• Define and implement backup and archival strategies per data retention requirements
• Automate routine tasks with scripts Monitor and maintain database health and ensure efficient operation.
• Work with cross functional teams planning, modeling, and implementing solutions utilizing NoSQL technologies.

Confidential, McLean, VA

Mongo DBA

Responsibilities:

• Determined Use Case would bring various data from different applications and create a single view of the data for quick access.
• Created data model and imported data using mongo import.
• Granted users authorization and authentication. Backed up databases using Mongodb backup facility in OPS manager.
• Developed, deployed and managed several MongoDB clusters whilst implementing robustness and scalability via Sharding and replication, including automating tasks with own scripts and open-source tools for performance tuning and system monitoring.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Developed enhancements to MongoDB architecture to improve performance and scalability.
• Collaborated with development teams to define and apply best practices for using MongoDB.
• Consulted with the operations team on deploying, migrating data, monitoring, analyzing, and tuning MongoDB applications.
• Rolled out and administered sharded and non-sharded clusters.
• Used various MongoDB utilities (mongostat, mongotop)to monitor database.
• Designed and implemented GridFS collections.
• Monitored and tuned user-developed JavaScript using explain plan.
• Changed priority of replicaset nodes to keep Primary on specific data nodes.Worked on BulkWrite operations in MongoDB.

Environment: Mongodb packages, server parameters, mongodb limits and thresholds, Explain plan results, connection string URI Format, log Messages, Exit codes and status, MongoDB versions, chunks, config server, shard, query router

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Provided System support for both development and 24/7 production environments.
• Experienced in ORACLE Software Installation, DBCA to create database and DBUA to upgrade Oracle database on the Red Hat LINUX and Windows environment.
• Experience in implementing and maintaining Virtual machine (VM).
• Tuning for performance at Operating system level and Database Level. Performance tuning with ASH, AWR, ADDM Reports.
• Monitors database activity and file usage, and ensures necessary resources are present.
• Perform daily incremental backup and full weekly backup using Oracle recommended backup utility, RMAN.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Database migration using Data Pump as well as RMAN.
• Operating system CPU average, Load average, IDLE time average monitoring by TOP, IOSTAT, NETSTAT, and VMSTAT.
• Creating and dropping of users, granting and revoking permissions to users/roles.
• Using Oracle Enterprise Manager (OEM) for routine administration, database monitoring, replication process and performance tuning.
• Familiar with Fine Grain Access (FGA) and Fine Grain Access Control (FGAC).
• Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
• Tablespace management including, adding/resizing data files, allocated quotas to user and managed disk space.
• Extensively used data moving utilities like export/import, Data Pump.
• Familiarity of Oracle High Availability Architecture (HA) involving Oracle RAC, ASM, Golden Gate, Data Guard and EXADATA.
• Optimized database performance by analyzing tables and indexes.

Environment: Oracle 10g,RMAN,Virtual machine (VM), Agile/Scrum Windows, MS-Project, MS-Office Suite, MS Visio, MS PowerPoint, Quality Center 10, UNIX, SQL, Data Analysis.

Confidential, Phoenix-AZ

SQL Server Database Admin

Responsibilities:

• Install, configure, update and maintain database instances. Created various database objects and create users with appropriate roles and levels of security.
• Responsible for maintaining the SQL server instances to ensure software is properly installed.
• Configured Snapshot, transactional and merge replication of SQL server databases and troubleshoot replication problems.
• Good understanding of SQL queries.
• Created linked servers accordingly in between the different servers based on the requirement. Ensured that all database environments are in sync.
• Maintained SQL Server Database and ensured accuracy of information and automated numerous functions.
• Managing Databases spread across multiple servers in production, staging and testing environments.
• Analyzed long running queries and tune the same to optimize application and system performance.
• Monitored and modified performance using execution plan and index tuning.
• Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.
• Worked as a part of a team and provided 24*7 support when required.

Environment: SQL Server, Windows, SSRS, .ASP, VB scripting, MS Excel and MS Access, Oracle, Teradata, UNIX, SSAS, System Monitor / Performance Monitor.