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 (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)
• Exadata Operations – Strong understanding of Exadata architecture, including Storage management (Storage Cell configuration, Intelligent Storage Pool), Performance optimization (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 (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)
• MySQL Databases – Expert-level understanding of MySQL administration, including 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, 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

• 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