Experience

timbre Digital

• New Zealand
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior DBA

  • Oct 2022 - Present

• MySQL/NoSQL DBA

  • Aug 2017 - Present

  - Database Administration for MySQL 8.x & 5.x and Cassandra- Knowledge on ElasticSearch.- Managing servers via Puppet (Puppet 3.7) including creating profiles, roles, manifest, hieradata, etc.- Managing and developing database related process via Ansible- Building servers via Terraform in Openstack- Managing high availability using native replication (including GTID) and Galera Cluster- Developed customised solution for MySQL failover/switchover- Managing backups using xtrabackup & mysqldump- Monitoring databases using ICINGA and Percona Monitoring Tool (PMM)- Query optimization- Handling Percona Xtradb Cluster Show less

• MySQL/NoSQL DBA

  • Aug 2017 - Present



Lazada Group

• Thailand
• Financial Services
• 1 - 100 Employee

• Senior Database Administrator

  • Oct 2015 - Aug 2017

  1. Cater to all the database related issues and support over JIRA 2. Managing high availability using MySQL replication, MariaDB Maxscale (also used for load balancing) 3. Maintaining database backups using Percona Xtrabackup, mydumper, etc. 4. Database health checks, monitoring over Zabbix, Grafana and Monyog 5. Managing database servers which including installing MySQL installation/upgradation, capacity planning, database deployments using percona toolkit etc. 6. Load testing for performance using sysbench. 7. Writing shell scripts for database analysis and troubleshooting. 8. Performing reviews for the development team in regards to the database structure changes or enhancements, data fixes 9. Working closely with the Business Intelligence, in regards to data migration and transformation. 10. Database performance enhancements/tuning using InnoDB table compression, tuning my.cnf file, etc. 11. MySQL troubleshooting which include slow queries, high load, etc. 12. User management 13. Basic system administration in regards to MySQL troubleshooting Show less



Emerio

• Netherlands
• Import & Export
• 1 - 100 Employee

• Senior DBA

  • Apr 2013 - Sep 2015

  Project : WideAngle Managed Security Services Client : NTT Communications Description : WideAngle Managed Security Services provide a safe and reliable ICT environment for intrusion prevention, containment, and data protection seamlessly whether in the cloud or on-premise, domestic or overseas, in response to targeted attacks and other new threats through a full, multi-layered range of total security outsourcing services. This is realized through advanced security operations including a new operational security platform powered by Security Incident and Event Management (SIEM) and a varied menu of security solutions. My profile was of Senior DBA, actively involved with the development team and consulting for the production environment. Also, involved in the database development which includes database modelling, table design, writing stored routines and SQL queries. Also, a part of the Platform Support Group which supports the product across 24x7 through the Service Desk Plus incident management tool. Involved in the infrastructure deployments using tool SALT. Lead the data migration activity of the in-house ticket tool with backend database as MySQL to the BMC Remedy Force, which is resides over the Salesforce platform Job Profile : • Database monitoring using OP5 monitoring tool and customised shell scripts • Managing backups using mysqldump and Xtrabackup. • Managing High Availability using replication (using GTID feature). • Database tuning • Database modelling and design • Writing SQL queries and stored routines. • Writing shell scripts for database troubleshooting and analysis. • Data migration from MySQL to Salesforce Show less



SpotOn Media Pvt. Ltd.

• Advertising Services
• 1 - 100 Employee

• Team Lead - DBA

  • Aug 2012 - Mar 2013

  Project : Database Maintenance (MySQL) Client : In-house Description : Spot On Media is a Value First Digital Media’s initiative and it brought India’s first Ad network on SMS where SpotOn would aggregate prime as well as remnant inventory across several SMS publishers i.e. Mobile Short Codes, Mobile VAS players, Mobile Networks, Internet Communities with Mobile services, other organizations with mobile services, making its cumulative reach on SMS very wide and offer the same to advertisers. Spot On Media owns all the major free SMS portals such as Way2sms, 160by2, etc and a social media website Indyarocks. and got their own in-house products viz.Ultoo and FullOnSMS. My profile is to administer databases and lead a team of MySQL DBAs and trainees who handle the database of all the above mentioned products. Job Profile : • Tuning SQL queries. • Backups using mysqldump and innobackup. • Database tuning • Load testing using mysqlslap • Database troubleshooting. • Database monitoring Show less



Atlantic Coast Media Group

• United States
• Software Development

• MySQL DBA

  • Dec 2010 - Jan 2012

  Atlantic Coast Media Group (ACMG) is a fast growing company in the beauty product market in US. The database is of the complete end to end process, right from product coming in the warehouse till the dispatch of the product to the customer and also customer service related. The major work here is database and query tuning. Query tuning being the major aspect and database migrated from MyISAM to InnoDB. Also had setup the replication (dual master and chain replication). Configuration file (my.cnf) tuning is also a part as the database is been migrated to InnoDB. Load testing using mysqlslap application (available in MySQL v5.1) is also one of the major tasks. Job Profile : ● Tuning SQL queries. ● Backups using mysqldump and raw backups. ● Implemented and maintained two-way replication and chain replication. ● Load testing using mysqlslap ● Database troubleshooting. ● Involved in the Datacenter Migration process. ● Database maintenance. Show less



Tata Consultancy Services

• India
• IT Services and IT Consulting
• 700 & Above Employee

• MySQL DBA

  • Oct 2009 - Jul 2010

  Working as full time MySQL DBA for the client Electronic Arts (one of the gaming giants). Majorly responsible for installations and maintenance of database and maintaining replication Working as full time MySQL DBA for the client Electronic Arts (one of the gaming giants). Majorly responsible for installations and maintenance of database and maintaining replication


UTV
• India
• Entertainment Providers
• 100 - 200 Employee
• Database Developer (MySQL)

  • May 2008 - Jul 2009


Saraswat Infotech Limited

• India
• IT Services and IT Consulting
• 100 - 200 Employee

• Database Administrator

  • Dec 2007 - Apr 2008

  Worked as a Database Administrator on the client side viz. ALW (A Little World) on MySQL Technology. Worked as a Database Administrator on the client side viz. ALW (A Little World) on MySQL Technology.



Novanet Technologies Ltd.

• Database Administrator

  • Oct 2006 - Dec 2007

  Comprehensive database management. Database technology used was MySQL. Comprehensive database management. Database technology used was MySQL.