DBA Administrator | Leading FinTech | Perfios

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.