About the role
Role Summary
We are seeking a highly experienced Database Architect responsible for defining designing governing and optimizing enterprisescale database platforms across Oracle Microsoft SQL Server MySQL PostgreSQL and AWS database services The architect will drive database strategy cloud transformation initiatives HADR architecture performance engineering security compliance and modernization programs supporting missioncritical business applications
The role requires strong expertise in both traditional RDBMS platforms and cloudnative database services along with leadership capabilities to guide DBA teams application architects and infrastructure teams
Key Responsibilities
Database Architecture Strategy
Define enterprise database architecture standards and best practices
Design scalable resilient and secure database solutions
Establish technology roadmaps for database modernization
Drive database platform consolidation and cloud migration initiatives
Review solution designs and provide architectural governance
MultiPlatform Database Management
Architect and govern environments involving
Oracle Database 12c19c21c and higher
Microsoft SQL Server
PostgreSQL
MySQL
AWS Database Services
Ensure standardization stability scalability and operational excellence across platforms
High Availability Disaster Recovery
Design and govern
Oracle RAC ASM Data Guard
SQL Server Always On Availability Groups
PostgreSQL Replication Patroni
MySQL Replication and Clustering
AWS MultiAZ Deployments
Crossregion DR solutions
Lead DR drills failover testing recovery validation and resilience planning
Cloud Database Architecture AWS
Architect and support
Amazon RDS
Amazon Aurora MySQLPostgreSQL
Amazon Redshift
DynamoDB
AWS Database Migration Service DMS
AWS Backup
AWS CloudWatch
Develop migration and optimization strategies for cloud adoption
Performance Engineering
Lead enterprise database performance tuning initiatives
Establish monitoring frameworks and performance baselines
Optimize
SQL Queries
Indexing Strategies
Execution Plans
Storage Architectures
Database Workloads
Security Compliance
Design secure database environments
Implement encryption and data protection controls
Establish database security standards and governance
Support audit compliance and regulatory requirements
Ensure adherence to organizational security policies
Migration Transformation Programs
Lead
Oracle to PostgreSQL migrations
SQL Server modernization initiatives
Onpremises to AWS migration programs
Database version upgrades and platform refresh projects
Automation DevOps
Drive Infrastructure as Code initiatives
Automate database provisioning and operational processes
Standardize CICD integration for database deployments
Promote SRE and selfhealing database practices
Leadership Governance
Mentor DBA teams and technical leads
Define operational runbooks and architecture standards
Conduct architecture reviews and technical workshops
Collaborate with application cloud security and infrastructure teams
Mandatory Key Skill Sets
Oracle
Oracle RAC
ASM
Data Guard
RMAN
OEM Oracle Enterprise Manager
GoldenGate
Performance Tuning AWR ASH ADDM
Database Upgrades Patching
Microsoft SQL Server
Always On Availability Groups
Replication
SSIS SSRS SSAS
Performance Tuning
Backup Recovery
Query Optimization
PostgreSQL
Streaming Replication
Patroni PgPoolII repmgr
pgBackRest
High Availability Design
Performance Optimization
PostgreSQL Security Auditing
MySQL
Replication
MySQL Cluster
Percona Toolset
Backup Recovery
Query Tuning
Performance Optimization
AWS Database Services
Amazon RDS
Amazon Aurora
Amazon Redshift
DynamoDB
AWS DMS
AWS Backup
CloudWatch
IAM
KMS
VPC Networking