Join Karsun Solutions to grow your career with the company transforming possible for the US Government. At Karsun, collaboration drives our community. We're committed to building an environment where team members from diverse backgrounds can innovate, learn and grow with us. Here at Karsun, the only limit to your potential is the limit of your curiosity. Join Team Karsun, and Find Your Next. NA Perform modifications to and maintenance of operational programs and procedures.
Analyzes business processes and procedures to recommend technical system/software solutions.
Prepares documentation of program development, modifications to code as needed.
Applies best practice for tuning SQL and PL/SQL for overall system performance.
Supports software development and test teams throughout the software development lifecycle. Includes incremental script execution and defect resolution.
Review proposed database structure changes by development teams and approve or modify based company standards and best practices.
Provides support for software releases
Researches interfaces to identify and code required updates to support integration Requires a Bachelor's Degree in Engineering, Math, or Science and a minimum of 8 years of relevant experience The ability to successfully obtain and maintain a U.S. Suitability/Public Trust Background Clearance
Provide all activities related to the administration of Oracle databases
Extensive experience and a solid understanding in administering complex database architectures of Oracle 19c & all latest releases.
Experience creating databases from design models and building physical environments.
Experience with logical and physical data modeling and RDBMS concepts.
Complete understanding of database partitioning
Experience designing, developing, testing, documenting, deploying, implementing and tuning Oracle SQL and PL/SQL Languages code.
Extensive experience with data migration and data loads, often from non-Oracle sources.
Knowledge of Real Applications Clusters, Data Guard, Flashback technology, Golden Gate, Recovery Manager, and Oracle Enterprise Manager.
Setup & Monitor DB servers proactively to ensure optimized usage of resources using various monitoring tools like Shell scripts, Oracle jobs, OEM etc.
Perform and setup daily environment health checks and generate reports to capture the findings
Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures.
Strong shell scripting knowledge is required
Design, implement, code, test and maintain Oracle PL/SQL including packages, procedures, triggers and functions in compliance with company standards and best practices.
Experience with logical and physical data modeling and RDBMS concepts.
Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.
Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.).
Ability to provide guidance, oversight, and peer review to more junior database developers and direction to other technical resources as required.
Working knowledge and ability to support IIS administration.
Firm understanding of the overall architecture required to support common schema-based objects used to store data and implement business logic.
Experience working in Linux & Exadata environment.
Aptitude for debugging problems in complex, unfamiliar code
Have worked closely with applications implementing full life cycle
Experience with tools such as TOAD, SQL Developer
Strong written and oral communication skills are essential
Solid work ethic, self-driven, can function independently with minimal oversight and direction Have worked in development tools - Jira, Git and Confluence
Worked in Agile/Scrum team environment
Development work in SQL Server environment
Having worked at FAA in the past is a plus The proposed salary range for this role is $ to $ USD. The salary range provided is a good faith estimate representative of all experience levels. Karsun considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate's work experience, location, education/training, and key skills. Karsun Solutions is an Equal Employment Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information. Third Party Resumes: Karsun does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Karsun and Karsun will not be obligated to pay a placement fee. Clearance Information This position requires the eligibility to obtain a security clearance. The Defense Industrial Security Clearance Office (DISCO), an agency of the Department of Defense, handles and adjudicates the security clearance process. More information about Security Clearances can be found on the US Department of State government website
Date Posted: 22 February 2025
Apply for this Job