Trellix

Staff Database Engineer

Trellix

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Job Level

Lead

Tech Stack

AnsibleAWSCloudCyber SecurityEC2GreenplumJenkinsLinuxNoSQLPostgresPythonSQL

About the role

  • Improve and maintain software development and database design, test and deliver infrastructure and services
  • Work closely with the development teams, follow DevOps practices, automate infrastructure activities, documents standards and procedures
  • Design and manage PostgreSQL (self hosted and Aurora), and Greenplum, and similar DB clusters, ensuring high availability and disaster recovery resilience
  • Optimize the usage of public cloud based resources to ensure cost-effective and efficient use
  • Monitor and maintain database systems in cloud environments and on-prem, ensuring data security and availability
  • Drive the existing automation frameworks forward to benefit automation across multiple products, and may be asked to create new frameworks depending on need
  • Provide visibility on application health by defining dashboards, metric/log aggregation mechanisms
  • Ensure that the database architecture complies with organizational security policies and best practices
  • Implement database encryption, user management, and access controls
  • Evaluate new technologies and provide proof-of-concept
  • Improve site performance, monitoring and overall stability of our infrastructure
  • Additional duties as assigned

Requirements

  • Strong knowledge of Linux systems administration and architecture
  • Experience with configuring, managing and supporting virtualized environments
  • Experience with continuous integration and deployment automation tools such as Jenkins, Ansible, GitHub Actions, ArgoCD
  • Experience with SQL and NoSQL databases
  • In-depth knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features like triggers, stored procedures, and replication
  • Familiarity with AWS services (Aurora, RDS, EC2, S3, etc.) and cloud database management practices
  • Expertise in tuning PostgreSQL databases for high performance, including memory usage optimization, connection pooling, and query optimization
  • Proficiency in analyzing and resolving database performance issues, especially in high-traffic and high-volume production environments
  • Analyse slow-running or poor performing queries and optimize performance through proper indexing, query restructuring, or caching mechanisms
  • Extensive scripting experience, including extract, transform, and load programs (Python preferred)
  • Experience supporting, analyzing and troubleshooting large-scale distributed mission critical systems