Snowflake Database Administrator

2 weeks ago

Nashville, Tennessee, United States Caterpillar Full time
Career Area:
Business Technologies, Digital and Data

Job Description:

Your Work Shapes the World at Caterpillar Inc.

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.


Role Definition:

As a Snowflake Database Administrator, you will be primarily responsible for ensuring the integrity, security, and performance of the Data platform that supports the data needs of various business units and functions.

You will work closely with the Enterprise Data Governance team and the Business Governance team to follow the standards and principles of data management and governance.

You will also collaborate with data engineers, data analysts, data scientists, and other stakeholders to provide data solutions that meet the business requirements and objectives.


What You Will Do:

Manage and monitor the Snowflake platform, including data ingestion, data transformation, data quality, data security, and data access.

Apply the principles and policies that have been agreed with the Business Governance team regarding data source ingestion, database functional organization, and access management.

Implement and enforce best practices for data modeling, data architecture, data governance, and data lifecycle management.

Troubleshoot and resolve any issues or incidents related to the Snowflake platform and provide root cause analysis and recommendations for improvement.

Provide technical support and guidance to data users and consumers and ensure that they have the appropriate access and permissions to the data they need.

Review and approve code changes as part of the CI/CD process.

Maintain and update our CI/CD Python package as required.

Collaborate with Enterprise Data Lakes to ensure efficient data flows.

Keep abreast of the latest developments and trends in Snowflake and other data technologies and evaluate and recommend new features or tools that can enhance the data capabilities and performance.

Lead actions to maintain the infrastructure of IT systems that support the business to function efficiently.

Guide the design solutions by assessing and aligning the current systems to best practices and comply to federal policies and procedures.

Execute the middleware application server and automated workflow tools, work with server virtualization technologies.

Administer updates, upgrades, and other maintenance tasks in both hardware and software areas, to make the network more efficient, cost-effective, and secure.


What You Have:

Bachelor's degree in computer science, Information Systems, or a related field, or equivalent work experience.

At least 3 years of experience as a Snowflake Database Administrator, or a similar role in data management and administration.

Strong knowledge and skills in Snowflake, including data ingestion, data transformation, data security, data access, and data optimization.

Experience with data governance and data quality frameworks and tools, such as Data Catalog, Data Lineage, Data Dictionary, and Data Profiling.

Experience with SQL and scripting languages, such as Python, JavaScript, Shell, or PowerShell.

Excellent communication, collaboration, and critical thinking skills.

Ability to work independently and as part of a team in a fast-paced and dynamic environment.

Certification in Snowflake or other data technologies is a plus.


Skills Descriptors:

Technical Excellence:

Knowledge of a given technology and various application methods; ability to develop and provide solutions to significant technical challenges.


Level Extensive Experience:

  • Advises others on the assessment and provision of all technical solutions.
  • Engages appropriate subject matter resources to effectively resolve technical issues.
  • Mentors' others to enhance their technical competence and its application to achieve more effective technical solutions.
  • Provides effective solutions to moderate technical challenges through strong technical competence, effectively examining implications of events and issues.
  • Assumes accountability for personal technical performance and holds others responsible for theirs.

Technology Advising:

Knowledge of effective advisory methods and ability to provide valued information and advice to clients regarding products, technologies, services, and solutions for a specific technology domain.


Level Working Knowledge:
Assesses the current technology environment, expressed needs and initiatives of client organizations.

Demonstrates basic competence and sound business knowledge regarding specific products, technologies, or services within a domain of technology expertise.


Achieves consulting relationship rating of 'professional' by delivering timely, meaningful advice meeting client needs in a narrow set of specific technologies.


Hardware Infrastructure:

Knowledge of computer architecture and systems programming; ability to design, build and integrate IT hardware into multi-platforms for the organization.


Level Extensive Experience:
Evaluates IT hardware vendors in the market and selects the most suitable products for the organization.

Guides employees on the integration of IT hardware throughout other organization-wide platforms.

Supervises the implementation process of IT hardware ensuring consistency in productivity and overall effectiveness.

Advises others on business standards and practices for IT hardware to meet designer requirements.

Evaluates the advantages and disadvantages of an organization's hardware components.

Diagnoses IT hardware problems and recommends dynamic solutions.

Requirements Analysis:

Knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.


Level Working Knowledge:
Follows policies, practices, and standards for determining functional and informational requirements.

Communicates with customers and users to elicit and gather client requirements.

Participates in the preparation of detailed documentation and requirements.

System Testing:

Knowledge of system and software testing; ability to design, plan and execute system testing strategies and tactics to ensure the quality of software at all stages of the system life cycle.


Level Extensive Experience:
Verifies the proper flow of transactions across all input, output and storage channels or devices.

Evaluates interoperability of new systems with existing systems during the beta testing phase.

Supervises the testing of complex, multi-platform, and distributed applications.

