Job Title

Candidate will be responsible for implementing solutions for database problems. Typical database activities include installation, backup, restoration, archiving, monitoring, performance tuning and other day to day operations. MySQL is used predominantly in most of the products and there are hundreds of such instances. Some of the products also use MongoDB, RDS, Postgres, and Elastic Stack. You will also be required to solve problems using serverless technologies. Requirements: ● Minimum 4+ years of MySQL / MongoDB database administration and migrations experience. ● Education: B.E/B.Tech degree. ● Comfortable managing multiple projects with MySQL or MongoDB is a must. ● Comfortable working with remote engineering teams. Responsibilities: ● DBA Tasks: MySql configuration, backup, restore, replication, deployment, server upgrade, schedule jobs, user management, audit plugin. ● Database Development: Good understanding of complete DB development related tasks. Eg. Developing Stored Procedures, Functions, Triggers, Complex SQL writing, Table creation etc. ● Database Optimization: Performance tuning, Indexing, Query optimization, Archiving of tables, Data type optimization, Index hint , Partitioning etc. ● Database Designing: Good understanding of designing of the table structure as per business requirement, Constraints, Keys, Columns, Data types. ● Database Code Review: Good understanding of DB code review. ● Database Server Monitoring: Ensure high availability of servers, Setting server alerts, Daily monitoring of parameters. Eg. Slow query log, Error log, Schedule jobs, Backups, Deadlock, Erroneous SQL statements, Failed login attempts, No. of connections etc. Good understanding of Percona monitoring and management or any other DB monitoring tool. ● DB Infrastructure Setup (Production, Development,Testing) : Setup DB server for Development, Testing and Production on AWS cloud or Own premises. Maintain the development and testing DB environment for e.g. Syncing of master or configuration tables with production DB etc. Finalization of production server architecture as per business needs such as Master-Slave, Group Replication ,Mirroring, Log shipping etc. ● Ensure DB Security: User management, Review of user privileges, Logging and monitoring of executed queries, Monitoring of failed login attempts, Encryption etc. ● Data Migration and Data transforming activities (ETL) :Migration of the data across different DBMS (For e.g. Oracle to MySQL), Transformation and loading of the data from different sources into DBMS as per business needs. ● DB load balancing :Load balancing of DB using ProxySQL or HAProxy ● Implementation of Data Warehouse :Data Warehouse implementation for business reports and data analysis, Combination of structured and unstructured data,Developed eco system from data storage to extraction ● Database Compliance Audit :Maintaining the DB with all audit compliances, Responsible for all audit related queries ● Guidance for DB related problems: Guide developers for designing DB, Writing optimize and complex SQL queries, Solving DB related problems ● Big Data technologies: Understanding of Hadoop, Hive,Spark and other big data technologies is desirable.