Junior Database Administrator
INKPAPER
Gurugrama
09.2023 - 03.2024
- User Creation and Management:Configured user accounts, privileges, roles, profiles. in the database server.
- Role-based Access Control (RBAC):Implement role-based access control (RBAC) to ensure that users have the appropriate access to data and resources based on their roles and responsibilities.
- Granting/Revoke Permissions: Grant or revoke access to databases, schemas, tables, and other objects within Snowflake.
- Warehouses Management: Create and manage virtual warehouses for query processing. Monitor and scale warehouses based on performance and usage.
- Database and Schema Management: Create, modify, and manage databases, schemas, tables, views, and other objects.
- Data Sharing: Set up and manage data sharing between Snowflake accounts for secure and efficient sharing of data.
- Query Performance Tuning: Monitor query performance, analyze slow-running queries, and optimize performance through the use of clustering, partitioning, or optimizing warehouse sizes.
- Warehouse Sizing and Scaling: Ensure that virtual warehouses are appropriately sized based on workload requirements and scale them up or down as needed to optimize performance and cost.
- Backup and Recovery: Manage Snowflake’s Time Travel and Fail-safe features to ensure that data can be recovered in case of accidental deletion or corruption.
- Data Masking and Sensitive Data Management: Set up dynamic data masking policies to prevent unauthorized access to sensitive data.
- Data Ingestion: Oversee the processes for loading data from various sources (e.g., external databases, cloud storage) into Snowflake.
- Data Replication: Set up and maintain data replication for disaster recovery or multi-region data consistency.
- Query Monitoring: Track query performance and troubleshoot performance issues using Snowflake’s built-in monitoring and diagnostic tools.
