Database administrator

Job Description/Responsibilities:

As a Snowflake Database Administrator (DBA), you will be responsible for managing and maintaining the Snowflake cloud data platform to ensure its optimal performance, reliability, and security.

Responsibilities:

o Set up and configure Snowflake databases according to business requirements, including storage, compute resources, and access controls.

o Monitor database performance metrics and proactively identify and address performance bottlenecks.

o Tune database configurations for optimal performance and scalability.

o Implement and maintain security measures to protect sensitive data stored in Snowflake databases.

o Develop and maintain backup and recovery strategies to ensure data integrity and availability in the event of system failures or disasters.

o Collaborate with data engineers and developers to design and implement data integration pipelines between Snowflake and other systems.

o Ensure data consistency and integrity across different data sources.

o Provide support for database-related issues and incidents, including troubleshooting performance problems, resolving data corruption issues, and coordinating with Snowflake support as needed.

o Develop and maintain scripts and automation tools to streamline routine tasks such as database provisioning, monitoring, and maintenance.

o Monitor database usage trends and forecast future resource requirements. Plan and implement capacity scaling strategies to accommodate growing data volumes and user loads.

Requirements:

- Bachelor's degree in Computer Science, Information Technology, or related field.

- Proven experience as a database administrator, preferably with expertise in managing Snowflake databases.

- Strong understanding of cloud computing concepts and experience with cloud data platforms (e.g., AWS, Azure, Google Cloud).

- Proficiency in SQL and experience with database query optimization.

- Knowledge of data modeling and schema design principles.

- Familiarity with data warehousing concepts and technologies.

- Excellent analytical and problem-solving skills.

- Strong communication and collaboration skills, with the ability to work effectively in a team environment.

- Certification in Snowflake or relevant cloud technologies is a plus.