Job Description
The Database Administrator (DBA) is responsible for the design, implementation, management, and optimization of Microsoft SQL Server and Oracle database environments. This role ensures database performance, availability, security, and reliability while supporting business-critical applications. The DBA will also work on database automation, backup strategies, and disaster recovery planning.
Key Responsibilities:
Database Administration & Management
- Install, configure, upgrade, and maintain MSSQL and Oracle database servers.
- Monitor and optimize database performance, tuning queries, indexes, and storage for high efficiency.
- Implement and manage database clustering, replication, and high availability solutions (AlwaysOn, Data Guard, RAC).
- Perform capacity planning and database scaling strategies.
- Manage database patching, upgrades, and migrations with minimal downtime.
Security & Compliance
- Ensure databases are secure and comply with government and organizational security policies.
- Implement role-based access control, encryption, and auditing.
- Regularly perform security assessments, vulnerability scans, and apply necessary patches.
Backup & Recovery
- Develop and maintain backup strategies using RMAN, Data Pump, SQL Server Backup, and other tools.
- Implement and test disaster recovery (DR) plans and ensure database recoverability.
Automation & Optimization
- Automate routine tasks such as backup, indexing, and monitoring using scripts and tools.
- Optimize database performance by identifying and resolving bottlenecks.
Support & Troubleshooting
- Provide L2,&3 support for database incidents, troubleshooting performance and connectivity issues.
- Work closely with application teams to optimize database queries and stored procedures.
Collaboration & Documentation
- Work with IT Security, Application, and Infrastructure teams to align database strategies with business goals.
- Document database architectures, configurations, and procedures.
- Train junior DBAs and IT staff on database best practices.
Qualifications & Experience:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 7+ years of experience in database administration, focusing on MSSQL and Oracle.
- Strong knowledge of SQL Server (2016/2019/2022) and Oracle (12c, 19c).
- Experience with HA & DR solutions: AlwaysOn, Data Guard, Oracle RAC, Log Shipping.
- Proficiency in T-SQL, PL/SQL scripting, and database tuning.
- Hands-on experience with cloud databases(Azure SQL, Oracle Cloud, AWS RDS) is a plus.
- Familiarity with database monitoring tools (OEM, SQL Server Profiler, RedGate, SolarWinds).
- Certification preferred: MCSA/MCSE (SQL Server), Oracle OCP (Database Administration).