You are here:   Home
Register  |  Login
 Links
Minimize
 Announcements
Minimize
October Meeting - Tuesday, September 16, 2014

When:   Wednesday October 15thth, 6:00pm – 8:00pm

              (Always the third Wednesday of the month)

 

Where:  New Horizons

               2727 NW Loop 410

 

Presenter:

              Mike Byrd

Former rocket scientist, retired USAF fighter test pilot; now a database geek. Former CTO for Texas Windstorm Insurance Association (9 years) and now part-time SQL Server consultant for several companies in greater Austin, TX area. Expertise is performance tuning. Just completed teaching a Basic TSQL class (15 classroom hours, 17 students) with emphasis on query writing and performance.

 

Topic:  

Foreign Keys have a bad rap - they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let's further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.

 

Give away:

            Several SQL books.

 

More Info:

            jim.steiner@rackspace.com

            www.salssa.com

 

Pizza and soda will be provided.  All are welcome.

 
 Text/HTML
Minimize
Essential Duties and Responsibilities:

Responsible for administration and maintenance of Enterprise databases. This includes support of SQL Server 2000, 2005, 2008 as well as assisting in support of vendor managed Oracle databases, their configuration, and administration. This position also requires occasional travel, off-hours work, and participation in an on-call rotation.

Ensure availability and high performance of the Enterprise SQL Server and Oracle Databases in a multi-site and multi-domain hosting environment.
Investigate and document Database and server information
Plan, deploy, support and maintain new Enterprise databases
Proactively Monitor databases and resolve any alerts
Implement and release database changes according to agreed cost and timelines
Problem solving and troubleshooting connection, performance and job scheduling issues
Stay up to date on and suggest new ways to better manage the database environments
Implement database backup strategies for new projects
Enforce security and best practices within database environments and patch database instances
24 hour availability when on-call and the willingness to work outside business hours as needed
Perform related duties as assigned by supervisor
Maintain compliance with all company policies and procedures and government regulatory requirements


Education and/or Work Experience Requirements:

Bachelor’s Degree or relevant work experience
In depth SQL Server Database Administration experience
Experience managing multiple MS SQL Server 2000, 2005, 2008 RDBMS on Enterprise Systems
Strong self-sufficiency and initiative working on Database projects
Practical experience in monitoring and tuning a database to provide high availability and maximum performance
Good database fundamentals and knowledge of SQL Server internals
Database system migration, upgrade and patching

In addition we expect:

Excellent verbal and written communication skills, including the ability to effectively communicate with internal and external clients
Excellent computer proficiency (e.g. MS Office – Word, Excel and Outlook)
Must be able to work under pressure and meet deadlines while maintaining a positive attitude and providing exemplary customer service
Ability to work independently and to carry out assignments to completion within parameters of instructions given, prescribed routines, and standard accepted practices
Innovation, focus, dynamism, off-centeredness, dedication, humor, compassion and intelligence.



Tanya Duelm
Technical Recruiter
8626 Tesoro Drive, Suite 480, San Antonio, TX 78217
P: 210-787-2217| C: 210-875-9046
tanyad@consultis.com
www.consultis.com

 Sponsors
Minimize

  

 

 


 

 


 

     
         

 

        

    

 

 

 

 

 

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