REQUIREMENTS:
• Analyze requirements and create performance, scalable database structures, objects and stored procedures
• Analyze, create and tune complex SQL code to ensure optimal performance and data integrity across very large data sets
• Troubleshoot database performance issues in an Oracle environment
• Must have experience with Performance Tuning. Proficiency with SQL & PL/SQL.
• Review and tune code to ensure best practices, quality standards and data integrity
• Design and implement approaches to improve database performance, capacity, and scalability
• Confer with appropriate managers and peer team members regarding problems with and capabilities of databases
• Experience in migrating from Oracle to MySQL or Postgres is a plus
• Experience with Oracle database, Elasticsearch, GitLab, MySQL, PostgreSQL a plus
• Experince with database migration to a cloud environment is a plus
• Excellent communication and reporting skills
• Work within a collaborative Agile environment
| | Skill | Required / Desired | Amount | of Experience |
| Analyze requirements and create performance, scalable database structures, objects and stored procedures | Required | 10 | Years | |
| | | | | | | | | |
| Analyze, create and tune complex SQL code to ensure optimal performance and data integrity across very large data sets | Required | 10 | Years |
| Troubleshoot database performance issues in an Oracle environment | Required | 10 | Years |
| Review and tune code to ensure best practices, quality standards and data integrity | Required | 10 | Years |
| Design and implement approaches to improve database performance, capacity, and scalability | Required | 10 | Years |
| PL/SQL | Required | 10 | Years |
| SQL | Required | 10 | Years |
| Toad / SQL Developer / PL SQL Developer or similar tools | Required | 10 | Years |
| ETL tools like Pentaho Kettle, Informatica | Required | 10 | Years |
| SVN/Git | Required | 10 | Years |
| Experience with Oracle database, Elasticsearch, MySQL, PostgreSQL | Required | 10 | Years |
| Experience in migrating from Oracle to MySQL or Postgres | Highly desired | 5 | Years |
| Experince with database migration to a cloud environment | Highly desired | 5 | Years |
| Excellent communication and reporting skills | Required | 10 | Years |
| Experience using Atlassian Suite - Jira, Confluence, etc. | Required | 5 | Years |