Coldfusion/Oracle Consultant - Remote

*** Webcam interview; long term project; initial PO for 3 years with multiyear extensions ***Remote

*** Need 3 verfiable references ***

Job Description:

Minimum Job-Specific Skills/Qualifications Required (in order of relative importance)

Candidates must have a minimum of ten (10) years of hands-on experience in software design, development, and architecture, demonstrating mastery of all required software platforms. Equivalent years of directly related professional experience or advanced academic credentials may be substituted on a year-for-year basis.

A. Demonstrated Experience In:

• Full SDLC: Requirements analysis, system design, coding, testing, deployment, post-production support, conversion, data reconciliation, user training, and documentation.
• Enterprise application architecture: Design and develop multi-tier, distributed, web-based systems with high availability and scalability.
• Lucee/ColdFusion & application servers: Architect, install, configure, maintain, and upgrade Lucee/ColdFusion, WebLogic, Apache, and Tomcat for optimal performance and reliability.
• Perl programming language: Developing, maintaining and supporting solutions using the Perl programming language. Troubleshoot production issues and optimize existing Perl codebases for performance, reliability, and maintainability. Integrate Perl solutions with databases and external/third-party systems (e.g., APIs, batch processes, data feeds).
• Databases and data engineering: Design and optimize Oracle 19c databases; write efficient ANSI SQL and PL/SQL, design data structures, views, and stored procedures, and perform performance tuning.
• Cloud and modernization: Design, deploy, and optimize Microsoft Azure architectures (IaaS, PaaS, serverless); create modernization roadmaps, refactor, containerize, and adopt cloud-native patterns.
• Security and compliance: Engineer secure payment gateway integrations with encryption, tokenization, and PCI DSS controls; implement identity solutions with Azure Active Directory.
• Networking and infrastructure: Apply TCP/IP, VLANs, VPNs, and software-defined networking to build secure, high-performance cloud networks.
• Deployment, migration, and CI/CD: Execute deployment and data migration plans to minimize downtime; implement CI/CD pipelines using Azure DevOps and GitHub Actions to automate builds, tests, and releases.
• Open-source toolchains and developer workflows: Leverage IDEs, build systems, libraries, frameworks, and version control practices to streamline development and code review processes.
• UX/UI and reporting: Design web UX/UI and produce Power BI dashboards, reports, and data visualizations with Crystal Reports, Bi-Query, SQL Developer, and Power BI. Translate business requirements into technical solutions, including data models, reporting logic, and visualization design. Perform data validation, troubleshooting, and performance tuning to ensure accuracy, reliability, and timeliness of reports. Collaborate with stakeholders to refine reporting requirements and deliver actionable insights aligned with business needs.
• Design patterns and testing: Apply object-oriented design, architectural patterns, and produce system test plans and scripts.
• Operational automation: Administer and automate Linux environments with shell scripting and configuration management for reliable operations.
• Delivery track record: Consistent on-time, on-budget product delivery with high user satisfaction and quality.

B. Analytical Experience

• Requirements translation: Convert business, information, and technical needs into functional and technical specifications and architectural diagrams.
• Solution evaluation: Identify, compare, and recommend alternative technical solutions with cost/benefit analysis.
• Complex problem solving: Break down complex ideas into actionable components and produce solution designs for web and cloud processes.
• Documentation: Produce and maintain comprehensive technical specifications and design artifacts. Ability to produce clear technical documentation and collaborate with cross-functional teams (developers, analysts, stakeholders).

C. Development Tools

• Version control: Git, GitHub, SVN; cloning, branching, merging, conflict resolution, pull requests, and code review best practices.
• IDE and editors: Visual Studio, Visual Studio Code, Notepad++, Sublime Text, GitHub Desktop.
• Platforms and testing: Linux, Windows, Postman, Fiddler.
• Automation and CI/CD: Azure DevOps, GitHub Actions; shell scripting and configuration management tools for environment automation. Experience working in Linux/Unix and using command-line tools/scripting in operational contexts.

D. General Skills

• Communication: Excellent written and verbal communication for technical and non-technical audiences.
• Interpersonal: Proven ability to establish and maintain effective working relationships.
• Methodologies: Experience with traditional and agile project management practices.
• Office proficiency: Word, Excel, PowerPoint, Forms, and Visio.

Additional Skills/Qualifications Desired

• Databases: Proficient with relational and cloud-native databases including MS SQL Server; MySQL; MariaDB; PostgreSQL; AWS RDS; Azure SQL Database; Azure Cosmos DB and Oracle Database Cloud Service (DBCS). Experience with relational databases SQL concepts as used by applications/scripts.
• Cloud and DevOps: Experienced designing and developing applications in AWS and Azure; deploying, migrating, and managing systems in government cloud environments; familiarity with monitoring, logging, alerts, metrics, and DevOps practices.
• Web application development: Architect and develop web applications using Java (Spring/Hibernate); modern JavaScript (ES6+); HTML5/CSS3; XML/XSD; JSON; RESTful APIs.
• API and integration: API design experience including versioning and public APIs; experienced with third party integrations, identity management for authentication/authorization, message exchanges, and service-oriented messaging.
• Application security: Knowledge of systems security and data encryption; experience identifying security issues such as out of date libraries, insecure calls, and common exploits; Application Security using Azure Active Directory.
• Secure remote access and scheduling: Design secure remote-access architectures and optimize scheduling processes for efficiency.
• Requirement-to-code delivery: Ability to take functional requirements and convert them into program design and production code.
• Testing and quality assurance: Experience with open-source or automated testing tools; developing system test plans and test scripts; usability testing to identify problems and validate interaction design.
• Operational analytics and reporting: Enhance data models and reporting capabilities to deliver richer operational insights (for example, Daily Activity Log improvements). Experience supporting Power BI platform infrastructure, including Gateway configuration, dataset refresh, and secure data integration. Strong background in end-to-end BI solution delivery, including data ingestion, transformation, modeling, and dashboard/report development using Power BI. Experience managing enterprise reporting environments, ensuring performance, scalability, and reliability of Power BI solutions.
• Accessibility and digital government: Proven track record developing web accessibility compliance protocols and procedures for large organizations; knowledge of digital government strategies.
• Solution design and analysis: Proven experience analyzing and developing solution designs for web and cloud-based processes and systems.