Technical Consultant - Public Safety Data Migration

Who We Are:

Oracle Public Safety has launched a new suite of SaaS applications and hardware for the public safety agencies to serve their communities using cutting edge technologies. These are exciting times in our space - we are growing fast and delivering innovative solutions to public safety agencies.

Who You Are:

The Public Safety Technical Consultant - Data Migration is a full-time, individual contributor on Oracle's Public Safety implementation team. This is a hands-on, SQL-focused technical position that partners with law enforcement and public safety agencies to extract, analyze, transform, validate, and migrate historical data into Oracle Public Safety software. Key responsibilities include investigating source-system data structures, identifying relationships and data-quality issues, and using SQL and related migration tools to build, test, and refine repeatable migration logic tailored to each agency's data. Other responsibilities include working directly with agency stakeholders to translate migration requirements and operational needs into reliable, repeatable technical solutions, and collaborating with implementation, product, and agency stakeholders to support successful go-lives. Candidates for this role should be excited about pushing the boundaries and adopting new technologies and tools to accomplish successful customer outcomes. This role requires the ability to adapt quickly, a drive for results, and a "never satisfied" mentality. You will be an early team member of this fast-growing and exciting line of business at Oracle.

Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.

True innovation starts when everyone is empowered to contribute. That's why we're committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling 1-888-404-2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

Disclaimer:

Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from: $97,500 to $209,500 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle''s differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:

1. Medical, dental, and vision insurance, including expert medical opinion

2. Short term disability and long term disability

3. Life insurance and AD&D

4. Supplemental life insurance (Employee/Spouse/Child)

5. Health care and dependent care Flexible Spending Accounts

6. Pre-tax commuter and parking benefits

7. 401(k) Savings and Investment Plan with company match

8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.

9. 11 paid holidays

10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.

11. Paid parental leave

12. Adoption assistance

13. Employee Stock Purchase Plan

14. Financial planning and group legal

15. Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.

Career Level - IC4

What you will do:

• Partner with public safety agencies, project teams, and technical stakeholders to define each data migration scope, requirements, priorities, and success criteria.
• Work directly with public safety agencies to understand legacy-system data, operational workflows, and migration requirements covering dispatch, records, and jail data.
• Use SQL and related migration tools to extract, analyze, transform, and validate historical data.
• Investigate source-system data structures, relationships, and data-quality issues, and document data mappings and transformation rules for each migration.
• Build, test, and maintain repeatable migration logic tailored to each agency's source data and mapping requirements.
• Investigate migration issues, data discrepancies, and validation feedback; refine migration logic and execute iterative migration cycles through agency validation and acceptance.
• Communicate progress, risks, issues, and dependencies to both internal and external project stakeholders throughout the migration lifecycle.
• Support migration planning and execution for production go-lives, including post-migration validation and issue resolution.
• Contribute to reusable migration practices, tools, and standards across Oracle Public Safety implementations.
• Collaborate with Product, Development, Support, and Implementation teams to resolve technical issues and help develop reusable migration tools and practices for future projects.

What you've done:

• Bachelor's degree in computer science, information technology, data management, or a related field, or equivalent work experience.

• 4+ years of hands-on experience with SQL, data analysis, data migration, database development, or related technical discipline.

• Proven ability to write and troubleshoot SQL queries for data extraction, transformation, validation, and reconciliation.

• Skill in analyzing source-system data structures, relationships, and data-quality issues.

• Excellent analytical and problem-solving skills, with exceptional attention to detail.

• Familiarity with relational databases, such as Oracle and SQL Server, and data formats, such as CSV, XML, and JSON.

• Effective communication skills and the ability to work directly with agency stakeholders to translate operational needs into technical solutions.

• Demonstrated ability to work independently while collaborating effectively with agencies, project teams, and technical stakeholders.

• Proactive relationship-building skills with internal and external stakeholders.

It would be awesome if you also had:

• Knowledge/familiarity with Oracle products and services, including Oracle Cloud Infrastructure (OCI).
• Experience working in a public safety position.
• Management experience including developing and leading a team.
• Experience with product development tools such as JIRA.
• Experience with AI development tools.

Note:

We are unable to provide visa sponsorship for this role at this time. No candidates requiring visa sponsorship will be considered. MUST be US Citizens to meet requirements of this role

This is a Criminal Justice Information Systems (CJIS) sensitive position and will require a fingerprint-based background investigation, conducted by customer criminal justice agencies, to determine an applicant's eligibility for access to criminal justice information. Employees hired for this position will be required to obtain and maintain CJIS access approval by Federal, state, and/or local agencies for Criminal Justice information, related law enforcement databases, and communications systems.

#LI-JC1

#LI-Remote

What you will do:

• Partner with public safety agencies, project teams, and technical stakeholders to define each data migration scope, requirements, priorities, and success criteria.
• Work directly with public safety agencies to understand legacy-system data, operational workflows, and migration requirements covering dispatch, records, and jail data.
• Use SQL and related migration tools to extract, analyze, transform, and validate historical data.
• Investigate source-system data structures, relationships, and data-quality issues, and document data mappings and transformation rules for each migration.
• Build, test, and maintain repeatable migration logic tailored to each agency's source data and mapping requirements.
• Investigate migration issues, data discrepancies, and validation feedback; refine migration logic and execute iterative migration cycles through agency validation and acceptance.
• Communicate progress, risks, issues, and dependencies to both internal and external project stakeholders throughout the migration lifecycle.
• Support migration planning and execution for production go-lives, including post-migration validation and issue resolution.
• Contribute to reusable migration practices, tools, and standards across Oracle Public Safety implementations.
• Collaborate with Product, Development, Support, and Implementation teams to resolve technical issues and help develop reusable migration tools and practices for future projects.

What you've done:

• Bachelor's degree in computer science, information technology, data management, or a related field, or equivalent work experience.

• 4+ years of hands-on experience with SQL, data analysis, data migration, database development, or related technical discipline.

• Proven ability to write and troubleshoot SQL queries for data extraction, transformation, validation, and reconciliation.

• Skill in analyzing source-system data structures, relationships, and data-quality issues.

• Excellent analytical and problem-solving skills, with exceptional attention to detail.

• Familiarity with relational databases, such as Oracle and SQL Server, and data formats, such as CSV, XML, and JSON.

• Effective communication skills and the ability to work directly with agency stakeholders to translate operational needs into technical solutions.

• Demonstrated ability to work independently while collaborating effectively with agencies, project teams, and technical stakeholders.

• Proactive relationship-building skills with internal and external stakeholders.

It would be awesome if you also had:

• Knowledge/familiarity with Oracle products and services, including Oracle Cloud Infrastructure (OCI).
• Experience working in a public safety position.
• Management experience including developing and leading a team.
• Experience with product development tools such as JIRA.
• Experience with AI development tools.

Note:

We are unable to provide visa sponsorship for this role at this time. No candidates requiring visa sponsorship will be considered. MUST be US Citizens to meet requirements of this role

This is a Criminal Justice Information Systems (CJIS) sensitive position and will require a fingerprint-based background investigation, conducted by customer criminal justice agencies, to determine an applicant's eligibility for access to criminal justice information. Employees hired for this position will be required to obtain and maintain CJIS access approval by Federal, state, and/or local agencies for Criminal Justice information, related law enforcement databases, and communications systems.

#LI-JC1

#LI-Remote