Oracle Developer

Hace 4 días

Ciudad de México Pyramid Consulting, Inc Jornada completa

> Develop, and support Oracle database solutions, including packages, stored procedures, functions, triggers, views, materialized views, and sequences, ensuring high performance, scalability, and maintainability.

> Develop, enhance, and optimize SQL and PL/SQL code to support application functionality, reporting, system integrations, and business operations.

> Create and maintain database migration scripts, schema updates, release deployment packages, and automated database deployment processes.

> Develop and support cloud-based data integration, reporting, and analytics solutions using AWS technologies such as Amazon Redshift, Amazon S3, Amazon RDS, and related services.

> Troubleshoot and resolve database issues, data quality concerns, application integration challenges, and performance bottlenecks across environments.

> Perform database performance tuning and optimization using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools.

> Collaborate closely with software engineers, architects, DevOps engineers, and business stakeholders to deliver scalable and reliable data solutions.

> Contribute to DevSecOps and CI/CD initiatives by implementing automated testing, deployment, monitoring, and compliance practices for database solutions.

> Develop and support database unit testing, regression testing, data validation testing, and automated test support for SQL, PL/SQL, and data migration changes.

> Support production operations, release deployments, incident troubleshooting, root-cause analysis, and post-deployment validation for mission-critical database and application components.

> Experience with Oracle Data Pump, Oracle GoldenGate, ODI,Flyway, or similar data integration and migration tools.

> Experience with Oracle DB,AWS, cockroachDB, or other enterprise database platforms.

> Experience supporting cloud modernization, database migration, or application modernization initiatives.