Database Production Support

Dexian - Tampa, FL

Full-time - Mid Level

Tampa, FL

10,001+ employees

Administrative and Support Services

About the position

The Production Support Specialist - ETL / Snowflake role is focused on providing critical support for production systems, particularly in the context of ETL processes and cloud technologies. This position requires a strong background in production support, troubleshooting, and incident management, with a focus on ensuring system reliability and performance in a hybrid work environment.

Responsibilities

• 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.
• 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.

Requirements

• Minimum of 5 years of relevant Production support experience.
• 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).
• Experience with Cloud Technologies (AWS services, Azure, OpenShift, RDS Aurora, Postgress).
• Scheduling Tool experience (CA AutoSys, Control-M).
• Middleware experience (Solace, Tomcat, Liberty Server, WebSphere, WebLogic, JBoss).
• Experience with Messaging Queue Systems (IBM MQ, Oracle AQ, ActiveMQ, RabbitMQ, Kafka).
• Proficiency in Scripting languages (Bash, Python, Ruby, Shell, Perl, JavaScript).
• Hands-on experience with ETL tools (Informatica Datahub/IDQ, Talend).

Nice-to-haves

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

Benefits

• Contract to hire opportunity with potential for full-time employment.
• Hybrid work model with flexibility in work arrangements.