SeniorTechnicalSpecialist–DatabaseAdministration&Middleware/BusinessIntelligence

and supporting enterprise-class database

and business intelligence solutions with a emphasis on Oracle technologies

and performant data platforms that support mission-critical applications and analytics

proposing solution architecture

and continuous enhancement of enterprise data environments

and maintain Oracle databases across development

and production environments

Design and implement scalable database architectures for OLTP and data warehouse workloads

including replication

and distributed environments

Implement backup and recovery strategies using RMAN

including regular restore/recovery testing to ensure recoverability and support non-production refreshes

Configure and support HA/DR solutions such as Oracle Data Guard and related technologies

including switchover/failover procedures and validation

Administer Oracle Enterprise Manager and related monitoring tools to proactively manage capacity

and support Oracle GoldenGate for unidirectional and bidirectional replication across multiple environments

enabling high availability and real-time data synchronization

Monitor GoldenGate environments

perform performance tuning

and resolve replication issues to maintain data integrity and consistency

and support Oracle APEX applications

and charts to modernize and improve user experience

configure and manage Oracle REST Data Services (ORDS) and related middleware components

develop PL/SQL and JavaScript logic within APEX

and optimize PL/SQL and SQL code for large-scale applications (e.g.

improving performance and scalability

Conduct detailed performance tuning of queries

and storage structures

to improve response times and throughput

Perform root-cause analysis on complex incidents and implement corrective and preventive actions

Design and maintain logical and physical data models to support transactional systems

Develop complex PL/SQL-based ETL/ELT routines for data extraction

Design and support data warehouse and BI solutions

including dimensional data models and reporting/analytics structures

self-service analytics

Produce technical documentation including solution architectures

operational procedures

and end-user reporting guides

Lead technical evaluations

providing recommendations based on structured ranking matrices and business requirements

Engage with business stakeholders

and QA teams to translate business requirements into robust technical designs and BI solutions