Job Type: Full Time

Job Category: IT

Job Description

Role: Cold Fusion Developer

Location: Seattle, WA / St. Louis, MO /Plano, TX / Dallas, TX / Houston, TX

FTE Only

Job Description

Must Have Technical/Functional Skills

• Design and develop Oracle PL/SQL scripts 
• Unix Command and develop & maintain shell scripts.
• Manage Cron jobs. Convert Cron jobs to Autosys.
• Code development conversant for supporting Applications using ColdFusion.
• Ensuring data quality, integrity, and consistency across different systems.
• SQL proficiency (intermediate skill level minimum)
• Troubleshooting and resolving data integration issues
• Solid skills with writing/translating SQL queries and SQL data validation.
• Performance tuning of SQL queries.
• Analyzing and resolving issues with Autosys jobs and processes
• Jobs failures troubleshoot in AutoSys, failure can be Linux scripting, Oracle schedulers.

Roles & Responsibilities

• Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
• Understand the existing ColdFusion code base and make any changes as per business requirements.
• Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations
• Interact with DBA for any Server related issues or DB tunings required to solve any performance issues.
• Engaged in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues.
• Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering to the code promotion process.
• Contributed to the development and maintenance of documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing Change Requests 
• Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction.
• Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows.

Required Skills