Aniruddha Wadekar

Email: adbrdk@r.postjobfree.com

Mobile: 750-***-****

Synopsis

10+ Years of experience as a Senior Database Administrator at TeleDNA Communications Pvt Ltd

Responsibilities include client communication, to gather requirement for development of reports that displays transactional data and development of these reports using MySQL technologies, BIRT reporting tool.

Well versed with SQL(MySQL).

Developed Complex database objects like Stored Procedures, Functions, Events and Triggers using SQL and PL/SQL.

Identify the data issues and provided solution options for resolution

Monitor entire application development, execution, and maintenance.

Believes in continuous learning and possesses an innovative approach.

Possess analytical thinking and innovation & problem-solving ability.

A quick learner with the ability to work under pressure and meet deadlines.

Proficiency at grasping new technical concepts quickly & utilizing it in a productive manner.

Remarkable ability to insure a database's availability, reliability, and security while in a production environment.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Knowledge of Putty,Mobaxterm, WinSCP, Linux command.

Good knowledge of MS Excel, macros.

Databases: MySQL, MySQL RocksDB, Cassandra, SQL Server 2000, Oracle 9i. Database Proficiencies:

Database Profiling and Tuning.

Transaction handling (ACID property)

Database backup, restore, recovery

Stored Procedures, Functions, Cursors

Query, Retrieve DB, Joins, Sub Queries, Table Creation, Database Maintenance, Indexes, Views, Transaction, DDL, DML, TCL etc.

Migration script

Cron job

Load balancing through SQLProxy

Load test use Jmeter

Monitoring Tool – Percona Monitoring and Management System(PMM) HA – HA Proxy & AWS – RDS (Multi AZ and Read Replica) DB Upgrade 5.7 to 8

Kafka :

a) Install, deploy of Kafka clusters

b) Kafka HA, Replication with emphasis on performance tuning c) Deployment of tools like Burrow for efficient monitoring of consumer lags d) Responsible for install and maintenance of tools like Presto for viewing Kafka contents that are based on ProtoBuf

Educational Details

PG Diploma (Computers), Welingkar Institute of Management Development & Research, Mumbai, 2018

B.sc (Computers), Mumbai University, 2008

Professional Qualification

Passed a certification exam of Oracle Certified Professional (OCP) in September 2008 (Oracle 9i) Key Responsibilities and Deliverables

Schedule/generate data and business reporting activities on the platform setups

Provide trend analysis and informed inputs to decisions regarding resource management

Capture, generate and provide access to audit trail reports and MIS related to transactions Database design and implementation

Work with development group on database design for new and existing application development

Develop and implement standards and procedures for schema and query design

Define and implement physical database layout

Hold responsibility for installation, configuration and testing of database systems and updates/patches Provide support to development teams (pre-launch review/tuning)

Develop and maintain an in-depth knowledge of application systems

Work on new features with cross-functional teams, such as product development, etc. and propose product architecture changes based on database features and best practices

Work with developers to monitor, test and implement new releases and/or enhancements to and/or MySQL based applications and ensure use of best industry methods

Assist in recommendations for the sizing of hardware and storage for new and/or current applications based on performance and projected growth of the organization

Participate in the support and implementation of automated server environments for hardware, operating systems and applications

Setup and maintain standards and documentation

Formulate and implement monitoring, policies, procedures and standards relating to database management/administration, based on industry best-practice standards.

Work with developers and DBA(s) to coordinate, test and document all application modifications to ensure operational and information integrity in the development, test and production environments Performance, Maintenance and Troubleshooting

Lead performance monitoring, fine tuning, troubleshooting of the database systems – ensure optimal performance, high resilience, and secure services with low downtime (24/7/365 production availability)

Develop scripts for database task scheduling e.g backup activity

Analyse errors, database performance issues to assess trends that may cause degradation of service

Establish and maintain sound backup and recovery policies and procedures and disaster recovery plans for MySQL databases

Plan upgrades, growth and changes – including capacity planning

Manage capacity, plan for capacity growth on a rolling 12-month proactive schedule: long-range database requirements and operational guidelines, with a focus on improving the performance and reliability of the databases and platform service overall

Work with technology team to proactively architect, plan, budget, implement and test scalable growth solutions within budgeted costs and timelines

