Hands-on experience in MariaDB and PostgreSQL database administration.
Expertise in database design, capacity planning, schema management, and storage optimization.
Installation, configuration, and tuning of databases to enhance server performance.
Plan and execute backup and recovery strategies, including point-in-time recovery.
Perform routine maintenance activities like VACUUM, ANALYZE, and full vacuuming.
Configure and manage data replication (Streaming / Logical).
Execute database upgrades and migrations with minimal downtime.
Deep understanding of MVCC, concurrency, transactions, indexing, and locking mechanisms.
Ensure database security, including encryption and role-based access control.
Proficiency in failover/switchover and disaster recovery configurations.
Troubleshoot performance issues and implement tuning measures.
Strong knowledge of UNIX/Linux systems and shell scripting.
Collaborate with DevOps teams for CI/CD pipeline integration for DB deployments.
Knowledge of containerization (Docker) and orchestration tools (Kubernetes) for running DB services.
Monitor databases using tools like Prometheus, Grafana, or Zabbix.
Familiarity with Git, Jenkins, and version control for DB change management.
Comfortable working in 24x7 rotational shifts.
Job Classification
Industry: Software Product Functional Area / Department: Engineering - Software & QA Role Category: DBA / Data warehousing Role: Database Administrator Employement Type: Full time