Role: My SQL DBA
Work Location: Noida/Hyderabad
Exp : 3+ Yrs
About the Role:
The ideal candidate would be working on the servers which impact various SaaS AI/ML products and
1000+ models in AI/ML. As a DBA administrator the server support would be provided for various
industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role
would give an opportunity working on multiple and complex databases for fortune 500 customers which
have impact on their data related to AI/ML products/models of the company.
About the Company:
We are America’s oldest machine learning solutions company. With offices across US, China and India,
we hire people with a broad set of technical and domain skills who can contribute to the creation of
machine learning solutions across verticals such as financial services, telecommunications, healthcare,
consumer products etc.
Preferred Qualification:
(Must have)
· Three years or above working experience, more than two years in MySQL, familiar with MySQL
database architecture.
· Have good experience in database troubleshooting and solutions for the whole system chain,
including OS, Database, storage, network, application, cloud and so on.
· Familiar with SQL tuning, know about how to split large tables in MySQL.
· Familiar with the daily backup and restore operations of MySQL, and know about the HA
principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.
· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.
· Experience about NoSQL databases is preferred, such as MongoDB, Redis.
· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.
· Oracle DBA or SQL Server DBA working experience is preferred.
· Careful work, strong sense of responsibility, good learning ability and team spirit.
Responsibilities:
· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL
and postgreSQL, make sure all database system running safely and stably.
· Establish MySQL daily backup and recovery policies, and data security policies.
· Responsible for the design and implementation of Database tables, and large table split policy.
· Provided daily support to the development team and application team, such as database design
specification and performance tuning suggestions.