DB2/PostgreSQL DBA

24 hours ago

Toronto, Ontario, Canada TRANSREACH TALENT LLC Full time $120,000 - $180,000 per year

DB2/PostgreSQL DBA (Snowflake DW administration and development experience)

Toronto, Canada (Hybrid, 3 days onsite/Week)

Long Term Contract

Job Description


• 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

  • Db2 Dba

    1 day ago

    Toronto, Ontario, Canada EROS Technologies Full time $100,000 - $120,000 per year

    Company Description EROS Technologies was founded with a simple motive of offering the clients exactly what they want, how they want and when they want it. By leveraging for its clients its technological edge and right-sourcing advantage, EROS in a short period of time has grown to become one of the most trusted strategic technology partners. Treating every...

  • DB2/PostgreSQL DBA

    1 day ago

    Toronto, Ontario, Canada Maven Workforce Inc. Full time US$80,000 - US$140,000 per year

    About the RoleCollaborate with cross-functional teams, including customers, project management, software engineering, and network operations, to gather database requirements, improve existing systems, and develop new systems.ResponsibilitiesInstall and upgrade database systems, ensuring smooth and efficient processes.Implement and maintain robust database...

  • PostgreSQL DBA-CockroachDB

    22 hours ago

    Toronto, Ontario, Canada Atlantis IT Group Full time US$1,200,000 - US$1,600,000 per year

    Skills Required: PostgreSQL Digital : DevOps Continuous Integration and Continuous Delivery (CI/CD)~Microsoft SQL Server 2019~Database Administration (DBMS)~Dynamic Scripting LanguagesJob Description: 5 years of experience as a Database Administrator or Database Reliability Engineer, or a similar role with a strong focus on automation and DevOps principles....

  • PostgreSQL DBA

    23 hours ago

    Toronto, Ontario, Canada OKAYA INFOCOM Full time $120,000 - $180,000 per year

    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.•...

  • dba

    1 day ago

    Toronto, Ontario, Canada Collabera Full time

    DayToDay Responsbilities:Database Administration:DB2 and IMS schema, objects, performance tuning, backups, recovery.Application Support:Debug application issues related to DB2/IMS/CICS.Transaction Manager/CICS:Knowledge of transaction flows, troubleshooting, and application interactions.Object/Application Creation:Create DB2 tables, IMS databases, batch...

  • Cassandra DBA

    23 hours ago

    Toronto, Ontario, Canada VeeRteq Solutions Inc - DBA AddSource Full time US$64,000 - US$72,000 per year

    Title: Cassandra DBALocation: Toronto, ON (Hybrid)Duration: Long TermJob Description:8-10 years' experience in building/RAC clustering/patching/administering/performance tuning analysis (Cassandra / PostgreSQL)- Automation experience, unix shell scripting, writing ansible playbooks to automate build and bau activities.- Demonstrates experience involving...

  • Cloud DBA

    1 day ago

    Toronto, Ontario, Canada My Client Full time $60,000 - $80,000 per year

    Job Title :- Cloud DBALocation: Toronto, Ontario (Hybrid)ContractJD:Cloud DBA DT:Experts:Github RepoTypescriptsYaml development and Ansible workflowsProvisioning and configure on Cloud RDS : Oracle ,MSSQL, PostgreSQL , RedshiftCloud backup and RestoreCloud RDS troubleshooting and performance turningDMS set upCloud alarm set up on DT and on Cloud

  • Cassandra DBA

    1 day ago

    Toronto, Ontario, Canada AddSource Full time $80,000 - $120,000 per year

    Title: Cassandra DBALocation: Toronto, ON (Remote)Duration: 6+ MonthsJob Description:8-10 years' experience in building/RAC clustering/patching/administering/performance tuning analysis (Cassandra / PostgreSQL)Automation experience, unix shell scripting, writing ansible playbooks to automate build and bau activities.Demonstrates experience involving strong...

  • Oracle Database Administrator

    22 hours ago

    Toronto, Ontario, Canada Tekgence Inc Full time $800,000 - $1,300,000 per year

    Database Administrator/ PostgreSQL DBALocation: TORONTODuration: 6 monthsSkills Required:Job Description: 5 years of experience as a Database Administrator or Database Reliability Engineer, or a similar role with a strong focus on automation and DevOps principles. Deep expertise in at least one, and preferably multiple, database systems Relational IBM...

  • Postgre SQL DBA

    16 hours ago

    Toronto, Ontario, Canada Cognizant Technology Solutions Full time $125,000 - $175,000 per year

    Cognizant is seeking a Senior Postgre DBA for a full-time opportunity in Toronto, ON.Cognizant's CIS (Cognizant Infrastructure Services) Practice is a global leader in providing IT infrastructure services. We deliver innovative solutions to optimize and transform IT infrastructure, ensuring business agility and operational efficiency. Our services include...