Job Type
Full-time
Description
Job Summary
The DBA supports Origin and utility-industry clients by designing, deploying, and maintaining secure, high-performance database environments across cloud and hybrid architectures. This role ensures database reliability, scalability, and compliance for Utilities applications and the Origin SmartCity SaaS platform. The DBA collaborates cross-functionally to align database operations with business requirements and service-level objectives.
Essential Job Functions
Solutions & Domain Experience
- Design, deploy, and administer Origin and client database architectures across dev, test, prod, and public environments.
- Perform Oracle database installations, patching, upgrades, and migrations for Oracle Utilities products (CC&B, C2M, MDM).
- Maintain and troubleshoot OUAF environments, including WebLogic and Fusion Middleware.
- Implement backup/recovery, disaster recovery, and high-availability configurations (RAC, Data Guard).
- Monitor and tune performance across environments to maximize uptime and reliability.
- Enforce database security, access controls, and encryption per Origin/client IT standards.
- Investigate and resolve user-reported issues; track and mitigate recurring problems.
- Support SaaS applications (billing, CIS, MDM) and their underlying databases.
- Manage hybrid (on-prem/cloud) architectures and ensure data synchronization and integrity.
- Align database operations with SaaS release cycles and CI/CD patterns.
- Integrate third-party utility SaaS modules and maintain data consistency.
- Design change management/versioning strategies to minimize service disruption.
- Develop disaster recovery and business continuity plans for 24/7 utility SaaS operations.
Customer Focus
- Collaborate with architects, PMs, and developers to align database capabilities with project needs.
- Communicate clearly with internal teams and client stakeholders via presentations, documentation, and incident updates.
- Provide proactive status, change, and incident communications focused on uptime and impact.
- Document configurations, changes, incidents, and performance improvements for transparency.
- Translate utility business requirements (e.g., meter-to-cash, outage response) into database solutions.
- Build dashboards to report uptime, availability, and performance metrics to clients.
- Act as database service owner, ensuring SLA adherence and root-cause resolution.
- Partner with utility operations and field teams to design data flows and database solutions.
- Deliver training and documentation for client technical teams on database usage and reporting.
Requirements
Competencies
- Strong analytical and problem-solving skills.
- Excellent communication and documentation abilities.
- Effective collaboration across distributed teams.
- Strong organizational and prioritization skills.
- Commitment to continuous learning and Oracle technology updates.
- Accountability for meeting SLOs and uptime targets.
Skill Requirements
Required Skills
- Oracle Database Administration (12c/19c/23ai), SQL, and PL/SQL.
- Performance tuning, monitoring, backup/recovery, and security controls.
- Database migration, patching, upgrades, and lifecycle automation (provisioning, cloning, decommissioning).
- Multi-environment management (dev/test/prod) and tenant isolation.
- Experience with containerized deployments (Kubernetes, Docker) and DBaaS in utility SaaS platforms.
- Chargeback/show-back metrics for shared services.
- Data privacy and compliance (NERC CIP, GDPR, CCPA); auditing controls (PCI, SOC2).
- Schema/index design for high-volume metering/usage data.
- Support for streaming ingestion (IoT/meter data) and OLTP/OLAP coexistence.
- Capacity planning, performance forecasting, elastic scaling, and cost optimization.
- Tuning for concurrency, latency, and high availability in multi-regional SaaS deployments.
Desired Skills
- Oracle Cloud Infrastructure (OCI) certification.
- Experience with Oracle Utilities Applications (CC&B, C2M, CCS).
- WebLogic Server and Fusion Middleware.
- Linux/Unix shell scripting.
- Oracle RAC and Data Guard.
- Familiarity with DevOps tools (Ansible, Jenkins, Git).
Experience/Education Requirements
- 5+ years of experience as an Oracle DBA in enterprise environments
- 2+ years of experience supporting Oracle Utilities or OUAF-based applications preferred
- 2+ years managing databases in a multi-tenant SaaS environment
- Demonstrated experience managing multiple environments (dev/test/prod) and ensuring high availability.
- Bachelor's degree in Coputer Science, Information systems, or related technical field
Certification Preferences (preferred but not required)
- Oracle Certified Professional (OCP) or equivalent certification preferred.
- Oracle Cloud Infrastructure (OCI) certification is desirable.