Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

MYSQL - Senior Lead DBA

Uttar Pradesh, India (On-site)

MYSQL - Senior Lead DBA

1 Month ago • 6 Years + • Administrative

About the job

3 skills required for this role

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

aws

sql

mysql

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

Not hearing back from companies?

Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

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!

undefinedundefinedundefined

View Full Job Description