Fullstack Developer - .NET

Responsibilities:

• Design, develop, test, and maintain Oracle PL/SQL code, including stored procedures, functions, packages, triggers, and views.
• Analyze business requirements and translate them into efficient database solutions.
• Optimize SQL queries and PL/SQL code for performance and scalability.
• Maintain and improve existing database schemas, data models, and ETL processes.
• Designs, develops, and maintains production, development, testing, and training environments.
• Controls access to these environments in compliance with SOX regulations.
• Migrates software changes to these environments in compliance with SOX regulations.
• Collaborate with application developers, data architects, and business analysts to support end-to-end solution delivery.
• Document technical designs, data flows, and development processes.
• Participate in code reviews and contribute to development standards and best practices.
• On-call rotation assignment in support of all implemented enterprise-level software.

Requirements:

• Strong proficiency in Oracle Database (12c or later) or Transactional SQL, including schema design, indexing, and query optimization.
• Solid understanding of relational database concepts and data modeling principles.
• Experience writing complex SQL queries, stored procedures, and packages.
• Familiarity with database performance tuning tools and techniques.
• Experience developing scalable, high-concurrency RESTful APIs and web services using C# and the. NET Core framework.
• Familiarity with React for developing modern, responsive front-end user interfaces.
• Experience with AWS cloud platform.
• Proficiency with Git and GitHub repositories for version control and collaborative development workflows.
• Must be able to perform all essential functions of the position with or without reasonable accommodations.

Skills

.NET, .NET Core, C#, Oracle, PL/SQL, React, React.js, SQL