Application Data Architect: Solution Architect

TITLE OF POSITION

Application Data Architect: Solution Architect

AGENCY NAME

The California Public Employees' Retirement System (CalPERS)

PERIOD OF PERFORMANCE

1 Year (7/1/2025, or upon Purchase Order execution, whichever date is later, through 6/30/2026)

REFERENCES

Three

INTERVIEW

Virtual or Client location (As client's Discretion)

PLACE OF PERFORMANCE

Hybrid (Consultant will be required to report to the CalPERS Headquarters three days per week)

SCOPE OF WORK

The consultant will work with the Application Engineering and Architecture and myCalPERS team and undertake duties and responsibilities as an Application Data Architect on critical system

change efforts and provide ongoing support for the delivery of robust and reliable solutions. The consultant will design and implement scalable database migrations strategy within the organization to solve complex business solutions.

The consultant will serve as a subject matter expert in data management; research, analyze, recommend, and select technical approaches for solving exciting, complex development and integration problems. The consultant will help monitor database efficiency, ensure high availability, and maintains database performance by troubleshooting problems, fine tune the database environments. The consultant will also assist to implement and maintain cloud database environments, troubleshoot, and resolve database performance issues.

*Mandatory Experience

Please see attachment A- Evaluation Criteria- Separately attached (Candidate needs to fill out the form)

Role and Responsibilities

Deliverable 1: Analysis and Design

Determine impact of database migration to existing applications.

Propose one or more design options as appropriate to each situation, including a level- of-effort estimate and target delivery date.

Document the design option selected by CalPERS.

Deliverable 2: Implementation, Testing and Support

Develop approved database changes within the existing technical environments, using the

approved promotion path and QA/testing methodology.

Performing internal unit/QA testing and facilitate user acceptance testing.

Support best practices in use of database efficiency and performance.

Update and enhance system documentation to keep it synchronized with system and

environment changes.

Deliverable 3: Knowledge Transfer

Contractor will provide knowledge transfer of reporting efforts, escalated system issues, and

database changes and enhancements.

Knowledge transfer to occur via collaborative documentation, code commenting, cross training, and job shadowing.

Knowledge transfer to take place at CalPERS via regular scheduled meetings and review of

documentation.

Documentation to include best practices and lessons learned during the project.

On an ongoing basis through the end of the contract all work products and deliverables (project status reports, business process, triage incident reports with resolution, meeting minutes, test cases, test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to the state personnel.

Minimum Qualifications

1. Must have a minimum of fifteen (15) years of experience in electronic data processing systems study, design, and programming; at least ten (10) years of

said experience shall have included responsibility on a project basis for analyzing operational methods and developing computer programs to meet desired results.

2. Must have minimum of fifteen (15) years of experience working as an application architect, in providing solutions that aligns with enterprise architecture and aligns with business process in use.

3. Must have a minimum of twelve (12) years of experience working with public pension systems or experience with Governmental Retirement Benefits and processes like CalPERS.

4. Must have a minimum of fifteen (15) years of experience with Oracle 11g, Oracle 19c, PL/SQL, SQL

5. Must have minimum of fifteen (15) years providing technical expertise and hands-on support in consolidation and migration of databases to new platforms.

6. Must have a minimum of five (5) years of experience with Version Control using Git and web-based repositories (GitHub, GitLab, B itbucket, etc.) and ticketing and collaboration tools like JIRA and

Confluence.

7. Must have a minimum of fifteen (15) years of experience with monitor database efficiency, ensure high availability, and maintain database performance by troubleshooting problems, fine tune the database environments.

8. Experience implement and maintain cloud database environments (AWS and/or Azure), troubleshoot, and resolve database performance issues.