Database Administrator (DBA)
Role Summary:
Responsible for managing, securing, and optimizing databases to ensure high availability, performance, and data integrity. Key activities include installation, maintenance, backup strategies, query optimization, and disaster recovery planning across SQL and NoSQL databases.
Mandate Skills:
- Clustering
- Sharding
- Relational Databases: PostgreSQL, MySQL
- NoSQL Databases: MongoDB, Cassandra, Redis
- Monitoring Tools: Nagios, Prometheus, Zabbix (or similar tools)
Key Responsibilities:
- Collaborate with software developers, system administrators, and IT teams to ensure database environment supports applications and business needs.
- Create and maintain detailed documentation for database configurations, procedures, and best practices.
- Install, configure, and maintain SQL and NoSQL databases 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; optimize queries, indexes, and resources for efficiency.
- Implement and maintain database security policies, including user permissions, encryption, and access controls.
- Ensure consistency and integrity of data through regular integrity checks.
- Implement and test disaster recovery plans, backup strategies, and point-in-time recovery.
Experience Requirements:
- 5 - 7 years in related DBA roles.
- Familiarity with SQL profiling and analysis tools such as SQL Profiler, EXPLAIN ANALYZE, Query Performance Analyzer.
- Proficiency with monitoring tools such as Nagios, Prometheus, Zabbix, New Relic, or Datadog.
- Experience with backup automation tools and scripting for scheduled backups and retention management.
Skills & Competencies:
- Relational Databases: PostgreSQL, MySQL, MariaDB, SQLite
- NoSQL Databases: MongoDB, Cassandra, Redis, Elasticsearch
- Expertise in designing normalized schemas with entities, relationships, and integrity constraints
- Advanced SQL query writing and optimization (complex joins, subqueries, indexing)
- Index management for query performance improvement
- Backup implementations: full, differential, incremental; data restoration planning
- Managing user permissions, roles, and access policies
- Data encryption techniques (at-rest and in-transit)
- Replication: master-slave, peer-to-peer setups for fault tolerance
- Clustering and load balancing for high availability
- Failover mechanisms for automatic system recovery and zero downtime
Education & Qualifications:
- Preferably B.Tech or equivalent technical qualification
