Trellix
Overview
Role Overview: We are hiring for a DevOps DBA Engineer who will improve and maintain software development and database design, test and deliver infrastructure and services. About the Role
Design and manage PostgreSQL (self hosted and Aurora), and Greenplum, and similar DB clusters, ensuring high availability and disaster recovery resilience. Automate infrastructure activities, follow DevOps practices, document standards and procedures, and work closely with development teams. 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 existing automation frameworks forward and create new frameworks as needed to benefit automation across multiple products. Provide visibility on application health by defining dashboards and 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. Ability to learn new tools and quickly become a subject matter expert. Improve site performance, monitoring and overall stability of our infrastructure. Evaluate new technologies and provide proof-of-concept. Additional duties as assigned. About You / Qualifications
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 poorly 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. Benefits
Retirement Plans Medical, Dental and Vision Coverage Paid Time Off Paid Parental Leave Support for Community Involvement We prohibit discrimination and harassment based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status.
#J-18808-Ljbffr
Role Overview: We are hiring for a DevOps DBA Engineer who will improve and maintain software development and database design, test and deliver infrastructure and services. About the Role
Design and manage PostgreSQL (self hosted and Aurora), and Greenplum, and similar DB clusters, ensuring high availability and disaster recovery resilience. Automate infrastructure activities, follow DevOps practices, document standards and procedures, and work closely with development teams. 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 existing automation frameworks forward and create new frameworks as needed to benefit automation across multiple products. Provide visibility on application health by defining dashboards and 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. Ability to learn new tools and quickly become a subject matter expert. Improve site performance, monitoring and overall stability of our infrastructure. Evaluate new technologies and provide proof-of-concept. Additional duties as assigned. About You / Qualifications
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 poorly 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. Benefits
Retirement Plans Medical, Dental and Vision Coverage Paid Time Off Paid Parental Leave Support for Community Involvement We prohibit discrimination and harassment based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status.
#J-18808-Ljbffr