MYSQL - Senior Lead DBA
Job Summary
Job Description
As a Lead MySQL DBA at Paytm, you will be responsible for the performance, integrity, and security of the database. You'll be involved in planning and developing the database, troubleshooting issues, and optimizing query and script performance. This role requires expertise in MySQL, AWS, and MySQL Enterprise monitoring, as well as experience with database objects, data migration, backup and recovery, and implementing high-availability clustering.
Must have:
- 6+ years of experience in MYSQL DBA
- Core MySQL, AWS, and MySQL Enterprise monitoring
- Extensive work experience on query optimization, script optimization, and other related optimization tools and techniques
- Design and create database objects
- Data migration, backup, restore & recovery
- Resolving performance issues, blocking and deadlocks
- Implement and maintain security and integrity controls
- Experience with database performance tuning and optimization
- Strong understanding of MySQL database architecture
- Experience with backup and recovery procedures
- Knowledge of database security best practices
- Experience with data migration and transformation
- Ability to work under pressure and meet deadlines
3 skills required
Job Details
About Us:
Paytm is India’s leading digital payments and financial services company, which is focused on driving consumers and merchants to its platform by offering them a variety of payment use cases. Paytm provides consumers with services like utility payments and money transfers, while empowering them to pay via Paytm Payment Instruments (PPI) like Paytm Wallet, Paytm UPI, Paytm Payments Bank Netbanking, Paytm FASTag and Paytm Postpaid - Buy Now, Pay Later. To merchants Paytm offers acquiring devices like Sound box, EDC, QR and Payment Gateway where payment aggregation is done through PPI and also other banks’ financial instruments. To further enhance merchants’ business, Paytm offers merchants commerce services through advertising and Paytm Mini app store. Operating on this platform leverage, the company then offers credit services such as merchant loans, personal loans and BNPL, sourced by its financial partners.
About the role:
Your responsibility as a Lead MYSQL 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.
Requirement:
6+ year of experience in MYSQL DBA.
Core MySQL, AWS and MySQL Enterprise monitoring.
Extensive work experience on query optimization, script optimization, other related optimization tools and techniques including Performance monitoring.
Design and create database objects such as data table structures, stored procedures, views, Triggers, reports, Database Administration, Configuration, Maintenance and Support.
Data migration, backup, restore & recovery, Resolving performance issues, blocking and deadlocks.
Implement and Monitor 2-Node Active\Passive SQL Clustering to provide High Availability for mission critical events, database mirroring, replication and log shipping.
Implement and maintain security and integrity controls including backup and disaster recovery strategies for document management system and MySQL databases.
Help in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects
Experience with database performance tuning and optimization.
Strong understanding of MySQL database architecture.
Experience with backup and recovery procedures.
Knowledge of database security best practices.
Experience with data migration and transformation.
Ability to work under pressure and meet deadlines.
Why join us
● A collaborative output driven program that brings cohesiveness across businesses through technology
● Improve the average revenue per use by increasing the cross-sell opportunities
● A solid 360 feedbacks from your peer teams on your support of their goals
● Respect, that is earned, not demanded from your peers and manager
Compensation:
If you are the right fit, we believe in creating wealth for you with enviable 500 mn+ registered users, 21 mn+ merchants and depth of data in our ecosystem, we are in a unique position to democratize credit for deserving consumers & merchants – and we are committed to it. India’s largest digital lending story is brewing here. It’s your opportunity to be a part of the story!
Similar Jobs
Saama Technologies, Inc
Chennai, Tamil Nadu, India (On-Site)
• 3 Months ago
The Walt Disney Company
Glendale, California, United States (On-Site)
• 1 Week ago
Every matrix
Batumi, Adjara, Georgia (On-Site)
• 1 Month ago
Penumbra
Alameda, California, United States (Hybrid)
• 3 Months ago
Interactive Brokers
Greenwich, Connecticut, United States (Hybrid)
• 4 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
PlayStation Global
Madison, Wisconsin, United States (On-Site)
• 1 Month ago
Super
Vancouver, British Columbia, Canada (Remote)
• 3 Months ago
CloudLinux
Warsaw, Masovian Voivodeship, Poland (Remote)
• 2 Months ago
Get notifed when new similar jobs are uploaded
Jobs in Noida, Uttar Pradesh, India
The Creation Company
Chennai, Tamil Nadu, India (On-Site)
• 4 Months ago
Blinkhealth
India (On-Site)
• 2 Months ago
Get notifed when new similar jobs are uploaded
Administrative Jobs
CD PROJEKT RED
Warsaw, Masovian Voivodeship, Poland (On-Site)
• 3 Weeks ago
The Walt Disney Company
Singapore, Singapore (On-Site)
• 1 Day ago
Get notifed when new similar jobs are uploaded
