2.9 - Oracle
a. Autonomous Database
I have experience with Oracle's Autonomous Database, leveraging its self-managing, self-securing, and self-repairing features to simplify database administration. My expertise includes workload optimisation, automation of maintenance, security enforcement, and utilising machine learning capabilities to enhance performance and operational efficiency.
More Information >
i. Provisioning & Configuration
I provision Oracle Autonomous Databases (ADB) on OCI, including Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW). I configure compute, storage, auto-scaling, backup retention, and network settings to ensure scalability, high performance, and cost-efficiency.
ii. Security & Access Control
I enforce robust security practices through private endpoints, IP whitelisting, and Oracle Cloud IAM policies. I manage roles, groups, and dynamic policies to ensure least-privilege access and compliance with security standards.
iii. Data Loading & Integration
I utilise tools such as Data Pump, SQL Developer Web, and OCI Object Storage integration for efficient data loading. I configure database links and REST APIs to enable seamless data ingestion and synchronisation across systems.
I monitor and optimise database performance using Automatic Indexing, SQL Plan Management, and Real-Time SQL Monitoring. I leverage Oracle Machine Learning (OML) and ADW analytics to identify and resolve bottlenecks for sustained throughput.
v. Automation & Lifecycle Management
I automate operational tasks using OCI CLI, Terraform, and Resource Manager, including scheduled backups, patching, and configuration management. I manage resource consumption and lifecycle policies to maintain efficient and current environments.
vi. Monitoring & Alerts
I implement OCI Monitoring, Logging, and Alarms to track database health, user activity, and system metrics. I configure custom alerts for storage thresholds, CPU spikes, and connectivity issues to ensure timely incident response.
vii. Disaster Recovery & Backup
I configure autonomous backups, schedule exports to Object Storage, and design cross-region replication strategies. I test and document restore procedures to meet recovery point and time objectives (RPO/RTO) aligned with business continuity requirements.
viii. Compliance & Auditing
I enable Database Activity Auditing (DBAAS) and integrate with OCI Audit logs for comprehensive visibility into user actions and system changes, supporting governance, audit readiness, and regulatory compliance.
ix. Database Management
Skilled in setting up and managing Oracle Autonomous Databases and Oracle Database instances. Proficient in configuring backups, scaling resources, and optimising performance for both transactional and analytical workloads.
x. Data Import & Export
Experienced in using Database Actions tools to import and export data efficiently. Proficient in handling data formats such as CSV, JSON, and XML to facilitate seamless data exchange between systems.
xi. SQL Developer Web
Proficient in using SQL Developer Web within Oracle Autonomous Database to execute SQL queries, manage database objects, and analyse data. Skilled in creating and managing tables, views, indexes, and other database objects directly from a browser.
b. Oracle Cloud Infrastructure
Skilled in leveraging Oracle Cloud Infrastructure to architect, deploy, and manage scalable, secure cloud environments. Experienced across core OCI services including compute, networking, storage, identity and access management, and monitoring. Adept at optimising resource configuration and ensuring operational excellence through effective cloud governance and performance tracking.
More Information >
i. Compute & Networking
Knowledgeable in provisioning virtual machines, configuring virtual cloud networks (VCNs), and setting up subnets, load balancers, and security lists. Skilled in managing public and private IPs and ensuring secure connections between resources.
ii. Storage Solutions
Proficient in managing OCI storage services, including Object Storage, Block Volumes, and File Storage. Experienced in configuring storage for backup, archiving, and high-performance applications.
iii. Identity & Access Management
Experienced in configuring OCI IAM policies to manage user access and permissions. Skilled in setting up compartments, groups, and dynamic groups to ensure secure and organised resource management.
iv. Monitoring & Logging
Proficient in using OCI Monitoring and Logging services to track resource performance and identify issues. Skilled in setting up alarms, metrics, and log analysis to ensure the health and availability of cloud applications.
v. OCI Console Management
Proficient in navigating the OCI Console to manage cloud resources effectively. Skilled in setting up and configuring services such as Compute, Storage, and Networking. Experienced in monitoring resource usage, managing budgets, and using the cost analysis tools available within the console.
c. Oracle APEX
Proficient in building scalable, secure low-code applications with Oracle APEX. Experienced in creating interactive data-driven apps featuring forms, reports, and dashboards tailored to business needs. Skilled in customising components and integrating database functionality, with expertise in cloud deployment.
More Information >
i. Application Design & Development
I develop secure, scalable web applications using Oracle APEX’s low-code environment. I leverage Page Designer, component-based architecture, and shared components to build user-friendly interfaces aligned with business processes.
I create interactive reports, forms, and grids to efficiently manage and present data. I apply dynamic actions, column-level logic, and conditional formatting for responsive, role-based user experiences.
iii. Authentication & Authorisation
I configure custom authentication schemes including LDAP, social sign-in, and OCI IAM integration. I implement granular authorisation controls, secure session management, CSRF protection, and SSL enforcement.
iv. PL/SQL & Backend Integration
I use PL/SQL for processes, validations, and dynamic content generation. I integrate stored procedures, views, and packages to ensure robust backend logic and data integrity.
v. RESTful Web Services & APIs
I consume and expose RESTful APIs via Oracle REST Data Services (ORDS), enabling integration with external systems and secure mobile access through well-designed API endpoints.
vi. Responsive UI & UX Design
I design responsive applications using the APEX Universal Theme and templates, customising with CSS/JavaScript as needed, while prioritising low-code maintainability and performance.
vii. Application Lifecycle & Deployment
I manage application lifecycle through export/import, versioning, and multi-environment promotion (dev/test/prod), ensuring structured release management and collaboration.
viii. Data Security & Auditing
I implement row-level security, audit trails, and session tracking. I use APEX Advisor to review security, enforce access controls, and mitigate vulnerabilities like SQL injection and XSS.
ix. User Training & Support
I provide user documentation, onboarding, and ongoing support. I design intuitive UIs and feedback mechanisms to minimise training time and iteratively improve applications.
I analyse performance using debug logs, page timings, and session stats. I optimise queries, strategically use APEX collections, and offload asynchronous processes for efficient app performance.
xi. Access Controls
Proficient in implementing authentication and authorisation schemes within APEX applications. Skilled in configuring role-based access and using Oracle Identity Cloud Service (IDCS) for secure user management.
xii. Data Loading
Experienced in creating data-loading interfaces to import data into Oracle APEX applications. Skilled in designing intuitive interfaces for managing and updating data records.
xiii. Interactive & Classic Reports
Proficient in creating and customising Interactive and Classic Reports to provide dynamic data views. Skilled in implementing advanced filtering, sorting, and charting options for actionable insights.