Alex J.

Work experience

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.