1) Working experience in both Maria and Postgresql DBA with 2-6 years of experience in PostgreSQL and Maria DB.
2) Experience should include DB design,Capacity Planning,Storage Management,Performance tuning,Schema Management.
3) Database Installation and configuration for enhancing server performance.
4) Database Backup and Recovery Planning.
5) Hands-on maintenance activities such as vacuum, full vacuum, analyze the database.
6) Data Replication - Streaming/Logical replication.
7) Database Migration and DB Upgrade with minimal downtime.
8) Understanding of basic database fundamentals: multi-version control, concurrency, transactions, indexing, locking. Analyze, recommend, and implement configuration for Optimized Performance.
9) Database security including backup encryption and implementation.
10) Good experience in Database Switch-over/Fail-over and Switch-backup/Fail-back.
11) Working experience troubleshooting database performance issue.
12) Understanding of UNIX environment with shell scripting.
13) Ready to work in rotational shift 24x7.
14) Excellent communication (Written and Oral) skill.
Note- The drive timings are from 10 am to 12 pm, anybody coming after 12 pm will not be allowed to attend the interview. Also do not carry your personal laptop, candidates with backgrounds in Mechanical, Civil, or Instrumentation are not eligible for the interview.
Keyskills: PostgreSQL Maria Upgrade Replication Mariadb Maria DB Query Optimization Database Upgrade Database Security