SacramentoRecruiter Since 2001
the smart solution for Sacramento jobs

PL/SQL Developer

Company: California Department of Justice
Location: Herald
Posted on: February 24, 2021

Job Description:

***Please note that the State of California requires you to complete the Civil Service application process and applying on LinkedIn does not complete this process. If you would like to complete the application process, please click on the Easy Apply button. Your information will be sent to one of our specialized recruiters and they will contact you to discuss next steps.***
Under the direction of the unit supervisor, the Information Technology Specialist I (ITS I) performs at the expert specialist level of this career series to analyze, design, develop and implement the most complex software systems for the Bureau of Firearms (BOF) program. The ITS I is involved in all aspects of the project life cycle, from the initial kickoff through the requirements analysis, design, and implementation. The ITS I serves as a leader in the development of application functionality and the design and maintenance of multiple highly scalable, fault-tolerant databases for business-critical, internal and external-facing applications. The ITS I provides on-going monitoring, support, and performance tuning of the BOF software systems and database.
The PL/SQL Developer responsibilities include, but are not limited to:

  • Analyzes proposed legislation to determine the impact on the systems and applications that support BOF.
  • Analyzes, reviews, evaluates, and integrates software products with the most complex operating systems, layered products, and secure n-tier architectures for mutual compatibility and applicability.
  • Designs and implements custom database configurations, procedures, and processes to support data migration, data integrity, system security, and audit requirements.
  • Plans and implements database upgrades and design system recovery and business resumption plans.
  • Develops and enhances PL/SQL packages and procedures.
  • Supports the installation of the most complex database modifications, evaluation activities, testing, problem-solving, and direct participation in upgrades that are unable to be addressed by peers.
  • Develops and enhances the most complex applications utilizing but not limited to the JBoss Enterprise Application Platform, the Java programming language, UNIX shell scripting language, JavaScript, HTML, Programming Language/Standard Query Language, Extensible Markup Language (XML), Struts frameworks, Spring framework, Apache Maven, and Apache Ant.
  • Develops logical design requirements/functional specifications for highly advanced systems/interfaces and leads the development team through implementation.

    • Works with the business analysts in the development of software requirement specification and technical design specification.
    • Creates technical design document to describe the software architecture and system built to meet BOF program needs.
    • Provides technical leadership in determining the best approach to resolving operational challenges or to design and implementation challenges.
    • Provides technical consultation, leadership, and expertise for all system related activities required to ensure proper development, implementation, and maintenance of various web applications and database designs undertaken by the Department. This will include making technical recommendations to management on the use of various data modeling, performance tuning, and software.
      We're a growing Department with an impact that spans the state
      • Over 4,500 Employees
      • Opportunities for upward mobility
      • "Been in Business" since 1850
        Desired Qualifications:--- Experience, knowledge, and skill performing SQL queries.--- Experience, knowledge, and skill in writing complex PL/SQL packages and procedures.--- Experience, knowledge, and skill developing documentation throughout all phases of the SDLC.--- Experience, knowledge, and skill analyzing and resolving system failures and software problems.--- Experience with performing data analysis and manipulation.--- Experience, knowledge, and skill developing web-based solutions.--- Knowledge and skill performing object-oriented design and programming.--- Knowledge and skill developing test cases and test automation with automation testing tools such as Junit, Selenium, and qtest.--- Knowledge and skill using software version control tools such as subversion, or GIT.--- Ability to work independently.--- Ability to work with customers to gather business requirements and prepare documentation utilizing strong written and oral communication skills.--- Ability to participate in multiple ongoing development projects.
        Don't miss out on your opportunity to help protect and serve the citizens of California!

Keywords: California Department of Justice, Sacramento , PL/SQL Developer, IT / Software / Systems , Herald, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Software Engineer - Novato, CA
Description: Job DescriptionJoin Hired and find your dream job as a Software Engineer at one of 10,000 companies looking for candidates just like you. Companies on Hired apply to you, not the other way around. You'll (more...)
Company: Hired
Location: Novato
Posted on: 03/3/2021

Senior Open Source Developer and Architect
Description: Senior Open Source Developer and Architect in Walnut Creek, California, United States - Jobs/Careers - Verizon Learn more about Verizon's response to COVID-19 Skip to main content li About li Search (more...)
Company: Verizon Communications
Location: Walnut Creek
Posted on: 03/3/2021

HIRED: Software Engineer (Security Clearance Required)
Description: Join Hired and find your dream job as a Security Software Engineer at one of 10,000 companies looking for candidates just like you.Companies on Hired apply to you, not the other way around. You'll (more...)
Company: HIRED
Location: San Ramon
Posted on: 03/3/2021

Front End Developer (Entry level)
Description: In the next 4 weeks, Revature is looking to hire over 300 Front End Developers across the country. We are the largest employer of emerging tech talent.One day someone is going to ask you where you got (more...)
Company: Revature
Location: San Bruno
Posted on: 03/3/2021

SDN Planning Architect-Data Modeling
Description: SDN Planning Architect--Data Modeling - About Verizon Learn more about Verizon's response to COVID-19 Skip to main content li About li Search Careers li Walnut Creek, CA li Full-Time Technology (more...)
Company: Verizon Communications
Location: Walnut Creek
Posted on: 03/3/2021

Technical Support Representative - Electrical, Solar
Description: If you are a Technical Support Service Representative with experience, please read on --- 20-25 / hour ---Rocklin, CAWhat You Will Be DoingThe Electrical Technical Service Representative is responsible (more...)
Company: CyberCoders
Location: Rocklin
Posted on: 03/3/2021

Senior Software Engineer
Description: The RoleOur Video Collaboration products help companies stay connected and can be found in the conference rooms of some of the biggest businesses in the--world. We are a small nimble group and--we are (more...)
Company: Logitech
Location: Newark
Posted on: 03/3/2021

Python AI/ML Sen. Dev
Description: Python AI/ML Sen. DevWoodland Hills, CA / Atlanta, GA / Mason, OH. UST Global-- is looking for a highly energetic and collaborative Python AI/ML Sen. Dev/Jr. Architect to work with one of the leading (more...)
Company: UST
Location: Woodland
Posted on: 03/3/2021

Software Engineer - Python
Description: FocusKPI, Inc. is looking for a Software Engineer to work for our client in San Bruno, CA. This is a full-time contract position.Responsibilities: Working with the analysts and their
Company: FocusKPI, Inc.
Location: San Bruno
Posted on: 03/3/2021

Oracle Retail Applications Consultant
Description: Role: Software Engg - Oracle Retail Applications Consultant Techno Functional Experience: Mid to Sr level DE's 8-10 years Location: Rocklin, CA/Remote till COVID 19 situation settles br br (more...)
Company: ITC Infotech
Location: Rocklin
Posted on: 03/3/2021

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Sacramento RSS job feeds