Database Administrator

A database engineer creates and manages databases for a company or organization. This involves designing and building databases to suit a purpose. The database engineer must also install and configure the database

Roles & responsibilities:

• Install/ backup/restore and recover the databases
• Database upgrade and data migration
• Query optimization and performance tuning
• Generate the complex automated/manual report
• Working closely with Development team to design and development of databases
• Database system monitoring and troubleshooting
• Strong knowledge of Relational Database Management System specially MySQL & PostgreSQL.
• Experience of managing high the volume OLTP/OLAP databases.
• Strong bash/shell and Python scripting skills.
• Strong experience of database upgrades, backup, recovery and migration.
• Experience with query optimization & performance tuning.
• Strong knowledge of replication and clustering technology(specially Galera or Percona,group replication)
• Experience of data warehousing and ETL processing.

  Other Specification

  Qualifications:

  1. Education: A bachelor’s degree in computer science, information technology, or a related field is typically required.
  2. Experience: Prior experience working with database management systems is essential, with a minimum of 2-5 years of relevant experience.
  3. Database Management Skills: Proficiency in working with database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL.
  4. SQL Proficiency: Strong understanding of Structured Query Language (SQL) and ability to write complex SQL queries, optimize database performance, and troubleshoot SQL-related issues.
  5. Data Security: Knowledge of database security concepts, including user access management, data encryption, and backup and recovery strategies.
  6. Performance Tuning: Experience in database performance tuning and optimization techniques, including indexing, query optimization, and caching strategies.
  7. Problem-solving Skills: Strong analytical and problem-solving abilities to diagnose and resolve database-related issues, performance bottlenecks, and data inconsistencies.