Designs processes to ensure that the system meets and maintains requirements and expectations.

Coaches end users on the development of test data and test scenarios for system validation.

Manages the execution of test plans, including resources, strategies, schedules, processes, and tools.

Systems Software Infrastructure:

Knowledge of computer architecture and system software interaction; ability to design and build a fundamental architecture of operating systems, database management systems, communications protocols, compilers, and other development tools.


Level Working Knowledge:
Demonstrates planned software changes on the local environment.

Analyzes the local software architecture components and products.

Tests key features for the entire software infrastructure environment.

Technical Troubleshooting:

Knowledge of technical troubleshooting approaches, tools, and techniques; ability to anticipate, recognize, and resolve technical issues on hardware, software, application or operation.


Level Extensive Experience:


Emphasizes the business impact of failure and the criticality and timing of needed resolution so that problems can be avoided in the future.

Creates trouble reports for all issues found and reviews solutions for completeness and correctness.

Directs the resolution of communications problems in multi-vendor environments.

Resolves a variety of hardware, software, and communications malfunctions.

Coaches' others on advanced diagnostic techniques and tools for unusual or performance-related problems.

Facilitates the distribution of releases reports and correction packages to departments or clients.

Technical Writing/Documentation:

Knowledge of technical writing; ability to write technical documents such as manuals, reports, guidelines or documents on standards, processes, and applications.


Level Extensive Experience:
Conducts training on alternative documentation delivery mechanisms, tools, and techniques.

Manages cost items in producing and maintaining documentation.

Designs and implements formal methodologies for producing documentation.

Collaborates with support function managers, the product management team, and design engineers with writing projects.

Supervises the analysis, design, and data collation on large documentation initiatives.

Establishes and references best practices for existing and planned tools and delivery vehicles for proper documentation.

Additional Information:

Location:
Peoria, IL, Dallas, TX or Nashville, TN

NO RELOCATION
3days MANDATORY IN OFFICE

Sponsorship is not available including OPT, H4-EAD. Must be US Citizen or Green Card holder.

What You Will Get:

Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world.

Here you earn more than just an hourly wage because we value your performance, we offer a total rewards package that provides day one benefits (medical, dental, vision, RX, and 401K) along with the potential of an annual bonus.

Additional benefits include paid vacation days and paid holidays (prorated based upon hire date).

About Caterpillar:
Caterpillar Inc.

is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives.

For nearly 100 years, we've been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future.

Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.

Visa Sponsorship is not available for this position.

This employer is not currently hiring foreign national applicants that require or will require sponsorship tied to a specific employer, such as, H, L, TN, F, J, E, O.

As a global company, Caterpillar offers many job opportunities outside of the U.S which can be found through our employment /careers.


Posting Dates:
October 15, October 28, 2024

Any offer of employment is conditioned upon the successful completion of a drug screen.

EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.

