Software Engr II

We are seeking a highly skilled Oracle SQL Database Developer / PL/SQL Expert to join our engineering team. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining backend database solutions that support mission-critical business applications. This role requires strong expertise in Oracle Database, SQL, and PL/SQL programming, along with experience integrating enterprise systems through Web Services and APIs using C#/.NET technologies. The successful candidate will work closely with application developers, business analysts, and cross-functional teams to deliver scalable, reliable, and high-performance solutions while adhering to engineering best practices. • Design, develop, maintain, and optimize Oracle database objects including: • Stored Procedures • Packages • Functions • Triggers • Views • Materialized Views • Analyze business requirements and translate them into efficient database solutions. • Develop and troubleshoot complex SQL and PL/SQL code for enterprise applications. • Perform database performance tuning, query optimization, and indexing strategies. • Support data migration, data integration, and ETL-related activities. • Develop and maintain interfaces between backend systems using REST/SOAP web services and APIs. • Collaborate with .NET developers to integrate database components with enterprise applications. • Participate in system design reviews and provide recommendations for database architecture improvements. • Develop unit tests and support integration testing activities. • Contribute to CI/CD initiatives and deployment automation processes. • Provide production support, root cause analysis, and timely resolution of issues. • Create technical documentation and maintain coding standards and best practices. • Work effectively within Agile/Scrum development teams. Required Qualifications: • Bachelor's Degree in Computer Science, Information Technology, Engineering, MCA, or related discipline. • 5+ years of experience in software development with a strong focus on Oracle databases. • Expert-level knowledge of: • Oracle Database • SQL • PL/SQL • Hands-on experience in developing: • Stored Procedures • Packages • Functions • Triggers • Complex SQL Queries • Strong understanding of database design, normalization, and data modelling concepts. • Experience in SQL performance tuning and query optimization. • Proficiency in troubleshooting database-related issues in production environments. • Working knowledge of Web Services, REST APIs, SOAP services, and system-to-system integrations. • Experience with C# and .NET technologies for backend integration. • Understanding of software engineering principles, coding standards, and version control systems. • Experience working in Agile development environments. • Strong analytical and problem-solving skills. • Excellent verbal and written communication skills. Preferred Qualifications: • Experience with Unix/Linux environments. • Knowledge of Shell Scripting (Bash/Korn Shell). • Experience with Oracle performance monitoring and database administration concepts. • Familiarity with CI/CD pipelines and DevOps practices. • Exposure to Microsoft Azure services and cloud-native concepts. • Experience with source control tools such as Git, SVN, or Azure DevOps. • Understanding of message-based integrations and enterprise application architecture. • Exposure to Angular, JavaScript, or other front-end technologies is a plus. Technical Skills Matrix Primary Skills (Must Have) • Oracle Database • SQL • PL/SQL • Query Optimization • Performance Tuning • Stored Procedures • Packages • Functions • Triggers • Data Modelling Secondary Skills (Good to Have) • C# • .NET Framework / .NET Core • REST APIs • SOAP Web Services • System Integrations Additional Preferred Skills • Unix/Linux • Shell Scripting • Azure • Git/SVN • CI/CD • Agile/Scrum