Mauricio Alvarez Email and Phone Number

Experienced and results-driven Oracle Database Engineer with over 9 years of expertise in designing, developing, and optimizing complex Oracle database solutions. Adept at leveraging Python (cx_Oracle, Pandas, NumPy, PySpark) for data automation, interaction, and performance optimization in multi-component platforms, including Cloud services (Cloudera, AWS) and R codebases for modeling and analytics. Skilled in managing, maintaining, and evolving Oracle database estates, with a focus on aligning with SDLC and collaborating in DevOps pipelines. Python-Powered Data Engineering: Leveraged Python (cx_Oracle, Pandas) to develop automated data pipelines, reducing data processing time by 20% and improving data accuracy.Oracle Database Optimization: Implemented performance tuning techniques, including indexing and query optimization, resulting in a 30% reduction in query execution time.Agile Development: Collaborated with cross-functional teams in Agile environments to deliver database solutions on time and within budget.DevOps Practices: Utilized Git for version control and automated deployment pipelines to streamline the development and deployment process.Environment Management: Collaborate in the management of the Developer, User Acceptance Testing, and Production Oracle environments, ensuring that they meet operational standards and support both business and IT objectives.Maintenance and Optimization: Perform regular maintenance tasks to keep Oracle environments stable, secure, and optimized for performance, addressing system upgrades, patches, and resource management as needed.

● Database Optimization: Identified and resolved performance bottlenecks, improving query execution time by 25%.● Agile Development: Worked in Agile teams to deliver database solutions iteratively and incrementally.● DevOps Practices: Utilized automation tools to streamline database administration tasks.● Designed and developed ETL processes using IBM DataStage to extract, transform, and load data from various sources into the target systems.● Created UNIX Shell scripts for automation of ETL workflows, data validation, and error handling.● Developed PL/SQL code for database design, schema creation, and data manipulation using Oracle database.● Created complex SQL queries, stored procedures, and functions for data retrieval and reporting.● Worked with Oracle RAC for high availability and performance tuning.● Collaborated with cross-functional teams including business analysts, data architects, and testers to deliver high-quality solutions.● Participated in project planning, estimation, and status reporting activities.● Conducted training sessions for new hires and provided technical guidance and support.

● Data Modeling and Design: Developed efficient data models and database schemas to support business requirements.● SQL Optimization: Wrote optimized SQL queries and stored procedures to improve query performance by 20%.● Agile Development: Collaborated with development teams to deliver database solutions on time.● Created complex SQL queries, stored procedures, and functions for data retrieval and reporting.● Collaborated with cross-functional teams including business analysts, data architects, and testers to deliver high-quality solutions.● Participated in code review, testing, and deployment activities● Provided technical support and troubleshooting for production issues.