Database Administrator
3 weeks ago
Job Title/Role
Lead DBA - Snowflake, Rate : CAD 60 T4
Mandatory Skills
Snowflake Administration
Client Interview Needed for Selection (Yes / No)
No
JD
**Skill**
**Mandatory**
**Proficiency Level (1-5)**
Snowflake Object creation and Management
Yes
4
Snowflake Connectivity
Yes
4
UDF, Snowpipe
Yes
4
User Management & RBAC
Yes
4
Workload Analysis & Optimization
Yes
4
Secure views, Account level Security
Yes
4
Python, Azure, Unix Shell script, JavaScript
Yes
3
**Responsibilities**:
- Creation & Management of
- Snowflake Objects like Database/Schema /Tables/Views/MV’s /Pipes, Streams, Task Creation & Management
- Account level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares
- Connectivity issues resolution wrt ODBC, JDBC, Python Connecters
- Snowflake UDF using SQL, Python, JavaScript and Java and help them to tune their SQL/UDF
- Create replication and failover groups and restore data from Fail safe or from time travel data
- Troubleshoot data loading issues, connection issues and Snow pipe issues
- User management, Implementation of RBAC best practices
- Access Rights Management, experience with privileged roles Accountadmin, Sysadmin and Securityadmin
- Analysing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumption
- Generate, manage and analyze Cost/credits Consumption reports and identify cost optimization areas
- ETL batch Support and issues resolution
- PII data management using Dynamic data masking, Secure views implementation, managing Account level Security using network policies, implementing Azure ADSSO for user Authentication
- Secure Data Sharing using managed accounts Creation, Reader Account provisioning and managing resource monitor, credit Quota, IP whitelisting
- In depth knowledge of Micro partition, Caching, Table Clustering, Recommendation for Cluster key, Analysing the SQLs using query profile, identifying gaps, patterns and trends, recommendation to BI team based upon the analysis
- Working experience in writing Procedures (PLSQL, Javascript) / UDF and calling them from Unix shell Scripts using SnowSql to automate day to day DBA BAU’s task
Must Have
Snowflake Datawarehouse Administration
Snowflake Utilities SnowSql, SnowPipe
Time travel, Fail safe, Clustering, Cloning, Metadata management
Scripting - Java Script, Unix shell Scripting, Basic of Python
Cloud Platform - Aws Storage (S3), Azure Blob Storage and Containers
- Snowflake Unique features use case and implementation (Time Travel, Un-drop, Zero Copy Clone) as per the requirement
- Worked on thorough testing and implementation of Dev-ops Pipeline for Objects Promotion using GitHub, Jenkins
- Working with Snowflake Support, handling P1, P2 incidents, Engaging Support for technical issue on all the Snowflake Accounts under organization including Readers Account
Good to Have
- Expertise in SQL, Snowflake procedures, UDF’s using JavaScript
- Automation
- CI/CD using Jenkins Pipeline (Code promotion), Github for version control
- Scheduling
- ESP Jobs Scheduling, AWX Ansible Tower
- Familiarity with JIRA, ServiceNow / GLPI
- Experience with ITIL process, Change management, Incident handling, JIRA, Development using Agile methodology
Thanks & Regards
Aman Sharma
Direct Number:408-459-7174
Mississauaga, Canada
**Job Type**: Fixed term contract
Contract length: 12 months
**Salary**: $33,029.51-$152,826.60 per year
Schedule:
- Day shift
- Monday to Friday
Ability to commute/relocate:
- Toronto, ON: reliably commute or plan to relocate before starting work (required)
**Experience**:
- Snowflake: 1 year (required)
- SnowSql: 1 year (preferred)
- SnowPipe: 1 year (required)
**Speak with the employer**
+91 +916399121513
-
Database Administrator
4 weeks ago
Toronto, Canada iPartner Staffing Full time3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...
-
Database Administrator
24 hours ago
Toronto, Canada Cleartech International ltd Full timeAs a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...
-
Database Administrator
11 hours ago
Toronto, Canada Cleartech International ltd Full timeAs a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...
-
Database Administrator
1 day ago
Toronto, Canada Cleartech International ltd Full timeAs a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...
-
Database Administrator
4 weeks ago
Toronto, Canada Institutional Shareholder Services Full timeLet's be Brilliant Together! - Advance your career with the leading provider of corporate governance and responsible investment solutions. Institutional Shareholder Services (ISS) empowers investors and companies to build sustainable financial and social value by providing high quality data, analytics, and insight. Our clients rely on ISS’ expertise and...
-
Database Administrator
1 day ago
Toronto, Canada Systematix Full timeWe are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...
-
Database Administrator
11 hours ago
Toronto, Canada Systematix Full timeWe are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...
-
Database Administrator
4 weeks ago
Toronto, Canada Information Services Corporation Full timeCompany Name: Information Services Corporation Location: Toronto, Ontario Requisition ID: JR0000349 Status: Full-time Permanent Job Close Date: November 30, 2023 We are ESC, an experienced provider that delivers solutions uniting public records data, customer authentication, corporate services, collateral management, asset recovery, and accounts...
-
Database Administrator
1 day ago
Toronto, Canada Systematix Full timeWe are Systematix and we are looking for4 experienced Sybase Database Administratorsfor our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension.The work can be done 100% remotely.Position Details: Title:Sybase...
-
Database Administrator
4 weeks ago
Toronto, Canada Canadian Institute for Health Information Full time**Category** - Data Governance **City** - Toronto, Ottawa, Ontario, Canada - Database Administrator - Who we are - We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we...
-
Database Administrator
3 days ago
Toronto, Ontario, Canada Ombudsman Ontario Full timeAlcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...
-
Database Administrator
5 days ago
Toronto, Canada CareRx Full timeJob Details Description CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We...
-
Database Administrator
8 hours ago
Toronto, Canada TekStaff IT Solutions Full timeThis is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience wit
-
Database Administrator
4 weeks ago
Toronto, Canada Interac Corp. Full timeDatabase Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...
-
Database Administrator
1 day ago
Toronto, Canada TekStaff IT Solutions Full timeThis is a 6 month contract located in Toronto, ON/ HybridCandidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...
-
Oracle Database Administrator
7 days ago
Toronto, Canada Procom Full timeOracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionEnhanced performance due to Database Offload in ExadataReduced size of database without compromising performance by leveraging compression technologyProvided trustworthy data from...
-
Database Administrator
5 days ago
Toronto, Canada Ombudsman Ontario Full timeThe Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating the alcohol, gaming, horseracing, and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.The Cybersecurity and...
-
Database Administrator
1 month ago
Toronto, Canada Canadian Institute of Plumbing & Heating Full timeThe Canadian Institute of Plumbing & Heating is looking for a database administrator to complete a data clean up for our organization. - Excellent technical skills - Meticulous attention to detail - A logical approach to work - The ability to prioritize tasks - Problem solving skills - Good organizational skills - Previous work in the database "Your...
-
Database Administrator
1 day ago
Toronto, Canada TekStaff IT Solutions Full timeThis is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions...
-
Database Administrator
1 day ago
Toronto, Canada TekStaff IT Solutions Full timeThis is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...