Title:  Senior Software Engineer

Job Summary:

We are seeking an experienced Database Developer with strong expertise in Relational Database Management Systems (RDBMS), particularly Oracle writing complex stored procedures, triggers, and functions. You will work closely with cross-functional teams to design, develop, optimize, and maintain scalable and efficient database solutions.

Key Responsibilities:

• Design, develop, and implement database structures and solutions for high-performance data processing and reporting.
• Work with Oracle RDBMS to write and optimize complex SQL queries, stored procedures, triggers, and functions.
• Basic knowledge on Talend to ensure efficient data integration, transformation, and loading.
• Collaborate with data architects and business stakeholders to translate requirements into technical solutions.
• Design, implement, and maintain complex database structures, ensuring consistency, reliability, and high availability.
• Troubleshoot database issues, including performance, security, and availability, and take necessary corrective actions.
• Perform database tuning to optimize the performance of queries, indexes, and system resources.
• Maintain data integrity and support data security protocols in line with industry best practices.
• Develop and manage database migration strategies, ensuring smooth data transitions between systems.
• Document and standardize coding practices, procedures, and database workflows.
• Monitor database system performance and create reports for operational monitoring and optimization.
• Collaborate with software development teams to ensure that database solutions align with application architecture and system requirements.

Skills and Qualifications:

• 6+ years of hands-on experience working with RDBMS such as Oracle.
• Proficient in writing and optimizing SQL queries, stored procedures, triggers, and functions in Oracle.
• Strong experience in database design, including normalization, indexing, and partitioning for performance optimization.
• Experience with Oracle PL/SQL and database tuning to improve query performance.
• Familiarity with database replication, data migrations, and backup and recovery strategies.
• Understanding of data security protocols and compliance standards (e.g., GDPR, HIPAA).
• Ability to troubleshoot complex database issues related to performance, integrity, and security.
• Strong analytical and problem-solving skills, with the ability to handle complex data challenges.
• Excellent communication skills and the ability to work well with both technical and non-technical teams.
• Familiarity with database administration concepts and monitoring tools.