Prophecy Technologies
Website:
prophecytechs.com
Job details:
Snowflake Database Administrator (Snowflake Platform DBA)
Position Summary
We are seeking an experienced Snowflake Database Administrator (Snowflake Platform DBA) to join the Enterprise DBA team supporting Dun & Bradstreet's Snowflake environments.
This role is responsible for administering, securing, monitoring, optimizing, and supporting Snowflake platforms across both production and non-production environments. The individual will work closely with Data Engineering, Analytics, Cloud Services, Information Security, Application Development teams, and external customer-facing data sharing initiatives.
The ideal candidate is a hands-on Snowflake administrator with strong SQL skills, deep knowledge of role-based access control (RBAC), practical troubleshooting expertise, and experience operating within an enterprise ticket-driven support model. The successful candidate will support daily operational activities while also contributing to platform engineering initiatives, including automation, account provisioning, security integrations, cost optimization, standards governance, and knowledge transfer.
Participation in an on-call rotation and occasional after-hours support may be required to support production environments and critical business initiatives.
Strong communication and collaboration skills are essential, as the role supports multiple Snowflake accounts and interacts with a broad range of business and technology teams.
________________________________________
Primary Responsibilities
• Administer, monitor, and maintain Snowflake environments across production and non-production accounts, including all Snowflake object types.
• Provision and manage Snowflake accounts, databases, schemas, warehouses, storage integrations, resource monitors, shares, and related platform components.
• Support external data sharing initiatives, secure data exchanges, and customer-facing Snowflake sharing solutions.
• Troubleshoot and resolve incidents, service requests, catalog tasks, change requests, access issues, permissions-related problems, connectivity issues, data-sharing challenges, and production escalations.
• Manage user access, role hierarchies, RBAC structures, privilege grants, and authentication mechanisms, including SSO, OAuth, key-pair authentication, and federation integrations.
• Monitor Snowflake usage, warehouse performance, storage consumption, credit utilization, and cost trends; identify and implement optimization opportunities.
• Support and review SQL-based processes, ETL integrations, and data platform automation activities.
• Implement and maintain operational standards, security controls, monitoring solutions, and governance requirements.
• Develop and maintain technical documentation, operational procedures, runbooks, and knowledge articles.
• Participate in change management, release activities, disaster recovery planning, and platform support initiatives.
• Collaborate with cross-functional teams to deliver new capabilities, onboard applications, and support business data initiatives.
________________________________________
Required Qualifications
• 3+ years of hands-on Snowflake administration experience in a production enterprise environment.
• Strong SQL development and troubleshooting skills.
• Deep understanding of Snowflake security architecture, RBAC, data sharing, resource management, and account administration.
• Experience supporting cloud-based data platforms in AWS and/or GCP environments.
• Experience with monitoring, performance tuning, capacity management, and cost optimization.
• Knowledge of authentication and identity integration technologies, including SSO, OAuth, SCIM, and key-pair authentication.
• Experience working within ITIL-based incident, problem, change, and request management processes.
• Strong analytical, troubleshooting, and communication skills.
________________________________________
Preferred Qualifications
• Experience with BigQuery, Databricks, Cloud SQL for PostgreSQL, AlloyDB, MongoDB, or other modern cloud data platforms.
• Experience with infrastructure automation and scripting (Python, PowerShell, Terraform, or similar).
• Familiarity with CI/CD pipelines and DevOps practices.
• Experience supporting customer-facing data-sharing solutions.
________________________________________
Work Schedule
• Standard business hours for onshore resources.
• For offshore resources, preferred coverage is 7:00 AM – 3:00 PM EST.
• Participation in scheduled on-call rotations and occasional after-hours support is required
Click on Apply to know more.
