Mysql dba at Mindtree Limited · Bengaluru (Bangalore), Chennai · 8 - 10 years · ₹2L - ₹8L / yr · Profitable · Posted 26 Apr 2022

Job Description:
MySQL - DBA L3 Support
- 7 -10 years of experience in MySQL, handled multiple versions & flavors of MySQL servers both for standalone & enterprise version, Data center and VM/Cloud setup.
- Strong database Configuration and troubleshooting / problem solving skills.
- Strong knowledge of database backup and recovery concepts and practices.
- Enabling disabling scheduled Jobs on MySQL Server
- Work with Dev and DevOps engineers to ensure that all needed data is gathered and provided to them for any performance issues
- Experience in managing both on-prem DB as well as VM / cloud based DBs
- Maintenance of backups (perform backups, monitor backup, report obsolete backups)
- Maintenance of user access (creating user accounts, dropping user accounts, granting privileges)
- Maintenance of log and trace files (remove, initialize, archive them)
- Knowledge on SQL scripts
- Managing Database administration includes Daily health checks, Database tuning, Query optimization & Backup & Replication
- Experience in alert configurations using existing alerting tools or scripts

About Mindtree Limited
About
Mindtree delivers digital transformation and technology services from ideation to execution, enabling Global 2000 clients to outperform the competition. “Born digital,” Mindtree takes an agile, collaborative approach to creating customized solutions across the digital value chain. We are co-headquartered in Bangalore, India and New Jersey.
Founded in 1999, we are now 17,000+ Mindtree Minds across the globe. Our annual revenue crossed $780+ million in 2016-17. Mindtree provides services in e-commerce, mobile applications, cloud computing, digital transformation, data analytics, EAI and ERP, with more than 290 clients and offices in 14 countries.
Company video


Connect with the team
Similar jobs (1)
Job Description (JD) for the MySQL Database Administrator role
Experience: 4-8 Years
Location : Mumbai
Job Title: MySQL Database Administrator
Responsibilities
- Provision and configure MySQL database instances in clustered and non-clustered environments.
- Ensure database performance, security, availability, and reliability.
- Prepare and maintain database documentation, technical specifications, and operational procedures.
- Perform database upgrades, backups, restoration, recovery, and migrations.
- Monitor database and server resource utilization and perform performance tuning and optimization.
- Manage database users, access privileges, periodic access reviews, audits, and documentation.
- Configure, monitor, and troubleshoot MySQL replication.
- Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues.
- Provide database and application deployment support, as required.
- Perform database backup and restoration validation, data integrity checks, and post-migration validations.
- Follow database change management, security, and operational best practices.
Skills and Qualifications
- Strong hands-on experience in MySQL database administration.
- Good working knowledge of recent MySQL versions, preferably MySQL 8.x.
- Understanding of MySQL storage engines, including InnoDB and MyISAM.
- Practical experience in configuring, monitoring, and troubleshooting MySQL replication.
- Knowledge of MySQL administration best practices, security, and high availability.
- Proficiency in writing, analyzing, and optimising SQL queries.
- Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring.
- Ability to assess database resource requirements based on application workloads and technical specifications.
- Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB.
- Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds.
- Working knowledge of version control tools such as Git, SVN, or CVS.
- Graduate degree in a relevant discipline and good verbal and written communication skills.
Good to Have
- Basic Linux administration, command-line troubleshooting, and Bash scripting skills.
- Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly.







