Numentica · 9 hours ago
Senior PostgreSQL Architect
Pasadena, CA
Full-time
Remote
Senior Level, Lead/Staff
8+ years exp
Maximize your interview chancesAnalyticsBusiness Intelligence
Insider Connection @Numentica
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design and implement scalable, high-performance PostgreSQL database architectures.
Develop schema designs that balance performance, scalability, and reliability.
Ensure database solutions align with business goals and technical requirements.
Analyze and optimize complex SQL queries, indexes, and database performance.
Identify and resolve performance bottlenecks in existing systems.
Implement partitioning, sharding, and other techniques to handle large-scale data sets.
Ensure compliance with security standards and data protection regulations.
Implement database access controls, encryption, and backup strategies.
Perform regular security audits and vulnerability assessments.
Design and manage PostgreSQL databases in cloud environments (AWS, Azure, GCP).
Leverage cloud-native tools for scaling, monitoring, and disaster recovery.
Collaborate with development teams to design and implement database solutions.
Provide guidance and mentorship to junior database engineers and administrators.
Work closely with DevOps teams to automate database deployment and maintenance.
Develop and maintain comprehensive database documentation.
Promote best practices in database development and management.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
8+ years of experience in database architecture, with a focus on PostgreSQL.
Proven expertise in designing and managing large-scale PostgreSQL databases.
Experience in cloud-based database management and tools (AWS RDS, Aurora, etc.).
Deep understanding of PostgreSQL internals, performance tuning, and optimization.
Proficient in SQL, PL/pgSQL, and database modeling.
Familiarity with tools like pgAdmin, pgBouncer, and replication techniques.
Experience with ETL processes and integrating PostgreSQL with data pipelines.
Knowledge of high availability, clustering, and disaster recovery solutions.
Strong problem-solving skills and attention to detail.
Excellent communication and ability to translate technical concepts to stakeholders.
Leadership and mentoring experience in a technical setting.
Preferred
Experience with NoSQL and hybrid database solutions.
Certifications in PostgreSQL or cloud platforms (e.g., AWS Certified Database – Specialty).
Knowledge of containerization (Docker, Kubernetes) and Infrastructure-as-Code tools.
Benefits
Competitive compensation and benefits package
Company
Numentica
Numentica is a data consulting and management firm that provides software product development, business intelligence, and data management.
201-500 employees
H1B Sponsorship
Numentica has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (9)
2022 (16)
2021 (11)
2020 (9)
Funding
Current Stage
Growth StageLeadership Team
Siva Periasamy
Co-Founder & President
Company data provided by crunchbase
