Alex J.

Oracle Consultant

Proso.AI Technologies Pvt Ltd- October 2023-Present‍

• Designed and developed Oracle-based solutions, leveraging SQL and PL/SQL for efficient data processing, manipulation, and reporting.
• Created and optimized complex queries, views, and stored procedures in Oracle and MySQL databases to ensure efficient data retrieval and analysis.
• Integrated Oracle databases with MySQL and other third-party systems, ensuring seamless data flow between applications.
• Developed Python scripts for automation of data extraction, transformation, and loading (ETL) processes, improving operational efficiency.
• Built custom APIs using Python to interact with Oracle databases for real-time data access and integration with web and mobile applications.
• Performed performance tuning on Oracle and MySQL databases, optimizing queries and indexes to improve system performance and reduce latency.
• Created data migration strategies to move data between Oracle and MySQL databases, ensuring data consistency and integrity.
• Automated routine database administration tasks using Python scripts, such as backups, monitoring, and performance analysis.
• Worked closely with developers and business analysts to ensure Oracle database architecture supported application requirements and performance goals.
• Implemented database security best practices, including user roles, permissions, and data encryption to safeguard sensitive data in Oracle and MySQL environments.

University of Groningen (Netherlands)

Oracle Cloud Infrastructure Foundations Associate

‍