Senior Oracle DBA Engineer (SQL - PL/SQL)
Oracle
- Zapopan, Jal.
- Permanente
- Tiempo completo
- Develop complex SQL and PL/SQL code to implement analytics algorithms and support the UI development
- Design and implement data model for scalable and performing solution with large data volumes
- Work with Develop Oracle Data Integrator to manage and maintain data integrations in the database
- Identify & address application data issues that affect application integrity
- Ensure that the database design fulfills functional & technical requirements, including design-for-performance
- Analyze and ensure efficient transition of all technical design documents
- Work effectively with Tech leads, Scientist and Data Science Developers to create and maintain the overall data architecture, priorities and success measures for the enterprise
- Review the deliverables throughout development to ensure quality & traceability to requirements and adherence to all quality management plans & standards
- Strong software development experience
- Strong knowledge of and experience with Data warehouse modeling and ETL design, and ETL tools
- Strong knowledge and hands on experiences in PL/SQL programming, including creating packages/functions/stored procedures/views
- Strong knowledge and ability to write complex SQL queries
- Knowledge in Unix/Shell scripting
- Experience with Linux/Unix operating system
- Experience with building images for use with Docker / Kubernetes
- Experience with creating a scalable and performing solution with large data volumes in the Oracle DB or in any java application server
- Good analytical skills and understanding of basics concepts in data science
- Experience working on analytic/data science projects like optimization and data mining is a plus
- Experience with ODI and OBIEE
- Experience using Oracle Data Visualizer
- Able to balance and prioritize multiple concurrent projects effectively.
- Eager to learn and work in an agile environment
- Self-motivated, responsible, and accountable
- Excellent communication skills
- Able to work with cross-functional teams responsible for product design, integration and testing
- Bachelor's or Masters degree in Computer Science or equivalent years of experience in related field.
- 5+ years in a developing, modeling, and deploying enterprise solutions, Retail/SCM experience preferred
- Which includes being a United States Affirmative Action Employer