ship required

Must be able to pass an in-depth background check, potential including fingerprinting.

12 months and can work 100% remotely from anywhere in US.

Required Skills -

• 5 years of experience designing and developing enterprise class applications & databases
• Proficient with SQL and AWS RDS-SQL
• Proficient working in Agile and Cloud-centric environments, including Git, CI/CD, VSCode IDE, DevOps
• Excel at designing solution architectures in fo business process automation
• Ability to work autonomously, proactively, and remotely within a cross-functional organization.
• Exceptional written and verbal communication skills in English.
• Comprehensive experience with database technologies and data modeling concepts, preferably involving leading Big Data Database & Analytics Vendors.
• Cloud computing knowledge: Experience working with cloud platforms, such as AWS, Azure, or Google Cloud Platform, is required. The candidate should be comfortable with cloud-based services, storage, and data integration tools that interact with Snowflake.
• Proficiency in Database Design Patterns, VS Code IDE, and database technologies is essential.
• The candidate must have experience in designing and implementing data pipelines, including extraction, transformation, and loading (ETL) processes.
• Expertise in complex data analysis, data migrations, system integration, and robust object-oriented programming skills.
• Functional programming experience is considered an asset.
• Familiarity with Agile working environments.
• Management of personal knowledge base tools is advantageous.
• Prior experience in a consultative role, handling intricate, customer-facing projects.
• Adaptable to learning new technologies and programming languages as needed.
• Capable of educating and training small groups.

Desired Skills:

• Familiarity with tools and technologies, such as Apache NiFi, Talend, Informatica, or Matillion, that integrate with Snowflake is highly desirable.
• Applicable training and/or certification
• NoSQL, MongoDB
• MySQL and/or Postgres
• REST APIs, Python, C#, NodeJS, Datawarehousing

Responsibilities:

• Collaborate with a compact team of developers to conceptualize and develop both prototype and production-ready solutions that exhibit and fulfill the required functionality.
• Design and implement efficient database structures to support organizational requirements.
• Monitor and maintain database performance, ensuring optimal stability, security, and scalability.
• Develop, implement and support backup and recovery strategies, safeguarding critical data assets.
• Conduct regular database audits to identify potential issues and maintain data integrity.
• strong communication and collaboration skills: The database administrator should be able to effectively communicate with cross-functional teams, including developers, analysts, and business stakeholders.
• The candidate must be capable of understanding and translating business requirements into technical solutions and working collaboratively to support data-driven decision-making within the organization.
• Perform database capacity planning and forecasting to support future growth and resource allocation.
• Implement and maintain database security measures, including user access controls and data encryption.
• Spearhead and contribute to all stages of the database implementation within projects, spanning from inception to deployment.
• Troubleshoot and resolve database-related issues to minimize downtime and maintain system reliability.
• Stay up-to-date with industry best practices and emerging technologies, continuously improving database management techniques.
• Provide technical expertise and guidance to team members, fostering a culture of collaboration and knowledge sharing.
• Design and implement solution architectures that cater to database-related technical needs of internal tools, leveraging AWS-RDS SQL Server as the primary cloud-based database.
• Serve as the Technical Subject Matter Expert for database components of the solution, adapting to evolving business requirements concerning data acquisition from diverse sources, data normalization, aggregation through ETL scripting, and compatibility with BI reporting tools.
• Utilize strong SQL skills and expertise in designing and optimizing data models, schemas, and table structures to support efficient querying and data analysis within the Snowflake and other database environment.

Responsibilities:

• Collaborate with a compact team of developers to conceptualize and develop both prototype and production-ready solutions that exhibit and fulfill the required functionality.
• Design and implement efficient database structures to support organizational requirements.
• Monitor and maintain database performance, ensuring optimal stability, security, and scalability.
• Develop, implement and support backup and recovery strategies, safeguarding critical data assets.
• Conduct regular database audits to identify potential issues and maintain data integrity.
• strong communication and collaboration skills: The database administrator should be able to effectively communicate with cross-functional teams, including developers, analysts, and business stakeholders.
• The candidate must be capable of understanding and translating business requirements into technical solutions and working collaboratively to support data-driven decision-making within the organization.
• Perform database capacity planning and forecasting to support future growth and resource allocation.
• Implement and maintain database security measures, including user access controls and data encryption.
• Spearhead and contribute to all stages of the database implementation within projects, spanning from inception to deployment.
• Troubleshoot and resolve database-related issues to minimize downtime and maintain system reliability.
• Stay up-to-date with industry best practices and emerging technologies, continuously improving database management techniques.
• Provide technical expertise and guidance to team members, fostering a culture of collaboration and knowledge sharing.
• Design and implement solution architectures that cater to database-related technical needs of internal tools, leveraging AWS-RDS SQL Server as the primary cloud-based database.
• Serve as the Technical Subject Matter Expert for database components of the solution, adapting to evolving business requirements concerning data acquisition from diverse sources, data normalization, aggregation through ETL scripting, and compatibility with BI reporting tools.
• Utilize strong SQL skills and expertise in designing and optimizing data models, schemas, and table structures to support efficient querying and data analysis within the Snowflake and other database environment.

• Experience level: Experienced
• Minimum 5 years of experience
• Education: Bachelors (required)