- Administer, sustain, and optimize Oracle databases supporting production enterprise applications.
- Develop and maintain PL/SQL procedures, schemas, data models, views, queries, and data dictionaries.
- Monitor database health, performance, and data issues and implement corrective actions.
- Maintain schema version control and coordinate database changes with application development, testing, and release activities.
- Support data imports, transformations, validation, reconciliation, and exception handling.
- Investigate data anomalies and develop ad hoc queries and data extracts.
- Support reporting and data visualization using tools like Oracle BI, Power BI, or Tableau.
- Support secure data exchange using APIs, XML, SFTP, middleware, and EDI.
- Develop and maintain architecture documentation, interface specifications, data mappings, SOPs, and technical documentation.
- Collaborate with application developers, testers, and Government stakeholders.
SQLETLOracle+1 more