Cold Fusion DeveloperLocation: Seattle, WA / St. Louis, MO / Plano, TX / Dallas, TX / Houston, TXFTE OnlyJob DescriptionMust Have Technical/Functional SkillsDesign and develop Oracle PL/SQL scriptsUnix 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 issuesSolid skills with writing/translating SQL queries and SQL data validation.Performance tuning of SQL queries.Analyzing and resolving issues with Autosys jobs and processesJobs failures troubleshoot in AutoSys, failure can be Linux scripting, Oracle schedulers.Roles & ResponsibilitiesOptimizing 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 operationsInteract 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 RequestsResolving 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.