Software Engineer 2

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.

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

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.

Key Responsibilities

• 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.