Snowflake Postgres Admin
- Tata Consultancy
- 8 - 10 years
- Pune
- 17 hours ago
- Email to a friend
- Report this job
Job Description
- Design, implement, and manage PostgreSQL and Snowflake databases, ensuring high availability, performance, and security.
- Perform database provisioning, configuration, monitoring, and performance tuning for both platforms.
- Manage user accounts, roles, permissions, and access control within both Snowflake and PostgreSQL.
- Develop and maintain backup, recovery, and disaster recovery strategies for both environments.
- Implement and enforce data retention policies and manage data lifecycle within both platforms.
- Conduct upgrades and apply patches as needed for PostgreSQL, and stay updated with Snowflake releases and features.
- Manage data storage, loading, transformation, and extraction processes within Snowflake.
- Work extensively with JSON data in PostgreSQL, including storage, indexing, querying, and transformation.
- Develop and optimize Dynamic DDL and DML scripts for flexible schema and data operations in PostgreSQL.
- Collaborate with data engineers, analysts, and developers to support ETL processes, data pipelines, and reporting needs.
- Monitor, troubleshoot, and optimize database performance for both PostgreSQL (queries, indexes, execution plans) and Snowflake (warehouse performance, query optimization).
- Identify and resolve bottlenecks and performance issues in both environments.
- Monitor Snowflake usage and costs, making recommendations for cost optimization.
- Implement and maintain database security policies, including role-based access control (RBAC) in both platforms.
- Ensure compliance with data privacy and security regulations (e.g., GDPR, HIPAA).
- Collaborate with cross-functional teams to align database architecture with business requirements.
- Provide technical support and training to end users on effective database usage.
- Document processes, configurations, database standards, and architectural decisions.
Required Skills
- Must have 7+ Yrs hands on experience
- Proven experience as a Database Administrator with strong expertise in both PostgreSQL and Snowflake.
- In-depth knowledge of Snowflake administration, including upgrades, maintenance, performance tuning, and cost optimization.
- Strong expertise in PostgreSQL administration, including dynamic DDL/DML, JSON data handling, and performance tuning.
- Proficiency in SQL and scripting languages.
- Experience with data pipelines, ETL tools, and data integration.
- Must have AWS certification
- Understanding of data governance, security principles, and compliance regulations.
- Excellent problem-solving, analytical, and communication skills.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Software Development - OtherEmployement Type: Full timeContact Details:
Company: Tata ConsultancyLocation(s): Pune+ View Contact
Keyskills: Postgresql Snowflake Postgres Database Postgresql Database Administration AWS DDL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Tata Consultancy
Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India. As of February 2021, TCS is the largest IT services company in the world by market ca...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in