The Snowflake DBA (Database Administrator) position is responsible for managing and optimizing databases performance, security, and reliability within the Snowflake Data Cloud platform.
Database Setup and Configuration: o Configuring warehouses, databases, and other Snowflake objects o Ensuring optimal configuration settings for performance and cost-efficiency
Performance Monitoring and Tuning: o Monitoring the performance of Snowflake environments and executing performance tuning strategies to optimize query execution and resource utilization
Data Security and Compliance: o Implementing and managing security measures within Snowflake, including data encryption, access controls, and network policies to protect sensitive information
Backup and Disaster Recovery: o Although Snowflake provides automatic backups and failover capabilities, the DBA is responsible for planning and managing disaster recovery strategies and data retention policies
Cost Management: o Monitoring and optimizing Snowflake credit usage to control costs without compromising performance o Advising on cost-effective use of Snowflake features and resources
User Management and Support: o Managing user accounts, roles, and access privileges to ensure secure and appropriate access to the database
Collaboration and Documentation: o Collaborating with data engineers, analysts, and IT teams to support data-related activities o Documenting database schemas, configurations, procedures, and best practices
12. Skill Sets :
Snowflake experience (3-5 years)
Strong understanding of Snowflakes architecture, including virtual warehouses, databases, roles, and security features
Proficient in SQL for querying and managing Snowflake databases
Skills in query performance tuning and resource optimization in a cloud environment
Experience with DB tools such as DBT and SQLDBM a plus
Knowledge of best practices in data security, encryption, and compliance within cloud environments (e.g. GDPR, StateRAMP, FedRAMP)
Familiarity with cloud services, particularly those related to data storage and computation, and an understanding of cloud cost management
Ability to troubleshoot and resolve database issues efficiently
Db2 experience and/or PostgreSQL (2-5 years)
Ability to establish and maintain effective working relationships
Excellent communication skills are required
Certifications specific to Snowflake, such as the Snowflake SnowPro Core Certification a plus
About Virtusa
Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
