Career Area:
Business Technologies, Digital and Data
Job Description:
Your Work Shapes the World at Caterpillar Inc.
When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.
Your Impact Shapes the World at Caterpillar Inc
When you join
Caterpillar , you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.
Job Summary
We are seeking a skilled
Data Specialist _
Snowflake Database Administrator in our
Caterpillar Information Technology team. In order to lead the development and implementation of the Global Finance Data Platform, the team is seeking a Senior Database Administrator to join their dynamic, high-performing team. Through the creation of platforms that enable data to be brought to modernized data platforms on AWS & Snowflake, this team is playing a crucial part in changing our mindset to using data as an enterprise asset.
The preference for this role is to be based out of
Whitefield Office, Bangalore, India
What You Will Do
Job Roles and Responsibilities
- The primary responsibility would be performing a vital role in transforming our mindset to using data as an enterprise asset by enabling platforms that bring data to modernized data platform on AWS & Snowflake.
- Incumbent would play central critical role for identifying performing core database administration for Snowflake environment, build automation to optimize the environment, build pipelines to define metrics related to all things snowflake and be key central point of contact for Snowflake within the organization.
Candidates Will Have:
- Should have minimum 3 years relevant experience into MS SQL or Snowflake as DBA.
- Actively work with MS SQL or Snowflake support for raising support tickets and triaging outages.
- Implement/support automation for production deployment in Snowflake.
- Good understanding of MS SQL or Snowflake tools
- Develop, build & maintain mission critical centralized data platform using SQL/Snowflake.
- Diagnose and troubleshoot SQL/Snowflake database errors.
- Implement Snowflake user /query log analysis and alerts.
- Support heterogeneous user groups from data engineers to data scientists.
- Implement data encryption/decryption/masking policies to protect PII/PCI data
- Implement security roles and role based policies.
- Derive system metrics for consumption and utilization.
- Demonstrated proficiency of index design, query plan optimization and analysis required
- Build User security auditing.
- Create Snowflake utilization and capacity plan.
- Provide technical leadership, fosters a team environment, and provides mentorship and feedback to technical resources. User onboarding and
- On-call responsibilities on rotational basis for Snowflake database administration.
- Should be able to review project requests describing database user needs to estimate time
- Develop processes for optimizing database security.
- Set and maintain database standards.
- Diagnose and troubleshoot database errors.
- Create and manage database reports, visualizations, and dashboards.
- Create automation for repeating database tasks.
- Database Administrator Skills and Qualifications: Proficient in writing complex SQL queries
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards Understanding of relational and dimensional data modeling
- Strong mathematical and statistical knowledge
- Excellent written and verbal communication skills
- Impeccable attention to detail
- Experience with cloud services (AWS, Microsoft Azure)
Education And Experience Requirements:
- Bachelor’s degree in computer science or a related field
- 3+ years of experience in database administration, database architecture, or a related field(mandate)
- Database Administration / Database related certifications preferred.
- Extensive experience with database technologies (Snowflake/Teradata/ Big Query/SQL Server/MongoDB)
What You Will Have
Communicating Complex Concepts : Knowledge of effective presentation tools and techniques to ensure clear understanding; ability to use summarization and simplification techniques to explain complex technical concepts in simple, clear language appropriate to the audience.
Level Working Knowledge:
- Uses comparisons to familiar ideas when introducing a technical or novel feature.
- Separates fundamental concepts from supporting details in explaining a product or service.
- Explains products and services with little or no use of technical jargon or advanced vocabulary.
- Emphasizes the most important facts or features of a product or service.
- Perceives lack of audience comprehension; further simplifies explanation when needed.
Cloud Computing: Knowledge of the concepts, technologies and services of cloud computing; ability to design, deploy and implement cloud computing solutions in various business environment.
Level Working Knowledge:
- Works with a specific cloud service model, such as Infrastructure as a Service (IaaS) or Software as a Service (SaaS).
- Follows established procedures in defining client requirements for cloud services.
- Implements a specific cloud service model, such as Infrastructure as a Service (IaaS), Software as a Service (SaaS) or Serverless computing.
- Carries out tasks, under supervision, to increase capacity or add capabilities through cloud computing.
- Documents and resolves basic problems related to cloud security.
What You Will Get:
- Work Life Harmony
- Earned and medical leave.
- Flexible work arrangements
- Relocation assistance
Holistic Development
- Personal and professional development through Caterpillar ‘s employee resource groups across the globe
- Career developments opportunities with global prospects
Health and Wellness
- Medical coverage -Medical, life and personal accident coverage
- Employee mental wellness assistance program
Financial Wellness
- Employee investment plan
- Pay for performance -Annual incentive Bonus plan.
Additional Information:
Caterpillar is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status; however, as a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at www.caterpillar.com/careers
Caterpillar is an Equal Opportunity Employer (EEO)
EEO/AA Employer. All qualified individuals, including minorities, females, veterans, and individuals with disabilities - are encouraged to apply.
Posting Dates:
June 5, 2024 - June 11, 2024
Caterpillar is an Equal Opportunity Employer (EEO).
Not ready to apply? Join our Talent Community .
