Tata Consultancy Services

Postgre SQL Admin

Tata Consultancy Services • $100K — $120K *
Toronto, ON M3C 0E3In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5-7 years as a Postgres Database Administrator in large-scale environments.
  • Deep understanding of PostgreSQL architecture and processes such as WAL, MVCC, and vacuum.
  • Hands-on experience with rep mgr clustering and failover management.
  • Expertise in performance tuning and query optimization techniques.
  • Experience migrating databases to cloud platforms.
  • Familiarity with Oracle systems and tools like RMAN and Goldengate.
  • Strong skills in backup, recovery, and disaster recovery strategies.

Responsibilities

  • Maintain and optimize PostgreSQL databases in enterprise settings.
  • Implement and manage database clustering and failover processes.
  • Tune database performance and optimize SQL queries for efficiency.
  • Develop and execute migration strategies for cloud transitions.
  • Ensure robust backup and disaster recovery protocols are in place.
  • Monitor database health and performance using various tools.
  • Collaborate with teams to troubleshoot and resolve database issues.

Benefits

  • Comprehensive health and wellness coverage.
  • Generous vacation and paid time off policies.
  • Opportunities for professional development and training.
  • Flexible work arrangements including remote options.
Full Job Description
Required Skills & Qualifications: • Proven experience as a Postgres Database Administrator in enterprise environments. • Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes. • Hands-on experience with rep mgr clustering, failover handling, and node recovery. • Expertise in performance tuning, query optimization, and troubleshooting. • Experience with migration strategies from on-premises to cloud platforms. • Familiarity with Oracle DBA, RMAN, Goldengate, Exadata. • Proficiency in backup, recovery, and disaster recovery planning. • Working knowledge of logical replication and streaming replication. • Excellent problem-solving and communication skills. Preferred Qualifications: • Experience with automation tools (Ansible, Terraform) for database deployments. • Knowledge of monitoring tools like pg Admin, Prometheus, or Grafana. • Scripting skills in Shell, Python, or similar for automation. Salary Range - CA$ 100,000 - CA$ 120,000 Per Year TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion.

About Tata Consultancy Services

Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, Maharashtra, India. It is a subsidiary of Tata Group and operates in 149 locations across 46 countries. TCS is the largest Indian company by market capitalization and is ranked 11th on the Forbes Global 2000 list of the world's biggest public companies. TCS is also the second-largest IT services company in the world by revenue and the largest employer of women in India. The company provides services in areas including IT, consulting, and business solutions.
Learn more about Tata Consultancy Services
Size
469,261 employees
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Tata Consultancy Services

More Information Technology Jobs

Find similar Postgre SQL Admin jobs:

NationwideToronto, ON