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, utilising Shell scripting/Ansible/Python for automation and self-healing.
- Integrations
- 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.
