Mindlance · 2 months ago
IT Software Development Advisor
Memphis, TN
Full-time
Hybrid
Senior Level, Lead/Staff
10+ years expMindlance is a company seeking an IT Software Development Advisor. The role involves designing and maintaining software architecture for CMS systems, overseeing programming and implementation, and ensuring software scalability and data integrity across applications.
Human Resources
Responsibilities
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
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
Bachelor's degree with major in Information Systems or Management from an accredited college or university preferred
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
Company
Mindlance
Mindlance is a Staffing and Recruiting company which provides multi-vertical staffing services
1001-5000 employees
H1B Sponsorship
Mindlance 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 (71)
2024 (53)
2023 (37)
2022 (72)
2021 (36)
2020 (40)
Funding
Current Stage
Late StageLeadership Team
R
Rajat Paul Dhall
Co-Founder & Managing Director
V
Vik Kalra
Co-Founder and Managing Director
Recent News
2025-11-19
Kelly Services, Inc.
2025-05-17
2025-04-14
Company data provided by crunchbase