Apply on Employer Site

Covetus · 2 days ago

Coldfusion Developer

Dallas, TX

Full-time

Onsite

Mid Level

Covetus is seeking a Coldfusion Developer to design and develop Oracle PL/SQL scripts and manage data integration issues. The role involves optimizing database jobs, troubleshooting production issues, and collaborating with stakeholders to enhance data processing workflows.

ConsultingDigital MarketingMobile AppsSoftwareStaffing AgencyWeb DesignWeb Development

H1B Sponsor Likely

Hiring Manager

Nikhil Jaiswal

Responsibilities

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

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

Qualification

Oracle PL/SQLColdFusionSQL proficiencyUnix CommandAutosysData quality assuranceTroubleshootingPerformance tuning

Required