Evaluate available system upgrades and enhancements and drive improvements/rollouts/upgrades

Work with the technology team to test planned databases upgrades/modifications Project planning at both the technical and executive levels

Provide timeline, manpower and cost estimates as required

Communicate effectively with users, cross-functional teams, stakeholders and management Replication server – Master-Master, Master-slave

Load balancing through SQLProxy

Operating System: Windows, Ubuntu, Linux, Centos

Installation: MySQL, Cassandra, SQL Proxy, PHP myadmin, Apache, Cas, Java, Kafka, Zookeeper, Presto, Burrow etc.

Reporting Tools: Business Intelligence and Reporting Tools (4.6) (BIRT), Crystal Report Other Technologies: ZPL2(Tag Printing language)

Configuration Tools: SVN, GIT

Tracking Product Tools: Jira, Bugzilla

IDE Software: Eclipse

Employers :

TeleDNA Communications Pvt Ltd

Professional Experience

Currently working with TeleDNA Communications Pvt Ltd as Senior Database Administrator from 19th November 2018 till date.

Project Details

Company: TeleDNA Communicatios Pvt Ltd

Role: Sr. DBA

Tenure: 19/11/2018 to till date

Description

Handle multiple products like

MESSAGER II - scalable-on-demand Short Message Service Center. Campaign Manager - The Enterprise Campaign Manager is an Integrated tool which uses Marketing Data

(Real time and batch inventories) to do targeted Campaigning. The campaign manager supports an add- on revenue stream through advertising via flexible inventory subscription and authorization mechanisms. Further integrated and real time pre/post campaign analysis enables campaign effectiveness monitoring. NowConfer - Automated Audio & Web Conferencing Solutions. MySQL installation & setup, updates, setup replication, MySQL With Percona, MySQL With RocksDB, performance tuning, Optimization, write stored procedure, cursors, triggers, functions, complex queries, code review.

Mysql Engines - Innodb, RocksDB, MyISAM

Cassanadra, Knowledge of Putty, WinSCP, Linux command, Kafka Administrator

Company: Three Sixty Degrees Solutions Pvt Ltd

Role: Project Lead (ERP Ver2)

Tenure: 01/04/2013 to 16/11/2018

Description

OptimusERP is a blend of open source technologies like MySQL 5.7, BIRT 4.6(Reporting tool), Apache, Jboss, Java.

I must handle a team of 5 developers. Along with the above activities here I was responsible for various database related activities like DBA (mention above Key Responsibilities and Deliverables), batch process, performance tuning, Optimization, write stored procedure, cursors, triggers, functions, complex queries, code review.

Company: Three Sixty Degrees Solutions Pvt Ltd

Role: Project Lead (Retail, POS)

Tenure: 01/09/2012 to 16/11/2018

Description

OptimusRetail is a blend of open source technologies like MySQL 5.7, BIRT 4.6(Reporting tool), Apache, Jboss, Java.

Along with the above activities here I was responsible for various database related activities like batch process, performance tuning, optimization, write stored procedure, functions, complex queries. Also, I was responsible for gathering requirements from the user for report and screen development. Here I had chance to mentor a few juniors, along with this I have to handle a team of 2-3 developers. Company: Three Sixty Degrees Solutions Pvt Ltd

Role: Software Developer (FineAPP)

Tenure: 10/03/2009 to 30/08/2012

Description

FineApp using technologies like SQL server 2000, Crystal Report (Reporting tool), Visual Basic 6.0 Here the database plays a major role, it stores all the data viz transactional data and master data. I was solely responsible for handling the database development to store the data and generate a large variety interactive reports like inventory reports, stock reports, Purchase order reports, QC reports, settlement reports and so on.

Company: Three Sixty Degrees Solutions Pvt Ltd

Role: Software Developer (ERP version 1)

Tenure: 10/03/2009 to 30/08/2012

Description

OptimusERP is a blend of open source technologies like MySQL 5.5, BIRT 2.7.2 (Reporting tool), Apache, Jboss, Java.

Here the database plays a major role, it stores all the data viz transactional data and master data. I was solely responsible for handling the database development to store the data and generate a large variety interactive reports like inventory reports, stock reports, Purchase order reports, QC reports, settlement reports and so on.

Contact this candidate