Access Control, Amazon Elastic Compute Cloud (EC2), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Automation, Best Practices, Caching, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cryptography, Data Analysis, Data Modeling, Data Processing, Data Science, Database Administration, Database Technology, Delivery Management, Detail Oriented, DevOps, Disaster Recovery, Firewalls, Information Technology & Information Systems, Information/Data Security (InfoSec), JDBC (Java Database Connectivity), Mentoring, Oracle, Problem Solving Skills, Process Improvement, Python Programming/Scripting Language, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Security Architecture, Service Delivery, Single Sign-On (SSO), Snowflake Schema, Tableau, Team Player, Unix Shell Programming, Warehousing
Job Title: Oracle Service Delivery Manage
Duration- Fulltime Permanent
Location:Mentor, OH (Day 1 Onsite)
Job Description:
Must Have Technical/Functional Skills
• Bachelor's degree in a relevant field.
• 10+ years of IT experience, including 5+ years in DevOps or Database Administration roles.
• 3+ years of hands-on experience with Snowflake administration, Python ELT, SQL, Unix, Shell scripting and AWS services like EC2 and S3.
• Strong communication and collaboration skills with attention to detail.
• Proven ability to design effective solutions, maintain consistency, and drive disciplined execution.
• Local to Dallas or willing to relocate and be in office atleast 3 days a week.
Roles & Responsibilities
• . Administrating Snowflake sub-prod, prod and the global environments. Create database, schema, tables, views, data share, external stage, storage integration.
• Document, maintain and implement Snowflake platform design standard, pattern, discipline, naming, sizing, optimization, automation, security, best practices, usage.
• Real world work experience in using Snowflake Stream, Task, Clone and Time Travel, multi-cluster Warehouses, scaling out, scaling up for different types of workloads.
• Security roles, privileges, users as per best practice. Integrate other tools as per business need but leverage snowflake role-based security to enforce access restrictions.
• Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increase scalability and be cost-effective.
• Well versed with Materialized views, Clustering, micro-partitioning, Caching like optimization techniques to tune the queries and fix the performance issues on priority basis.
• Experience in setting up the Snowflake account from scratch for an enterprise-wide implementation, the Private Link setups, VPC, Networking, Firewall.
• Should have written in past the DBA scripts using Python and/or Shell scripts and the SNOW SQL. Execution from Amazon EC2 to automate and/or notify Admin related alerts. Must have used the AWS services like the S3, EC2, EKS.
• Snowflake SSO/Okta integration and AD Groups setups, Access Control, Encryption, Secured Views. Work experience on Network policy, Row Access Policy, Masking policy.
• Support to Tableau connection to Snowflake. SAS, Python and other jdbc connections.
• Should have done the Data Share, Account Replication, Disaster Recovery exercise.
• Should know the CI/CD in Snowflake, familiarity with Cortex /LLM, Streamlit
• Perform POT and POC for new features, capabilities and their evaluations and then adaption.
• Collaborate with Data Modelers, Data Engineers, Data Architects, Information Security and maintain the standards, consistency, adhere to best practices and be compliant.
• Partner with Data Science, Data Analysis teams, address snowflake platform issues, concerns if there is any. Provide Snowflake solution to the business problem as applicable.