About the role
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.