Job
Description
Requirements Minimum 4+ years of MySQL / MongoDB database administration and migrations experience. Comfortable managing multiple projects 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.
