Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

MySQL DBA-Paytm Money-Paytm Money

Karnataka, India (On-site)

MySQL DBA-Paytm Money-Paytm Money

3 Weeks ago • 3-6 Years • Administrative

About the job

5 skills required for this role

Test your skills to join the top 1% applicants for this job

mongodb

unix

aws

linux

mysql

Job Description

As a MySQL DBA at Paytm Money, you'll be responsible for the performance, integrity, and security of the database. This involves planning and developing the database, troubleshooting user issues, and ensuring data consistency and accessibility. Key responsibilities include managing databases in AWS, handling master-slave data synchronization, and performing performance tuning and query optimization. Experience with MySQL internals, replication strategies, upgrades, migrations, and various storage engines is crucial. A good understanding of indexing, partitioning, and data security/recovery is also expected. The role requires hands-on experience in setting up replication and configuring MySQL parameters within a Linux/Unix environment. You will support and implement technology projects as the primary DBA.

Must have:

3-6 years core experience in MySQL
Expertise in MySQL internals, configuration, replication
AWS cloud infrastructure management
Master-slave data sync
Performance tuning and query optimization

Good to have:

Exposure to MSSQL Server, Redshift, Snowflake, MongoDB
Basic understanding of MySQL development
Exceptional knowledge of MySql and InnoDB/Clustering
Experience with Indexing, Partitions, and storage engines
Experience setting up replication and configuring parameters

About the role: Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.

Expectations/ Requirements

Data remains consistent across the database, data is clearly defined

Users access data concurrently, in a form that suits their needs

There is provision for data security and recovery control (ensuring all data is retrievable in an emergency).

Skills that will help you succeed in this role

3-6 Years of core experience

Good Expertise in MySQL internals, configuration, and replication strategies and up-gradation/Migration

Manage databases in AWS cloud infrastructure

Handle master-slave data sync

Exposure to other Databases (MSSQL Server, Redshift, Snowflake, MongoDB) is a plus

Should have basic understanding of MySQL development

Expertise in upgrading and migrating databases to Cloud

Exceptional knowledge of both MySql and InnoDB/Clustering

Hands on experience on Performance Tuning and Query Optimization

Should have good understanding on Indexing, Partitions, and different storage engines available under MySQL

Hands on experience in setting up replication and different configuration parameters available in MySQL

Good exposure working with Linux/Unix environment

Capable of supporting and implementing technology projects as the primary DBA in support of business initiatives

Why join us

Because you get an opportunity to make a difference, and have a great time doing that.

You are challenged and encouraged here to do stuff that is meaningful for you and for those we serve.

You should work with us if you think seriously about what technology can do for people.

We are successful, and our successes are rooted in our people collective energy and unwavering focus on the customer, and that's how it will always be.

undefinedundefinedundefined

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%