SUMMARY:

• A database consultant with over 14 years of specialization in Information Management. Master’s degree in Computer Applications. In - depth skills in product architecture, solution design, capacity planning, database & data warehousing strategy reviews of solutions
• Supervising and mentoring consultants in engagements utilizing their relevant technical skills. Assist and encourage the development of objectives, strategies & plans aimed at achieving customer satisfaction. Facilitate technical reviews of solutions & assist clients for resolving business issues.
• Coordinate with clients on an ongoing basis to develop and maintain business relationships, ensure satisfaction with services provided, and identify opportunities for further consulting work to promote latest technology & trends in the business.Keynote speaker at various
• Extensively led teams comprised of contractors, vendors, and other resources both onshore and offshore. Experience in executing complex projects and planning smooth project transition from onshore to offshore.

TECHNICAL SKILLS:

RDBMS: DB2 (v10.x, v9.x, v8.2, v7), Oracle (v10g, v9i, v8i)

NoSQL DBMS: MongoDB (v 2.x, 3.x), Cassandra (Apache 1.x, 2.x & DataSta

PROFESSIONAL EXPERIENCE:

Confidential

Senior DB consultant

Responsibilities:

• Implement database solution for new development with consideration to impacts in application, network, hardware, and operating system
• Perform physical data base design based on analysis of business requirements.
• Identify, analyze, and correct database and database application performance problems.
• Balance database across processors and nodes.
• Involve in performance tuning, indexing strategy and monitoring.
• Involve in database maintenance - dbclean, runstats, reorg and rebind.
• Monitor, predict, and manage file allocations and usage across disk volumes.
• Plan and practice disaster recovery procedure.
• Work with DB2 in a Websphere stack (WCS, WPC, and WCC), DB2 with Symantec Net backups.
• Involve in Backup and Recovery.
• Recognize the need and assume ownership for improvement in the technical infrastructure including short and long-term deliverables.
• Develop and implement policies, procedures, and standards for tools and methodologies to improve database administration capabilities and efficiencies.
• Responsible for core Installation and Configurations of various releases in Confidential DB2 including different Fixpack Levels.
• Perform Migration of databases in different versions of Confidential DB2 ESE.
• Recommend the configuration parameters for the database and implement the changes.
• Maintain the performance of database and tune the respected changes of DB2.
• Resolve DB2 issues, monitoring data security and integrity, assessing data models to ensure technical accuracy for OLTP systems.
• Implement security policies for Authentication, Authorization & Auditing.
• Develop Performance & Capacity Test Plans of migrating application.
• Support stress testing and load testing of applications.
• Coordinating Project activities and tasks as well as dependent deliverables.
• Provide documentation support and best practices.
• Provide production deployment guidelines and execution plan. MongoDB Work -
• Designed & Implemented 12 production clusters, 15 stress clusters and 20 QA clusters. Clusters were ranging from 56 nodes to 4 nodes.
• Worked on migrating the Databases from 2.6 to 3.0 and 3.0.4
• Enabled Sharding at the Database and collection level
• Worked on adding the replica set to the cluster for high availability.
• Setup Arbiters on different Datacenters for enabling Voting rights.
• Enabled Wired tiger storage engine along with Version 3.0.4 that supports document level Locking, compression & partial reads.
• Worked on copying the data using utilities like mongoexport/mongoimport.
• Worked on migrating the data from version 2.2 to version 2.6 and above using mongodump andmongorestore.
• Setup users privileges and specific roles for read and writes.
• Created secondary indexes in production environment in a rolling manner without causing Downtime.
• Worked with application team for capacity planning and application design.
• Worked on creating DB's, collections, indexes, users etc.
• Worked on setting up different indexes like TTL, unique, sparse, background etc.
• Worked closely with application team to tune the queries using profiling. Turned on profiling toidentify slow running queries and created necessary indexes.
• Identified Long running queries using db.currentOp() which were causing performance issues.
• Tested failover strategies.
• Implemented Tags for using different data centers and also setup different priorities at each node level.
• Setup hidden secondary in production environment as a backup strategy.
• Enabled delayed replication to test data loss scenarios.
• Worked on issue when one of the config DB went out of sync.
• Used MMS(MongoDB management Service) to identify locking, pagefaults, High backgroung flush average, high connections, queues, memory etc...
• Reduced the cursorTimeoutMillis to 5 sec from a default of 10 minutes to help resolve a Performance issue.
• Worked on adding new shards to the production cluster for scaling.
• Worked on renaming the host names in the mongodb cluster.
• Worked on downgrading the mongoDB instance from 3.0.2 to 2.6.8
• Worked closely with the Mongo support to fix stale connections issues, wherein some of the Queries were scanning the whole collection. We created appropriate indexes and resolved the Issue. Worked on upgrading the standalone cluster from 2.6 to 3.0.4
• Tested Hints to force the query planner to pick the given index for the particular query.
• Prepared scripts to drop and recreate a Database along with its collections and indexes.
• Created scripts to filter the output of db.currentOp().
• Used Repair command to correct the fragmentation in a database.
• Expert in the mongostat, mongotop, mtools, serverStatus, currentOp and MMS to debug & Resolve the production issues.
• Worked closely with mongo support for find root cause analysis of new issues.
• Worked on a major production issue during which one of the data center was down and both Nodes in the existing cluster went to secondary status without any primaries. We used the
• Database Architecture & Administration activities, which involved Data Modeling, Configuration, Administration, Monitoring, Security Management, Performance Tuning, Replication, Backup/Restore and troubleshooting of issues.
• Designed and implemented 30 node Cassandra cluster for online checkout Application in Cassandra dse-4.6.7.
• Designed and implemented DSE SOLR solution to push incremental orders data into centralized Hadoop cluster.
• Designed and implemented 48 node Cassandra cluster for Single Point Inventory application.
• Designed and implemented Cassandra cluster between the two datacenters for Universal Checkout application.
• Upgraded mobile checkout cluster from Apache Cassandra1.1 to DSE 4.6.7
• Designed and implemented dual datacenter set up for all Cassandra cluster.
• Designed implemented Datstax Hadoop solution to integrate promotional data with enterprise Hadoop cluster.
• Implemented Spark solution to enable real time reports from Cassandra data.
• Performed Cassandra HealthChecks for several key components like:
• •Data Model Review
• •Operations Review (Disk Configuration, JVM Heap Size, Memory, Network Throughput)
• •Application/Development Review (Concurrency, Consistency Levels for Reads/Writes, Security)
• Applied best practice guidelines for designing, deploying, and managing DataStax Enterprise (DSE) database clusters.
• Responsible for setting up Alerts for Monitoring and capacity analysis.
• Deep understanding of internals of NoSQL framework, functionality of Cassandra Architecture.
• Acquaintance with hardware, including RAID, multi-processor architecture, networking and how it relates to cassandra database operations and connectivity.
• Knowledge of Building high performance cassandra clusters according to best practices, bootstrapping/decommissioning/removing of nodes.
• Provide advanced troubleshooting of cassandra systems for database related project activities.
• Proactive performance analysis using OpsCenter and other tools like nodetool (status, repair, cleanup, cfstats, tpstats, drain, compactionstats, snapshot, netstats, compact, cfhistograms)
• Knowledge of Day-to-Day Cassandra DBA activities & provide 24/7 on call support.

Confidential

Senior IT Specialist / Solution Architect

Responsibilities:

• Extensive experience in database and data-warehouse design and architecture, implementation, up-gradation, production support and benchmarking environments as an Confidential DB2 Architect and DBA for a wide range of applications
• Designed, deployed & Maintained solutions for Netezza warehouse, Confidential Smart Analytics Systems (BCU)
• Experienced in handling of more than 250+ Terabytes of multi-partitioned databases. Worked with Confidential DB2 EEE and UDB ESE environments using the data partitioning feature
• Subject Matter Expert in up-gradation and migration for Databases versions 9.x, 8.x, 7.x among different OS and hardware platforms (Heterogeneous Platforms Migrations). Participated in SAP OS/DB Migration Activities as well
• Proficient in DB2 Administration under SAP Environment, all kind of UNIX and Linux distributions.
• Proficient in assessing and applying various fix packs to DB2 UDB Databases
• Designed and implemented backup and recovery strategies for multi partition environments on various platforms
• Implemented strategies for log archival including log shipping to TSM (Tivoli Storage Manager)
• Extensive experience in execution of utilities & tools such as LOAD, REORG, REORGCHK, RUNSTATS, DB2DART, DB2CHKBKP,High performance Unload, Performance Expert, Data Studio, Optim Performance Manager
• Proficient in logical data modeling and physical data modeling for data-warehouses and data marts
• Experience in SQL performance tuning and troubleshooting for performance enhancements
• Experience in snapshot monitoring, log monitoring and event monitoring
• Performed numerous installations/upgrades of Confidential DB2 UDB of various releases on several O/S platforms
• Experience as a database architect involved in implementing high availability DB solutions, configuring application environments and administration of databases in development and production
• Highly experienced as a database expert involved in installation, configuration of DB2 UDB server
• Deployed DB2 ISAS BCU/BDWH data-warehouse implementation for number of customers worldwide. Worked on D5100/D5600/E7100/E7600/E7700 ISAS solutions
• Experience in designing and implementing guidelines for database development, maintenance and security policies
• Installation and troubleshooting experience of Confidential DB2 Q Replication and SQL based replication.
• SME level knowledge of DB2 Internals which is required for Benchmarking & Performance Tuning.
• In-depth troubleshooting, problem solving, analytical & design skills
• The key projects executed in last several years include DB2 Advanced SME Skills like DPF, HADR, HACMP, VCS, MSCS, SQL Replication, Q Replication, all kinds of high availability scenarios, WLM, data compression, LBAC security, MQTs, MDCs, designing & data modeling, infoSphere balanced warehouse ISAS, SAP OS/DB Migration, heterogeneous database porting, Confidential smart analytics systems, Netezza twinfin appliance etc.
• Expert in Designing & implementing the standard operating procedures (SOP) for the Database/datawarehousing team
• Provided product feedback to the Confidential DB2 product development team, which was included in the fix packs & next release of the products.

Confidential

Datacenter In-Charge

Responsibilities:

• Maintaining, monitoring and troubleshooting production and development environment for the entire South Zone data-center located at Hyderabad. Supporting the complete IT Department.
• Supporting and managing the team of eight people responsible for telecom billing.
• Analyzing the problems arising after, minimizing the problem, in order to meet the SLA.
• Overseeing performance and tuning activities (Applications and SQL tuning).
• Communicating with the top management and giving recommendations for the smooth functioning of the databases for the different applications of the data-center environment.

Confidential

Production DBA

Responsibilities:

• Working as production DBA & system administrator in Confidential . The technical team comprised of Oracle DBAs, UNIX system administrators and developers.
• Responsible for the smooth functionality of all the databases servers.
• Rendering backend support for the clients, tuning databases, backup and recovery strategies and web server architecture.
• Hardware: Sun Solaris SPARC, LINUX Systems

Confidential

ORACLE DBA Consultant

Responsibilities:

• Conducting theoretical & practical classes in computer education for different levels of students in system analysis & design.
• Developing application software Packages that were taken up by UPTEC.
• On-call DBA support for various clients in Northern region. Mainly various government units and several private companies.
• Guiding & training the students in preparation of project assignments in Module III of 'O' and 'A' Level courses of Department of Electronics, Government of India.