Lead PLSQL Developer

Must Have Skills:

Minimum 6+ years of experience in support and operation process with below skills-

• DB PL/SQL: Oracle, MySQL (performance tuning of SQL queries)
• Cloud Technology: Oracle cloud/Azure, Kubernetes, Docker, Jenkin CI/CD etc.
• Servers: Linux (must)-Understanding and through knowledge of Linux server environment (bash) 
• Script: Bash/Python 
• Application Server: Apache Tomcat 
• Production Support: Troubleshoot application problems, analyze logs and provide details
• API test tools: Postman, Swagger 

Good to Have:

• Report: PowerBI /Jasper/Crystal 
• Performance Test: JMeter/LoadRunner
• Communication: Should have good analytical and communication skills. Create any necessary
• Documentation: Create necessary documentation as part of the support activity, RCA and process. 
• Good knowledge of system security, update OS process, analyze vulnerability, apply patches

Job Roles / Responsibilities: 

• Support running production application, validate data, validate data replication between multiple databases and data processing with client.
• Analyze application logs to validate if application is running as expected.
• Support QA Platform: validate deployment package provided by dev team, deploy application to QA platform, validate application is running as expected in QA environment.
• Identified potential issues in QA and report to dev team.
• Develop required script which will help in day-to-day support activity LSQL - Procedures/Functions, bash/python scripts and Windows bat scripts.
• Deploy application to staging and production environment. Validate deployment, test application, debug application.
• Coordinate support activity across support team and getting job done.