Senior Database Architect

Job Description

Key Responsibilities :

• Database Architecture & Design : Design large-scale database architectures for both operational and analytical systems (OLTP & OLAP); Develop database schema blueprints, entity relationship models, indexing strategies, and partitioning approaches; Design data flows and replication topologies across systems (microservices, DWH, real-time pipelines); Define naming conventions, data modeling standards, and comprehensive documentation.
• Performance & Scalability : Analyze and optimize query performance, indexing, and storage layers; Implement sharding, caching (Redis), and read replica strategies to achieve high scalability; Develop and monitor capacity planning and long-term data growth projections.
• High Availability & Disaster Recovery : Design HA/DR systems using techniques such as streaming replication, failover clustering, and backup rotation; Define RTO/RPO targets in alignment with business SLAs; Conduct periodic disaster recovery tests to ensure system resilience.
• Data Governance & Security : Implement data encryption, access control, and auditing policies; Ensure compliance with security standards such as GDPR, ISO 27001, and PCI DSS; Collaborate with the DevSecOps team to maintain data security and privacy.
• Integration & Cloud Infrastructure : Design data integration across platforms (PostgreSQL, BigQuery, Redis, Kafka, RabbitMQ, etc.); Experienced in working with Cloud Platforms such as GCP, AWS, and Azure; Implement CDC pipelines and real-time synchronization across data systems.
• Leadership & Collaboration : Provide technical direction to DBA, Data Engineer, and Developer teams; Collaborate with application and infrastructure architecture teams to design end-to-end systems; Develop database architecture documentation and best practice guidelines.

Requirement :

• Bachelor’s degree or higher in Computer Science, Information Systems, or related field.
• Minimum 8+ years of experience in database design, development, and administration.
• Proven experience in architecting large-scale and high-performance database systems (OLTP & OLAP).
• Deep understanding of relational and non-relational databases, such as PostgreSQL, MySQL, MongoDB, and Redis.
• Hands-on experience with data warehousing (e.g., BigQuery, Snowflake, Redshift) and ETL/ELT pipeline design.
• Strong knowledge of database performance tuning, indexing, query optimization, and partitioning.
• Experience implementing high availability (HA) and disaster recovery (DR) strategies (e.g., replication, failover, backup/restore).
• Skilled in data modeling (conceptual, logical, and physical) and schema versioning.
• Familiar with real-time data streaming technologies such as Kafka or RabbitMQ.
• Understanding of cloud-based database services (GCP Cloud SQL/BigQuery, AWS RDS/Redshift, Azure SQL).
• Proficiency in scripting and automation using SQL, Python, or Shell scripting.
• Knowledge of data governance frameworks, data retention, and archival strategies.
• Experience in implementing data encryption, access control, auditing, and compliance with standards such as GDPR, ISO 27001, or PCI DSS.
• Ability to design scalable, fault-tolerant, and secure data architectures supporting microservices and analytics workloads.
• Experience designing data replication and synchronization topologies across multiple systems.
• Strong understanding of API-based data integration and event-driven architecture.
• Excellent communication and documentation skills to define and maintain database architecture blueprints and best practices.
• Ability to lead and mentor DBA, Data Engineer, and Developer teams.
• Proven experience collaborating with cross-functional teams (application, infrastructure, and DevSecOps).

Are you interested in this position?

Apply by clicking on the “Apply Now” button below!

#GraphicDesignJobsOnline

#WebDesignRemoteJobs #FreelanceGraphicDesigner #WorkFromHomeDesignJobs #OnlineWebDesignWork #RemoteDesignOpportunities #HireGraphicDesigners #DigitalDesignCareers# Dynamicbrand guru