Thursday 15 November 2012

urgent Requirement for SQL Server WITH OLAP AND OLTP in NY

 

 

Hi friends.

 

This is Pavan  from VST Consulting Inc. We have a  requirement of Sql Server in NY . Please review the job description below. Please include your updated resume along with the following Details to pavan@vstconsulting.com. My contact number  732-791-4829.

 

 

 

Candidate MUST be able to attend a face to face interview after a phone.

 

 

Position: SQL Server 

Location: NY-New York

Rate: DOE

Duration: Long term

 

 

MUST PASS STRONG OLAP OLTP SKILLS

 

 The successful candidate will have a minimum of 7 years SQL Server DBA experience and be considered an Senior Database Administrator resource.

 

Position Description:

 

The Senior Database Administrator is responsible for designing, developing, supporting and communicating data in support of the health, availability and performance of the SQL Server database environment to peers, management and business owners. This individual will be adept at building and maintaining a network of internal and external interfaces in support of monitoring the environment; researches and interprets quantitative and qualitative information to provide root cause and solutions based on the output of those interfaces. This individual collaborates with process owners, business managers, technical peers and project managers to leverage the use of data and data strategy across a full spectrum of business needs.

 The Senior Database Administrator must possess the technical and business aptitude to identify, analyze and evaluate complex issues; performs input of multi-source business and technical data points, including trending and exception data points as a means to provide technical solutions which will drive increased throughput, performance and stability of the SQL Server database environment.

 

 

Must have following skills:

 

·        OLAP

·        OLTP

·        RDBMS

·        SQL Server database environment

·        Troubleshooting issues

 

 

Essential Duties and Responsibilities: 

 

1.     Create t-sql solutions for custom monitoring and alerting to include reporting, maintenance and management of the SQL Server database environment

 

2.     Summarize and present results

 

3.     Perform the triage and analysis of support requests related to production and non-production databases

 

4.     Perform database upgrades, including non-production environments and testing

 

5.     Provide expert recommendations on query optimization

 

6.     Deep experience in SQL Server 2005, 2008, 2008R2 and some exposure to Denali (2012)

 

7.     Extensive experience with Windows 2003, 2008 and 2008R2

 

 

8.      Experience with VLDB’s (>1 TB) for both OLTP and OLAP workloads

 

9.     Experience with large quantities of transactions on an OLTP workload

 

10.  Provide 24X7 on-call support (rotating schedule)

 

 

General Qualifications:

 

 

·         7+ years of progressive professional experience working with data and RDBMS (SQL Server) tools

 

 

·         Excellent verbal and written communication skills

 

 

·         Ability to multi-task

 

·         Excellent at troubleshooting issues

 

·         Ability to develop productive business relationships with all team members through cooperation, courtesy and professionalism

 

·         Ability to play an integral part in project delivery given tight constraints and uncompromising quality

 

 

·         A fundamental knowledge and ability to understand technology, information systems, data and business processes

 

 

·         Motivated to identify and develop solutions

 

 

Required Education:

 

Bachelor's degree in MIS, Computer Science, or related field is preferred

 

 

Training and certifications are a plus

Excellent verbal and written communication skills

 

Creates scheduled database jobs (backend processes) including: replication (publications, and subscriptions), backups, maintenance jobs, etc…

 

Resolves database performance issues, database capacity issues, replication, and other distributed data issues.

 

Provides reporting on performance and works with the Server, Networking and Storage groups to provide root cause analysis, performance trending and capacity planning

 

 

Author documents as they relate to database process, scheduling, design, etc…

 

 

--

 

 

 

Thanks & Regards,

Pavan

VST Consulting INC.

Off: 732-791-4829

pavan@vstconsulting.com

www.vstconsulting.com

 

Note:  We respect your online privacy.  This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list.  If you are not interested in receiving our e-mails, then please reply with REMOVE" in the subject line.

 


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5394 - Release Date: 11/14/12

No comments:

Post a Comment