DB2/PostgreSQL DBA

1 day ago

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

About the Role

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.

Responsibilities

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

Qualifications

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

Required Skills

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

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

  • 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

    22 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

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