Not ready to apply? Join our Talent Community ( .

  • Snowflake Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Caterpillar Full time

    About the Role:Caterpillar is seeking a highly skilled Snowflake Database Administrator to join our team. As a key member of our data platform team, you will be responsible for ensuring the integrity, security, and performance of our data platform.Key Responsibilities:Manage and monitor the Snowflake platform, including data ingestion, data transformation,...

  • Snowflake Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Caterpillar Full time

    About the RoleCaterpillar Inc. is seeking a highly skilled Snowflake Database Administrator to join our team. As a key member of our data management team, you will be responsible for ensuring the integrity, security, and performance of our data platform.Key ResponsibilitiesManage and monitor the Snowflake platform, including data ingestion, data...

  • Database Administrator

    3 weeks ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Omni Inclusive. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database infrastructure to ensure high performance and reliability.Key Responsibilities:Develop and implement automated...

  • Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Omni Inclusive. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database infrastructure to ensure high performance and availability.Key Responsibilities:Design and implement database...

  • Database Administrator

    1 week ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job DescriptionWe are seeking a highly skilled Database Administrator to join our team at Omni Inclusive. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database infrastructure to ensure high performance and availability.Key Responsibilities:Design and implement database solutions using Sybase,...

  • Database Administrator

    1 week ago

    Nashville, Tennessee, United States GovCIO Full time

    Job DescriptionGovCIO is seeking a skilled Database Manager to lead database administration in structured and unstructured database platforms, including NoSQL databases. The ideal candidate will have 8+ years of experience in designing, implementing, and administering SQL-based relational database management systems (RDBMS) and STIGs on database...

  • Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Tekfortune Inc Full time

    Job Title: Sybase + MSSQL/PostgreSQL AdminAbout the Role:We are seeking an experienced IT System Engineer to join our team at Tekfortune Inc. as a Sybase + MSSQL/PostgreSQL Admin. As a key member of our database support team, you will be responsible for providing expert-level support for our MSSQL and SYBASE platforms within the banking organization...

  • Database Administrator

    5 days ago

    Nashville, Tennessee, United States Saxon Global Full time

    Job Title: Database AdministratorJob Summary:We are seeking an experienced Oracle Apps DBA to join our team at Saxon Global. The ideal candidate will have a strong background in Oracle database administration, with a focus on EBS support and security patching.Key Responsibilities:- Participate in team meetings and troubleshooting calls- Resolve customer...

  • Senior Database Administrator

    5 days ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job SummaryThe Senior Database Administrator will be responsible for designing, developing, and maintaining large-scale database systems in a cloud environment. This role requires a strong understanding of database design, development, and administration, as well as experience with cloud-based technologies such as Azure and AWS.Key Responsibilities Design...

  • Oracle Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Randstad Full time

    Job Title: Oracle Database AdministratorAre you a skilled Oracle database administrator looking for a new challenge? We have an exciting opportunity for a seasoned professional to join our team as an Oracle Database Administrator.Responsibilities:Install, configure, and maintain Oracle Multi-Tenant Architecture and PostgreSQL database servers.Set up...

  • Senior Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job Title: Senior Database AdministratorOmni Inclusive is seeking a highly skilled Senior Database Administrator to join our team. As a key member of our database team, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance, security, and scalability.Key Responsibilities:Design and implement...

  • Database and Administration Specialist

    2 weeks ago

    Nashville, Tennessee, United States (NAHT) Nashville Anti-Human Trafficking Coalition Full time

    About NAHTNAHT (Nashville Anti-Human Trafficking Coalition) is a non-profit organization dedicated to rescuing and restoring women and children affected by trafficking in Nashville, TN.Job DescriptionWe are seeking a highly organized and detail-oriented Database and Administration Specialist to join our team. The successful candidate will support the...

  • Senior Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job SummaryWe are seeking a highly skilled Senior Database Administrator to join our team at Omni Inclusive. As a key member of our database team, you will be responsible for designing, implementing, and maintaining our database systems to ensure high availability, performance, and security.Key ResponsibilitiesDesign and implement database systems to meet...

  • SQL Database Administrator

    2 weeks ago

    Nashville, Tennessee, United States Centraprise Full time

    Job Title: SQL Database AdministratorJob Summary:We are seeking a highly skilled SQL Database Administrator to join our team at Centraprise. The successful candidate will have expertise in designing, implementing, and maintaining large-scale SQL Server environments.Key Responsibilities: Design and implement high-performance SQL Server environments Ensure...

  • Senior Database Administrator

    1 month ago

    Nashville, Tennessee, United States Oracle Full time

    Job DescriptionOracle is seeking a highly skilled Senior Database Administrator to join our team. As a key member of our database infrastructure team, you will be responsible for designing, implementing, and maintaining our Oracle Autonomous Database (ADB) infrastructure in Oracle Cloud Infrastructure (OCI).This is a unique opportunity to work with a...

  • Senior Oracle Database Administrator

    4 days ago

    Nashville, Tennessee, United States Tekfortune Inc Full time

    Job Description:At Tekfortune Inc, we are seeking a highly skilled Senior Oracle Database Administrator to join our team. As a key member of our database administration team, you will be responsible for ensuring the smooth operation of our Oracle databases.Key Responsibilities:Design, implement, and maintain high-performance Oracle databasesDevelop and...

  • Database Administrator 5

    2 weeks ago

    Nashville, Tennessee, United States Saxon Global Full time

    Job Title: Database Administrator 5Job Summary:We are seeking an experienced Oracle Apps DBA to join our team at Saxon Global. The ideal candidate will have a strong background in Oracle database administration, with a focus on EBS security patching, cloning, and troubleshooting.Key Responsibilities:Actively participate in team meetings and troubleshooting...

  • Senior Oracle Database Administrator

    1 week ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    Job SummaryWe are seeking a highly skilled Senior Oracle Database Administrator to join our team in Nashville. As a key member of our Domain Expert team, you will be responsible for providing expert-level support for our 16,000+ PostgreSQL and Oracle databases.Key ResponsibilitiesDevelop and implement automated solutions using DevOps constructsProvide...

  • Senior Oracle Database Administrator

    3 weeks ago

    Nashville, Tennessee, United States Omni Inclusive Full time

    About the RoleWe are seeking a highly skilled Senior Oracle Database Administrator to join our team in Nashville. As a key member of our Domain Expert team in Infrastructure and Platform function, you will be responsible for providing high-level database expertise for day-to-day support of production and development environments.Key ResponsibilitiesDevelop...

  • Senior SQL Database Administrator

    5 days ago

    Nashville, Tennessee, United States Insight Global Full time

    Job SummaryWe are seeking a highly skilled Senior SQL Database Administrator to join our team at Insight Global. As a key member of our database operations team, you will be responsible for the administration and maintenance of our Microsoft SQL Server systems.Key Responsibilities:Monitor and maintain the health and performance of our database...