SUMMARY

• Extensive experience in design, administration, analysis, development and implementation stages of various databases and web applications using Ruby, Java/J2EE, JavaScript, jQuery, Object Oriented Programming, JSP, Servlet, Web Services, ORACLE, SQL Server and MySQL. Experience in Agile software development approach, a framework that delivers customer collaboration and interaction with processes and tools.
• Extensive experience with JavaScript, Ruby and Python in Linux, UNIX and Windows environments.
• Extensive experience in developing Map - Reduce programs and aggregation frameworks using JavaScript's.
• Installing, Upgrading and configuring PostgreSQL servers.
• Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data with extensive security.
• Proficiency in multiple databases like MongoDB, Cassandra, MySQL, ORACLE and MS SQL Server.
• Shared responsibility for administration of HADOOP, Hive, Scoop, Flume and Pig.
• Skilled in troubleshooting with good organizational and interpersonal skills.
• Good understanding of various components of SAP HANA XS.
• Having strong knowledge on SAP HANA Data Modeling using views and SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Having expertise in delivering SQL and PL-SQL project Implementations.
• Created schema, table definitions and loaded flat files into HANA.
• Involved in data provisioning into SAP HANA system from flat file, RDBMS, CRM, SAP BW and ECC systems.

PROFESSIONAL EXPERIENCE

Sr. Oracle Database Administrator (DBA) /PostgreSQL Developer

Confidential

Environment: Oracle Cloud and PostgreSQL DB, Azure DB, PG Admin3/4, POS (Point Of Sale), MMSO, Linux/Unix, Backup Scheduler, Replication, Shell scripting, Java and Jasper Reports scheduler.

Responsibilities:

• Perform Oracle database performance analysis and optimization, backup/recovery, define bottlenecks and manage testing and production implementation.
• Oversees capacity planning including CPU utilization and space management. Makes recommendations to improve processes.
• Provide the technical support for incidents & investigation applications deployed for Confidential .
• Create and execute scripts.
• Perform Root Cause analysis, security and data testing strategies and practices.
• Perform deep impact analysis of problems, projects or technical solutions
• Closely cooperate with vendors and external service providers
• Develop and implement processes
• Assist with migration and/or load of application data into the database environment.
• Responsible for working with the development/support teams to optimize SQL statements
• Following release management, change management and quality assurance standards
• Having strong Unix scripting (Shell/Perl) knowledge
• Have solid working knowledge to support very large databases with heavy OLTP and batch activities
• Develop and improve procedures for monitoring (Enterprise Manager) and proactive intervention, preventing customer impact.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Scheduling the databases backup using Cron tab. applied patch set and interim patches whenever required to make the database software up to date.
• Installing, Upgrading and configuring PostgreSQL servers.
• Maintaining multiple PostgreSQL data base servers and services in different platforms.
• DB Performance tuning, Indexing, Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Database Back-ups and restores.
• Creating Users and Providing DB access privileges.
• Integrated ERP & RPM Application with External interfaces like POS, App Launcher, PostgreSQL and Oracle Databases etc.
• Co-ordinate & worked with various teams on integration components like DB issues, application defects, change request responses and site Build configuration.

Mongo Database Administrator (DBA) Come Developer

Confidential

Environment: MongoDB, Cassandra, Ruby, Linux/Unix, LVM Snapshots, Backup Scheduler, Data guard, Sharding, Replication, Python, Shell scripting, Perl, PyMongo, JavaScript, Oracle DBA.

Responsibilities:

• Extensive experience in deploying, managing and developing MongoDB clusters. Creation, configuration and monitoring Shards sets.
• Analysis of the data to be shared, choosing a shard Key to distribute data evenly.
• Architecture and Capacity planning for MongoDB/ Cassandra clusters. Implementing on-premise MMS monitoring and backup solution.
• 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. Backup & Recovery, Database optimization and Security maintenance.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Experience in managing MongoDB environment from high availability, Locality, performance and scalability perspectives. applied patch set and interim patches whenever required to make the database software up to date.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Managing Mongo databases using MMS, Grafana and Icinga2, Splunk monitoring tools.
• Applying OS patches for Linux Instances every month by excluding the ruby gem and mongo after that rebooting the instances.
• Performance tuning and stress-testing of NoSQL database environments in order 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 to 2.4,2.6,2.8 and soon 3.0,3.2 Also involved with creating shards, replica sets, monitoring and projections for Mongo Systems.
• Worked with capped collections to wipe out aged data based on requirements.
• Administered multiple environments (up to 25TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• Implemented read preferences in MongoDB replica set.

Oracle Database Administrator (DBA)

Confidential

Environment: SQL * Plus, SQL*Loader, SQL Developer, Oracle RAC, Shell Scripts, UNIX, Windows XP.

Responsibilities:

• Created a recovery catalog, performed the complete and incomplete recovery using RMAN.
• Wrote scripts for backup of databases, maintenance of archive logs for databases.
• Streamlined backup procedures and implemented rman for backup and disaster recovery.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current Oracle configuration, capacity, and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures, and guidelines necessary to effectively administer the database environments.
• Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the optimal flex architecture.
• Provided instance-level performance monitoring and tuning for event waits, sessions, physical and logical io, and memory usage.
• Monitoring the scheduled backup procedures for daily basis using crontab.
• Used power designer, e/r studio for data modeling and to estimate the database size, database design reviews.
• Perform Root Cause analysis, security and data testing strategies and practices.
• Perform deep impact analysis of problems, projects or technical solutions
• Develop and implement processes
• Create and execute scripts.