Oracle Database Architect
Core
Manage, maintain, and optimize enterprise databases to ensure data integrity, security, and availability while supporting business applications and analytics.
Role type
Senior Oracle Database Architect
Builds
Production database environments, optimized data models, and automated maintenance scripts
Domain
Enterprise Data Management / Oracle Database
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Oracle Database administration, SQL query optimization, PL/SQL development, database performance tuning, AWR report analysis, conceptual and logical data modeling, backup and recovery procedures, disaster recovery planning, shell scripting, Python scripting
Preferred skills
Oracle certification, Agile/Scrum methodology experience, product development background, cloud computing services experience
Technologies
Oracle Database, PowerDesigner, ERWIN, AWR, Python, Shell scripting
Responsibilities
Analyze and optimize complex SQL queries for performance improvements; Generate and interpret AWR reports to identify bottlenecks; Utilize enterprise data modeling tools for conceptual-level database design; Develop and maintain PL/SQL stored procedures, triggers, and packages; Create and maintain automation scripts for monitoring and maintenance; Troubleshoot and resolve database issues in production environments; Implement database security, user access control, and compliance policies; Develop and maintain backup, recovery, and disaster recovery procedures; Communicate progress and issues through regular status reports.
Seniority
Senior, hands-on IC
