-
ID
#13512825 -
Job type
Permanent -
Salary
TBD -
Source
Pinnacle Group -
Date
2021-05-17 -
Deadline
2021-07-16
Snowflake DBA
Ohio, Cincinnati, 45201 Cincinnati USAPermanent
Vacancy expired!
- Work in a globally distributed team to provide robust enterprise data platform in Snowflake
- Design, optimize, document and implement the operational aspects in supporting the snowflake cloud platform. Including cost monitoring and optimizations, User security auditing
- Implement/support automation for production deployment in Snowflake
- Implement Snowflake standards and methodologies for DB security - both infrastructure and app level
- Implement/support automation Snowflake - Accounts/Databases and access roles
- Diagnose and troubleshoot database errors
- Implement data sharing /replication - cross cloud/cross region for internal/external clients
- Create Snowflake utilization and capacity plan
- Tune the DB performance and improve Snowflake queries.
- Identify system bottlenecks in the DB and recommend solutions
- Implement Snowflake user /query log analysis and alerts
- Implement data encryption/decryption/masking policies to protect PII/PCI data
- Hands on experience with Snowflake
- Experience implementing Snowflake external functions
- Hands-on experience in administering Snowflake in AWS
- Experience with Agile and DevOps concepts
- Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
- Experience with architecting and maintaining high availability production systems
- Experience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations and alerts
- Knowledge of security controls for the Public cloud ( encryption of data in motion/rest and key management )
- Demonstrated proficiency of index design, query plan optimization and analysis required
- Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools
- Experience with AWS CLI and Networking
- Strong communication and written skills
- Self-starter with ability to take direction and manage tasks with minimal supervision within an energized, collaborative and entrepreneurial environment
- Snowflake Advanced certification - Desired
- Snowpro core certification required
- Experience in development of SQL, Python, and Shell based scripting to build a variety of reporting and application data warehouses - Preferred
- 4+ years of experience as Snowflake DBA
Vacancy expired!
Report job