Job responsibilities
- Oracle Database administration, query optimization / Schema design and build, ownership of the database environment.
- Executes software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems.
- Collaborates with software engineers and teams to design and implement deployment approaches using automated continuous integration and continuous delivery pipelines.
- Review designs and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow, and understand and comply with Project Life Cycle Methodology in all planning steps.
- Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules.
- Collaborate with fellow developers in design sessions ensuring that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation.
- Lead and participate in performance tests, identifies the bottlenecks, opportunities for optimization and capacity demands.
- Supports end-user functional and system support issues via various channels (e.g. tickets, email, chat).
- Proactively identifies hidden problems and patterns in data and uses these insights to drive improvements to coding hygiene and system architecture.
- Contributes to software engineering communities of practice and events that explore new and emerging technologies.
- Adds to team culture of diversity, equity, inclusion, and respect.
Required qualifications, capabilities, and skills
- Formal training or certification on Oracle administration and PL/SQL development concepts and 3+ years applied experience
- Exposure to and experience with the following additional technologies: Java, C#, NoSQL & Graph databases and source control (git).
- Hands-on practical experience in system design, application development, testing, and operational stability.
- Proficient in coding in one or more languages.
- Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages.
- Overall knowledge of the Software Development Life Cycle.
- Solid understanding of agile methodologies such as CI/CD, Application Resiliency, and Security.
- Demonstrate ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes.
Preferred qualifications, capabilities, and skills
- Experience with Oracle EXADATA a strong plus.
- Experience with Oracle 12c/19c a strong plus.
- Exposure to cloud technologies.
- Development experience with PL/SQL.
- Experience with database schema/table design.