Role: DB2/PostgreSQL DBA (Snowflake)
Location: Toronto, Canada (Hybrid - 3 days onsite / week)
Employment type: Contract
Key Words - Snowflake + Postgres + DB2(Senior) + Production support + Troubleshoot the database + On call support + Azure
Overview
• Collaborate with cross-functional teams, including customers, project management, software engineering, and network operations, to gather database requirements, improve existing systems, and develop new systems.
• Install and upgrade database systems, ensuring smooth and efficient processes.
• Implement and maintain robust database security measures, adhering to industry standards and guidelines.
• Design and support 24x7 high-availability solutions for seamless database operations.
• Optimize database and server performance by analysing and configuring physical server hardware, operating systems, and database software settings. Provide recommendations for upgrades and new systems.
• Develop and optimize database components, including queries, stored procedures, ETL processes, and conduct code reviews and optimizations to enhance performance.
• Execute database schema and code changes, perform bottleneck analysis, and ensure efficient server/database performance, including recovery and restores when needed.
• Plan for system growth and scalability to accommodate future requirements.
• Ensure compliance with vendor license agreements to maintain legal and operational integrity.
• Handle various reporting and data export/import tasks, working with different formats like CSV, XML, and unstructured data.
• Document the database environment, processes, and best practices to maintain a comprehensive knowledge base.
• Provide technical support and prompt problem resolution to address any database-related issues.
• Be available for production/on-call support to maintain continuous system availability and address emergencies effectively.
• Be willing to learn new technologies and assist with architecture and design.
• Work efficiently within a high security environment (PCI-DSS Level 1 certified)
• Communicate clearly and effectively to all levels of the organization.
Position Requirements:
• 5+ years of DB2 or PostgreSQL database administration experience
• 2+ years of Snowflake data warehouse administration and development experience
• Experience working with cloud PaaS database services.
• Jenkins, gitlab/bgit-bucket
• Linux/Unix experience
• Experience supporting highly available and fault tolerant systems.
• Participate in on-call shifts, our infrastructure runs 24/7
• Security knowledge & experience (Ex. Database Encryption/masking/Certificates/PKI/SSH/VPN)
• Expert problem solver by applying problem analysis methodologies.
• Computer Science or Engineering degree or equivalent experience
What Sets You Apart:
• Advanced Azure cloud technologies experience
• Experience on cloud database deployment using terraform.
• Azure Cosmos or similar database technology experience
• Desire to automate everything , automate & anything
• Database development experience
• Networking experience (Ex. TCP/IP, UDP, Routing, Firewalls, load-balancers)
• Desire to document everything
• PCI-DSS or similar experience (ex. financial/government/healthcare)
• Understanding of the ITIL framework
• Familiarity with JBoss or WebSphere application server
