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, InfiniBand 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)
•
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 (e.g., performance degradation, data corruption) and identifies root causes
Governance (Risk, Policy & Processes)
•
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
Requirements:
7+ years of experience in Oracle DBA roles
Strong experience in OCI, Exadata, RAC, Data Guard, and GoldenGate
Experience in database migration and performance tuning