- Experience with complicated SSIS Package coding and maintenance.
- Participate in ongoing DW/BI performance tuning activities.
- Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have).
- Refine and automate regular processes, track issues, and document changes.
- Perform scheduled maintenance and support deployment activities as required.
- Manage SQL Databases but not limited and can extend to NoSQL/Cloud Database as applicable.
- Experience in creation of SQL Tables, Views, MV’s, Stored Procedures and working on complex T- SQL statements.
- Expert knowledge in traditional relational database concepts and design. Fluent in SQL.
- Database design and query optimization.
- Write and debug stored procedures and ability in advanced SQL operations.
- Automate manual data tasks through workflows and ETL packages.
- Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent.
- Administrate application and server environments.
- Analyze data quality and make recommendations for data preparation.
- Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).
- Experience with data manipulation, data engineering, and working with large data sets.
- Follow guidance from senior team members to plan, deploy, and maintain critical data solutions.
- Data engineering and manipulation of large data sets.
- Perform system monitoring and technical support.
- Analyze data quality and make recommendations for data preparation.
- Installing and configuring SQL Server, applying patches and fixes and monitoring, troubleshooting, and optimizing performance.
- Creating backup plans, developing, and testing disaster recovery scenarios, managing security, server sizing, and performance tuning.
- Bachelor’s or master’s degree in computer science or related discipline.
This is a summary of the primary accountabilities and requirements for this position. The company reserves the right to modify or amend accountabilities and requirements at any time at its sole discretion based on business needs. Any part of this job description is subject to possible modification to reasonably accommodate individuals with disabilities.
About UsMouser Electronics, founded in 1964, is a globally authorized distributor of semiconductors and electronic components for over 1,200 industry-leading manufacturer brands. We specialize in the rapid introduction of the newest products and technologies targeting the design engineer and buyer communities.Mouser has 28 offices located around the globe. We conduct business in 23 different languages and 34 currencies. Our global distribution centre is equipped with state-of-the-art wireless warehouse management systems that enable us to process orders 24/7, and deliver nearly perfect pick-and-ship operations.
Skills Required
- Hands-on experience developing and maintaining complex SSIS packages
- Create and automate ETL packages; SSIS mandatory
- Advanced T-SQL: tables, views, materialized views, stored procedures, complex queries
- Expert knowledge of relational database design and query optimization; fluent SQL
- Experience managing SQL Server databases, including installation, patching, performance tuning
- Ability to maintain, monitor, and troubleshoot scheduled jobs using SQL Server Agent
- Experience with data engineering, data manipulation, and working with large data sets
- Familiarity with NoSQL and cloud databases (ability to extend beyond SQL Server)
- Experience with DW/BI performance tuning and deployment activities
- Bachelor's or Master's degree in Computer Science or related discipline
- Strong written and verbal communication skills for technical analysis and documentation
What We Do
Mouser Electronics is a worldwide leading authorized distributor of semiconductors and electronic components from over 1,100 manufacturer brands. We specialize in the rapid introduction of new products and technologies for design engineers and buyers. Our extensive product offering includes semiconductors, interconnects, passives, and electromechanical components. In 2007, Mouser became a part of the Warren Buffett Berkshire Hathaway family of companies. Today, Buffett's holdings include insurance and finance subsidiaries and a host of almost fifty businesses ranging from jewelry and furniture to manufactured homes. Mouser has a strong commitment to customer service. That’s why we’ve won awards for our legendary worldwide customer service excellence. We understand the value of having a knowledgeable person there to answer your questions quickly. Mouser is redefining customer-focused distribution. For more information, visit www.mouser.com To learn about careers at Mouser, visit careers.mouser.com Facebook: www.facebook.com/mouserelectronics Twitter: www.twitter.com/mouserelec Instagram: www.instagram.com/mouserelec YouTube: www.youtube.com/mouserelec
