Job Description

We are seeking a highly skilled and experienced Senior Technical Consultant to design, develop, troubleshoot, and support enterprise-grade backend systems and database solutions. The ideal candidate will possess strong expertise in Oracle RDBMS, Java backend development, and Linux scripting, with a proven ability to work independently in fast-paced environments while collaborating effectively across technical teams.

Key Responsibilities

Database Design & Development

• 
  Design and implement robust Oracle RDBMS solution architecture, including database schema, indexing strategies, constraints, and performance optimization.
• 
  Develop and maintain Oracle database objects, including DML scripts, stored procedures, triggers, packages, and PL/SQL components.
• 
  Analyze, troubleshoot, and optimize database performance to ensure reliability, scalability, and efficiency.

Backend Application Development

• 
  Design and develop Java backend applications, including multi-threaded systems to support scalable and high-performance solutions.
• 
  Perform troubleshooting, debugging, and root cause analysis of Java applications, including JVM-related issues, exception handling, and performance tuning.
• 
  Develop and execute unit tests (JUnit) to ensure code quality, maintainability, and application stability.

System Automation & Scripting

• 
  Design, develop, and maintain Linux shell scripts for automation, monitoring, deployment, and operational support.

Technical Documentation & Configuration Management

• 
  Produce high-quality technical documentation, including solution designs, technical specifications, and implementation documents.
• 
  Manage and maintain technical source code repositories using GIT/SVN version control systems.

Collaboration & Stakeholder Support

• 
  Collaborate with technical teams, business stakeholders, and cross-functional teams to deliver scalable technical solutions.
• 
  Provide technical guidance, troubleshooting support, and recommendations for system improvements.
• 
  Work independently with minimal supervision while maintaining high-quality delivery under tight timelines.

Required Qualifications & Skills

• 
  Minimum 5 years of relevant experience in software development, backend engineering, or technical consulting.
• 
  Strong expertise in Oracle RDBMS database architecture, including schema design, indexes, and constraints.
• 
  Hands-on experience in Oracle PL/SQL development, including DML scripts, stored procedures, triggers, and scripting.
• 
  Strong experience in Linux shell scripting
• 
  Proven experience in Java backend development, including multi-threading concepts and enterprise application design.
• 
  Strong troubleshooting experience in Java applications, including JVM, exception handling, debugging, and JUnit testing
• 
  Experience writing technical documentation and system specifications
• 
  Proficiency in source control tools, such as GIT/SVN
• 
  Strong English communication skills with the ability to work effectively in a team environment.
• 
  Ability to work independently, handle pressure, and manage multiple priorities.

Preferred / Value-Added Skills

• 
  Experience in Java/Spring Web Services development, including SOAP and REST APIs
• 
  Experience with software quality scanning tools, such as SonarQube
• 
  Strong presentation skills with the ability to communicate and present technical solutions to stakeholders.

Preferred Profile

• 
  Self-motivated, detail-oriented, and highly analytical.
• 
  Strong problem-solving mindset with excellent troubleshooting capabilities.
• 
  Team player with the ability to collaborate across technical and business functions.