IT Systems Admin Specialist

Job Summary

The DBA Specialist oversees the management, performance, security, and availability of enterprise databases across on‑premises and cloud environments such as Azure, AWS, and OCI. This role ensures databases are optimally configured, highly available, secure, and aligned with organizational standards and SLAs while supporting operations, modernization efforts, disaster recovery readiness, and continuous service improvement.

Duties and Responsibilities

1. Database Administration & Operations

• Install, configure, administer, and maintain database platforms (e.g., Oracle, SQL Server, MySQL, PostgreSQL) across on-premise and cloud environments
• Perform routine database maintenance, patching, and upgrades in accordance with enterprise standards
• Ensure high availability and reliability of all production and non-production database systems
• Conduct regular database health checks and resolve operational issues

2. Performance Monitoring & Optimization

• Monitor database performance, resource utilization, and query execution efficiency
• Perform performance tuning (queries, indexing, memory, and storage optimization)
• Analyze trends and recommend enhancements to improve system efficiency
• Support capacity planning and forecasting for database growth and scalability

3. Backup, Recovery & Disaster Recovery

• Design, implement, and manage backup and recovery strategies across hybrid environments
• Ensure regular backup validation and successful restore testing
• Support and participate in Disaster Recovery (DR) planning, drills, and failover testing
• Manage replication and data synchronization between on-prem and cloud platforms

4. Security & Access Management

• Manage database users, roles, and privileges in alignment with RBAC and least privilege principles
• Implement database security controls including encryption, auditing, and monitoring
• Ensure compliance with corporate security policies, regulatory requirements, and audit standards
• Integrate databases with enterprise identity systems (e.g., Entra ID, AWS IAM, OCI IAM)

5. Cloud Database Management

• Provision, configure, and administer cloud-native and managed database services (e.g., Azure SQL, AWS RDS, OCI DB)
• Monitor cloud database performance, cost utilization, and scalability
• Implement high availability (HA), auto-scaling, and failover mechanisms in cloud environments
• Ensure adherence to cloud governance standards, policies, tagging, and naming conventions

 

6. Database Migration & Modernization

• Support database migration initiatives (on-prem → cloud, replatforming, upgrades)
• Collaborate with application and infrastructure teams on database design and optimization
• Participate in modernization efforts including automation, cloud adoption, and performance improvements
• Validate data integrity and consistency during migrations

7. Monitoring, Automation & Reporting

• Implement and manage monitoring tools for database health, availability, and performance
• Configure alerts and proactive incident detection mechanisms
• Automate routine DBA tasks such as backup validation, patching, and reporting
• Generate reports on database performance, utilization, SLA compliance, and risks

8. Documentation & Compliance

• Maintain up-to-date documentation on database configurations, architecture, SOPs, and DR procedures
• Ensure adherence to ITIL processes (incident, problem, and change management)
• Support audit and compliance requirements related to database systems and data governance

9. Collaboration & Support

• Work closely with system administrators, cloud teams, and application developers
• Provide support for database-related incidents, service requests, and changes
• Participate in root cause analysis (RCA) and continuous improvement initiatives
• Provide on-call support for critical database systems when required

Technical Competencies and Skills

Database Administration and Operations, Performance Monitoring and Optimization, Backup Recovery and Disaster Recovery, Security and Access Management, Cloud Database Management

Education, Trainings and Licenses Required

Bachelor’s degree in Computer Science Information Technology Computer Engineering or a related field