Database Administrator

Creating and maintaining database standards and policies.

Supporting database design, creation, and testing activities.

Managing the database availability and performance, including incident and problem management.

Installing and configuring database software (MySQL, PostgreSQL, MongoDB, Oracle, AWS RDS, Azure DB) to meet performance and scalability requirements.

RAC installation, configuration, and administration (Grid Infrastructure) for clustering and high availability.

Upgrading databases across versions (10g, 11g, 12c, 19c) and applying PSU patches (RDBMS, GRID).

Designing efficient database architecture and schemas to support millions of users and video metadata.

Monitoring and tuning database performance to ensure smooth playback and fast query responses.

Implementing backup and recovery strategies using RMAN, Data Pump, cloning, and disaster recovery procedures.

Enforcing robust security management, including Oracle Advanced Security and transparent data encryption for tablespaces.

Supporting Oracle SQL, PL/SQL code functionalities and assisting developers with query optimization.

Capacity planning and scalability analysis to forecast storage and compute needs.

Managing data migration and integration across platforms and environments.

Performing database housekeeping, such as tuning, indexing, etc.

Monitoring usage, transaction volumes, response times, concurrency levels, etc.

Implementing security measures and frameworks, while ensuring compliance.

Identifying, reporting, and managing database security issues, audit trails, and forensics.

Designing database backup, archiving, and storage strategy.

Installing upgrades and patches to various apps.

Managing database analytics, cloud integration, monitoring, troubleshooting, and compliance in AWS environments.

Handling cloud cost management, clustering technologies, and data migration from on prem to RDS and between RDS instances.

Performing rehydration and ensuring optimized use of computing resources (CPU, memory, storage).

Managing Google Cloud Platform (GCP) database services (Cloud SQL, BigQuery, Firestore) for scalable analytics, integration, and cost optimization.