Triangulas HR Solutions - Snowflake DBA Expert - PostgreSQL/MySQL

Hiring for Snowflake DBA - IT. Location : Chennai / Coimbatore / Pune. Mode of work : Hybrid (2 days from Office) and Only Night Shifts. Responsibilities : Database Setup and Configuration : - Configure and manage cloud databases using best practices and well-architected frameworks. - Configure warehouses, databases, and Snowflake objects for performance and cost-efficiency. Performance Monitoring and Tuning : - Monitor Snowflake and PostgreSQL/MySQL environments, executing performance tuning strategies. - Conduct health checks and performance tuning for Snowflake and PostgreSQL/MySQL databases. Data Security and Compliance : - Implement security measures like data encryption, access controls, and network policies. - Manage user accounts, roles, and access privileges to secure and appropriate database access. Backup and Disaster Recovery : - Plan and manage disaster recovery strategies and data retention policies. - Ensure sound backup and recovery procedures for Snowflake and PostgreSQL/MySQL databases. Cost Management : - Monitor and optimize Snowflake credit usage to control costs. - Propose cost-effective usage of Snowflake features and resources. User Management and Support : - Support data-related activities in collaboration with data engineers, analysts, and IT teams. - Document database schemas, configurations, procedures, and best practices. Automation and Self-Healing : - Automate database management, utilizing Shell scripting/Ansible/Python for automation and self-healing. Integrations : - Set up integrations between on-premises applications and cloud environments. 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 checkups. - 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. (ref:hirist.tech)

Location: in, IN

Posted Date: 11/26/2024