Talent.com
No longer accepting applications
Principal Database Architect

Principal Database Architect

ConfidentialBengaluru, Republic Of India, IN
12 days ago
Job description

Senior PostgreSQL DB Admin

About the Role :

We are seeking a highly skilled Senior PostgreSQL Database Administrator to setup, manage, optimize, and support our PostgreSQL databases in a mission-critical, high-performance environment. The ideal candidate will have deep expertise in database tuning, backups, high availability, monitoring and automation.

As a key member of the data team, you will collaborate closely with business stakeholders, cross-functional data teams, and subject matter experts (SMEs) to implement data solutions that support data-driven decision-making at scale.

Key Responsibilities :

PostgreSQL Management :

  • Work with very large datasets (hundreds of millions of records) efficiently and reliably.
  • Expertise in PostgreSQL clustering, replication and high-availability configurations
  • Familiarity with PostgreSQL backups, recovery procedures and disaster recovery strategies.
  • Experience in managing and optimizing PostgreSQL database performance, including query optimization, indexing and partitioning.
  • Lead efforts to harden PostgreSQL environments against internal and external threats
  • Define and enforce database security policies, including role-based access control, encryption, and auditing

Governance & Standards :

  • Promote and enforce Data Governance , Data Quality , and Model Governance practices across critical data projects.
  • Work with stakeholders to ensure the application of Data Architecture Policies , Standards , and Guiding Principles in all data-related projects.
  • Ensure the Reference Architecture is adhered to by all teams.
  • Collaboration & Consultation :
  • Act as a Data and Model Governance Consultant , educating internal teams on data governance, architecture principles, and best practices.
  • Provide technical guidance and support to data engineering teams to ensure compliance with Data & Analytics Principles in areas like new dataset creation, pipeline design, and data integration.
  • Technical Documentation :

  • Write detailed design specifications and documentation to clearly communicate architectural and modelling decisions.
  • Demonstrate design and technology approaches through prototypes and proofs of concept.
  • Continuously assess and recommend opportunities for Database Optimization to Ensure Low Latency
  • Work closely with cross-functional data owners, SMEs, and teams to monitor and manage Data Health .
  • Cloud and AI / ML Exposure (Nice to Have) :
  • Work on cloud-based data architectures, ensuring integration and alignment with modern cloud technologies (AWS, Azure, or GCP).
  • Exposure to AI / ML frameworks and support integration of advanced analytics into the data platform.
  • Experience with Modern data platforms such as Databricks, Snowflake.
  • Stakeholder Management :

  • Strong Communication skills and ability to Build strong relationships with business and technical stakeholders to understand business needs and deliver data solutions that support organizational goals.
  • Communicate complex data architecture concepts clearly and effectively to both technical and non-technical stakeholders.
  • About Candidate :

    You are an experienced PostgreSQL Database Administrator with a proven track record of designing implementing, maintaining and optimising data solutions at an enterprise scale. You are a problem solver who thrives in a collaborative environment and can effectively manage multiple stakeholders across the organization.

    Qualifications : Experience :

  • Minimum of 10+ years of experience in data, digital, technology or analytical roles.
  • Expertise in installing, configuring, securing and maintaining PostgreSQL databases.
  • Deep understanding of networking concepts, including setting up PostgreSQL replication (master-slave, master-master), failover and clustering.
  • Expertise in query performance tuning, using tools like pg_stat_statements, EXPLAIN ANALYZE and server settings to optimize database performance. Experience with PostgreSQL-specific tools such as pgAdmin, pgBouncer, pgBadger, pg_repack etc.
  • Install and configure new database servers using best practices. Knowledge of High Availability (HA) and Disaster Recovery (DR). Upgrade minor and major versions.
  • DB Backup and Recovery Activities such as Ensure all database servers are backed up. Perform restoration testing. Follow Industry Best Practices.
  • Define and implement maintenance plans for database systems. Standardize maintenance approaches across systems. Index and statistics maintenance.
  • Proactively identify, troubleshoot, and resolve live database system issues. Capacity planning and forecasting. Creating and reviewing data access audits. Tracking and reporting on Recovery Point Objectives (RPO) metrics.
  • Identification of queries having the largest performance impact.
  • Improvements to indexes and execution plans. Troubleshoot transaction and concurrency issues. Assist developers with query optimization.
  • Create documentation on processes and procedures. Providing training for developers and other technical resources.
  • Collaborate with DevOps and application teams to optimize query performance and database architecture
  • Conduct regular security assessments, patching, and vulnerability remediation
  • Provide expert-level troubleshooting and root cause analysis for database-related incidents
  • Experience in Cloud Architecture (Azure)
  • Technical Skills :

  • Strong knowledge of Database Administration, Governance a nd Data Modelling best practices.
  • Hands-on expertise in Cloud-based Architecture on Azure.
  • Experience in integrating AI / ML frameworks into data platforms. (Good to have)
  • Ability to write clear design specifications and technical documentation.
  • Proven ability to mentor and guide teams on Data Architecture Principles .
  • Certifications :

    Relevant certifications in Cloud-based Architecture (Azure) are a plus.

    Create a job alert for this search

    Principal Architect • Bengaluru, Republic Of India, IN

    Related jobs
    • Promoted
    Database Architect (DB2, Sybase, Cassandra, SQL, Oracle)

    Database Architect (DB2, Sybase, Cassandra, SQL, Oracle)

    Voya IndiaBengaluru, Karnataka, India
    Database Architect (DB2, Sybase, Cassandra, SQL, Oracle).Lead the database architecture and strategy across multi-platform database systems, with a focus on Azure cloud solutions.Provide hands-on l...Show moreLast updated: 7 days ago
    • Promoted
    Lead Oracle Database Administrator

    Lead Oracle Database Administrator

    Atyeti IncBengaluru, Karnataka, India
    Expertise in managing multiple oracle 11g,12c, & 19c databases on medium to large systems.Expertise in managing databases in Exadata. Expertise in ASM management is must.TDE, SSL, TLS and other DB s...Show moreLast updated: 2 days ago
    • Promoted
    • New!
    Senior Principal- Solutions Architect

    Senior Principal- Solutions Architect

    LTIMindtreehosur, tamil nadu, in
    Lead Solutions Architect – AI Infrastructure & Private Cloud.High Performance Computing (HPC).Enterprise AI Factory Solutions. This role is instrumental in architecting, deploying, and optimizing pr...Show moreLast updated: 22 hours ago
    • Promoted
    • New!
    Senior Data Architect- Snowflake

    Senior Data Architect- Snowflake

    USEReadyhosur, tamil nadu, in
    USEReady is a data and analytics firm that provides the strategies, tools, capability, and capacity that businesses need to turn their data into a competitive advantage. USEReady partners with cloud...Show moreLast updated: 22 hours ago
    • Promoted
    Cloud Data Architect (Azure / AWS)

    Cloud Data Architect (Azure / AWS)

    BrillioBengaluru, Karnataka, India
    The ideal candidate is passionate about learning, data, scalability, and agility.You'll leverage your strong collaboration skills and data architecture expertise, along with a deep understanding of...Show moreLast updated: 14 days ago
    • Promoted
    Data Architect

    Data Architect

    Recrohosur, tamil nadu, in
    Central Data Office – Data Architect.SMEs, engineers, and developers to design and govern enterprise-level data architectures, ensuring alignment with corporate data principles and standards.This p...Show moreLast updated: 17 days ago
    • Promoted
    • New!
    Database Administrator

    Database Administrator

    HCLTechhosur, tamil nadu, in
    We are seeking for skilled and experienced.A Teradata Administrator will be responsible for managing and maintaining Teradata database systems to ensure optimal performance, security, and availabil...Show moreLast updated: 22 hours ago
    • Promoted
    • New!
    SQL Database Administrator

    SQL Database Administrator

    HCLSoftwarehosur, tamil nadu, in
    MS SQL Database Support Engineer.The MS SQL Database Support Engineer is a.Microsoft SQL Server database environments.This role acts as the final escalation point for the most complex, critical, an...Show moreLast updated: 22 hours ago
    • Promoted
    Solution Architect - Database

    Solution Architect - Database

    Jio Platforms Limited (JPL)bangalore district, karnataka, in
    We are looking for Solution Architects for designing data management solutions, having strong knowledge of architecting and designing highly available and scalable database on cloud • He will deliv...Show moreLast updated: 16 days ago
    • Promoted
    Data Architect

    Data Architect

    Andelahosur, tamil nadu, in
    Andela exists to connect brilliance and opportunity.Since 2014, we have been dedicated to breaking down global barriers and accelerating the future of work for both technologists and organizations ...Show moreLast updated: 3 days ago
    • Promoted
    • New!
    Architect

    Architect

    Kumaran Systemshosur, tamil nadu, in
    We are seeking a highly skilled.The ideal candidate will be responsible for designing scalable systems, analyzing existing architectures, and delivering robust, cloud-native solutions.This role req...Show moreLast updated: 22 hours ago
    • Promoted
    Database Architect

    Database Architect

    RAPIDD TechnologiesBengaluru, Karnataka, India
    We are seeking a talented and experienced Database Architect to join our international development team.You will work on development of solutions for various industries such as news and media, spor...Show moreLast updated: 14 days ago
    • Promoted
    Associate Director, Data Architecture (Snowflake • Databricks • AWS • CPG / FMCG • Enterprise Data)

    Associate Director, Data Architecture (Snowflake • Databricks • AWS • CPG / FMCG • Enterprise Data)

    Sky Systems, Inc. (SkySys)hosur, tamil nadu, in
    Associate Director, Data Architecture.Full-Time Contract (40hrs / week).Months+ (with a possibility of Contract-to-Hire). Marketing, Product, Finance, Supply Chain, and global business teams.This role...Show moreLast updated: 1 day ago
    • Promoted
    Engineer - Databases [Returnship Program]

    Engineer - Databases [Returnship Program]

    KenvueVadigenhalli, Karnataka, India
    Kenvue is currently recruiting for a : .Engineer - Databases [Returnship Program].At Kenvue , we realize the extraordinary power of everyday care. Built on over a century of heritage and rooted in sc...Show moreLast updated: 2 days ago
    • Promoted
    Principal Architect

    Principal Architect

    BrillioBengaluru, Karnataka, India
    Brillio is the partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Backed by Bain Capital private equity, a...Show moreLast updated: 30+ days ago
    • Promoted
    Database (Oracle EBS – DBA Architect)

    Database (Oracle EBS – DBA Architect)

    Zenith Services Inc.Bangalore, IN
    Role : Senior Consultant – Database (Oracle EBS – DBA Architect).This role demands deep technical expertise, customer-facing ability, and flexibility to support mission-critical systems in a 24×7 en...Show moreLast updated: 1 day ago
    • Promoted
    • New!
    Cloud Architect

    Cloud Architect

    AventIQhosur, tamil nadu, in
    AventIQ is a leading software development company specializing in Robotic Process Automation (RPA) to revolutionize businesses through cutting-edge automation technologies.Our mission is to deliver...Show moreLast updated: 22 hours ago
    • Promoted
    • New!
    Azure + Mongo- Data Architect

    Azure + Mongo- Data Architect

    People Prime Worldwidehosur, tamil nadu, in
    Our client is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies.Powered by mo...Show moreLast updated: 22 hours ago