Virtual Development

Software Engineer/Developer

Position is for a combined role for a developer with expertise in Oracle stored procedures, cloud-native development, and AWS data lake house products. Focus of work  will be crucial in migrating and modernizing data solutions from traditional Oracle environments to scalable, cloud-based data lake house architectures.  Requires experienced developer to support legacy Oracle based back-end applications and evolving AWS-based data lake house solutions.  Must have strong background in Oracle PL/SQL development and hands-on expertise in designing, implementing, and optimizing data pipelines and applications within the AWS cloud ecosystem. 

 Skills and Experience (Requires minimum of 5 years direct experience

• Hands on experience within operating systems  UNIX Solaris;  UNIX  Linux; and experience with UNIX/ Oracle PL/SQL. Linux experience is required
• Oracle 11g, 12c  experience with programming stored procedures for business applications; shell scripting to create job work streams
• AWS environment experience is required
• Experience, understanding, and knowledge of Unix scripting and automation using shell, Perl, etc. and file exchange such as sFTP; putty; CRT; in multi interface/data exchange environment
• A big plus is understanding and knowledge of SQL skills in Oracle, basic Oracle 11g, 12 C or higher skills, to include, experience with Oracle back end stored procedures and queries.
• A plus is  operations and maintenance experience,  experience with the full life cycle of a business application.
• Experience with structured change management and ticketing tools such as JIRA; code/repository management tools such as Subversion/SVN is a plus
• Additional skills if available but not required is experience with SAS programming in a Unix environment and any Java and/or .Net experience
• Oracle Development & Maintenance: Design, develop, test, and maintain complex Oracle databases and applications using SQL and PL/SQL.
• Stored Procedures & Performance Tuning: Write and optimize complex stored procedures, functions, packages, and triggers, and conduct performance tuning for existing Oracle queries and database structures.
• AWS Lakehouse Architecture: Design and build data solutions within the AWS environment, leveraging services such as/similar to Amazon S3, AWS Glue, Amazon Athena, and Amazon Redshift/Spectrum to build and maintain a robust data lake house.

Education

• Bachelor's Degree or equivalent required;
• A plus is certificates evidencing additional training/skills; and  can be substituted for Degree

Background Check Required

Location

Position is remote/telecommute.  Or in Office located in Rockville/Gaithersburg Area.