Piper Companies is looking for a SQL Database Refactoring Developer, Tech Lead for a Managed Services organization in Remote.
Responsibilities for the SQL Database Refactoring Developer, Tech Lead
Locating and cataloging all Oracle
database objects, develop compatibility matrix with Oracle objects to
- Expertise in PostgreSQL (Schemas, Functions, Views,
Materialized views, cast operators, sequences, FDW, extensions, pipelined
functions, table functions, types etc)
- Evaluate Oracle PL/SQL Code and check for
compatibility with PL/pgSQL in PostgreSQL, look for retrofitting options.
- Check dynamically generated SQL within middleware,
application server objects, Java classes and shell scripts. Design and develop
repository-based SQL code that could be dynamically constructed at runtime.
- Expertise with Ora2PG, AWS SCT and techniques to map
out compatibility of data types and Data migration
- Evaluate and innovate the mapping of application
functionality requirements using cloud native technologies such as AWS Lambda.
- Must have essential soft skills in negotiating and
discussing with customers internal and external
Qualifications for the SQL Database Refactoring Developer, Tech Lead
- Refactor and Retrofit embedded and dynamic/generated
SQL from Oracle to PL/pgSQL in PostgreSQL together with related schema changes,
including within C++, C#, Python, Perl, Java classes, batch programs, external
scripts, PL/SQL DB objects (procedures, functions, triggers, views, etc.) and
SQL stored within DB tables.
- Inventory and evaluate objects to be
refactored, cataloging specific migration topics to be addressed (e.g. a Decode
function, pipelined functions, types, table functions) within the objects, and
assessing for dependencies and functional / technical complexity.
- Ensure performance is scalable and robust on target
PostgreSQL databases on AWS EC2 and RDS Platforms.
- Continuously improve skills with Oracle, PostgreSQL
and AWS Cloud Platform.
- Developing, testing and deploying application on AWS
is a plus
- Experience with testing frameworks a plus
- Oracle SQL and PL/SQL
- PostgreSQL PL/pgSQL
- PostgreSQL Schema Objects
- AWS RDS PostgreSQL, Aurora
- AWS Data Migration Service (DMS)
Let us know
Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:
SPECIFIC RESPONSIBILITIESEnter program incentives on a monthly basis through the Fusion systemConduct quality control measures on Fusion system to ensure incentives are error-freePerform system support and issue resolution procedures when necessaryMake recommendations to Sales, O
Description:The Solution Consultant Trainee (Academy Consultant) works closely with teammates to ensure the maximum value of our clients’ UKG Dimensions, Workforce Management (WFM) system investment is achieved. Specifically, the Solution Consultant Trainee implements both
Director of Product and Technology - Remote with no Travel Requirement. Motive is seeking a driven self-motivated individual to join our company as our Director of Product and Technology. This position is an individual contributing engineer as well as manager and product visionar
Job DescriptionWe are very excited to look for an Sr. IT Solution Architect to join our Avery Dennison IT Team! The Sr. IT Solution Architect is accountable for technical integrity, system quality, fitness-for-purpose, and conformance to the enterprise architecture of business an
Headquartered in New York City, Dataiku was founded in Paris in 2013 and achieved unicorn status in 2019. Now, more than 800 employees work across the globe in our offices and remotely. Backed by a renowned set of investors and partners including CapitalG, Tiger Global, and ICONI
More jobs by this company
Piper Companies is seeking a Manager of Data Engineering for a growing technology driven organization. The Manager of Data Engineering role is a 100% remote role that can reside anywhere in the United States. The Manager of Data Engineering will be working with a team primarily b
Piper Companies is seeking a REMOTE Network SRE for a world leading technology organization. The REMOTE Network SRE will need to work east coast based hours and will have the opportunity work fully remote. The REMOTE Network SRE will have more networking responsibilities to begin
Piper Companies is seeking a Remote Sr. Java Developer for a growing software company. The Remote Sr. Java Developer can sit 100% remote and will be contributing towards greenfield development.Responsibilities for the Remote Sr. Java Developer include: Design, develop, and implem
Piper Companies is currently seeking a Senior UI Software Engineer for a contract to hire remote opportunity! As a Senior UI Software Engineer, you will be on the leading edge of UI product design and implementation. The Senior UI Software Engineer will have the opportunity to be
Piper Companies is looking for a SQL Developer for a leading financial lender located in Oaks, PA.This position is 100% remote.Essential Functions/Responsibilities: Can help in defining, documenting and developing software, software applications, as well as contributes to
Piper Companies is looking for a Data Analyst in Horsham, PA (100% remote) for a leading Mortgage solutions company.This position is 100% remote.Key responsibilities for the Data Analyst include:Analyze data, identify, and document PII in the databases.Writing complex SQL queries
Piper Enterprise Solutions is looking for an experienced and enthusiastic Technical Sourcer for an exciting, remote opportunity with one of the leading home furnishing companies in the nation. The Technical Recruiter role is tasked with designing, building, and executing strategi
Piper Companies is currently seeking a Lead Software Engineer for a remote fulltime opportunity for an international financial SaaS company. The Lead Software Engineer will participate in the creation and delivery of cloud-based software for web applications, build and integrate.
Piper Companies is seeking a Fully Remote Information Technology Manager to support a Debt Collection and Recovery Solutions provider. The IT Manager will report directly to the CEO and serve as the process owner for all corporate systems.Responsibilities of the Fully Remote Info
Piper Companies is currently seeking a Sr. Java Developer for a full-time, fully remote 12 month contract opportunity with the Federal Government . The Sr. Java Developer will partake in engineering and developing features of an existing platform. The incumbent can be based anywh
Piper Companies is currently seeking a Sr. Front End Engineer for a full-time opportunity with a leading Banking provider based in North Carolina (NC). The Sr. Front End Engineer will partake in engineering and developing features of an existing platform.*FULLY REMOTE* Responsibi
Piper Enterprise Solutions is searching for a Data Security Engineer for a financial services company. This is a 100% remote position.Responsibilities for the Data Security Engineer:Responsible for developing routines and creating reconciliation processes to assure data securityW
Piper Companies is looking for a Manager, Front-End Engineering who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Manager, Front-End Engineering include:You will be responsib
Piper Enterprise Solutions is searching for Software Engineers for multiple positions with a client in the financial service industry. These are 100% remote positions.Responsibilities for the Software Engineers:Responsible for the design, deployment, testing and overall managemen
Piper Enterprise Solutions is searching for an QA Analyst for a financial services company. This is a 100% Remote position.Responsibilities for QA Analyst: Responsible for created and executing backend test plans, querying data, and testing backend data changes Responsible for bi
UX/UI Designer (remote position)My client, a financial services provider, is in need of a UX/UI Developer for a 6-month contract to potential hire opportunity. This project will include a new product launch. This role can sit 100% remote from home.Qualifications:3-5 years of expe
Piper Companies is looking for a Database Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Database Architect include:You will be responsible for providing leaders
Piper Companies is currently seeking a Python Developer for a new project supporting a federal client. This position will be 100% remote.Duties of the Python Developer:Designing and Developing new software systems to meet client requirements.Performing QA work on the code for pee
Piper Companies is currently seeking a React Software Engineer for a full time position with a Remote first, innovative and modern SaaS company based out of San Francisco, CA. The React Engineer will help support the main application. Responsibilities of the React Software Engine
Piper Companies is looking for a ColdFusion Developer for a Cloud Services company.Responsibilities for the .ColdFusion DeveloperMust have significant experience with ColdFusion, should also have Lucee (open source CFML-generator), ideally experience migrating ColdFusion to Lucee
Piper Companies is presently looking for a Technical Sourcing Specialist for a large commercial retail organization to represent their Software Engineering and Product Management departments. The Technical Sourcing Specialist will create Boolean searches to recruit candidates who
Piper Companies is seeking a 100% remote- Sr. Front End Software Engineer for an opportunity based in San Francisco, California! The Sr. Front End Software Engineer will be responsible for supporting and being a technical lead in an agile environment!Responsibilities of the Sr. F
Piper Companies is currently seeking a Senior Business Intelligence Analyst for a fully remote opportunity in the EST time zone. The BI Analyst will design and implement data reports and visualization, build dashboards for executive leadership, and collaborate with internal teams
Piper Companies is currently seeking a Senior Software Engineer for a 100% remote opportunity! As a Senior Software Engineer, you will utilize your extensive background in web development (C#, and ASP.NET) to contribute to a company culture where change is welcomed and there is c
Piper Companies is seeking a Remote Full Stack Developer for a well-known technology organization in the Raleigh-Durham, NC area. The Full Stack Developer will be responsible for developing and maintaining internal applications. The ideal candidate for the Full Stack Developer ro
Piper Companies has an opportunity for a Java Developer supporting our client who specializes in the development of advanced software solutions for customers across a broad range of industries, from Logistics, Maritime and Aviation to Metals and Manufacturing.Responsibilities for
Piper Companies is seeking a Remote Sr. Digital Applications Developer for a well-known technology organization in the Raleigh-Durham, NC area. The Sr. Digital Applications Developer will be responsible for designing and implementing web applications. The ideal candidate for the.
Piper Companies is looking for a ColdFusion Engineer who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the ColdFusion Engineer include:You will be responsible for planning, organ