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.

Key Responsibilities

Design, develop, maintain, and optimize Oracle database objects including:

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

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

Competencies

• Strong ownership and accountability.
• Ability to work independently with minimal supervision.
• Customer-focused mindset.
• Effective collaboration across cross-functional teams.
• Strong analytical and troubleshooting capabilities.
• Continuous learning and improvement mindset.
• Results-oriented approach to software delivery.