Role Summary
We are hiring engineers with 23 years of experience who can operate and troubleshoot mission critical banking/automation applications while thinking with a developer's mindsetespecially for Java based systems. The role requires strong MSSQL skills, solid application testing, Familiarity with workflow-based applications, and logical problem-solving to accelerate RCA.
Key Responsibilities
1. Database (MSSQL)
- Install, configure, and administer Microsoft SQL Server (20162019).
- Write, optimize, and troubleshoot SQL queries, views, stored procedures, and functions.
- Analyze execution plans, eliminate blocking/deadlocks, and tune indexing strategies.
- Support & maintain HA/DR (Failover Cluster Instances, Always On Availability Groups).
- Apply backup/restore strategies and environment migrations (DEV / Test / Prod).
2. Application & Middleware
- Provide operational and technical support for Javabased and .NETbased applications.
- Reading and analyzing different applications logs, troubleshoot exceptions, and communicate technical findings effectively to developers.
- Work with middleware such as IBM WebSphere ND for Java application clusters.
- Support reporting components (e.g., SAP BO).
- Participate in releases, hotfix rollouts, and controlled changes in production environments.
3. Testing & Quality
- Design and execute functional, integration, and regression test cases.
- Prepare test data and validate results against system rules and workflows.
- Document defects with clear steps, logs, screenshots, and environment details.
- Validate hotfixes, patches, new releases, and infrastructure changes.
4. Systems & Infrastructure
- Administer hybrid environments involving:
- VMware ESXi & vCenter
- Windows Server (20162019)
- Linux servers is a plus.
- Manage Active Directory objects, group policies, FTP/SFTP, IIS, roles/features is a plus
- Work closely with network and automation teams during integration or deployment tasks.
- Support secure remote access systems and hardware infrastructure used in cash centers.
5. Incident Handling & RCA
- Perform structured analysis of:
- Logs
- SQL traces
- Application thread behaviors
- Connection pools and latency issues
- Produce developer friendly RCAs with facts, metrics, and reproduction steps.
- Provide evidence during incident escalations (DB stats, query plans, environmental metrics).
6. Collaboration & Communication
- Work in coordination with local teams and global R&D teams to deploy fixes and align designs.
- Communicate technical issues clearly and professionally with stakeholders.
- Maintain documentation, runbooks, and operational procedures.
Required Qualifications
- Bachelor's degree in engineering, Computer Science, or related field.
- 23 years in systems, application support, or software engineering roles.
- Strong MSSQL skills: implementation, query writing, troubleshooting, and performance tuning.
- Ability to think logically and structurally when analyzing issues.
- Experience with application testing and test planning.
- Comfortable reading Java code snippets and understanding how Java interacts with MSSQL.
- Familiarity with Git or similar version control workflows.
Highly Preferred
- Handson Java development background (Core Java, Spring basics).
- Understanding of:
- REST APIs
- Transactions
- Threading basics
- Connection pooling
- Experience in supporting enterprise applications deployed on WebSphere ND or similar application servers.
Nice to Have
- Scripting (PowerShell, Bash, Python).
- Experience with:
- Windows Failover Clustering
- .NET applications
- NFS, FTP/SFTP, Active Directory, HW firewall concept, material handling systems.
- Familiarity with backup solutions, and backup/restoration plans.
- Exposure security assessments and hardening.
Key Competencies
- Strong teamwork abilities and effective communication skills
- Strong analytical and logical reasoning.
- Excellent troubleshooting methodology.
- Clear written and verbal communication.
- Ownership, accountability, and attention to detail.
- Ability to work under pressure in a critical environment.
KPIs (First Year)
- Reduction in incident resolution time through accurate analysis.
- Quality and accuracy of RCAs sent to development teams.
- Successful completion of test cases during releases.
- Reduction of repeated incidents due to improved documentation and testing.
- Stability of MSSQL environments (performance & availability targets).
