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.
