Senior PostgreSQL Database Expert

6 days ago

Pasadena, California, United States Numentica LLC Full time

We are seeking a highly skilled Senior PostgreSQL Architect to lead our database strategy, design, and implementation of scalable, secure, and efficient database solutions. This role involves overseeing database architecture, optimizing performance, ensuring data security, and collaborating across teams to support business needs.

Key Responsibilities:
  • Database Architecture and Design:
    • 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.
  • Performance Tuning and Optimization:
    • 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.
  • Database Security and Compliance:
    • Ensure compliance with security standards and data protection regulations.
    • Implement database access controls, encryption, and backup strategies.
    • Perform regular security audits and vulnerability assessments.
  • Cloud Integration and Management:
    • Design and manage PostgreSQL databases in cloud environments (AWS, Azure, GCP).
    • Leverage cloud-native tools for scaling, monitoring, and disaster recovery.
  • Team Leadership and Collaboration:
    • 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.
  • Documentation and Best Practices:
    • Develop and maintain comprehensive database documentation.
    • Promote best practices in database development and management.

The ideal candidate has extensive expertise in PostgreSQL, database design principles, and a strong understanding of cloud-based and on-premises environments.

Requirements:
  • 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.

We offer a competitive compensation package, including a salary range of $180,000 - $250,000 per year, depending on experience.

  • PostgreSQL Solutions Architect

    6 days ago

    Pasadena, California, United States Numentica LLC Full time

    We are seeking a highly skilled Senior PostgreSQL Architect to lead our database strategy and implement scalable, secure, and efficient database solutions. This role involves designing database architectures, optimizing performance, ensuring data security, and collaborating across teams to support business needs.The ideal candidate has extensive expertise in...

  • Senior System Infrastructure Specialist

    4 days ago

    Pasadena, California, United States Punchcard Full time

    About the RoleUberMedia is seeking a skilled Senior System Administrator to join our team. As a Senior System Administrator, you will be responsible for designing, implementing, and maintaining our technology infrastructure.Key Responsibilities:Design and implement current and new technology infrastructurePerform production application deploymentParticipate...

  • Benefits and Compliance Expert

    6 days ago

    Pasadena, California, United States ACC - Association of Corporate Counsel Full time

    Job SummaryWe are seeking an experienced Benefits Staff Counsel to join our team at the Los Angeles County Employees Retirement Association (LACERA). The successful candidate will provide expert legal advice and representation on benefits-related matters.About UsLACERA is a leading retirement association in the United States, serving over 188,000 members...

  • Senior Technology Solutions Specialist

    6 days ago

    Pasadena, California, United States Alcala Consulting, Inc. Full time

    About the RoleAlcala Consulting, Inc. is seeking a highly skilled Senior Technology Solutions Specialist to join our team. This role offers a competitive salary of $70,000 per year and is an excellent opportunity for professionals who want to make a meaningful impact in their careers.Job ResponsibilitiesThe Senior Technology Solutions Specialist will be...

  • Senior Financial Analyst

    7 days ago

    Pasadena, California, United States Wescom Central Credit Union Full time

    Job SummaryWe are seeking an experienced Senior Financial Analyst to join our team at Wescom Central Credit Union. In this role, you will be responsible for producing and analyzing complex financial reports to support profitability and financial reporting functions.About the RoleCoordinate and distribute financial data to junior staffConduct performance and...

  • Senior Lawyer Advocate

    2 days ago

    Pasadena, California, United States Direct Counsel, LLC Full time

    Job Title: Senior Lawyer AdvocateAbout the Position:Direct Counsel, LLC is partnering with a reputable law firm to find a Senior Lawyer Advocate. This role is critical for overseeing all assigned client cases, encompassing case research, client relationship management, diligent counsel, intra-firm coordination, and achieving favorable case outcomes.The...

  • Senior Retirement Planning Analyst

    6 days ago

    Pasadena, California, United States Shuster Advisory Group, LLC Full time

    Job OverviewWe are seeking a detail-oriented and analytical individual to join our team as a Senior Retirement Planning Analyst. This role will be responsible for analyzing and integrating data from various sources to provide comprehensive presentations and reports.ResponsibilitiesDevelop and maintain databases and spreadsheets to analyze retirement plan...

  • Senior Software Engineer

    6 days ago

    Pasadena, California, United States Avani Technology Solutions Full time

    We are seeking a highly skilled Senior .NET Programmer to join our team at Avani Technology Solutions. This is a full-time position that requires a minimum of 4-6 years of experience in software development.About the RoleThis Senior Software Engineer will be responsible for designing, developing, and maintaining complex software applications using C#/.NET,...

  • Senior Biometric Software Architect

    3 days ago

    Pasadena, California, United States ZipRecruiter Full time

    Job SummaryWe are seeking an experienced Senior Biometric Software Architect to join our team at PopID, Inc. in Pasadena, CA. As a key member of our engineering team, you will be responsible for designing and leading the development of complex integrated systems involving biometric authentication, payment tokenization, risk management, and data...

  • Senior Technical Support Specialist

    6 days ago

    Pasadena, California, United States Alcala Consulting, Inc. Full time

    Job SummaryWe are seeking a highly skilled Senior Technical Support Specialist to join our team at Alcala Consulting, Inc. As a key member of our technical support team, you will be responsible for providing advanced level installation, support, and maintenance of servers, core infrastructure, and other computer systems.This is a fantastic opportunity for an...

  • Senior Financial Reporting Specialist with Bank Experience

    4 weeks ago

    Pasadena, California, United States Vertical Careers, Inc. Full time

    Job SummaryWe are seeking a highly skilled Senior Financial Reporting Specialist to join our team at Vertical Careers, Inc. This is an exceptional opportunity for an experienced professional to leverage their knowledge of financial reporting regulations and standards to drive business growth and success.### Key Responsibilities* Prepare and review complex...

  • Senior Foreign Exchange Specialist

    7 days ago

    Pasadena, California, United States First Citizens Bank Full time

    Job OverviewThis is a unique opportunity to join First Citizens Bank as a Senior Foreign Exchange Specialist. As a key member of our team, you will be responsible for promoting and selling Foreign Exchange services through personal sales efforts and relationship business banking development.About the RolePromote FX services to existing and potential...

  • Senior Account Manager

    3 weeks ago

    Pasadena, California, United States Shuster Advisory Group, LLC Full time

    Job DescriptionAbout Shuster Advisory Group, LLC:We are a leading provider of comprehensive employee benefits solutions, dedicated to delivering exceptional service to our clients. Our goal is to help businesses design and implement benefits programs that align with their goals and enhance employee satisfaction.Position Overview:The Senior Account Manager -...

  • Senior Wealth Management Advisor

    2 weeks ago

    Pasadena, California, United States East West Bank Full time

    Company OverviewEast West Bank is a leading financial institution dedicated to providing exceptional service and innovative solutions to its clients. With a strong presence in the market, we are committed to delivering top-notch financial services that meet the evolving needs of our customers.About the RoleWe are seeking a highly skilled and experienced...

  • Head of Data Engineering Lead

    6 days ago

    Pasadena, California, United States Deep 6 AI Full time

    Job Title:Head of Data EngineeringAbout the Role:At Deep 6 AI, we are seeking a seasoned data engineering leader to spearhead the continued development and application of our data engineering platform.Key Responsibilities:Lead the continued development and enhancement of our clinical data ingestion and comprehension pipeline.Drive the utilization of core...

  • Senior Traveling Medical Nurse

    5 days ago

    Pasadena, California, United States Aequor Healthcare Full time

    About the RoleAequor Healthcare is seeking an experienced Senior Traveling Medical Nurse to join their team as a Labor and Delivery Specialist. This 13-week contract offers a unique opportunity for a skilled RN to provide high-quality patient care in a dynamic environment.Key Responsibilities:Provide expert nursing care to patients in the labor and delivery...

  • Senior Cardiovascular Care Coordinator

    6 days ago

    Pasadena, California, United States HCA Houston Healthcare Southeast Full time

    HCA Houston Healthcare Southeast is a leading healthcare provider dedicated to delivering exceptional patient care. Our team of experts is committed to providing a supportive and inclusive work environment that fosters growth and development.Job SummaryWe are seeking a highly skilled Registered Nurse to join our Cardiovascular unit. As a Senior...

  • Principal Engineer

    2 days ago

    Pasadena, California, United States System One Full time

    System One is seeking a highly skilled Senior Structural Engineer to assist in the development of comprehensive survey reports and provide expert recommendations based on site surveys. The selected candidate will play a key role in preparing tower condition assessments, collaborating with internal teams, and ensuring high-quality deliverables.About UsWe are...

  • Hydraulic Engineering Expert Wanted

    6 days ago

    Pasadena, California, United States GEI Consultants Full time

    Job SummaryWe are seeking a highly skilled Hydraulic Engineer to join our team at GEI Consultants. This role involves providing expertise in the design, analysis, and construction of hydraulic structures, including dams, spillways, and water conveyance systems.About GEI ConsultantsGEI Consultants is a leading engineering firm with nearly 60 offices across...

  • Senior Civil Engineer and Water Project Lead

    6 days ago

    Pasadena, California, United States Stantec Full time

    About StantecStantec is a global consulting engineering firm that specializes in water resources projects. Our team of experts works together to deliver innovative solutions for communities around the world.