SQL Server 2000 Database Administrator

Summit Technologies, Inc has a consulting to full-time employment opportunity for a SQL Server 2000 Database Administrator in Farmington, CT 06032.  A description is below.  Good communication, interpersonal and professional skills are required.  The client can not sponsor visas.  Perhaps you or someone you know is a good match.  Please share the information with them.



 

Purpose

To support the configuration and operational requirements of client’s RDMS and Business Intelligence environments

 

Key Accountabilities

1. Assist SQL Server Database Administrator’s in administering change management principals to all database elements including the creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers and integrity constraints.
2. Perform configuration and provide operational support for the CCI Data Warehouse/Pharmacy and other SQL Server databases. Operational support includes ensuring that downloads, data feeds, backup/recovery strategy, logging, security, and access are performed properly and according to agreed upon refresh schedule.
3. Support IPA, PHO, Employer Group and other third party vendor access to utilization data through data feeds or other forms of access. Responsible for creation, maintenance, and execution of data feeds according to schedule.
4. Assist in the Implementation of projects under project management and SDLC principles and procedures.

5. Assist the SQL Server team in monitoring server performance, utilizing monitoring tools such as Enterprise Manager, SQL Profiler, Performance Monitor, Diagnostic Manager, and Configuration Manager.
6. Support the administration of system security for all SQL Server databases including the creation and management of user profiles, passwords, and database access rights. Assist in altering current environment to meet new role-based security requirements, SOX and HIPAA compliance.
7. Assist in applying service packs and hot-fixes to SQL Server environment and testing support for any OS patches.
8. Support development teams & business areas in use of the Data Warehouse and other SQL Server databases.
9. Assist in the implementation of system, data, and architectural operating principles and standards.
10. Assist in administering the Reporting Services environment.

11. Assist in the planning of upgrading our SQL Server environments from 2000 to either 2005 or 2008.
12. Responsible for maintaining documentation of the database environment, including data models, data dictionaries, configurations for Disaster Recovery purposes.
13. Assist in the maintenance and security of the Business Intelligence environment, including making sure OLAP Cubes run successfully, and providing backup support for troubleshooting problems and granting security to the web environment.
14. Help ensure innovative technology/database solutions are brought to the table for all major projects.
15. Participate in audits, on an as needed basis.
16. Perform other related projects and duties as assigned.

 

Technical Knowledge, Experience, Skill Requirements

1. Bachelor's Degree required or equivalent work experience.
2. Two to Four years of previous experience with relational SQL Server databases and Data Warehouse operations. Experience with client/server development preferred.  Knowledge of MS SQL Server 2000/2005, Reporting Services and DTS/SSIS required.

3. Strong Transact SQL skills required.

4. Experience upgrading from SQL Server 2000 to SQL Server 2005 preferable.
5. Oracle 10g and HP-UX knowledge helpful.
6. MS SQL Server certification preferred.
7. Familiarity Cognos Administration or other OLAP technology preferred.

8. Excellent analysis, troubleshooting, and technical skills required.
9. Working knowledge of PC software MS Windows XP, Server 2003, MS Access, VISIO, MS Project and multi-user client/server applications preferred.
10. Good oral and written communication and interpersonal skills required.
11. Ability to handle multiple priorities required.



 

Competencies

1. Member and Customer Focus: Recognizes that members and customers (internal & external) are the driving force behind every business activity. Continuously makes an effort to exceed the expectations of members and customers.
2. Quality Orientation: Assumes responsibility for providing the highest level of quality to members and customers.

3. Analytical Ability:  Ability to break down a complex problem into its component parts and arrive at an appropriate solution in a timely fashion.
4. Innovation: The ability to see opportunities for change, to capitalize on them and implement them when appropriate for the benefit of Client’s.
5. Communication: The ability to communicate with clarity both orally and in writing.
6. Teamwork: Demonstrates enthusiasm for the mission of Client and inspires the same in others.
7. Results Orientation: The ability to break a complex problem down into its component parts and arrive at the appropriate solution in a timely fashion.
8. Change Mastery: Embraces change.
9. Learning Orientation: Assumes responsibility for personal and professional development.

 

Behavioral Traits:Excellent written and verbal communication proficiency, good interpersonal skills Strong troubleshooting, analytical, debugging, and problem solving skills Project planning and leadership skills Ability to multi-task in a fast paced systems vendor environment Requires flexibility to adapt readily to direction change Demonstrates initiative and adaptability, values achievements and action Looks for a better way, follow best practices



Summit Technologies, Inc. requires and its Clients require a background investigation and professional reference checks. A drug test may also be required. Reliable transportation to the primary site is expected. If you or someone you know is a good match and interested in more information, please forward the following information to es.cts@summtech.com at your earliest convenience.Updated resume in Word format with Month/Year information for work experience Daytime and evening phone numbers Desired hourly pay rate and basis and annual base salary Availability to interview and start Provide two professional references



Summit Technologies Inc. appreciates your interest.  We will contact the best matching prospects, and will consider you for future opportunities.



 

Summit Technologies, Inc. is an information technology services company offering staffing, consulting and direct hire services to Fortune 1000 organizations and the public sector. We began as a technology consulting organization and have evolved to include technical staffing services. We bring the discipline and methodologies of a technical consulting organization to your staffing needs and to date we provide elite technical consulting and staffing services to our clientele.  We are an equal opportunity employer.