Strong SQL Server Developer with Data Warehouse Experience in NYC (Consultant)

Project Description:

The Senior SQL Server Developer will act as a leader in the design and development of proprietary SQL Server based database code.  Initially, this person will play a lead role in the migration of company’s transactional systems and data warehouse from SQL Server 2000 to SQL Server 2005.

  • Participate in analysis of current systems to determine impact of upgrade
  • Define and implement approaches to load and extract data from multiple sources using SSIS
  • Act as a Senior Developer to resolve complex technical issues for the team and review ETL code before migrating to production
  • Build physical ETL processes (stored procedures, VB, Active X, etc.)
  • Teach other team members the differences between SQL Server 2005 and 2000 and how to best implement the changes

In the months following the upgrade, if both parties are in agreement, the Sr. SQL Server Developer would work on the following:

  • Design and develop incremental ETL code for the first two data marts of the Data Warehouse
  • Participate in the design, development, unit testing and documentation of a Data Warehouse Mart as well as SQL Server ETL code for a proprietary Risk Management System
  • Coordinate with Business Systems Analysts and Project Managers to clarify and resolve issues with business requirements

Further details upon interest.

If you are interested in this positon, please email your resume to lsandoval@genevaconsulting.com with job code ‘NJSQL’.

SQLDiva

SQL Server DBA: Wayne, NJ

FUNCTIONAL TITLE

SQL Server Data Base Administrator

 

DESCRIPTION OF DUTIES

The SQL Server Database Administrator’s role is to install, monitor, maintain, consult and implement production and test databases throughout the organization.  The position requires at least 5 years relational database administration experience with the majority of that experience in SQL Server 2000 and 2005.  The DBA will be involved in many levels of the Software Development Lifecycle including, technical design, optimizing database performance, capacity planning and system test support.

 

REQUIREMENTS

▪          Proven ability to communicate with managers, colleagues, and subordinates

▪          Ability to work with large integrated cross functional teams to accomplish the larger mission

▪          Outstanding attitude and a desire to ensure customer success

▪          Configure SQL Server 2005 RDBMS components on Windows OS

▪          Maintain and upgrade database servers

▪          Provide advice to applications and infrastructure staff regarding SQL Server components and configurations; advise developers to write optimal code

▪          Implement database monitoring and make performance recommendations

▪          Create and Maintain database backup scripts and procedures

▪          Has an understanding of and experience with all of the phases of the SDLC.

▪          Provide expertise in T-SQL including queries, stored procedures and triggers

▪          Monitor automated jobs and processes

▪          Ensure optimal performance and conduct tuning of databases and their processes

▪          Resolve problems and issues within the production environment

▪          Conduct capacity planning

▪          Ensures that completed work meets with all IS best practices and policies.

▪          Familiar with data warehousing database design and schema configurations; star and snowflake schema; dimensional modeling; highly de-normalized models

▪          Is willing to administer and support mission critical 24×7 applications.

EDUCATION REQUIRED

  • BA/BS degree in Computer Science or related field.
  • Certifications:
    • MCDBA
    • MCITP DBA

EXPERIENCE REQUIRED

  • 5-7+ years of information technology experience. Including:
    • 3+ years experience as a SQL Server 2000 / 2005 DBA
    • 5+ years experience as a RDBMS DBA
    • 1+ years experience as a SQL Analysis Server 2005 DBA

 

EXPERIENCE DESIRED

  • 2+ years experience SQL Server Reporting services (2000/2005)
  • 2+ years experience SQL Server Analysis Services (2000/2005, 2005 preferred)
  • Experience using ERwin to maintain database schemas and synchronize database models with the physical implementations
  • 3+ years experience SQL Server DTS/IS
  • Experience in very large database environment, support, and administration
  • Understands the relationship between SQL and other Microsoft Application s (Biztalk, SharePoint, etc)

 

REPORTS TO:

Manager of Business Intelligence

If you are interested in this position, please contact Joe Morris with job code ‘NJSQL’.

Joe Morris

Email: jmorris@corpsrch.com

SQLDiva

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

http://eclipsys.recruitmax.com/ENG/candidates/

Eclipsys is proud to be an equal-opportunity employer

To learn more about Eclipsys and the products and services we provide, please visit www.eclipsys.com.

Principals only.

SQLDiva

Microsoft SQL Server 2008 – Releasing in Q3

Last Friday, a Microsoft Blog (http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx) announced that SQL Server 2008 will not be released until the 3rd Quarter of 2008.

This news isn’t unexpected and I’m sure a lot of SQL Server Professionals out there will enjoy having their “2008 Summer Vacation” to get up to speed with SQL Server 2008.  Enjoy the extra time!!!

SQLDiva

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: http://www.amazon.com/s/ref=nb_ss_b/102-8888029-6567367?url=search-alias%3Dstripbooks&field-keywords=ken+henderson+SQL

Kalen Delaney’s Blog Entry regarding Ken: http://sqlblog.com/blogs/kalen_delaney/archive/2008/01/29/ken-henderson.aspx

Ken’s Blog: http://blogs.msdn.com/khen1234/default.aspx

SQLDiva

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.

 SQLDiva

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.

Overview:
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.

SQLDiva 

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
Swissôtel
Neuss, Germany

Click here to Register – and join us in Germany!

SQLDiva

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
– SQL XML
– 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

Email: careers@njm.com

SQLDiva 

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.

 

SQLDiva