You are here:   Home
Register  |  Login
 Links
Minimize
 Announcements
Minimize
May Meeting - Thursday, May 14, 2015

When:   Wednesday May 20th, 6:00pm – 8:00pm (Always the third Wed. of the month)

 

Where:  New Horizons 2727 NW Loop 410

 

Presenter:

              Tim Mitchell is a business intelligence consultant, author, and trainer.  He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010.  Tim is an independent BI consultant and a group principal with Linchpin People.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBitsSQL ConnectionsSQL Saturday events, and various user groups and webcasts.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

 

Topic:  

Building Bullet-Resistant SSIS Packages

 

It's 2:30 a.m., and you've just gotten that call no ETL developer wants to get: an SSIS package has failed unexpectedly. Immediately, you start asking yourself: "What could have caused this?", "What do I do to fix the data from this failed execution?", and, most importantly, "Could I design the package in such a way that this doesn't happen again?"

In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we'll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We'll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.

 

More Info:

            jim.steiner@rackspace.com

            www.salssa.com

 

Pizza and soda will be provided.  All are welcome.

 
 Job Opportunities
Minimize

JR Database Administrator

As a member of the DBA team, you will be responsible for configuring, managing, maintaining and monitoring SQL Servers in our Production environment. Our DBAs will also assist in supporting our SQL Servers in multiple Development environments. Database security, reviewing object level changes for deployments, implementing new SQL technology/features, upgrading our SQL servers will also be an essential part of your role. You will report to the DBA Manager.

ESSENTIAL JOB DUTIES:

·         Support a high volume, large database environment within our Production infrastructure

·         Own, track and resolve database related incidents and requests within established SLA’s

·         Review service related reports (capacity, post-deployment performance, etc.)

·         Respond to database related alerts and escalations within expected timeframes

·         Assist with DR documentation and drills

·         Act as the lead on major department initiatives and projects

·         Assist with creating functional documentation

·         Work with Engineering and Data Center team to help resolve performance issues

·         Work with the IT Infrastructure team for SQL Server installation and administration

·         Work with the Engineering team to come up with strategic solutions for recurring issues

·         Configure and manage backups

·         Provide 24x7 on-call support for production database issues

Skills & Requirements

EDUCATION:

·         Bachelor’s Degree in Information Systems, Computer Science or related field or related experience

EXPERIENCE:

·         3+ years of experience with MS SQL Server in a production environment

·         Profiler and other monitoring and troubleshooting tools

·         Experience with any of the following Failover Cluster/Log shipping/AlwaysOn

·         Ability to identify and prioritize actions to achieve goals and mitigate risk

·         Excellent written and oral communication

 

Contact me at Doug.Valdez@uhs-sa.com

 

 

 Sponsors
Minimize

  

 

 


 

 



       

 

 

 

 

 

 FAQs
Minimize
 SALSSA Contacts
Minimize
Name Role Email
Jim Steiner SALSSA Coordenator