Database Expert; Oracle, SQL Server, Exadata

Technology Management

Database Expertise Possesses in-depth knowledge of multiple database technologies, including:

Oracle Technologies Expert‑level understanding of Oracle database administration, including:

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

Exadata Operations Strong understanding of Exadata architecture, including:

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

Microsoft SQL Server Expert‑level understanding of SQL Server administration, including:

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

MySQL Databases Expert‑level understanding of MySQL administration, including:

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

Additional Capabilities

• 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

Database Design & Security

• 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

Operational Excellence

• Develops complex scripts to automate database administration tasks and improve efficiency
• Monitors database health, performance, and availability using advanced tools
• Troubleshoots complex issues (e.g., 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 (e.g., 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