Duration:
6 months to start
Job Description
We are seeking an experienced Snowflake\SQL Database Administrator (DBA) to join our team and manage, optimize, and maintain our database platforms. As a Snowflake\SQL DBA, you will play a critical role in the administration of corporate databases, ensuring performance, scalability, and security for our data infrastructure.
Key Responsibilities:
- Administer and manage Snowflake\SQL databases to ensure availability, integrity, and security.
- Ensure proper backup and recovery procedures for all databases.
- Implement, monitor, and optimize database performance for query optimization.
- Implement best practices for database tuning, partitioning, and indexing.
- Manage database access controls, user roles, and permissions.
- Collaborate with developers, data engineers, and business intelligence teams to support data integration and analytics needs.
- Provide technical support and troubleshooting
- Work with the team to ensure smooth data pipeline operations and integrate with other data sources and platforms.
- Proven experience as a Snowflake\SQL DBA or Database Administrator.
- Expertise in Snowflake\SQL optimization techniques.
- Proficiency in Snowflake\SQL, including complex queries and performance tuning.
- Experience with Snowflake\SQL security features, including role-based access control (RBAC), data masking, and encryption.
- Familiarity with ETL processes and data integration tools (e.g., Talend, Informatica).
- Strong understanding of database performance monitoring, query optimization, backup and restore techniques.
- Ability to work with cloud platforms.
- Certifications in Snowflake or other cloud data platforms (Azure).
- Knowledge of scripting languages like Python or PowerShell for automation.
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Relevant certifications (e.g., Snowflake\Microsoft SQL Certified Professional) are a plus.