Senior SQL Server Database Administrator: Mountain Lakes, NJ

Do you thrive in an environment where innovation and change are encouraged? If you are a big-picture person who is not afraid to make decisions, take responsibility for them, and strives to complete things on time – we want to talk to you! We continue to raise the bar in innovation and quality and seek people who want to make a real difference in healthcare.

Eclipsys is a leading provider of advanced clinical, financial and management information software and service solutions to more than 1,500 healthcare facilities. Eclipsys empowers healthcare organizations to improve patient safety, revenue cycle management and operational efficiency through innovative information solutions.

Our Technology Solutions Center (TSC) provides a complement of remote-hosting options to our customers including remote processing of Eclipsys and non-Eclipsys applications and disaster recovery. Today, over 100 healthcare organizations are tapping into the expertise, equipment and round-the-clock computing services of the TSC’s state-of-the-art hosting facility based in Mountain Lakes, New Jersey. The TSC can host Eclipsys solutions, as well as applications from its strategic partners and other non-Eclipsys applications that complement Eclipsys solutions. The center can provide and maintain all aspects of a Healthcare Organization’s hosted IT infrastructure, including operating systems, database software, systems and database administration, continuous capacity planning and monitoring, and Wide Area Network (WAN) infrastructure.

We are currently hiring a Senior SQL Server Database Administrator for the TSC. We seek self-starters who are results oriented, work well independently and have excellent customer service skills. You will be approachable, teachable, and a team player with a strong desire to continue learning and expanding your experience in a high impact, client focused environment.

Job Purpose and Scope:
The Senior Database Administrator is responsible for all activities related to installation, administration, and maintenance of computerized relational databases including RDBMS object design, maintenance and migration.

Job Duties and Responsibilities:
• Perform database backups, restores, integrity checks, optimizations, performance tuning, and database troubleshooting.
• Develop custom backup/restore and disaster recovery plans for production servers.
• Design and implementation of data disaster recovery procedures including construction of scripts and programs at the database level
• Installing, configuring, administering and securing production servers.
• Implementing and administering database replication between SQL Server databases, as well as dissimilar databases.
• Upgrading and upsizing databases from earlier versions to the latest versions.
• Develop and support database processes and workflows necessary for product production using DTS packages, stored procedures, batch jobs, and system reports.
• Participate in database support activities throughout the full lifecycle of a project.
• Provide On-call Production Support as needed.
• Problem identification and resolution
• Recommend and use database administration tools which improve support effectiveness and minimize downtime
• Provide support and guidance to maintain and adhere to database standards, backup procedures, and routine and periodic database maintenance processes
• Database Connectivity/Networking – Understand the design and characteristics of SQL Server networking by maintaining optimal performance between databases to resolve latency.
• Follow procedures and plans to monitor database activities including reaciing to alerts and creating new alerts.
• Understanding the requirements for growth and capacity planning, data storage optimization as it relates to performance, and space planning for new business opportunities.
• Review TSC Vision Statement and the Quality Policy periodically and understand TSC’s commitment to excellent client service and continual improvement and conform to these policies and TSC principles at all times.
• Review the Quality System Responsibility Matrix to understand the quality procedures that apply to your specific assignment(s) within the scope of this job position and conform to these procedures, including any reporting (and/or record keeping) responsibilities
• Report any client problem or any service degradation that may cause potential client problems per applicable procedures.
• Communicate improvement ideas that you have regarding the TSC service quality or client satisfaction per established means.

Required Experience:
• 3 plus years experience as a Database Administrator responsible for the design, implementation and support of SQL Server databases.
• Extensive physical database administration experience in supporting MS SQL Server database systems on Windows NT/ 2000/ 2003 platforms.
• Strong working knowledge of relational database management systems and related tools (e.g. Enterprise Manager, Query Analyzer, OSQL, Profiler, SQL Server Job Agent, Analysis Services and Performance Monitor) is required.
• Strong knowledge of database design, normalization, and data structures
• Possess a solid understanding of SQL queries and transactions in order to recommend strategies to optimally manage database resources and improve performance
• Ability to work from ISO 9000 procedures
• Detail-oriented, able to organize, adjust and prioritize responsibilities accordingly.
• Good verbal and written communication skills
• Strong interpersonal skills

Required Education:
• Bachelor’s degree in Computer Science or equivalent combination of education and experience.

Desired Skills and Experience:
• IT experience in a healthcare environment a plus
• Datacenter experience a plus
• MCSE/MCDBA preferred

Our employees work as a cohesive team to define and solve problems, develop solutions, and promote our collective objectives. The continued growth and success of Eclipsys is dependent upon the efforts and contributions of every employee. At Eclipsys, our employees truly are our greatest assets.

Consider joining our team. We offer a competitive salary, comprehensive benefits, and an entrepreneurial, innovative, team-oriented environment.

For fastest response, please apply at

Eclipsys is proud to be an equal-opportunity employer

To learn more about Eclipsys and the products and services we provide, please visit

Principals only.


RIP: Ken Henderson, 1966 – 2008

