MySQL DBA-Paytm Money-Paytm Money
About the job
Summary
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
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.
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.
View Full Job Description
