Database Production Support

Dexian - Coppell, TX

Full-time - Mid Level

Coppell, TX

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 ETL processes and cloud technologies. The position requires a strong background in troubleshooting, incident management, and collaboration across teams to resolve application issues. The role is hybrid, allowing for a mix of onsite and remote work, and involves working with various technologies and tools to ensure system reliability and performance.

Responsibilities

• Resolve critical production issues by leading Major Incident calls, engaging proper teams, and driving root cause analysis.
• Troubleshoot and debug system components to resolve technical issues in complex environments.
• Analyze proposed application designs and provide feedback on potential gaps or recommendations for optimization.
• Hands-on experience with Monitoring and Alerting processes in Distributed, Cloud, and Mainframe environments.
• Knowledge of cyber security best practices and general security concepts.
• Contribute to Monthly Service Reviews (MSR) with Development partners to review KPI metrics.
• Participate in Disaster Recovery events, executing tasks and collecting evidence.
• Collaborate 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 catch potential issues and aid in observability.
• Gather and analyze project requirements and translate them into technical specifications.
• Provide on-call support with flexible work arrangements.

Requirements

• Minimum of 5 years of relevant Production support experience.
• Hands-on experience in Unix, Linux, Windows, SQL/PLSQL.
• Familiarity with relational databases (DB2, Oracle, Snowflake).
• Experience with Monitoring and Data Tools (Splunk, DynaTrace, Thousand Eyes, Grafana, Selenium, HiPam IBM Zolda).
• Knowledge of Cloud Technologies (AWS services, Azure, OpenShift, RDS Aurora, Postgress).
• Experience with Scheduling Tools (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, CICS).
• Mainframe scheduling experience (Job abends, Predecessor/Successor).

Benefits

• Hybrid work environment (3 days onsite, 2 days remote).
• Opportunity for contract to hire after 6 months.