Principal Cloud Database Architect
Company | Partner.Co |
---|---|
Location | Utah, USA |
Salary | $Not Provided – $Not Provided |
Type | Full-Time |
Degrees | |
Experience Level | Senior, Expert or higher |
Requirements
- Expert-level Oracle database administration experience (11g, 12c, 19c, 21c)
- Advanced PL/SQL development and optimization skills
- Deep expertise in Oracle performance tuning, including execution plan analysis and query optimization
- Proficiency with PostgreSQL and MySQL/MariaDB database administration and optimization
- Experience with AWS database services (RDS, Aurora, DynamoDB) and serverless database architectures
- Knowledge of AWS Lambda, serverless computing, and event-driven database architectures
- Proficiency with Oracle Enterprise Manager, AWR reports, and performance monitoring tools
- Experience with database security, backup/recovery, and high availability solutions across multiple platforms
- Knowledge of Oracle partitioning, indexing strategies, and storage optimization
- Experience with cloud database migration strategies and multi-database environments
- Experience with database replication, data integration, and ETL processes
- Understanding of database design principles and data modeling across SQL and NoSQL platforms
Responsibilities
- Manage and optimize Oracle, PostgreSQL, and MySQL database systems supporting mission-critical applications
- Perform advanced database tuning across multiple platforms, including query optimization, index management, and performance monitoring
- Develop, maintain, and optimize complex PL/SQL procedures, functions, and packages, as well as stored procedures in PostgreSQL and MySQL
- Design and implement serverless database architectures using AWS Lambda and managed database services
- Collaborate with the engineering teams on database architecture decisions for migration to AWS
- Implement database security best practices and ensure compliance with global data protection requirements across all platforms
- Design and execute database backup, recovery, and disaster recovery procedures for multi-platform environments
- Monitor database performance across Oracle, PostgreSQL, and MySQL environments and proactively identify optimization opportunities
- Support legacy system maintenance while leading cloud database migration initiatives
- Provide 24/7 on-call support for critical database issues across all platforms
- Create and maintain comprehensive database documentation and procedures for multi-database environments
Preferred Qualifications
- Experience with large-scale, mission-critical database environments across multiple platforms
- Background supporting global, distributed systems preferred