Database Architect

Company:  Eclypsium
Location: Portland
Closing Date: 01/11/2024
Salary: £150 - £200 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description

Database Architect

We are looking for an experienced Database Architect to join our team. The ideal candidate will be able to work in a fast paced environment, operate gracefully under stress, effectively manage multiple assignments, be self-driven, proactive and have great interpersonal and communication skills.

As a Database Architect, you will play a vital role in designing, developing, and maintaining the underlying database architecture that powers our cybersecurity SaaS platform. You will collaborate with data engineers, developers, and other stakeholders to ensure the optimal performance, scalability, security, and integrity of our data storage and processing systems. This role requires a strong technical background in database technologies, data modeling, and performance optimization, as well as a passion for designing elegant and efficient solutions to complex data challenges.

Role & Responsibilities

Database Architecture Design:

  1. Design and implement scalable, high-performance database architectures that meet the evolving needs of our cybersecurity SaaS applications.
  2. Evaluate and select appropriate database technologies (e.g., PostgreSQL, MongoDB, Google BigQuery) based on specific use cases and requirements.
  3. Create and maintain comprehensive data models that accurately represent business requirements and support efficient data access patterns.

Performance Optimization:

  1. Monitor database performance, identify bottlenecks, and implement optimizations to ensure optimal query response times and resource utilization.
  2. Develop and enforce database performance standards and best practices.
  3. Proactively identify and address potential performance issues before they impact production environments.

Data Integrity and Security:

  1. Implement robust security measures to protect sensitive data, ensuring compliance with industry regulations and company policies.
  2. Design and maintain backup and recovery strategies to prevent data loss and ensure business continuity.
  3. Develop and enforce data governance policies and procedures to maintain data quality and integrity.

Collaboration and Support:

  1. Collaborate closely with data engineers, developers, and other stakeholders to understand their data needs and provide effective solutions.
  2. Provide technical guidance and support to development teams on database best practices and optimization techniques.
  3. Participate in code reviews and architecture discussions to ensure the optimal use of database resources.

Minimum Qualifications

Experience

  1. 5+ years of experience in database administration or engineering.
  2. Proven track record of designing and implementing database solutions for high-traffic applications.
  3. Strong experience with PostgreSQL, MongoDB, and/or Google BigQuery.
  4. Familiarity with data modeling tools and techniques.

Skills:

  1. Deep understanding of database design principles, including normalization, indexing, and query optimization.
  2. Strong SQL skills and experience with query performance tuning.
  3. Knowledge of data warehousing concepts and ETL/ELT processes.
  4. Experience with database administration tasks, such as backup, recovery, and security management.
  5. Excellent communication and collaboration skills, with the ability to explain technical concepts to non-technical audiences.

Education:

  1. Bachelor's degree in Computer Science, Engineering, or a related field.

Bonus Points:

  1. Experience with cloud infrastructure (e.g., GCP).
  2. Familiarity with containerization (e.g., Docker) and orchestration (e.g., Kubernetes).
  3. Knowledge of cybersecurity principles and best practices.
  4. Experience with data visualization tools (e.g., Tableau, Looker).

Required Technical Skills

Database Technologies

  1. Expert: PostgreSQL, MongoDB
  2. Proficient: Google BigQuery
  3. Bonus: Experience with other database technologies like MySQL, Cassandra, Redis, or Elasticsearch

Cloud Infrastructure

  1. Expert: Google Cloud Platform (GCP)
  2. Proficient: On-premises infrastructure (Linux/Unix administration)
  3. Bonus: Experience with other cloud providers (AWS, Azure) or hybrid cloud environments

Data Modeling and Design

  1. Expert: Conceptual, logical, and physical data modeling
  2. Proficient: Normalization, denormalization, data dictionary creation, and database schema design
  3. Bonus: Experience with data modeling tools (e.g., ERwin, ER/Studio)

Query Languages and Optimization

  1. Expert: SQL
  2. Proficient: Query performance tuning, indexing strategies, explain plans
  3. Bonus: Experience with NoSQL query languages (e.g., MongoDB Query Language) or graph query languages (e.g., Cypher)

ETL/ELT Processes

  1. Proficient: Understanding of ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes
  2. Bonus: Experience with ETL/ELT tools (e.g., Apache Airflow, Stitch)

Security

  1. Proficient: Data encryption (at rest and in transit), access controls, auditing, security best practices
  2. Bonus: Experience with data masking, tokenization, or anonymization techniques

Programming and Scripting

  1. Proficient: Python, Bash (or other shell scripting)
  2. Bonus: Experience with other languages relevant to database development and administration (e.g., Java, Go)

Additional Skills (Nice to have)

  1. Data warehousing concepts and design
  2. Data visualization tools (e.g., Tableau, Looker)
  3. Familiarity with Infrastructure as Code (IaC) tools like Terraform
  4. Experience with monitoring tools (e.g., Prometheus, Grafana)

Soft Skills

  1. Strong analytical and problem-solving skills
  2. Excellent communication and collaboration skills
  3. Ability to work independently and as part of a team

About Eclypsium

Eclypsium is a supply chain security platform that builds trust in every device by identifying, verifying and fortifying software, firmware and hardware throughout enterprise infrastructure. Eclypsium’s SaaS platform does this by integrating the bill of materials from suppliers and continuously monitoring to independently assess risk of each critical asset from chip to cloud, throughout the life cycle, and across enterprise ecosystems. Protecting Fortune 100 enterprises and federal agencies, Eclypsium has been named a Gartner Cool Vendor in Security Operations and Threat Intelligence. A TAG Cyber Distinguished Vendor, one of the World’s 10 Most Innovative Security Companies by Fast Company, a CNBC Upstart 100, a CB Insights Cyber Defender, and an RSAC Innovation Sandbox finalist. For more information, visit eclypsium.com .

Benefits

Eclypsium headquarters are located in Portland, OR with distributed remote employees and global teams in Argentina and Asia. We offer competitive compensation and benefits packages and are committed to the well-being of our employees and their families.

  • Benefits & Perks include:
  • Competitive compensation & startup equity
  • Comprehensive medical, dental, and vision coverage
  • Life insurance, short-term, and long-term disability coverage
  • Flexible time off
  • Employee assistance program
  • 12 week paid parental leave
  • Paid sabbatical
  • Company sponsored 401K plan
  • 12 Paid Holidays
  • Bonusly Rewards Program

Equal Opportunity

Eclypsium is an equal opportunity employer. We believe in the importance of diverse teams and value candidates of all backgrounds. We do not discriminate on the basis of age, ancestry, citizenship, color, ethnicity, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or invisible disability status, political affiliation, veteran status, race, religion, or sexual orientation.

#J-18808-Ljbffr
Apply Now
Share this job
Eclypsium
  • Similar Jobs

  • Principal Database Administrator

    Portland
    View Job
  • Senior Database Admin

    Portland
    View Job
  • Manager, SQL Database Administration

    Portland
    View Job
  • UX Architect

    Portland
    View Job
  • Senior Manager, Software Engineering- Database Platform

    Portland
    View Job
An error has occurred. This application may no longer respond until reloaded. Reload 🗙