Product Manager- Supplychain/logistics/ Tranportation/ Railroad Domain

 Job Description For Database Engineer

Job Title: Database Engineer(MySQL)

Company: Mydbops 

About Us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering commitment to maintaining the highest standards of security and operational excellence.

Role Overview:

You will work in a fast-paced environment where we are responsible for the most critical systems. Our external teams ( Customers ) count on us to keep their MySQL database running and we are vital to the success of their business. You will troubleshoot and resolve customer issues related to the DB system's availability and performance.  You will develop relationships with customers, comprehend and fulfil their needs, and maintain their satisfaction through regular communication and engagement with their environments.

Responsibility :

• The major focus is on handling all the alerts in MDS MySQL.
• Optimising the complex SQL Queries.
• On-Demand Query Optimization.
• Monthly Query optimization assigned ( based on customer list ).
• Get into Client calls on Performance issues and other tasks.
• Reaching the DBE-2 and DBRE's for escalations.
• Assisting and mentoring the ADBEs.
• Efficient troubleshooting using MySQL MDS Internal tools 
• Writing the technical and process documents.
• Managing the client-based operations documents to ease scheduled & repeated tasks for the database engineering team.

Skills Required :

• Teamwork in a fast-paced environment.
• Alarm resolution expert
• Good in SQL language.
• Linux commands for day-to-day operations.
• Kernel tuning and Linux performance tools
• Expertise in MySQL backup tools
• mysqldump
• mydumper/myloader
• Xtrabackup.
• mariabackup
• Knowledge on AWS basic operations
• log collections
• S3 Push
• AWS Workspace
• Deep Skills in query optimization, index tuning and implementing the database features for SQL optimisation.
• Polite, friendly and professional; this position requires significant customer interaction and teamwork.
• Process-oriented and teamwork play a pivotal role.
• Excellent and strong written and spoken English Communication Skills.
• Strong work ethic and accepts feedback from others.
• Strong understanding of MySQL architecture, storage engines (InnoDB, MyISAM), and replication (Binlog Based And  GTID).
• Good understanding of database security practices (users, roles, encryption, authentication mechanisms).
• Strong problem-solving and troubleshooting skills.
• Experience with monitoring tools such as PMM (Percona Monitoring and Management), Prometheus, Grafana

Good to Have (Optional but Preferred): Experience with AWS RDS/Aurora MySQL.

Why Join Us:

• Opportunity to work in a dynamic and growing industry.
• Learning and development opportunities to enhance your career.
• A collaborative work environment with a supportive team.

Job Details:

• Job Type: Full-time opportunity 
• Work Days - 6 days
• Work time: Rotational shift
• Mode of Employment - Work From Home

We are looking for very hands-on DevOps engineers with 3 to 6 years of experience. The person will be part of a team that is responsible for designing & implementing automation from scratch for medium to large scale cloud infrastructure and providing 24x7 services to our North American / European customers. This also includes ensuring ~100% uptime for almost 50+ internal sites. The person is expected to deliver with both high speed and high quality as well as work for 40 hours per week (~6.5 hours per day, 6 days per week) in shifts that will rotate every month.

This person MUST have:

• B.E Computer Science or equivalent

• 2+ Years of hands-on experience troubleshooting/setting up of the Linux environment, who can write shell scripts for any given requirement.

• 1+ Years of hands-on experience setting up/configuring AWS or GCP services from SCRATCH and maintaining them.

• 1+ Years of hands-on experience setting up/configuring Kubernetes & EKS and ensuring high availability of container orchestration.

• 1+ Years of hands-on experience setting up CICD from SCRATCH in Jenkins & Gitlab.

• Experience configuring/maintaining one monitoring tool.

• Excellent verbal & written communication skills.

• Candidates with certifications - AWS, GCP, CKA, etc will be preferred

• Hands-on experience with databases (Cassandra, MongoDB, MySQL, RDS).

Experience:

• Min 3 years of experience as DevOps automation engineer buildingg, running, and maintaining production sites.

• Not looking for candidates who have experience only as L1/L2 or Build & Deploy.
  
  

Location: Remotely, anywhere in India.

Timings:

• The person is expected to deliver with both high speed and high quality as well as work for 40 hours per week (~6.5 hours per day, 6 days per week) in shifts that will rotate every month.
  
  

Position:

• Full time/Direct

• We have great benefits such as PF, medical insurance, 12 annual company holidays, 12 PTO leaves per year, annual increments, Diwali bonus, spot bonuses and other incentives etc.

• We dont believe in locking in people with large notice periods.  You will stay here because you love the company.  We have only a 15 days notice period.