Senior - AWS+Snowflake Professional

4 - 8 years

6 - 10 Lacs

Posted:2 months ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

KPMG India is looking for Senior - AWS+Snowflake Professional to join our dynamic team and embark on a rewarding career journey.
  • Database Administration : Manage and administer Snowflake databases on AWS, including provisioning, configuration, monitoring, performance tuning, and troubleshooting.
  • Ensure the availability, reliability, and security of database systems to meet business requirements.
  • Database Design and Modeling : Design and implement database schemas, tables, views, and other database objects according to data modeling best practices.
  • Optimize database structures for performance, scalability, and query efficiency.
  • Data Loading and Integration : Develop and implement data loading strategies to ingest data from various sources into Snowflake databases.
  • Configure data pipelines, ETL (Extract, Transform, Load) processes, and data integration workflows using Snowflake's native capabilities or third-party tools.
  • Query Optimization and Performance Tuning : Analyze query performance and optimize SQL queries to improve execution times, reduce resource consumption, and enhance overall database performance.
  • Utilize Snowflake's query profiling and optimization features to identify bottlenecks and inefficiencies.
  • Security and Access Control : Implement security measures and access controls to protect sensitive data stored in Snowflake databases.
  • Configure user roles, privileges, and permissions to enforce data security policies and compliance requirements.
  • Monitor database activity for unauthorized access or suspicious behavior.
  • High Availability and Disaster Recovery : Implement high availability and disaster recovery solutions to ensure business continuity and minimize downtime in the event of hardware failures, network outages, or other disruptions.
  • Configure database replication, failover mechanisms, and backup and restore procedures.
  • Monitoring and Alerting : Monitor database performance, resource utilization, and system health using monitoring tools and dashboards.
  • Set up alerts and notifications to proactively identify issues, anomalies, and performance degradation and take corrective actions as needed.
  • Capacity Planning and Scaling : Monitor database usage and resource consumption trends to forecast capacity requirements and plan for scaling resources as needed.
  • Provision additional compute and storage resources, adjust configurations, and optimize resource utilization to accommodate growing workloads and changing business needs.
  • Mock Interview

    Practice Video Interview with JobPe AI

    Start Job-Specific Interview
    cta

    Start Your Job Search Today

    Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

    Job Application AI Bot

    Job Application AI Bot

    Apply to 20+ Portals in one click

    Download Now

    Download the Mobile App

    Instantly access job listings, apply easily, and track applications.

    coding practice

    Enhance Your Skills

    Practice coding challenges to boost your skills

    Start Practicing Now
    KPMG India logo
    KPMG India

    Professional Services

    Pune

    RecommendedJobs for You