Snowflake DBA

Triangulas HR Solutions LLP
Kandanchavadi, TN, in
Full-time

Responsibilities :

Database Setup and Configuration

o Configure and manage cloud databases using best practices and well architected frameworks.

o Configure warehouses, databases, and Snowflake objects for performance and cost-efficiency.

Performance Monitoring and Tuning

o Monitor Snowflake and PostgreSQL / MySQL environments, executing performance tuning strategies.

o Conduct health checks and performance tuning for Snowflake and PostgreSQL / MySQL databases.

Data Security and Compliance

o Implement security measures like data encryption, access controls, and network policies.

o Manage user accounts, roles, and access privileges to secure and appropriate database access.

Backup and Disaster Recovery

o Plan and manage disaster recovery strategies and data retention policies.

o Ensure sound backup and recovery procedures for Snowflake and PostgreSQL / MySQL databases.

Cost Management

o Monitor and optimize Snowflake credit usage to control costs.

o Propose cost-effective usage of Snowflake features and resources.

User Management and Support

o Support data-related activities in collaboration with data engineers, analysts, and IT teams.

o Document database schemas, configurations, procedures, and best practices.

Automation and Self-Healing

o Automate database management, utilising Shell scripting / Ansible / Python for automation and self-healing.

Integrations

o Set up integrations between on-premises applications and cloud environments.

Requirements

Qualifications & Experience :

  • Bachelor’s or Master’s degree in IT.
  • 7-12 years of IT experience, including 4+ years as a Snowflake and PostgreSQL / MySQL DBA.
  • Must have experience of managing high volume data in high available environment
  • Experience with AWS / Azure cloud platforms and cloud DB technologies (RDS, Aurora).
  • Proficiency in Snowflake and PostgreSQL / MySQL configuration, upgrades, and health check-ups.
  • Knowledge of high-availability setups, like hot standby and AD integration.
  • Ability to write complex queries, optimize them, and create procedures and functions.
  • Familiarity with backup, recovery, and point-in-time recovery processes.
  • Experience in applying network policies, AD integration, and cost optimization.
  • Skills in automation using Shell scripting, Ansible, and / or Python (Terraform is a plus).
  • Strong communication and problem-solving abilities.
  • Willingness to work in night shifts.
  • 23 hours ago
Related jobs
Triangulas HR Solutions LLP
Kandanchavadi, TN, in

IT experience, including 4+ years as a Snowflake and PostgreSQL/MySQL DBA. IT experience, including 4+ years as a Snowflake and PostgreSQL/MySQL DBA. Configure warehouses, databases, and Snowflake objects for performance and cost-efficiency. Monitor Snowflake and PostgreSQL/MySQL environments, ...

Triangulas HR Solutions LLP
Kandanchavadi, TN, in

IT experience, including 4+ years as a Snowflake and PostgreSQL/MySQL DBA. Configure warehouses, databases, and Snowflake objects for performance and cost-efficiency. Monitor Snowflake and PostgreSQL/MySQL environments, executing performance tuning strategies. Conduct health checks and performa...

Triangulas HR Solutions LLP
Kandanchavadi, TN, in

IT experience, including 4+ years as a Snowflake and PostgreSQL/MySQL DBA. IT experience, including 4+ years as a Snowflake and PostgreSQL/MySQL DBA. Configure warehouses, databases, and Snowflake objects for performance and cost-efficiency. Monitor Snowflake and PostgreSQL/MySQL environments, ...

Promoted
Vaco
Memphis, Tennessee

The HR Data Analyst will be responsible for analyzing and presenting employee data to improve workforce decisions in innovative ways that drive business performance and growth. Utilize SQL, Python, or R to extract, transform, and analyze data from various sources, including BigQuery. Provide trainin...

Promoted
VirtualVocations
Chattanooga, Tennessee

A company is looking for a Database Developer to design and build components of a data warehouse to support business intelligence and data science initiatives. ...

Promoted
SPB Hospitality
Nashville, Tennessee

As part of our Information Systems team, you will work with multiple business operations teams to plan, design, develop and implement various SQL, inter-platform, and data solutions. ...

Promoted
recruit22
TN, United States

More than 3 years of experience with Oracle Database DDL, DML, and related concepts (tables, triggers, views, procedures, functions, packages), as well as PL/SQL, SQL languages using SQLplus, SQLcli, and/or SQLdeveloper. Experience with modeling tools like SQLmodeler, ERWIN, and TOAD, data extractio...

Promoted
Genius Business Solutions
Nashville, Tennessee

Must Have] 5+ years of experience in database development, with a focus on writing stored procedures in SQL. Experience with performance tuning and optimization of databases and queries. ...

Promoted
IDR, Inc.
Nashville, Tennessee

IDR is seeking a Database Developer to join one of our top clients in Nashville, TN. Position Overview/Responsibilities for the Database Developer:. Required Skills for the Database Developer:. Oracle Database DDL, DML and concepts (table, triggers, views, procedures, functions, packages), PL/SQL, S...

Promoted
Singenuity
TN, United States

We want SQL developers who are driven by curiosity and creativity, excited by new technologies, and motivated to take ownership of projects. As a SQL Developer at Singenuity, you'll be an essential part of our team. Experience with Azure (managing databases, resources, firewalls, and runbooks). ...