It is with great sadness that I report that at the young age of 41, Ken Henderson passed away on January, 27th.  Many of us are familiar with his many “Guru’s Guide to SQL” books.  I’ve spent many hours with his books. I’m sorry that I never got a chance to meet Ken. So Sad….

Ken’s Books on Amazon.Com:

Kalen Delaney’s Blog Entry regarding Ken: 

Ken’s Blog: 


Crystal Reports 2008: Free 30-Day Trial

Crystal Reports is currently offering a 30 Day Trial available for download so developers can sample first hand the new features and interface.

Please see additional resources listed below:

Crystal Reports 2008 Home Page (Features & Demos/What’s New/Sample Reports)

Webinar – Introduction to Crystal Reports 2008: Productivity and Visualization (Pre-recorded)

Webinar – Getting to Know Crystal Reports 2008: XML, What-If Analysis, and Deployment Options  (Pre-recorded)

Diamond Developer Community for the latest Crystal Reports .NET developer information including white papers, blogs, forums, webinars and more.


NJSQL February 19th Meeting: Stored Procedure Code Generation w/ Kathleen Dollard

We are please to announce that INETA Speaker, Kathleen Dollard will be joining us for the February meeting.   Join us and explore different ways to create stored procedures for general/complex SQL scripting tasks.

Have you ever wanted to generate stored procedures on the fly using the underlying metadata/catalog vews?  How about a simple insert, update, delete stored procedure for every fact table in a Data Warehouse?  Well, you are closer than you think to finding a solution!!!  Code Generation….

Date: Tuesday, February 19th

Time: 6pm(Networking/Refreshments), 6:30pm-8:30pm(Presentation)

Sponsor:  INETA

Refreshments: Pizza/Soda

Give-A-Ways:  TBD

Topic: SQL Server Stored Procedure Code Generation in 2008

Presenter:  Kathleen Dollard
Kathleen Dollard is a consultant, author, trainer, and speaker. She’s been a Microsoft MVP since 1998, wrote “Code Generation in Microsoft .NET” (Apress) and is a regular contributor to Visual Studio Magazine. She speaks at industry conferences such as VSLive, DevConnections, and Microsoft DevDays as well as local user groups. She’s the founder and principal of GenDotNet. Her passion is helping programmers be smarter in how they develop by learning to use Visual Studio, XML related technologies, .NET languages, code generation, unit testing, and other tools to their full capacity. She’s currently working on full life cycle improvements, such as better debugging and capturing business intent in metadata and test definitions. When not working, she enjoys woodworking, snowshoeing, and kayaking depending on the outdoor temperature.

Code generation allows you to output any code – including TSQL. You’ll see how generation combines metadata with templates to produce the code you need. Metadata comes primarily from the database structure, but you can also enrich it with more detail such as the mapping to business objects. You’ll see how a harness can coordinate generation activities extracting metadata, building scripts, and loading scripts with a single button click. While code generation has been around for decades, .NET 3.0 and 3.5 offer significant new opportunities in terms of templates and the code generation the harness process. You’ll see new approaches to templates that work well when creating complex templates and leave ready to incorporate code generation into your own development when and where it’s appropriate.


European PASS Conference: Why not spend a few April days in Neuss, Germany!!!

The next European PASS Conference will take place between the 14th – 16th of April 2008 in Neuss, Germany!

The NJ SQL Server Group is a member of “PASS”, the Professional Association for SQL Server & Business Intelligence which boasts having more than 25 thousand Database administrators, Business Intelligence Experts and Application Developers as members, from all over the world.

Apart from the numerous community meetings and technical workshops PASS provides to its members globally, they hold 2 major conferences every year, one in the United States, and one in Europe. This year, the European PASS Conference will be held in beautiful Neuss, Germany from Monday the 14th of April 2008 until Wednesday the 16th of April 2008 inclusive.

Almost perfectly timed with the lead up to the SQL Server 2008 launch, attendees will be able to choose from two focussed technical preconference workshops and over 24 technical sessions on SQL Server & Business Intelligence as well as discuss new and improved SQL Server-based technologies and services with exhibitors and sponsors at the European PASS Expo held during the conference.

For details of the sessions available, contact your Regional PASS Chapter Leader.

European PASS Conference 2008
April 14-16, 2008
Neuss, Germany

Click here to Register – and join us in Germany!


Senior DBA Position: NJM in Trenton, NJ

Job Description:
The candidate will be responsible for the operational support of NJM’s SQL Server Database environment. This advanced position plays an integral role in the maintenance and support of business critical applications.  Candidates should be team players with excellent communication skills and have the ability to manage a multitude of database assignments independently.

Responsibilities include:

* Database object review, creation, maintenance, and change control
* Monitor relational databases to optimize performance, resource use, and physical implementation

* Support Highly-available database technologies (clustering)
* Monitor and maintain database security in cooperation with data security administrators

* Migrating databases between servers and various platforms

* SQL Server Reporting services support and implementation
* Database back-up/recovery
* Fault analysis and resolution

* Implementation and maintenance of disaster recovery solutions including replication and Log Shipping
* Monitor and manage database backups, logs, and maintenance

* Support the Data Modeling unit with the design of new databases to meet application requirements
* Support design and implementation of ETL processes between disparate systems

