Key Areas of Responsibility
- Database Design and Development- Collaborate with stakeholders to understand business requirements, then translate them into database designs.
- Extract, Transform, Load (ELT) Processes- Develop and maintain ETL processes to extract data from various sources, transform it into the desired format, and load it into databases.
- Risk & Security- Ensures risk analysis and mitigation is built into each IT project and is engaged in advancing the safety culture.
Key Competencies for Success
Values People and Teams
- Establishes regular communication channels with individuals and teams involved in the project.
- Drives project performance and communicates issues and concerns timely to leadership.
- Values the teams they are a part of by listening, contributing, and engaging regularly in a positive and productive manner.
- Collaborate with software developers, data analysts, and other teams to integrate database solutions into applications and reporting systems.
Customer Centric
- Ensure compliance with data privacy regulations, data security principles and other data integrity/compliance standards.
- Must maintain strong relationships with your customers, ensuring that they are satisfied with the products and services they receive, and provide ongoing support when needed.
- Ensure project deliverables meet quality standards and customer requirements to receive exceptional customer feedback.
- Demonstrates strong collaboration skills and reliably follows through on their promises to other departments.
- Stay up to date with the latest developments in database technologies and best practices to identify opportunities to enhance database performance and recommend improvements.
Operational Excellence
- Perform quality assurance testing, facilitate end-user testing, and secure user sign-off/approval of new or modified solutions.
- Monitor database performance and troubleshoot issues promptly.
- Ensure data integrity, accuracy, and consistency through proper normalization and validation techniques.
- Write and optimize complex SQL queries for data retrieval, manipulation, and reporting.
- Identify and resolve performance bottlenecks in queries and database structures.
- Develop and maintain database schemas, tables, views, and indexes.
- Monitor and fine-tune query performance to improve system responsiveness.
- Document database designs, schemas, processes, and troubleshooting guides for reference.
- Perform regular backups and recovery procedures to maintain data availability and integrity.
- Follows the established best practices to achieve better results, reduce risks, improve efficiency, increase stakeholder satisfaction, and enhance reputation.
- Degree in Database Management, Database Administration, Software Engineering, Computer Science or Management Information Systems
- Experience working on Oracle or SQL Server environments
- Experience in T-SQL, PL/SQL
- Excellent Problem-Solving Skills
We Offer:
- Paid holidays
- Health, dental and vision insurance
- Growth potential with a stable company
- Paid vacation and sick days
- Health club reimbursement
- Wellness - $100 a year for getting your yearly physical
- 401k with company match and profit-sharing
- Tuition reimbursement
- Term, AD&D and Dependent Life insurances
- Prepaid Legal
The Waldinger Corporation is a full-service mechanical, electrical, sheet metal and service contractor operating under a people-first approach. The Waldinger Corporation has branches throughout the Midwest United States and has built a reputation of success since 1906.
The Waldinger Corporation is an EOE, including disability/vets.
The Waldinger Corporation participates in E-Verify.