Job Description:
Responsibilities:
- Design and implement high-performance transactional database solutions using Oracle Database technologies.
- Develop database schemas, tables, indexes, stored procedures, triggers, and other database objects to support application requirements.
- Optimize database performance, scalability, and reliability through effective database design, indexing strategies, and query optimization techniques.
- Collaborate with software engineers, application developers, and system administrators to integrate database solutions into software applications and infrastructure environments.
- Provide technical guidance and mentorship to junior database developers and engineers.
- Conduct performance tuning, troubleshooting, and resolution of database-related issues.
- Stay current with industry trends, emerging technologies, and best practices in database architecture and development.
- Contribute to the continuous improvement of database development processes, tools, and methodologies.
- Participate in cross-training initiatives to gain proficiency in SQL Server database technologies.
Qualifications:
- Bachelor’s degree in computer science, Information Technology, or a related field. Master's degree preferred.
- Extensive experience (10+ years) working as a Database Architect or Database Developer with a focus on transactional database development using Oracle Database technologies.
- Proficiency in Oracle Database technologies, including Oracle SQL, PL/SQL, Oracle Data Guard and preferably in Oracle RAC.
- Strong understanding of database design principles, normalization, and data modeling techniques.
- Experience with database performance tuning, query optimization, and scalability enhancements.
- Excellent problem-solving skills and the ability to troubleshoot complex database issues.
- Strong communication skills and the ability to collaborate effectively with cross-functional teams.
- Willingness to learn and adapt to new technologies, including SQL Server database technologies.
- Certification in Oracle Database Development or SQL Server development is a plus.