at Koch Business Solutions, LP in Lisle, Illinois, United States
Job Description
Your Job
As a Database Administrator specializing in Snowflake, you will play a critical role in maintaining, optimizing, and securing systems of our enterprise data platform. You will work closely with data engineers, dataarchitects, BI Analysts, and other stakeholders to ensure data availability, performance, and reliability.
This role is not eligible for sponsorship
Our Team
KBX is looking for a Database Administrator to join our team! The role will be part of the transformation of our Data and Analytics team responsible for building, supporting and enhancing our enterprise data platform. We are seeking an individual who will be part of design and implementation of the enterprise platform that possesses strong collaboration and communication skills, as well as a deep understanding of data management and processing.
What You Will Do
Manage and maintain all environments of cloud data warehouses, databases, and schemas, including provisioning, scaling, and optimizing for performance.
Implement and enforce data security best practices, including access controls, encryption, and compliance with industry regulations (e.g., GDPR). Identifying, reporting, and managing database security issues, audit trails etc.
Documentation and Training of new designs and best practices
Monitoring and tune cloud data warehouse workloads to ensure optimal query performance and resource utilization. Monitoring usage, transaction volumes, response times, concurrency levels and troubleshoot proactively.
Set up monitoring systems and alerts to identify and address performance issues or anomalies.
Diagnose and resolve data platform-related issues, working closely with cross-functional teams.
Other relevant tasks include develop, backup and recovery, data object role management, documentation and capacity planning.
Who You Are (Basic Qualifications)
Experience managing and maintain databases to ensure security, performance and availability to support data storage and retrieval
Experience with ELT pipelines and BI Consumptions systems
Experience using SQL and Python in an enterprise environment
Experience implementing data security measures, access controls, and design within a database
Experience communicating with cross functional stakeholders and collaborating with data teams.
What Will Put You Ahead
Experience with large-scale data warehouse technology such as Snowflake or Redshift
Experience using Python for automation, building data pipelines and managing resources
Experience in design and implementing role-based access controls within the Snowflake platform.
Experience with data analysis and visualization solutions, such as PowerBI or Tableau
Experience with API (REST, GRPC) and streaming data capabilities (Kafka, AWS Kinesis, etc.)
Experience with ELT/ETL tools like AWS Glue or Talend
For this role, we anticipate paying $100,000 - $140,000 per year. This role is eligible for variable pay, issued as a monetary bonus or in another form.
The application window is anticipated to close on 30 days from March 26, 2024.
At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value and get rewarded for our individual contributions. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate's knowledge, skills, abilities, and geographic location. If you have questions, please speak to your recruiter about the flexibility and detail of our compensation philosophy.
Hiring Philosophy
All Koch companies value diversity of thought, perspectives, aptitudes, experiences, and backgrounds. We are Military Ready and Second Chance employers. Learn more about our hiring philosophy here.
Who We Are
As a Koch company, KBX provides the global transportation, logistics and technology solutions that help our customers deliver life's essentials to people all over the world. We develop and deploy cutting-edge technologies to deliver better solutions for increasingly complex supply chains. Our team of tenacious problem-solvers are driven to create real, long-term value for our customers.
At... For full info follow application link.
Infor does not discriminate in employment opportunities or practices on the basis of race, color, creed, religion, sex, gender identity or expression, sexual orientation, national origin, genetics, disability, marital status, age, veteran status, protected veterans, military service obligation, citizenship status, individuals with disabilities, or any other characteristic protected by law applicable to the state in which you work. If you have a disability under the Americans with Disabilities Act or similar law, and you wish to discuss potential accommodations related to applying for employment at our company, please contact Human Resources at 470-548-7173 and/or ADAAA@infor.com.
