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.
Snowflake DBA
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, ...
Snowflake 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, executing performance tuning strategies. Conduct health checks and performa...
Snowflake DBA
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, ...
Human Resource Data Analyst - Workday
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...
Database Developer
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. ...
SQL Developer
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. ...
PL/SQL Developer
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...
Database Developer | Nashville, TN | 6+ Months
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. ...
Database Developer
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...
Database Developer
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). ...