2.9 - Oracle
a. 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.
b. Autonomous Database
I have experience with Oracle's Autonomous Database, using its self-managing, self-securing, and self-repairing features to simplify database management. My skills include configuring and optimizing workloads for transactional and analytical purposes, automating maintenance tasks, and implementing security through encryption and monitoring. I also use machine learning features to improve performance and enhance operational efficiency.
c. 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.
d. 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.
e. Database Security
Knowledgeable in managing database security features, including user roles, privileges, and data encryption. Skilled in auditing database access and ensuring compliance with security policies.
f. 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.
g. 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.
h. 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.
i. 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.
j. 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.
k. 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.
l. Oracle APEX
Proficient in building low-code applications that are both scalable and secure using Oracle APEX. Experienced in creating interactive data-driven applications with forms, interactive reports and dashboards tailored to business needs. Skilled in customising APEX components to deliver a seamless user experience. I specialise in integrating applications with database functionalities and deploying applications to the cloud with ease.
Proficient in optimising query performance and database operations using execution plans and tuning advisors. Skilled in identifying performance bottlenecks and applying indexing or partitioning strategies for faster query results.
n. 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.
o. 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.
p. SQL
Skilled in writing efficient SQL queries and PL/SQL scripts for database operations. Experienced in creating stored procedures, triggers, and functions to automate complex data processing tasks.