Database Administrator

Job Description

A Database Administrator (DBA) is responsible for managing, securing, and optimizing databases to ensure high availability, performance, and data integrity. This role involves database installation, maintenance, backup strategies, query optimization, and disaster recovery planning across SQL and NoSQL databases. Mandate Skills for DBA : - Clustering - Shardening - Relational DB : Postgree sql , MYSql - Nosql DB : MongoDB, Casandra, Redis - Tool : Nagios, Prometheus, Zabbix ( any other tools if not anyone of these) Key Responsibilities : - Collaborate with software developers, system administrators, and other IT teams to ensure the database environment supports applications and business needs. - Create and maintain detailed documentation for database configurations, procedures, and best practices. - Install, configure, and maintain databases (SQL and NoSQL) to ensure high availability, performance, and reliability. - Perform regular database backups, ensuring data integrity, and restore capabilities. - Manage database migrations, upgrades, and patches. - Monitor database performance and optimize queries, indexes, and resources for optimal speed and efficiency. - Implement and maintain database security policies, including user permissions, encryption, and access controls. - Ensure the consistency and integrity of data through regular integrity checks. - Implement and test disaster recovery plans, backup strategies, and point-in-time recovery. Requirements : Experience : - 5 - 7 Years of experience in related roles. - Familiarity with tools like SQL Profiler, EXPLAIN ANALYZE, and Query Performance Analyzer for profiling and analyzing queries. - Proficiency with tools like Nagios, Prometheus, Zabbix, New Relic, or Datadog for database performance monitoring. - Knowledge of backup automation tools and scripts for scheduled backups and retention management. Skills and Competencies : - Relational DB : PostgreSQL, MySQL, MariaDB, SQLite. - NoSQL Databases : MongoDB, Cassandra, Redis, Elasticsearch. - Expertise in designing normalized database schemas, including defining entities, relationships, and integrity constraints. - Expertise in writing and optimizing SQL queries for performance, including complex joins, subqueries, and indexing strategies. - Proficiency in creating and managing indexes to improve database query performance. - Implementing regular backups (full, differential, incremental) and ensuring a recovery plan for data restoration. - Managing user permissions, roles, and database access policies. - Understanding encryption techniques for data-at-rest and data-in-transit. - Replication : Configuring and managing database replication (master-slave, peer-to-peer) for fault tolerance. - Clustering : Expertise in database clustering and load balancing techniques for ensuring high availability. - Failover Mechanisms : Implementing automatic failover systems for zero downtime in case of database failures. Education & Qualifications : - Preferably BTECH or suitable tech qualification.