Provide operations and maintenance (O&M) and database development for legacy databases for Sponsor systems to include the enterprise API Gateway, EDW and new modern databases consistent with the Sponsor’s business data strategy.
Provide support for deployment packaging, system maintenance and troubleshooting to maintain sustainability and reliability of the Sponsor’s systems and applications. These mission critical systems must continue without interruption and meet Sponsor approved timelines for new development activities.
Ensure that all development and modifications to existing Sponsor applications and databases comply with Sponsor’s security and architectural policies and regulations.
The Contractor shall be required to communicate and collaborate across organizational boundaries, to include other contractor teams. The Contractor shall be required to work with Sponsor staff and contractor
Demonstrated experience utilizing Oracle and PostgreSQL databases.
Demonstrated experience with Tableau and COGNOS for reporting presentation.
Demonstrated experience developing and interfacing with Application Program Interfaces (APIs).
Demonstrated experience performing testing and quality assurance of developed solutions within the existing Oracle data tier.
Demonstrated experience developing, creating, and modifying data structure and data load routines for analytic use cases.
Demonstrated experience working with relational data tiers including cleansing, transforming and processing of structured data.
Demonstrated experience working with views, triggers and Oracle PL and SQL.
Demonstrated knowledge of Amazon Web Services environments, including RDS, s3 etc.
Demonstrated experience working within an Agile project management model.
Demonstrated experience as agile scrum master.
Demonstrated experience with Amazon Web Services/Cloud Data Migration Services.
Demonstrated experience with JIRA.
Demonstrated experience with IMMUTA data policy.
Demonstrated experience collaborating with Sponsor staff, IT customers, and other technical and non-technical staff and contractors at all levels.
Demonstrated experience with a variety of data repository types (i.e., relational, NoSQL, distributed processing framework, etc.).
Demonstrated experience creating and interfacing with REST APIs.