Database Expert; Oracle, SQL Server, Exadata

Database Expertise

Possesses in‑depth knowledge of multiple database technologies, including Oracle technologies.

• Performance tuning (SQL optimization, indexing strategies)
• Security best practices (Oracle Data Redaction, user privilege management, database auditing)
• High availability and disaster recovery (Data Guard configuration, failover testing)
• Backup and recovery (RMAN backups, point‑in‑time recovery)
• User and access control management (RBAC)
• Advanced features (partitioning, materialized views)

Strong understanding of Exadata architecture, including storage and performance optimization.

• Storage management (Storage Cell configuration, Intelligent Storage Pool)
• Performance optimization (In‑Memory technology, Infini Band networking)
• Integration with Oracle database features for optimal performance

Expert‑level understanding of SQL Server administration.

• Performance optimization (query tuning, indexing strategies)
• Security best practices (Always Encrypted, data masking, role‑based security)
• High availability and disaster recovery (Always On Availability Groups, Failover Clustering)
• Backup and recovery (transaction log backups, point‑in‑time recovery)
• User and access control management
• Advanced features (partitioning, replication)

Expert‑level understanding of MySQL administration.

• Performance optimization (query optimization, buffer pool management)
• Security best practices (user privileges, encryption in transit and at rest)
• Replication configurations (master‑slave, multi‑master replication)
• Backup and recovery (mysqldump, binary backups)
• Advanced features (partitioning, stored procedures)

• Stays up to date with industry trends, emerging database technologies, and security best practices
• Designs and implements solutions to optimize performance, scalability, security, and resource utilization, including:
  • Capacity planning and resource allocation
  • Performance tuning and bottleneck resolution
  • High availability and disaster recovery implementation
  • Database security design and enforcement

• Leads the design and implementation of secure database configurations across Oracle, SQL Server, MySQL, and Sybase environments
• Defines and enforces security policies (access control, encryption, auditing)
• Implements advanced database security features

• Develops complex scripts to automate database administration tasks and improve efficiency
• Monitors database health, performance, and availability using advanced tools
• Troubleshoots complex issues (performance degradation, data corruption) and identifies root causes

• Adheres to established database administration policies, security standards, and operational procedures
• Identifies and assesses database‑related risks and recommends mitigation strategies
• Contributes to the development of governance frameworks in collaboration with the Database Manager

• Participates in planning and executing database changes in line with change management procedures (change windows, rollback plans)
• Provides technical support to ensure clear communication of changes and impacts to stakeholders
• Supports development and testing of database change scripts
• Assists in implementing rollback procedures when required

• 7+ years of experience in Oracle DBA roles
• Strong experience in OCI, Exadata, RAC, Data Guard, and Golden Gate
• Experience in database migration and performance tuning