Database Administrator

As a Database Administrator (DBA) at Domo, you will play a crucial role in managing critical components of the SaaS platform by leveraging the power of AWS and other Cloud Data Warehouse providers. Your responsibilities will include: - **Data Modeling and Engineering:** - Design and implement efficient data models to support business requirements. - Create and maintain data pipelines to ensure data integrity and consistency. - Optimize data storage and indexing strategies to improve query performance. - Collaborate with data engineers and analysts to design and implement data solutions. - **Cloud Integration:** - Integrate Cloud Data Warehouses (CDWs) with AWS, Azure, GCP, and OCI services to leverage their capabilities. - Configure and manage cloud resources (VMs, storage, networks) to support CDWs. - Implement automated deployment and provisioning processes using infrastructure as code (IaC) tools. - Monitor cloud costs and optimize resource utilization. - **Performance Optimization:** - Analyze query performance and identify bottlenecks. - Tune queries and optimize database configurations to improve performance. - Implement caching strategies to reduce query execution time. - Monitor resource utilization and adjust resource allocations as needed. - **Security And Compliance:** - Implement robust security measures to protect sensitive data. - Monitor and enforce security policies and procedures. - Conduct regular security audits and vulnerability assessments. - Ensure compliance with industry standards and regulations, including GDPR, HIPAA, and SOC 2. - **Backup And Recovery:** - Implement and maintain backup and recovery strategies. - Test recovery procedures to ensure data integrity. - Implement disaster recovery plans to minimize downtime in case of failures. - **Troubleshooting And Support:** - Diagnose and resolve database issues. - Provide technical support to users. - Collaborate with other teams to ensure smooth operations. **Job Requirements:** - Bachelor's degree in computer science, information systems, or comparable experience. - 5+ years of experience as a Database Administrator. - Strong understanding of cloud data warehouses, features, and best practices. - Proficiency in SQL and Python. - Experience with data modeling and ETL processes. - Knowledge of cloud platforms (AWS and Azure) and their services. - Strong analytical and problem-solving skills. - Excellent communication and interpersonal skills. - Ability to work independently and as part of a team. - Experience with infrastructure as code (IaC) tools like Terraform or CloudFormation. - Understanding of security best practices and compliance standards. - Availability to provide on-call support and handle out-of-band requests. - Familiarity with a wide range of database admin. Please note that Domo is an equal opportunity employer. As a Database Administrator (DBA) at Domo, you will play a crucial role in managing critical components of the SaaS platform by leveraging the power of AWS and other Cloud Data Warehouse providers. Your responsibilities will include: - **Data Modeling and Engineering:** - Design and implement efficient data models to support business requirements. - Create and maintain data pipelines to ensure data integrity and consistency. - Optimize data storage and indexing strategies to improve query performance. - Collaborate with data engineers and analysts to design and implement data solutions. - **Cloud Integration:** - Integrate Cloud Data Warehouses (CDWs) with AWS, Azure, GCP, and OCI services to leverage their capabilities. - Configure and manage cloud resources (VMs, storage, networks) to support CDWs. - Implement automated deployment and provisioning processes using infrastructure as code (IaC) tools. - Monitor cloud costs and optimize resource utilization. - **Performance Optimization:** - Analyze query performance and identify bottlenecks. - Tune queries and optimize database configurations to improve performance. - Implement caching strategies to reduce query execution time. - Monitor resource utilization and adjust resource allocations as needed. - **Security And Compliance:** - Implement robust security measures to protect sensitive data. - Monitor and enforce security policies and procedures. - Conduct regular security audits and vulnerability assessments. - Ensure compliance with industry standards and regulations, including GDPR, HIPAA, and SOC 2. - **Backup And Recovery:** - Implement and maintain backup and recovery strategies. - Test recovery procedures to ensure data integrity. - Implement disaster recovery plans to minimize downtime in case of failures. - **Troubleshooting And Support:** - Diagnose and resolve database issues. - Provide technical support to users. - Collaborate with other teams to ensure smooth operations. **Job Requirements:** - Bachelor's degree in computer science, informati