Database Production Support - Dexian : Job Details

Job Title: Production Support Specialist - ETL / SnowflakeLocation: Jersey City, NJ [OR] Coppell, TX [OR] Tampa, FL ( Choose Any 1 )Hybrid: 3 days Onsite & 2 days REMOTEDuration: 6 Months (CONTRACT TO HIRE)Shifts: Maybe required to work Tuesday through Saturday [OR] Sunday through Thursday on rotational or permanent basis. Skills & Experience Needed: Minimum of 5 years of relevant Production support experience. Distributed/Cloud:

• Hands on experience in Unix, Linux, Windows, SQL/PLSQL
• Familiarity working with relational databases (DB2, Oracle, Snowflake)
• Monitoring and Data Tools experience (Splunk, DynaTrace, Thousand Eyes, Grafana, Selenium, HiPam IBM Zolda)
• Cloud Technologies (AWS services (S3,EC2,Lambda,SQS,IAM roles), Azure, OpenShift, RDS Aurora, Postgress)
• Scheduling Tool experience (CA AutoSys, Control-M)
• Middleware experience (Solace, Tomcat, Liberty Server, WebSphere, WebLogic, JBoss)
• Messaging Queue Systems (IBM MQ, Oracle AQ, ActiveMQ, RabbitMQ, Kafka)
• Scripting languages (Bash, Python, Ruby, Shell, Perl, JavaScript)
• Hands on experience with ETL tools (Informatica Datahub/IDQ, Talend)

Responsibilities:

• Experience with using ITIL Change, Incident and Problem management processes.
• Resolve critical production issues by leading Major Incident calls, engaging proper teams, and driving root cause analysis.
• Troubleshoot and debug system component(s) to resolve technical issues in complex and highly regulated environments comprised of ground and cloud applications and services.
• Analyze proposed application design(s) and provide feedback on potential gaps or provide recommendations for optimization.
• Hands-on experience with Monitoring and Alerting processes in Distributed ,Cloud and Mainframe environments.
• Knowledge and understanding of cyber security best practices and general security concepts like password rotation, access restriction and malware detection.
• Contribute in Monthly Service Reviews (MSR) with Development partners to go over KPI metrics.
• Participate in Disaster Recovery / Loss of Region events (planned and unplanned) executing tasks and collecting evidence.
• Collaborate both within the team and across teams to resolve application issues and escalate as needed.
• Support audit requests in a timely fashion providing needed documentation and evidence.
• Plan and execute certificate creation/renewals as needed.
• Create, Modify and Monitor Dashboards to better catch potential issues and aide in observability.
• Strong ability to gather and analyze project requirements and translate them into technical specification(s).
• Deep understanding of all lifecycle components (code, test, deploy).
• On-call support with flexible work arrangement

Mainframe: (Nice to Have)

• Mainframe troubleshooting and support skills (COBOL, JCL, DB2, DB2 Stored Procedures, CICS, SPUFI, File aid)
• Mainframe scheduling (Job abends, Predecessor/Successor)

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals. Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit to learn more. Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.