* Assist the DB2 DBA team with DB2 administrative duties

* On-Call Support

Required Skills
* Strong expertise (4+ years) in SQL Server 2000 and 2005

* Proven troubleshooting abilities
* Specific SQL Server Administration experience including:

– Triggers
– Stored Procedure Code reviews and Development
– Data integration and Migration
– Management Studio
– Database Auditing and controls

* Strong understanding of Security implementation

* Strong knowledge of Windows 2000, 2003 and XP 5+ years
* Strong knowledge of SQL and Stored Procedure Language
* Strong knowledge of relational database concepts
* Ability to translate Logical Data Models into physical structures
* SQL Server performance management and tuning
* Strong Project Management and communications skills
* Strong planning and analysis skills
* Ability to mentor/guide junior administrators
* Prior application development experience including architectural and design skills are strongly preferred.
* Excellent communication and interpersonal skills

If you are interested in this position, contact NJM HR with Job Code NJSQL.

NJM Insurance Group



Free Business Intelligence/Business Objects Session: 2/21 at the Hanover Marriot (Whippany, NJ)

Calming the Information Storm

A seminar focused on optimizing trust and visibility into your data using Business Intelligence (BI), and maximizing the effectiveness through BI user adoption

You’ve automated your business processes and invested in CRM, ERP and other operational systems. Yet, you feel inundated by the storm of data coming in and out of your system. Isn’t it time to optimize your investments and convert your data into a strategic asset that all of your business and IT stakeholders will be able to leverage?

Attend our seminar to discover how you can use your data as your competitive edge and get everyone on board with the strategy. Learn how other organizations have successfully capitalized on Business Intelligence to achieve corporate goals and overcome 3 key informational challenges surrounding:

1. Data integrity and trust
2. Consolidation and automation of performance metrics
3. User adoption

Do you relate to any of the touch points above and wish to calm the manic data storm? Then this is a seminar you do not want to miss!

We look forward to seeing you.



SetFocus is partnering with Conversion Services International

SetFocus has partnered with Conversion Services International to combine the power of CSI’s leading-edge expertise in information management with SetFocus’ world-class training in Microsoft Business Intelligence and Microsoft Performance Point Server™.


CSI is a leading provider of professional services focusing on strategic consulting, data warehousing, business intelligence, and business process reengineering, as well as integration and information technology management solutions.

As part of this partnership launch, SetFocus will be offering the opportunity to secure reduced one-on-one consultative services with CSI

SetFocus will also be hosting two specialty seminars developed and delivered by CSI’s Senior Vice President of Information Management, William McKnight:

“Introduction to Master Data Management for the Enterprise”

“Introduction to Data Warehousing”

Both one day seminars will be held this March.  For registration details and pricing, please see the links listed about.
And don’t forget – all SetFocus Alumni receive an exclusive 20% discount off all SetFocus services!


PASS Database Adminstration SIG Live Meeting Event: February 27th at 12pm EST

PASS hosts several SIGs (Special Interest Groups) in the area of Database Administration, Business Intelligence, Application Development and Women in Technology.

The PASS Database Adminstration SIG is offering a live meeting event featuring TJay Belt. TJay will give a talk about SQL Server Logical Query Processing

Abstract: The first noticeable aspect of SQL that is different from other programming languages is the order in which the code is processed. In most programming languages, the code is processed in the order in which it is written. In SQL, the first clause that is processed is the FROM clause, while the SELECT clause, which appears first, is processed almost last. The presentation will be a brief description of the different logical steps applied in both SQL Server 2000 and SQL Server 2005. You’ll also see a demonstration of SQL code written by Itzik Ben-Gan from his book Inside Microsoft® SQL Server™ 2005 T-SQL Querying.

TJay Belt is a Database Administrator for the Accounts Payable division of Affiliated Computer Services.  He has studied computer science at BYU and developed in and administered databases his entire career.  TJay has used SQL Server versions 7, 2000 and 2005 since 1998, and has been a DBA for 5 1/2 + years.  TJay has enjoyed delivering presentations for Microsoft, Affiliated Computer Services, and local SQL Server User groups.  He is the founder and PASS chapter leader of the Utah County SQL Server user group.  TJay truly enjoys working with and administering database, and his real passion lies in creating solutions.

To attend the meeting, you will need:

·         An Internet connection for the presentation
·         A telephone connection for the audio

The URL for the meeting is: 

Audio Conferencing (Toll-free): +1 (866) 500-6738
Participant Code: 4048733

When attending the meeting, please observe the following common courtesies:

1. If you are using a speaker phone, please mute it unless you are asking a question. That way, other participants will not be disturbed by the noise in your environment.

2.  If you need to leave the meeting temporarily, please hang up and call us back, unless your phone is silent when on hold. Your hold music and/or message is disturbing to other participants.


To save time before the meeting, check your system to make sure it is compatible with Microsoft Office Live Meeting:

Interested in presenting on your favorite topic for a Live Meeting Event? Presentations are an hour to an hour and a quarter long. You use your own computer. You can present PowerPoint slides and do demos. If you’re interested, contact