Source description
About the role
ROLE: DATA ARCHITECT
Location- 100% Remote Duration:12+ months Interview- 1 video interview and then offer Note:Must work on w2
Job Description:
Configure and maintain a large Snowflake data repository. Understand and translate the business need into queries and implement processes to get the output available in the AWS based cloud environment. Experiments with available tools and advises on new tools to determine optimal solutions given the requirements dictated by the model/use case.
Provide Database Admin functions (installing, managing, configuring, optimizing, etc.) for MSPSC databases, which include SQL Server, Postgres, and MySQL. Administer self-managed databases on EC2 and databases hosted in RDS. Assist with the design, maintenance, problem resolution and troubleshooting of all database components, as necessary. Administer big data repositories such as Snowflake. Develops and conducts test to ensure data solutions meet documented user requirements. Collaborates with data engineers/architects to transform data and integrate algorithms and models into automated processes. Works with stakeholders, including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs. Design conceptual and logical data models and flowcharts. Improves system performance by conducting tests, troubleshooting, and integrating new elements. Optimizes new and current database systems. Defines security and backup procedures. Coordinates with the project team to identify future needs and requirements. Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance. May coach and review the work of less-experienced professionals. Ensure deliverables are completed on time and of high-quality. Maintains current knowledge of relevant technology as assigned.
Requirements
Bachelor’s Degree in a Computer Science related technical discipline, or the equivalent combination of education, technical training, or work/military experience. 5+ years of related experience in IT operations & development Proven work experience as a DBA, Data Architect, or similar role In-depth understanding of database structure principles. Experience gathering and analyzing system requirements. Exposure to Snowflake, DataBricks, Redshift Spectrum or similar platform. Hands on experience creating SQLs that will work on an existing Snowflake (or similar technology) schema. Expertise in SQL and NoSQL High level of self-motivation and initiative
--
Thanks & Regards, Mohan Sai| Account Manager Thoughtwave Software and Solutions Desk: 6304804004 EXTN: 143 Mobile/Text Messages:3099656527 Email:Mohan@thoughtwavesoft.com linkedin:https://www.linkedin.com/in/mohan-sai-badaru-112b581b9/
More at Thoughtwave Software and Solutions