Senior Database Administrator

Role Summary

Senior Database Administrator (DBA)

Key Responsibilities

1. Database Administration & Management

• Administer and manage DB2, Oracle, PostgreSQL, and MS SQL Server databases across development, test, and production environments.
  
• Ensure availability, reliability, and scalability of databases to meet business requirements.
  

2. Performance Tuning & Optimization

• Monitor and analyze database performance, identifying and resolving bottlenecks.
  
• Optimize queries, indexes, and resource allocation across DB2, Oracle, SQL Server, and PostgreSQL.
  

3. Backup & Recovery

• Implement, manage, and regularly test backup and recovery strategies.
  
• Ensure data integrity and business continuity in line with RTO/RPO requirements.
  

4. High Availability & Disaster Recovery

• Design, implement, and maintain HA and DR solutions such as:
  

• DB2 HADR

• Oracle Data Guard

• MS SQL Server Always On

5. Security & Compliance

• Manage database security, including

  user access controls, encryption, and audit logs

  .
• Ensure compliance with regulatory and organizational security standards.
  

6. Automation & Scripting

• Develop and maintain automation for routine DBA tasks (backups, patching, monitoring).
  
• Use scripting languages such as

  Shell

  and

  PowerShell

  for efficiency improvements.

7. Database Migration & Upgrades

• Plan and execute database upgrades, migrations, and patching across DB2, Oracle, and MS SQL Server environments.
  
• Minimize downtime and ensure smooth transitions.
  

8. Database Architecture & Design

• Design schemas, tables, stored procedures, and views to support application requirements.
  
• Ensure data integrity, scalability, and optimal performance.
  

9. Troubleshooting & Incident Resolution

• Diagnose and resolve complex issues such as

  performance bottlenecks, corruption, and outages

  .
• Provide root cause analysis and implement permanent fixes.
  

10. Capacity Planning & Monitoring

• Perform database sizing, capacity planning, and growth forecasting.
  
• Proactively ensure databases scale with evolving business needs.
  

11. Collaboration & Leadership

• Work closely with

  developers, system administrators, and other stakeholders

  to deliver high-performing solutions.
• Mentor junior DBAs and share best practices.
  

Required Skills & Qualifications

• 810 years of DBA experience, primarily with

  IBM DB2

  .
• Strong knowledge of

  Oracle, PostgreSQL, and MS SQL Server

  (On-Prem & Azure).
• Expertise in

  performance tuning, HA/DR, and backup/recovery strategies

  .
• Hands-on experience with

  DB2 HADR, Oracle Data Guard, MS SQL Server Always On

  .
• Proficiency in

  Shell scripting, PowerShell, or equivalent automation tools

  .
• Excellent troubleshooting, analytical, and problem-solving skills.
  
• Strong communication and leadership abilities.