Production Support Engineer

Looking for Database and Unix Production support Engineer As a Production Support Engineer, the candidate will be responsible for ensuring the stability, reliability, and efficiency of production systems and applications. The candidate will work closely with development and operations teams to troubleshoot issues, deploy fixes, and implement enhancements to our production environment. This role must be filled at the client site 5 days per week in Pittsburgh PA. For this role on this particular client engagement, employer sponsorship of immigration‑related visa and/or green card status as part of the PERM process will not be available Job Duties & Responsibilities: Continuously monitor production systems and applications for performance issues or errors and promptly troubleshoot and resolve identified problems. Resolving production issues by analyzing root causes, assessing tickets, and collaborating with cross functional teams, ensuring SLA adherence as per Organization standards. Work with Business users and Application Production Support team to handle the application issues and user requests. Create Incidents, Change Requests, release documentation to ensure smooth transitions with minimal downtime. Create documentation for support procedures, system configurations, and incident resolutions. Scheduling the mainframe CA7 jobs and monitoring them during support hours. Perform configuration checks, input file validations, and troubleshooting on Linux servers in the application to ensure seamless operations. Analysis, design and development modules with Oracle, PL/SQL, Informatica and SQL. Tuning PL/SQL Blocks & queries using hints and utilities such as DBMS_PROFILER, Explain Plan. Familiar with UNIX functions and writing Shell Scripts and Scheduling jobs using Cron tabs. Respond to and manage incidents and outages, ensuring minimal disruption to services and user impact. Effectively communicate with stakeholders, including users, developers, and other team members, to ensure clear information flow and effective issue resolution. Environment: Database: Oracle, MySQL Programming & Scripting: Java, Python, SQL, PL/SQL, Linux Shell Scripting, Unix commands ETL & Data Integration: ETL knowledge is added advantage Platform: Linux, Windows Servers: Tomcat application server, Apache, Windows application servers, Windows IIS server #DICE #LI-SG2 Other Information: CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $46,900.00 $95,700.00. CGI's benefits are offered to eligible professionals on their first day of employment to include: . Competitive compensation . Comprehensive insurance options . Matching contributions through the 401(k) plan and the share purchase plan . Paid time off for vacation, holidays, and sick time . Paid parental leave .Learning opportunities and tuition assistance . Wellness and Well being programs