### Job_Dedcrip:
Hi,.Sr. Oracle PL/SQL Developer.Tallahassee, FL.Spruce Technology, Inc., a mid-size and rapidly-growing technology services firm, seeks to hire an in-house corporate counsel. An award-winning firm (Inc 5000, SmartCEO, Entrepreneur of the Year) with a steadily growing portfolio of commercial and government clients, Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing..Please visit www.sprucetech.com for additional information on our services...JOB TITLE: Oracle PLSQL Developer.DURATION: 12 Months.LOCATION: Tallahassee, FL (ON-SITE WORK).Primary Work: Serve as an Application Developer focusing on the following technologies: Oracle Forms, Oracle PL/SQL, PHP, and Classic Microsoft ASP (3.0). This role supports ongoing maintenance needed to ensure the stability of applications. The focus of this support work will focus on a specific Division’s application portfolio, however the team member may also be assigned to work on other projects and/or applications in the application portfolio, as specified by management..Education:.Required Tasks to be performed:.Required Tasks to be performed:.Provide maintenance, enhancement and support for a variety of the agency’s business applications..Assisting in the preparation and documentation of program requirements and specifications..Research and document requirements of program users..Writing, translating and coding software programs and applications per specifications..Assisting in the development and maintenance of user manuals and guidelines..Working with network administrators, systems analysts and software engineers to assist in resolving problems with software products or company software systems..Providing mentoring and guidance to junior programmers..Required Knowledge, Skills & Abilities (KSAs):.Required Knowledge, Skills & Abilities (KSAs):.9+ years’ experience with Oracle databases with the capability to write complex queries and develop complex PL/SQL database objects, including both DML and DDL..9+ years’ experience developing Oracle Forms.5+ years’ experience with database and/or SQL performance tuning.Experience developing application reporting, preferably with PHP and/or Classic ASP 3.0.Experience using code repositories, preferably Git.Experience using continuous integration tools, preferably Jenkins.Knowledge of relational database designs.Knowledge of Information Systems Development Methodology (ISDM).Experience with database query tools (i.e., TOAD, SQL Developer, SQL Navigator).Knowledge of database security, including role-based security.Knowledge and experience with Unified Modeling Language (UML).Ability to be creative, to use sound judgment, and to display foresight to identify potential problems and design/specifications and assigned application software systems.Ability to establish and maintain effective working relationships with others.Ability to work independently.Ability to determine work priorities and ensure proper completion of work assignments.Ability to work well under pressure and meet deadlines without sacrificing quality.Excellent interpersonal, collaborative, oral and written communication skills.Preferred Knowledge, Skills & Abilities (KSAs):.Preferred Knowledge, Skills & Abilities (KSAs):.Oracle certification(s).Familiarity with Agile development, specifically Scrum, Extreme Programming (XP) and Kanban..Experience in web development leveraging XML and CSS.Experience with jQuery (JavaScript library) or other JavaScript frameworks (such as AngularJS, NodeJS, and React).Experience with environmental regulatory business processes and practices.Knowledge and understanding of DEP’s technical environment..Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.

### Response:

Required Tasks to be performed:- Provide maintenance, enhancement and support for a variety of the agencys business applications.- Assisting in the preparation and documentation of program requirements and specifications.- Research and document requirements of program users.- Writing, translating and coding software programs and applications per specifications.- Assisting in the development and maintenance of user manuals and guidelines.- Working with network administrators, systems analysts and software engineers to assist in resolving problems with software products or company software systems.- Providing mentoring and guidance to junior programmers.Required Knowledge, Skills & Abilities (KSAs):- 9 years experience with Oracle databases with the capability to write complex queries and develop complex PL/SQL database objects, including both DML and DDL.- 9 years experience developing Oracle Forms.- 5 years experience with database and/or SQL performance tuning.- Experience developing application reporting, preferably with PHP and/or Classic ASP 3.0.- Experience using code repositories, preferably Git.- Experience using continuous integration tools, preferably Jenkins.- Knowledge of relational database designs.- Knowledge of Information Systems Development Methodology (ISDM).- Experience with database query tools (i.e., TOAD, SQL Developer, SQL Navigator).- Knowledge of database security, including role-based security.- Knowledge and experience with Unified Modeling Language (UML).- Ability to be creative, to use sound judgment, and to display foresight to identify potential problems and design/specifications and assigned application software systems.- Ability to establish and maintain effective working relationships with others.- Ability to work independently.- Ability to determine work priorities and ensure proper completion of work assignments.- Ability to work well under pressure and meet deadlines without sacrificing quality.- Excellent interpersonal, collaborative, oral and written communication skills.Preferred Knowledge, Skills & Abilities (KSAs):- Oracle certification(s).- Familiarity with Agile development, specifically Scrum, Extreme Programming (XP) and Kanban.- Experience in web development leveraging XML and CSS.- Experience with jQuery (JavaScript library) or other JavaScript frameworks (such as AngularJS, NodeJS, and React).- Experience with environmental regulatory business processes and practices.- Knowledge and understanding of DEPs technical environment.