Dear Candidates
TCS is looking for Senior Greenplum Database Administrator
Experience: 4-6 years
Location: PAN India
Must have skills:
- Greenplum DBA in enterprise-scale environments.
- Expertise in Greenplum tools (gpfdist, gpbackup, gprestore) and MPP architecture.
- Strong SQL skills and deep understanding of data warehousing concepts.
- Proficiency in Linux administration, scripting (Bash/Python), and workflow automation.
Good to have skill:
- Familiarity with Terraform, cloud platforms (AWS/GCP), and containerization (Docker/Kubernetes).
- Knowledge of data governance, compliance standards, and integration with data catalog tools.
Roles and responsibilities:
- The Senior Greenplum DBA will manage and optimize Greenplum Data Warehouse, ensuring high availability, performance, and compliance. This role involves advanced query tuning, capacity planning, and automation of administrative tasks. The position supports ETL workflows (Informatica), data lake integration (HDFS), and readiness for hybrid cloud and containerized environments as part of modernization roadmap.
- Install, configure, and maintain Greenplum database clusters across on-prem and hybrid environments.
- Perform performance tuning, query optimization, and capacity planning for large-scale analytical workloads.
- Implement backup, restore, and disaster recovery strategies ensuring business continuity.
- Automate administrative tasks using Bash, Python, and orchestration tools.
- Collaborate with ETL teams (Informatica) for efficient data loading and transformation.
- Ensure security and compliance for sensitive data, including PII masking and governance policies.
- Support integration with metadata management tools (Informatica EDC) and BI platforms (MicroStrategy, Power BI).
Prepare for cloud migration and containerization (Docker/Kubernetes) as per roadmap.
