Production Support Engineer
LOCATIONS BY PREFERENCE: Strongsville, OH, 44136
WORK ARRANGEMENT: 5 days onsite
LENGTH OF ASSIGNMENT: 4 months Contract to Hire role
Pay Rate: $60-65/hr. on W2 ONLY
FUNCTION OF THE GROUP: Mitigating Risk
INDUSTRY BACKGROUND: Development/Engineer
ROLE/RESPONSIBILITIES:
1. Continuously monitor production systems and applications for performance issues or errors, and promptly troubleshoot and resolve identified problems.
2. Tuning PL/SQL Blocks & queries using hints and utilities such as DBMS_PROFILER, Explain Plan.
3. Familiar with UNIX functions and writing Shell Scripts, Scheduling jobs using Cron tabs and CA7 scheduler.
4. Analysis, design and development of modules and troubleshooting job failures involving Oracle, PL/SQL, Informatica, SQL and Python, Axiom controller view and Connect Direct (NDM).
5. Debug the data related issues and fix the defects raised by the Testing team and Business team in various regulatory reports and prepare the deployment plan.
6. Analyze application and server logs to identify issues in various environments and resolve it.
7. Collecting, analyzing CPU and memory utilization data from various sources (servers, applications, etc.) and recommend to adjust application settings, upgrade hardware, or optimize the code based on the analysis of collected data.
8. Perform Go-Live Production activity to have smooth and seamless deploy to production environment for various application objects including PL/SQL packages, unix scripts, Axiom controller view objects, Sql and Python.
9. Create Incidents, Change Requests, release documentation, support procedures to ensure smooth transitions with minimal downtime.
10. Respond to and manage incidents and outages, ensuring minimal disruption to services, user impact and assist in on-call duties.
MUST HAVE SKILLS REQUIRED (4+ Years of Experience Required):
1. Oracle, PL/SQL, SQL, MongoDB
2. Unix commands, Shell scripting
3. Informatica
4. Connect Direct (NDM)
5. Toad
6. OpenShift Platform
FLEX SKILLS:
1. Axiom controller view (Regulatory Reporting)
2. Python
3. Oracle Analytics (OAS) Reports
4. ServiceNow, Big Panda, Dynatrace
5. Tomcat application servers, Apache and Windows IIS servers
EDUCATION: Bachelors Degree Minimum
INTERVIEW PROCESS: (How many rounds and with what team members?) - 1st Round w/HM then 2nd round w/HM and team members.
SHORTLISITING STACK RANKING (MOST IMPORTANT TO LEAST IMPORTANT):
1. Skill Set 2. Location 3. Rate 4. Former Client Exp.