Oracle Apex Developer Job at Sparibis, Suitland, MD

VEtwaERVSkJQbjhuejJtQ2p1Q29uc1Y1bnc9PQ==
  • Sparibis
  • Suitland, MD

Job Description

Location: 100% remote Years' Experience: 7+ years professional experience Education: Bachelor's degree in computer science, Software Engineering or IT related field. Clearance: Applicants must be able to obtain and maintain a Public Trust security clearance. United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance. Key Skills: Highly experience with Oracle database Must have hands-on professional experience with Oracle APEX Experience writing and executing PL/SQL statements At least one Oracle database certification preferred Current or prior Census Bureau experience preferred. Responsibilities Design and implement database schemas, tables, views, and indexes. Developed procedures, functions and triggers for using PL/SQL. Optimize Oracle database for performance, scalability and reliability. Perform database programming and support systems design. Developer reports using Oracle APEX. Write and execute proficient PL/SQL code. Debug and troubleshoot PL/SQL scripts for stored procedures. Tuning, optimization and troubleshooting multiple environments (20+), stand-alone and pluggable databases, SQL and PL/SQL routines. Analyzing performance issues, diagnosing/resolving affecting database systems. Analyze and improve SQL query performance and identity potential bottlenecks. Ensure database security, access control and compliance with policies. Assist with database migrations and manage Oracle database. Design and develop ETL processes to transform data between systems. Experience with Oracle tools such as SQL*Loader, Data Pump, and/or Oracle Data Integrator (ODI). Manage database jobs. Manage materialized views. Manage connections with external databases. Performs data access analysis design, and archive/recovery design and implementation. Develop strategies for data acquisitions, archive recovery, and implementation of a database. Design, build, and maintain structure (e.g. relational) and unstructured databases within a multiple tier environment. Reviews and develops object and data models and the metadata repository to structure the data for better data management and performance. AWS cloud experience highly preferred. Qualifications 7+ years professional experience. Must be able to obtain a maintain a Public Trust Security Clearance. Bachelor's degree. Oracle development experience supporting large production databases. Must have hands-on professional experience with designing, building, and maintaining web applications using Oracle APEX. Experience creating interactive reports, forms, dashboards, and workflows. Experience optimizing APEX applications for scalability and user responsiveness. Integrate APEX applications with REST APIs, web services, and external systems. Proficiency in programming languages such as JavaScript, HTML, CSS, and JQuery. Other development experience to include familiarity with REST, OAuth, and/JSON preferred. Experience writing and executing PL/SQL statements. Experience writing and optimizing PL/SQL code. Experience developing complex queries, stored procedures, functions, packages, and triggers. Must have professional experience with Oracle SQL and PL/SQL for Performance tuning. Deep knowledge of Oracle partitioning, Indexing and Compression Experience developing complex business logic in the Oracle database using PL/SQL. Monitoring and troubleshooting SQL*Loader/PL/SQL Data Loads for Performance, Coding and Infrastructure issues. Oracle RDBMS experience preferred. Experience monitoring and maintaining Oracle database to optimize performance. Proven ability to resolve architectural issues in the environment and database infrastructure, as well as develop and maintain an in-depth understanding of the database architecture and the application functionality. Critical thinking and problem-solving abilities to address complex issues involving data movement and data replication. Be able to work independently and have good oral and written communication skills. Must have experience Providing 24X7 and on-call troubleshooting and production support. About Sparibis Sparibis LLC is a professional solution firm that Clients rely on to access the best talent to drive their business success. Sparibis is an equal opportunity employer that values diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. Sparibis

Job Tags

Work at office, Remote work,

Similar Jobs

Kenan Advantage Group

OTR CDL-A Owner Operator Truck Driver Job at Kenan Advantage Group

 ...Job Description KAG Energy, a division of Kenan Advantage Group, is currently Leasing on OTR Owner Operator Truck Drivers in your area! Join KAG today to take advantage of great pay, competitive benefits packages, supportive terminal managers and great equipment!... 

Truist

Data Scientist II Job at Truist

Join to apply for the Data Scientist II role at TruistJoin to apply for the Data Scientist II...  ...below. Specific activities may change from time to time.Independently perform...  ...based on date of hire and by full-time or part-time status) during their first year of... 

Compunnel

Product Owner Job at Compunnel

 ...The Product Owner is responsible for leading and coordinating cross-functional project/program teams from the design phase to the delivery of fully-developed products that are ready for customer use. This role involves frequent interpretation and independent decision-making... 

Pinnacle Fertility

Become A Surrogate! Earn $65k-$100k (Women 21-40 with Prior Pregnancy Experience Only) Job at Pinnacle Fertility

 ...Experience Only. Become a surrogate and feel the immense joy of helping create families while earning $65-$100k.Whether you're a stay-at-home mom or looking to supplement your income, surrogacy is a deeply rewarding opportunity to help others while being supported every... 

River Rock Academy LLC

Special Education Teacher Job at River Rock Academy LLC

 ...Job Description Job Description Title: Special Education Teacher - 2025 26 School Year Location: Red Lion, PA 17356 Employment Type: Full-Time (Monday to Friday) Salary: Based on education and experience Join River Rock Academy, a Pennsylvania Department...