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
Luxoft
Poland, Ohio, United States (Remote)
• 3 Months ago
Mattel Inc
New York, New York, United States (On-Site)
• 2 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
Microsoft
Hyderabad, Telangana, India (On-Site)
• 4 Weeks ago
Luxoft
Turin, Piedmont, Italy (On-Site)
• 3 Months ago
Super
Los Angeles, California, United States (Remote)
• 4 Months ago
Synamedia
Bengaluru, Karnataka, India (On-Site)
• 5 Months ago
Get notifed when new similar jobs are uploaded
Jobs in Noida, Uttar Pradesh, India
PwC
Mumbai, Maharashtra, India (On-Site)
• 4 Months ago
Enphase Energy
Bengaluru, Karnataka, India (On-Site)
• 1 Month ago
Buckman
Chennai, Tamil Nadu, India (On-Site)
• 3 Months ago
Get notifed when new similar jobs are uploaded
Administrative Jobs
Zoox
Foster City, California, United States (On-Site)
• 4 Months ago
Keywords Studios (Player Support)
Benito Juárez, Buenos Aires Province, Argentina (Hybrid)
• 6 Months ago
Keywords Studios (Player Support)
Katowice, Silesian Voivodeship, Poland (On-Site)
• 2 Months ago
Next Level Business Services
Bloomington, Minnesota, United States (On-Site)
• 4 Months ago
Tencent
Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)
• 5 Months ago
Nintendo
Redmond, Washington, United States (Hybrid)
• 2 Months ago
Next Level Business Services
Charlotte, North Carolina, United States (On-Site)
• 4 Months ago
Get notifed when new similar jobs are uploaded
