Database Administrator

Job Summary

Administer, develop, and test databases. Perform many related database functions across one or more teams or clients, including designing, implementing and maintaining new databases, backup/recovery and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.

Technical Skills Required

A DBA should possess deep technical knowledge of database designing, optimization techniques, and high availability setups.

MySQL Skills

• Proficiency in SQL and database normalization techniques.
• Knowledge of MySQL architecture, storage engines (InnoDB, MyISAM).
• Replication (Master-Slave, Group Replication).
• Backup and recovery tools
• Query optimization and indexing strategies.
• Performance tuning and troubleshooting
• Scripting with Bash / Python

PostgreSQL Skills

• Working knowledge of PostgreSQL database.
• Experience with performance tuning
• Replication techniques
• Knowledge of partitioning and sharding strategies.
• Experience with backup and recovery using pg_dump, pg_basebackup.
• Scripting and automation using PL/pgSQL, Python, or Bash.