Job Information
Oracle Public Safety Technical Consultant in Pierre, South Dakota
Job Description
The Public Safety Technical Consultant is a key member of the Oracle Public Safety implementation team responsible for assisting customers in migrating historical data, facilitating data integrations, and enabling GIS functionality in the Oracle public safety solution. Part of this results-oriented role will include planning, executing, and validating data migration, integration and GIS processes, ensuring data integrity, accuracy, and consistency throughout the transition. Candidates for this role should be excited about pushing the boundaries of traditional data migrations and adopting new technologies and tools to accomplish successful customer outcomes. This role requires the ability to adapt to change 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.
Career Level - IC4
Responsibilities
What you will do:
Collaborate with stakeholders, project managers, and technical teams to define data migration requirements, objectives, and scope for each project.
Develop detailed data migration strategies, including timelines, resources, and risk assessments for assigned project.
Identify data sources, target systems, and determine the appropriate migration approach (ETL, direct transfer, etc.).
Work with customers to analyze and understand the structure and format of source data to ensure accurate mapping to the target system.
Design and implement data transformation rules to ensure data is compatible with the target system's schema.
Create and maintain data mapping documentation for reference and future audits.
Develop and execute scripts, queries, or tools to extract, transform, and load data from source to target systems.
Monitor the migration process, troubleshoot issues, and resolve any errors that occur during data transfer.
Conduct testing and validation of migrated data to ensure completeness, accuracy, and compliance with requirements.
Prepare detailed documentation of migration processes, including technical specifications, workflows, and data models.
Provide regular progress reports to stakeholders, highlighting any risks, issues, or delays.
Create post-migration reports and assist in post-migration audits to ensure data accuracy and completeness.
Offer post-migration support to address any issues or concerns that arise after data migration.
Use your exceptional customer service skills to guide customers through a successful migration process.
What you've done:
Bachelor’s degree in computer science, information technology, data management, or equivalent (minimum 8 years) work experience.
2+ years of technical and/or consulting experience architecting enterprise and application solutions in public safety software.
Proven experience in data migration, data analysis, or database management.
Experience with data migration tools and techniques (e.g., ETL tools, SQL, data mapping tools).
Familiarity with different database systems (e.g., Oracle, SQL Server, MySQL) and data formats (e.g., CSV, XML, JSON).
Excellent analytical and problem-solving skills, with attention to detail.
Ability to work independently and collaboratively in a fast-paced environment.
Strong communication skills, with the ability to translate technical concepts into business terms.
Proven self-starter that proactively develops working relationships with key internal and external stakeholders.
Demonstrated experience in requirements gathering, use-case documentation, business analysis, integrations/interfaces, data conversions and other key elements of public safety implementations.
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 hiring, developing and leading a team
Experience with product development tools such as JIRA
Note:
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-Remote
#LI-JC1
Disclaimer:
Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.
Range and benefit information provided in this posting are specific to the stated locations only
US: Hiring Range in USD from: $97,500 to $199,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:
Medical, dental, and vision insurance, including expert medical opinion
Short term disability and long term disability
Life insurance and AD&D
Supplemental life insurance (Employee/Spouse/Child)
Health care and dependent care Flexible Spending Accounts
Pre-tax commuter and parking benefits
401(k) Savings and Investment Plan with company match
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.
11 paid holidays
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.
Paid parental leave
Adoption assistance
Employee Stock Purchase Plan
Financial planning and group legal
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.
About Us
As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.
When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.
We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.
Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first 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 calling +1 888 404 2494, option one.
Disclaimer:
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.
* Which includes being a United States Affirmative Action Employer
Oracle
-
- Oracle Jobs
