Software Engineer/Developer
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.
Company Description
Technology and Data Services