Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of the transformation of the public sector’s IT environment. Our team is on the forefront of helping to solve the government’s most complex IT challenges. If you are seeking a role that offers you the opportunity to work on rewarding projects, consider a career with Cloud and Things.
Overview:
We are seeking an experienced Oracle PL/SQL Developer to join our team. The ideal candidate will be responsible for the full life cycle development of Oracle databases, including data modeling, database architecture, SQL and PL/SQL development, unit testing, and ongoing support.
Key Responsibilities:
- Participate in the full life cycle development of Oracle databases.
- Design and implement data models and database architecture.
- Develop, test, and maintain complex PL/SQL packages, procedures, functions, triggers, views, and materialized views.
- Create and improve reusable database objects.
- Utilize PL/SQL programming expertise in data types, cursors, exception handling, collections, merge statements, analytic functions, table functions, and dynamic SQL.
- Develop software for web-based applications.
- Create fast, easy-to-use, high-volume production code.
- Develop prototypes quickly to validate designs.
- Optimize and tune SQL queries to ensure maximum speed and scalability.
- Perform performance tuning and optimization for database applications.
- Work with Oracle REST Data Services (ORDS) and API Gateway Cloud databases.
Required Skills and Expertise:
- Proven experience in Oracle database development and architecture.
- Extensive knowledge and hands-on experience with PL/SQL programming, including:
- Data Types, Cursors, Exception Handling, Collections
- Merge statements, Analytics Functions
- Views, Materialized Views, Table Functions
- Stored Procedures, Functions, Packages
- Database Triggers, Dynamic SQL, External Tables
- Performance Tuning, Object Programming
- SQL built-in functions, joins, aggregate functions
- Strong understanding of database performance tuning and optimization.
- Experience with ORDS and API Gateway Cloud database.
Preferred Qualifications:
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Experience with high-volume, web-based application development.
Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard protected veteran status, or any other category protected by applicable federal, state, or local laws. to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.
1503
Job Type: Full-time
Pay: $100,000.00 - $110,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Experience level:
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Experience:
- Informatica: 6 years (Preferred)
- SQL: 6 years (Preferred)
- Data warehouse: 6 years (Preferred)
Ability to Commute:
- Brooklyn, NY 11201 (Required)
Ability to Relocate:
- Brooklyn, NY 11201: Relocate before starting work (Required)
Work Location: Hybrid remote in Brooklyn, NY 11201