Oracle Database Developer
Must-have:AWSCloudDevOpsCI/CDRemote
Machine translation — original language: Spanish.Show original
Your tasks
- Oracle database development
- Design, develop, and maintain Oracle database solutions.
- Create and optimize Packages, Stored Procedures, functions, triggers, views, materialized views, and sequences.
- Develop and maintain SQL and PL/SQL code to support application functionalities, reports, integrations, and business processes.
- Ensure the performance, scalability, stability, and maintainability of database solutions.
- Implement improvements and optimizations in database structures and components.
- Database optimization and performance
- Perform analysis and optimization of SQL query performance and PL/SQL processes.
- Analyze Execution Plans and implement indexing strategies.
- Apply partitioning techniques and optimizer statistics optimization.
- Use Oracle diagnostic and monitoring tools to identify performance issues.
- Resolve problems related to data quality, integrity, and process efficiency.
- Data migration and integration
- Develop and maintain database migration scripts and Database Schema updates.
- Prepare release packages and deployment of database changes.
- Participate in database and application migration and modernization projects.
- Implement data integration solutions using tools such as Oracle Data Pump, Oracle GoldenGate, and Oracle Data Integrator (ODI).
- Participate in data transfer, synchronization, and validation processes between different platforms.
- Cloud solutions and AWS services
- Develop and provide support for integration, reporting, and data analytics solutions using AWS services.
- Work with technologies such as Amazon Redshift, Amazon S3, and Amazon RDS.
- Participate in database modernization projects and migration toward cloud environments.
- Integrate enterprise database solutions with cloud-hosted services and applications.
- Contribute to the implementation of scalable, high-performance data architectures.
- Automation, testing, and DevSecOps
- Implement automated processes for database deployments and releases.
- Develop and maintain migration, update, and version control scripts.
- Participate in CI/CD and DevSecOps initiatives related to database solutions.
- Implement unit tests, regression tests, and data quality validations.
- Use tools such as Flyway or equivalent solutions to automate database deployments and changes.
- Contribute to security, monitoring, and compliance practices in development processes.
- Production support and incident resolution
- Provide support for databases and critical components of enterprise applications.
- Diagnose and resolve problems related to databases, integrations, and performance.
- Participate in version deployments and post-release validations.
- Perform Root Cause Analysis (RCA) and implement corrective actions.
- Collaborate with development, architecture, and DevOps teams to ensure operational continuity.
Requirements
Indispensable knowledge
- Experience in Oracle database development.
- Mastery of SQL and PL/SQL.
- Development of Stored Procedures, Packages, Functions, Triggers, Views, and Materialized Views.
- Experience in database optimization and Performance Tuning.
- Knowledge of Execution Plans, Indexing, Partitioning, and Optimizer Statistics.
- Experience in developing migration scripts and schema updates.
- Knowledge of database deployment and release processes.
- Experience in production support and database troubleshooting.
- Knowledge of data integration and information validation.
Desirable knowledge
- Experience with AWS, especially Amazon Redshift, S3, and RDS.
- Knowledge of CockroachDB or other enterprise database platforms.
- Experience with Oracle Data Pump, Oracle GoldenGate, and Oracle Data Integrator (ODI).
- Knowledge of Flyway for migrations and deployment automation.
- Experience with data integration and migration tools.
- Knowledge of CI/CD, DevSecOps, and test automation.
- Experience in application modernization projects and database migration to the cloud.
Requirements
- Minimum education: Higher education - Bachelor's degree
- 3 years of experience
What we offer
- Salary according to experience
- 100% payroll scheme
- Statutory benefits (Prestaciones de Ley)
- Superior benefits (Family SGMM, SV 1 million, Grocery vouchers, 30 days of aguinaldo, PTU).