SUMMARY:

• Over 7+ years of experience in IT industry. Over 3 + years of experience to deploy and maintain MongoDB databases/DB projects.
• Manage and maintain both MongoDB servers across multiple data centers.
• Experience in managing multi - node MongoDB clusters on public cloud environment.
• Strong SQL Server Developer skills including writing stored procedures, triggers, views, query writing.
• Experience in creating DTS packages with ActiveX scripting for transferred data modifications .
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages.
• Good SQL Server administration skills including user authorizations, Database creation, Tables, indexes and clusters creation.
• Generated and managed reports using Reporting services.
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
• Strong Mongo, MySQL and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment.
• Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Expertise with Shell Script, PHP backend, C# application integrations & development.
• Extensive knowledge in Tuning SQL queries, T and PL/SQL queries & improving the performance of the Database.
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Expert in Database Design and data interaction process between Web server and Database server
• Excellent skills in database backup, replication, recovery, restoration, DTS and Linked servers.
• Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment & maintenance of Projects.
• Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.
• Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.
• Excellent Communication and inter personal Skills when working with developers, project managers and application end-users.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working.

TECHNICAL SKILLS:

• MS SQL Server 2008 R2
• Windows 9x/2000/NT/XP
• OLAP
• C
• C++
• Java
• SQL
• Oracle
• Transact SQL
• MS Reporting services
• MS Office
• MS Access
• HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Mongo DBA

Responsibilities:

• Responsible for administration, maintenance, Performance analysis, and Capacity planning for Mongodb/Cassandra clusters.
• Coordinate and plan with Application teams on Mongodb capacity planning for new applications.
• Created aggregation queries for reporting and analysis.
• 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.
• Ensure the continuous availability of our mission critical MongoDB clusters using replication across data centers.
• Implemented TTL and indexing based on collection data time duration.
• Performance tuning and indexing strategies using mongo utilities like Mongostat and Mongotop.
• Migrated multiple shards from MMAPV1 storage engine to Wiredtiger. Implemented MMS monitoring and backup solution for sharded clusters.
• Monitored and tuned user-developed JavaScript using explain plan.
• Created capped collection, Gridfs collection and created shard keys to distribute data across the shards.
• Developed Mongo DB embedded documents from java code using spring data MongoDB.
• Developed enhancements to MongoDB architecture to improve performance and scalability.
• Created Python scripts to conduct routine maintenance and deliver ad hoc reports.
• Implemented Ops Manager monitoring, alert, automation, backup and restore.
• Developed new enhancements for the application node.js driver.
• Comfortable in writing map reduce programs to load data into MongoDB environment.
• Developed Scripts for transferring data from production server to testing/development servers.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: MongoDB, MMS/OPS manager, mongostat, mongotop, mongofiles, Ruby, Puppet, Linux/Unix, LVM Snapshots, Backup scheduler, Pearl, PyMongo, Java script.

Confidential, New York City, NY

Mongo DBA

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of HA solution.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Proficiency in Unix/Linux shell commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Documented all servers and databases.
• Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment.
• Shell script is being used for some data migration and backend work management.
• Supporting management with different database related decisions.
• Handling Release management and user acceptance.

Environment: MySQL 5.1, PHP, Shell Script, Apache, NDB Cluster, LINUX 5.0,5.1, OSX

Confidential, Cincinnati, Ohio

Database Administrator

Responsibilities:

• Gathered functional requirements and Written the technical specifications
• Created database, tables, security and backup database along with hundreds of stored procedures, triggers, user permissions, pass through queries and temporary tables.
• Written T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server
• Created automatically running Stored Procedures and trigger for the day end operation using SQL Server agent
• Involved in planning and administration of data migration and performance tuning to achieve cost efficiency and effectiveness of the system.
• Capacity planning in estimating and sizing of tables
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers
• Created DTS Packages to import data from Excel spreadsheets
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Developed the dimensional modeling of the data ware house to design the business process data representation, dimensions and fact tables using ERWIN 4.0

Environment: SQL Server 2008 R2 Enterprise Edition, Enterprise Manager, Windows 8, MS Access, MS Excel, HTML.

Confidential, Fontana, CA

SQL Server DBA

Responsibilities:

• Created database objects like tables, views, indexes etc. Created and modified stored-procedures, triggers, cursors
• Developed stored procedures and views for managing efficient data retrieval. Migration of databases.
• Wrote various Stored procedures for the purpose of application development
• Converted various SQL statements into Stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time.)
• Used DTS Packages for data import and export data from SQL Server to Access, text and EXCEL files.
• Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to SQL server.
• Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2008 R2.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Generate Daily, Weekly and Monthly Trigger based reports regarding assigned projects to appropriate Managers and Clients.
• Applied Security to Web Server and Database Server that affects Report server installation. Manage role-based security to reports and reporting resources. Backup and Restoration of SQL Reporting Service.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
• Performed analysis and design of the application.
• Good Experience with Query Analyzer and Enterprise Manager

Environment: SQL Server 2008 R2, Oracle, MS Access, MS Excel and Windows Server 2008 R2 SP1