Senior Technical Consultant

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:

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

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

3. System Automation & Scripting

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

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

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

Requirements:

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

• 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