Providence, RI - IT - DHS - Central Management - N/A - Systems Analyst - Interm

Job#: 3047748

Job Description:

Apex Systems is a world class technology services business that incorporates industry or insights and experience to deliver solutions that fulfill our clients' digital visions.

Apex has an opportunity for a Systems Analyst, For applicants who are interested in this opportunity, send your updated resume to

Here are the details:

Position:Systems Analyst - Onsite

Location: Providence, Rhode Island

Project Duration: 1 Year with Potential for more

The Department of Human Services (DHS) is seeking an experienced Senior SQL Developer with deep expertise in Oracle database development, data analysis, and reporting solutions. This individual will work closely with business stakeholders, technical leads, and project teams to design, develop, support, and optimize complex database-driven applications and reporting initiatives. The ideal candidate will have strong analytical skills, extensive experience working with large datasets, and the ability to deliver scalable, high-quality solutions in a collaborative environment.

Key Responsibilities

• Design, develop, maintain, and support database-driven applications and reporting solutions.
• Develop complex SQL queries, PL/SQL procedures, packages, functions, triggers, and other database objects.
• Create and maintain database structures, including DDL and DML components.
• Analyze, troubleshoot, and resolve performance issues within Oracle databases and SQL code.
• Perform data modeling and support enterprise data architecture initiatives.
• Develop, validate, and maintain data extracts, transformations, and loading processes.
• Collaborate with business users, project teams, and technical stakeholders to gather requirements and deliver solutions.
• Ensure data quality, validation, referential integrity, and compliance with established standards.
• Document system architecture, workflows, and technical designs using UML and other methodologies.
• Support Agile development practices and participate in continuous improvement initiatives.
• Utilize version control, deployment, and workflow management tools to support development lifecycle activities.

Required Qualifications

Education & Experience

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, or a related technical field.
• 8 to 10+ years of professional experience in database development and data management environments.

Database Development & SQL Expertise

• 8 to 10 years of hands-on experience working with Oracle databases.
• Advanced expertise writing complex SQL queries and developing PL/SQL objects, including:
  • Stored Procedures
  • Functions
  • Packages
  • Triggers
  • DML and DDL operations
• Expert-level experience querying, manipulating, and optimizing very large datasets.
• Strong database performance tuning and query optimization experience.
• Thorough understanding of Database Management Systems (DBMS).

Data & Reporting

• Experience with data modeling concepts and techniques.
• Experience supporting reporting and analytics initiatives.
• Working knowledge of ETL processes and methodologies.
• Strong data validation, quality assurance, and data integrity skills.

Development Tools & Methodologies

• Experience using source code repositories, preferably Git.
• Experience with Continuous Integration tools such as Jenkins.
• Knowledge of relational database design principles and ISDM methodologies.
• Experience with database security concepts, including role-based security.
• Proficiency with Oracle development tools such as:
  • TOAD
  • SQL Developer
  • SQL Navigator

Technical & Analytical Skills

• Experience using UML to document system architecture and technical solutions.
• Strong troubleshooting and debugging skills, particularly involving complex SQL and PL/SQL code.
• Ability to identify, analyze, and solve complex technical problems.
• Excellent written and verbal communication skills.
• Strong collaboration and stakeholder management capabilities.

Agile & Software Development Practices

• Familiarity with Agile development methodologies, including:
  • Scrum
  • Kanban
  • Extreme Programming (XP)

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Everforth Apex uses a virtual recruiter as part of the application process. Click for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at

Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at or . Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered.

UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.