www.sqlpass.org    Professional Association for SQL Server
 Welcome

We have meetings on the second Friday of every month starting at 11:30 MST.  Our location varies from month to month so please double check our Next Meeting notice often.

 


 

 

 

 What's Happening?

Next Meeting: Fri, Aug 09 2013

August Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

August meeting: speaker TBD

When

iCal
UTC : Fri, Aug 09 2013 17:30 - 19:30
Event Time : Fri, Aug 09 2013 11:30 - 13:30 Mountain Daylight Time
Your Local Time: Fri, Aug 09 2013 17:30 - 19:30

Where

6700 Jefferson Street
Albuquerque , New Mexico

Direction: None

Featured Presentation

Dynamic Data Auditing Made Simple

Speaker: Tim Venditti

Summary: Over the past several years, the need to audit the data changes in your onsite database applications has grown. Whether you’re confronted by rules from Sarbanes–Oxley, FDA computer systems validation, or any other rules or requirements that require you to track your data’s history, the task can be easier than you think. We will go over a simple solution using nothing more than a uniform, lightweight trigger and the XML data type to track the history of your data. We will also discuss the benefits and challenges for creating a custom solution like this and compare it to the SQL Server built in solution, Change Data Capture.

About Tim: Tim Venditti currently works as a Database Software Engineer for the Prism Group who specializes in corporate contracting software solutions for the airline industry. Prior to joining the Prism Group, Tim has spent over 13 years providing database solutions across industries like manufacturing, medical services, mortgage lending, pharmaceuticals, and software. Tim has worn many hats over the years and has played the role of DBA, Database Developer, Data Warehouse Architect, Database Analyst and Database Consultant.

Attachments

Transcore, a subsidiary of Roper Industries, Inc. (NYSE: ROP) is seeking a full-time ERP software developer to join the Engineering department in Albuquerque, NM.  Transcore is a local Albuquerque electronics manufacturer.

Job Summary:

The ERP software developer is responsible for enhancing existing and writing new IQPlus reports, SSIS/SSAS/SSRS packages, and developing and maintaining engineering, manufacturing, and finance applications using the ERP system for application validation.

Essential Duties and Responsibilities:

·         Troubleshoot ERP data problems and correct
·         Maintain and write new IQPlus reports
·         Develop and maintain engineering, manufacturing, and finance applications
·         Develop and manage interfaces to and from other systems for Visibility
·         Develop and maintain new SSIS, SSAS, and possibly SSRS packages
Required Skills and Experience:

·         Bachelor’s degree in related field.
·         Visibility.net experience desired with expert IQPlus report development experience but experience in another manufacturing ERP environment is acceptable with willingness to learn IQPlus
·         Databases: MS SQL Server a must,  Oracle, mySQL and Postgre knowledge is beneficial
·         Database Tools: T-SQL in SSMS, SQLplus, ErWin, SQL Navigator, SQL Developer, SQL modeler, or TOAD
·         Interfaces & reporting: SSIS (interfaces), SSAS (data cubes) and SSRS (reports) desired on the MS SQL Server side.
·         Development Tools: VB.Net experience a must; NetBeans & Delphi experience a plus.
To apply: http://www.transcore.com/careers
Select "Albuquerque" and "ERP Software Developer"
  

 

 

 

 

Analyst Programmer 2

UNM Medical Group, Inc. (UNMMG) is the practice plan organization for providers associated with the UNM Health Sciences Center. UNMMG is a New Mexico non-profit corporation and is an equal opportunity employer. UNMMG offers a competitive salary and an attractive benefit package which includes medical, dental, vision, and life insurance as well as tuition assistance, paid leave and 403(b) retirement match.

We are seeking dedicated and talented individuals who will work as part of the IT team responsible for the development and maintenance of revenue cycle application software at UNMMG.  Specifically involves developing and supporting professional billing applications, medical claim editing applications, and other vendor software and in-house developed applications and processes.  The successful recruits will provide primary and backup support to designated modules and processes involved in the billing, collecting, and reporting of professional medical services.

Desired skills: analytical or programming experience with business accounting or medical billing software; SQL experience; experience with QA testing; excellent attention to detail.  The successful candidate will have a strong focus on creating and maintaining superb customer relationships.  
 
BEST CONSIDERATION DATE:  JULY 24, 2014

https://ch.tbe.taleo.net/CH07/ats/careers/requisition.jsp?org=UNMMEDICALGROUP&cws=1&rid=597
This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer. 

 

From our friends at Robert Half:

 

Well respected professional services organization is seeking a SQL Database consultant to provide development support on a couple of key applications. The SQL Database consultant will assist with an upgrade to an existing billing application as well as developing a new web based application for an existing client. Day to day duties include developing database objects and structures for data storage, retrieval and reporting according to project specifications; implement and test database design and functionality, and tuning for performance; Design and develop back-end database interfaces to web and e-commerce applications.

 

The successful SQL Database consultant will have experience with MS SQL Server development. Experience with MS SQL Server, writing stored procedures and queries, ETL . Business intelligence is a plus. Must have excellent communication skills and customer service. 

Contact Willis Johnson:   

Willis.johnson@rht.com (505)888-6225

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif