Provision MySQL instances, both in clustered and non-clustered configurations
Ensure performance, security, and availability of databases
Work with the various Engineering groups and ensure database changes are in-line with operational standards and meet the strategies needed to scale
Data Mining and Data Analysis.
Prepare documentations and specifications
Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, optimize and tweak as necessary
Collaborate with other team members and stakeholders

Skills and Qualifications

Strong experience in writing SQL queries, Cloud SQL, procedures and functions. (Mandatory)

Experience in administering MySQL replication, configuration, and deployment strategies (Mandatory)
Should have experience in data modeling and database design
Experience in scripting preferred ( shell, Python, etc )
Must be highly proficient in all aspects of database administration, including backup/recovery/replication, clustering, advanced performance tuning, and proactive monitoring
Experience in handling databases as a service when production environments are in the cloud.
Metadata management and repository usage
Ensuring data integrity & Performance management and tuning
General systems management and networking skills.
Strong Knowledge with database architecture design, including data partitioning
Strong understanding of distributed systems, different levels of data consistency
Experience in any NoSQL database such as MongoDB is preferred.
Expert knowledge in maintaining, building, supporting, tuning, and monitoring production in MySQL database servers.
Understand data locking concepts and the different levels of locking in MySQL

More Jobs at Techtree It Systems

Associate Java Developer

Noida, Bengaluru, Belgaum

2 - 4 yrs

INR 4 - 7 Lacs

Business Analyst Intern

Belgaum

Experience: Not specified

Salary: Not disclosed

Java Full Stack Developer

Noida, Bengaluru, Belgaum

2.0 - 4.0 yrs

INR 4 - 7 Lacs

Sr. Accounts Executive

Noida

5.0 - 6.0 yrs

INR 1 - 2 Lacs

Java Software Developer_ 3-5 Years_Walkin

Noida, Delhi / NCR

3.0 - 5.0 yrs

INR 1 - 6 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.