ICONMA ยท 1 month ago
IT Software Development Advisor
United States
Full-time
Remote
Senior Level, Lead/Staff
$58.57/hr - $61.29/hr
8+ years expICONMA is a Business Solutions company seeking an IT Software Development Advisor for their remote location. The role involves designing and maintaining software architecture, ensuring data integrity, and collaborating with management to implement strategic technology initiatives.
Staffing & Recruiting
Responsibilities
To design and maintain robust, scalable software architecture for one or more elements of CMS software systems; to oversee programming, implementation and maintenance revisions of specified projects; and to evaluate technologies and provide consultation regarding applications and systems needs related to these elements
Ensures software scalability and data integrity throughout all claims-related applications
Ensures software compatibility and alignment with overall business, IT and infrastructure strategies
Identifies and directs implementation of strategies for maintaining JURIS data and application integration
Collaborates with management and colleagues throughout CMS and develops overall designs and defines projects for implementation of strategic technology initiatives
Consults with project managers to keep informed of active and future projects and to identify areas of overlap
Assists as needed in implementation of large client programs involving numerous interfaces or system modifications
Manages analyst/programmers as needed
Reviews software change requests to identify duplication, similarities, and feasibility and recommends specific actions needed
Provides recommendations toward prioritization of tactical and strategic change requests
Assists in projecting software and hardware requirements for claims-related applications
Performs other duties as assigned
Supports the organization's quality program(s)
Administers company personnel policies in all areas and follows company staffing standards and training recommendations
Interviews, hires and establishes colleague performance development plans; conducts colleague performance discussions
Provides support, guidance, leadership and motivation to promote maximum performance
Qualification
Required
Bachelor's degree with major in Information Systems or Management from an accredited college or university preferred
High School Graduate/GED
Experience in writing Packages for data loads
Experience creating and maintained Stored Procedure (Packages, Procedures, Function, and anonymous block) with Oracle PL/SQL
Experience using Cursors to pull data from the Database
Experience with performance tuning, query optimization, explain plan etc
Experience with external tables, and high volume data import into Oracle DB
At least 8+ years of experience as an Oracle PL/SQL Developer
Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ
Hands on experience on XML generation inside PL/SQL components
Strong Skills in data analysis, data modeling, development, testing and documentation
Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus
Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues
Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application
Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements
Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes
Good understanding of Oracle Explain Plan
Experience Ten (10) years of related experience or equivalent combination of education or experience required to include seven (7) years of software and development experience
Strong oral and written communication, including technical writing skills and presentation skills
PC literate, including Microsoft Office products
Leadership/management/motivational skills
Analytical and interpretive skills
Strong organizational skills
Excellent interpersonal skills
Excellent negotiation skills
Ability to work in a team environment
Ability to meet or exceed Performance Competencies
Preferred
Masters degree strongly preferred
Five (5) years hands-on programming experience in database and data driven applications strongly preferred
High level knowledge of software development areas including software development life cycle methodologies, specification development, security, application modularization and logic specifications
Benefits
Health Benefits
Referral Program
Company
ICONMA
ICONMA: Your Partner in Global Staffing Solutions and Digital Transformation ICONMA is a globally recognized, Woman-Owned staff augmentation and technology consulting firm.
1001-5000 employees
H1B Sponsorship
ICONMA has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (34)
2024 (31)
2023 (26)
2022 (39)
2021 (37)
2020 (69)
Funding
Current Stage
Late StageLeadership Team
Claudine George
Founder and CEO of ICONMA, LLC
Company data provided by crunchbase