What are the responsibilities and job description for the Software Engineer/Developer position at Virtual Development Corporation?
Software Engineer/DeveloperPosition 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 requiredOracle 11g, 12c experience with programming stored procedures for business applications; shell scripting to create job work streamsAWS environment experience is requiredExperience, 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 environmentA 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 plusAdditional skills if available but not required is experience with SAS programming in a Unix environment and any Java and/or .Net experienceOracle 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.EducationBachelor's Degree or equivalent required;A plus is certificates evidencing additional training/skills; and can be substituted for DegreeBackground Check RequiredLocationPosition is remote/telecommute. Or in Office located in Rockville/Gaithersburg Area.Company DescriptionTechnology and Data Services