Database Architecture & Design :

- Partner with Product management and Application teams to design and implement OLTP and analytical database solutions optimized for performance, scalability, and reliability.

- Develop efficient data models, ensuring normalization and denormalization based on workload requirements.

- Establish best practices for indexing, partitioning, and materialized views to optimize performance.

- Lead database schema evolution and version control strategies.

- Design and implement multi-tenant database architectures, ensuring data isolation, security, and scalability.

- Architect and implement database replication strategies for high availability and disaster recovery.

- Design and maintain active-active and active-passive database configurations for high availability and load balancing.

Performance Tuning & Optimization :

- Conduct deep-dive query optimization using execution plans, indexing strategies, and caching techniques.

- Tune databases for high-performance transaction processing, ensuring low latency.

- Implement resource management strategies to optimize CPU, memory, and disk utilization.

- Proactively monitor database health and resolve performance bottlenecks.

Database Administration (Oracle & PostgreSQL) :

- Install, configure, and manage Oracle and PostgreSQL databases on licensed and cloud platforms.

- Implement backup, recovery, and high availability strategies.

- Ensure security, access controls, and compliance with industry standards.

- Support database migration and upgrades with minimal downtime.

- Manage multi-tenant database strategies, such as schema-based, database-based, or hybrid approaches.

- Configure and manage database replication using technologies like Logical Replication, Streaming Replication, Oracle GoldenGate, and PgBouncer.

- Architect and maintain active-active clusters for real-time synchronization and zero-downtime operations.

Collaboration & Data Engineering (Preferred Skills) :

- Work closely with data engineers to design efficient ETL pipelines and support big data processing.

- Ensure seamless data movement and transformation across OLTP and analytical environments.

- Support cloud-based and hybrid data architecture initiatives (AWS RDS, GCP, Azure).

Qualifications :

- 13+ years of experience in database architecture and design.

- Expertise in OLTP and analytic database design principles.

- Strong skills in SQL performance tuning, indexing, and query optimization.

- Hands-on experience in Oracle and PostgreSQL database administration.

- Deep understanding of partitioning, materialized views, and caching techniques.

- Experience in designing and implementing multi-tenant databases.

- Proficiency in database security, backup, and disaster recovery strategies.

- Experience with database replication techniques (e.g., Oracle GoldenGate, Logical Replication, Streaming Replication).

- Experience in designing and maintaining active-active database architectures for high availability.

- Familiarity with cloud database services (AWS, GCP, Azure).

Preferred Qualifications :

- Experience in data engineering and ETL pipelines (Airflow, Apache Kafka)

- Knowledge of big data technologies (Snowflake, Redshift, BigQuery, Databricks)

- Hands-on experience with NoSQL databases (MongoDB, Cassandra)