- Install, configure, and maintain both operational databases and data warehouse systems. Design and implement database structures, schemas, and data models to support organizational requirements.
- Develop and maintain Extract, Transform, Load (ETL) processes to extract data from various sources, transform it as necessary, and load it into the data warehouse. Ensure data consistency and accuracy throughout the ETL process.
- Implement security measures to protect sensitive data stored in both databases and the data warehouse. Ensure compliance with data privacy regulations and industry standards (e.g., GDPR, HIPAA) through proper data encryption, access controls, and auditing.
- Monitor and optimize the performance of databases and data warehouse systems. Identify and resolve performance bottlenecks, optimize SQL queries, and fine-tune database configurations to improve overall system performance.
- Develop and maintain backup and recovery procedures for both operational databases and the data warehouse. Test backup and recovery processes regularly to ensure data availability in case of system failures or disasters.
- Establish and enforce data governance policies and procedures to ensure data consistency, integrity, and quality across databases and the data warehouse. Implement data validation rules and data quality checks as part of ETL processes.
- Estimate future database and data warehouse capacity requirements and plan for scalability to accommodate growing data volumes. Implement strategies for scaling database and data warehouse systems as needed.
- Provide technical support to users experiencing database and data warehouse-related issues. Develop and deliver training sessions to educate users on database and data warehouse best practices and procedures.
- Maintain accurate documentation of database and data warehouse configurations, ETL processes, and troubleshooting steps. Generate reports on database and data warehouse performance, usage statistics, and compliance metrics as required.
- Collaborate with other IT teams, data engineers, data analysts, developers, and business stakeholders to understand database and data warehouse requirements and to ensure that solutions align with organizational goals and objectives.
- Bachelors degree in computer science, Information Technology, or related field
- Proven experience as a Database Administrator or Data Warehouse Specialist.
- Proficiency in database management systems such as MySQL, Oracle, SQL Server, or PostgreSQL
- Experience with data warehouse technologies such as Amazon, Google BigQuery, or Snowflake.
- Strong understanding of database design principles, normalization, and data modeling techniques.
- Knowledge of ETL tools and processes for data integration and transformation.
- Familiarity with data security best practices, regulatory compliance requirements, and data governance principles.
- Excellent troubleshooting and problem-solving skills.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
- Relevant certifications (e.g., AWS Certified Solutions Architect, Microsoft Certified: Azure Data Engineer Associate) are a plus.
-
Database Specialist
4 days ago
S3 Connections Pvt Ltd Appleton, United States**Job Title: Database Architect** · **Department: Information Technology** · **Duration: 6 months Contract with the possibility of extension or converted to full-time.** · **Location : Appleton WI (Relocation is also fine)** · **(Only for US Citizen and Green Card Holders)** · ** ...
-
Sourcing Specialist
1 week ago
Employment Resource Group, Inc. Appleton, United StatesWe are looking for a driven self-starter to join our team as a Sourcing Specialist - to take the lead in the research efforts and drive the candidate side of the process · The Sourcing Specialist works across a variety of functions including market research, sourcing, database ma ...
-
Support Specialist
4 weeks ago
InsideHigherEd Appleton, United States Administrative Jobs ,· Support Specialist - Information Technology Division · Fox Valley Technical College · Job Category · Regular Support Staff · FVTC Worksite · Appleton Main Campus · Hourly Rate · $22.29 · Hours Per Week · 40 · Job Description Summary · Employee demonstrates responsibility and i ...
-
Support Specialist
3 weeks ago
InsideHigherEd Appleton, United States Administrative Jobs ,· Support Specialist - Transportation · Fox Valley Technical College · Job Category · Regular Support Staff · FVTC Worksite · J.J. Keller - Transportation Center · Hourly Rate · $22.29 · Hours Per Week · 40 · Job Description Summary · This position performs a wide variety of adm ...
-
Sourcing Specialist
4 days ago
Employment Resource Group Inc Appleton, United StatesWe are looking for a driven self-starter to join our team as a Sourcing Specialist - to take the lead in the research efforts and drive the candidate side of the process · The Sourcing Specialist works across a variety of functions including market research, sourcing, database m ...
-
Economic Support Specialist
4 days ago
Outagamie County Appleton, United StatesThe Economic Support Specialist establishes eligibility for Economic Support Programs in accordance with policy.The ideal candidate will have the ability to manage multiple priorities and work in a fast-paced environment. They must also possess critical thinking skills, adapt to ...
-
Customer Service
2 weeks ago
CMD CORPORATION Appleton, United StatesJob Description · Job DescriptionCollaborate for Excellence Make a Difference Drive Customer Success · Position: Customer Service and Parts Sales Coordinator · Our Purpose: Making It Better Together... We believe in building lifelong partnerships, providing high performing equipm ...
-
Sr Safety Coordinator
2 weeks ago
Oshkosh Corp. Appleton, United StatesAbout Pierce, an Oshkosh company · At Pierce Manufacturing, we build trucks that protect people and communities around the world. To our team, there is no room for anything less than providing the absolute best. Since 1913, building truck bodies on Model T Ford chassis in an old ...
-
Director of Case Management
2 days ago
ACC Community Connections Appleton, United StatesJob Description · Job Description: · Salary: Director of Case Management This position will provide supervision to a group of Forensic Case Managers who could be assigned caseloads in the following Wisconsin Counties: Ozaukee, Sheboygan, Washington, Dodge, Fond du Lac, Green Lake ...
-
Senior Marketing Specialist
2 weeks ago
Crane Engineering Sales Kimberly, United StatesWe are a family-oriented Midwest and East coast based company; with locations in Wisconsin, Minnesota, Michigan, Maryland, and Pennsylvania. As a result of our growth, we have a need for a Senior Marketing Specialist.The Senior Marketing Specialist is responsible for developing a ...
-
Systems Specialist in IT with Outagamie County
2 weeks ago
County of Outagamie Wisconsin Appleton, United StatesUnder the day-to-day direction of the Senior System Engineer; the Systems Specialist helps to support the County's physical and virtual infrastructure, server applications, databases and security administration. Perform analysis, implementation, supp IT, Specialist, Systems Engin ...
-
Sourcing Specialist
1 week ago
Employment Resource Group Inc Appleton, United StatesWe are looking for a driven self-starter to join our team as a Sourcing Specialist - to take the lead in the research efforts and drive the candidate side of the process · The Sourcing Specialist works across a variety of functions including market research, sourcing, database m ...
-
Technical Support Specialist
1 week ago
Werner Electric Appleton, United States** Technical Support Specialist** · **Job Category****:** Sales **Requisition Number****:** TECHN001189 Showing 1 location **Job Details** · **Description** · **Technical Support Specialist - Appleton** · **A Great Place to Work.** · As a Technical Support Specialist at Wern ...
-
Environmental Health
3 weeks ago
Reynolds Consumer Products Inc. Appleton, WI, United StatesJoin Reynolds Consumer Products Drive Your Career across a world of opportunities We provide amazing job opportunities for growth with competitive salaries and benefits in an exciting, dynamic, fast-paced, and fun workplace environment. If you are looking to build a strong care ...
-
Specialist, Pharmacy Relations
2 weeks ago
Navitus Health Solutions LLC Appleton, United StatesJob Description · Job DescriptionJob Summary: · The Pharmacy Relations Specialist (PRS) is a highly motivated professional with at least 3 years of successful experience working in a pharmacy or interfacing directly with pharmacies or accounts, preferably in healthcare. Responsib ...
-
Environmental Health
1 week ago
Reynolds Consumer Products Appleton, United StatesJob Description · Job Title: Environmental Health & Safety Specialist · City: Appleton / State: Wisconsin · Job Description · Join Reynolds Consumer Productsand Drive Your Career across a world of opportunities We provide amazing job opportunities for growth with competitive ...
-
Email Marketing Specialist
3 weeks ago
TEKsystems Neenah, WI, United StatesDetails: Email marketing specialist, 6 month contract to hire, Hybrid 3 days on site in Neenah, WI. 1-3 years of experience. Conversion salary 60-70K. Need someone with HTML, CSS, HubSpot, email campaign exp. · Description: · The Marketing Automation Specialist plays a vital rol ...
-
Project Specialist
6 days ago
Fox Valley Technical College Appleton, United States**Project Specialist - National Criminal Justice Training Center** · **Fox Valley Technical College** · **Job Category** · Regular Management · **FVTC Worksite** · Appleton Main Campus · **Hours Per Week** · 40 · **Fox Valley Technical College celebrates diversity, supports equit ...
-
Executive Assistant
2 weeks ago
Fox Valley Surgical Associates, Ltd. Appleton, United States**Job Title**:ExecutiveAssistant · **Company**:Fox Valley Surgical Specialists - Appleton, WI · **Department**:Business Office · **Immediate Supervisor**:Chief Operating Officer andDirector of Business and Finance · **Hours**: 40 hours per week, Monday - Thursday 8:30-5:00 and Fr ...
-
Clinical Research Specialist
4 days ago
ThedaCare Appleton, United States**Why ThedaCare?** · Living A Life Inspired · Our new vision at ThedaCare is bold, ambitious, and ignited by a shared passion to provide outstanding care. We are inspired to reinvent health care by becoming a proactive partner in health, enriching the lives of all and creating va ...
Database Specialist - Appleton, United States - S3 Connections LLC
Description
Job Title: Database Architect
Department: Information Technology
Duration: 6 months Contract with the possibility of extension or converted to full-time.
Location : Appleton WI (Relocation is also fine)
Only - Citizens - Green Card Holders
Job Summary:
This job involves installing, configuring, and maintaining operation databases and data warehouse systems, as well as designing and implementing database structures, schemas and data models.
Duties/Responsibilities:
Required Skills/Abilities: