Software Engineer

Computer Enterprises Inc
Strongsville, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Strongsville, United States of America

Tech stack

Microsoft Windows
Apache HTTP Server
Tomcat
Unix
Cron
Software Debugging
IIS
Python
MongoDB
Connect-Direct (Internet Protocols Based Network Software)
Openshift
Oracle Applications
Performance Tuning
Standard Sql
Shell Script
PL-SQL
SQL Databases
Unix Commands
Informatica Powercenter
Oracle Service Cloud
Toad (Software)
Dynatrace
ServiceNow

Job description

Continuously monitor production systems and applications for performance issues or errors, and promptly troubleshoot and resolve identified problems. This role involves tuning PL/SQL and queries, scheduling and supporting automated workflows, and performing Go-Live production activities to ensure smooth and seamless deployments., * Continuously monitor production systems and applications for performance issues or errors, and promptly troubleshoot and resolve identified problems.

  • Tuning PL/SQL Blocks & queries using hints and utilities such as DBMS_PROFILER, Explain Plan.
  • Familiar with UNIX functions and writing Shell Scripts, Scheduling jobs using Cron tabs and CA7 scheduler.
  • 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).
  • 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.
  • Analyze application and server logs to identify issues in various environments and resolve it.
  • 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.
  • 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.
  • Create Incidents, Change Requests, release documentation, support procedures to ensure smooth transitions with minimal downtime.
  • Respond to and manage incidents and outages, ensuring minimal disruption to services, user impact and assist in on-call duties

Requirements

  • Oracle
  • PL/SQL
  • SQL
  • MongoDB
  • Unix commands
  • Shell scripting
  • Informatica
  • Connect Direct (NDM)
  • Toad
  • OpenShift Platform

Preferred Skills

  • Axiom controller view (Regulatory Reporting)
  • Python
  • Oracle Analytics (OAS) Reports
  • ServiceNow, Big Panda, Dynatrace
  • Tomcat application servers, Apache and Windows IIS servers

Apply for this position