Snowflake Developer with DBA Need USC-

Position: Snowflake Developer with DBA

Location: Remote

Length: 6+ months

W2 Role Only

Required Experience:

• 10+ years of related experience in IT operations & development
  

Required Technical Skills:

• Provide Database Admin functions (installing, managing, configuring, upgrading, optimizing, etc.) for cloud-based MSPSC databases which include SQL Server, Oracle, Aurora-Postgres, and MySQL.
• Manage data in a Snowflake environment
• Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms
• Optimize the performance of data repositories such as Snowflake and AWS RDS
• Deploy and configure tools to monitor and report on the performance of the Snowflake system
• Create & manage Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks
• User management, Implementation of RBAC best practices
• Execute day-to-day Snowflake Administration in accordance with industry best-practices.
• Maintain an automate first approach reducing toil and overhead by collaborating with data engineers/architects to transform data and integrate algorithms and models into automated processes
• Maintains current knowledge of relevant technology and a curiosity for opportunities for improvement, innovation, and cost-reduction
  

Required Skills and Abilities:

• In-depth understanding of database structure principles
• Experience gathering and analyzing system requirements
• Hands-on experience creating SQLs that will work on an existing Snowflake schema
• Hands-on experience with Snowflake Administration, Snowflake development, Snowflake Utilities, Snow SQL, Snow Pipe
• Snowflake certification is required and must be active
• Expertise in SQL
• Problem-solving mindset
• High level of drive, self-motivation and initiative
• Experience with source control and automation tools, platforms such as Git/GitHub, and languages such as Python is highly desirable
• Experience supporting Federal, civilian and health agencies including experience with claims data is a plus

Preferred Skills:

• Experience supporting Federal, civilian and health agencies including experience with claims data is a plus.

Required:

• Candidate must have 3 of the last 5 years of work history in the US and will be required to go through a public trust background investigation
• Work visa sponsorship will not be provided for this position

Frequently Asked Vendor Questions

• What is the mission of the program/contract? Develop and maintain solutions for querying and matching large amounts of data while continuously maintaining, enhancing and improving our data architecture strategy and database estate.

• What will a typical workday look like for the Contractor? Is this a team setting? Learning, growing, and maturing the MSPSC Snowflake application and processes in order to support, maintain and manage the environment providing increased value and stellar user experience.

• What are the top three skillsets the candidate should have? Please list top THREE only.

DB maintenance and management in cloud-based environments (Aurora Postgres, MSSQL, Oracle, MySQL) in accordance with best practices and industry standards.

Snowflake - Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms including the creation & management of Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks.

Improving system performance through conducting tests, troubleshooting, query tuning, and integrating new elements and features.