Crest Jobs SQL database

SQL DBA @ Microsoft India - Hyderabad Center- Multiple positions

noreply@blogger.com (Crest Consultants) — Wed, 02 Feb 2011 07:17:00 +0000

SQL DBA _Microsoft Corp hyd

Location : Hyderabad

Job Title: Senior Software Operations (SO2)

We are looking for Senior Software Operations lead to manage the systems powering MSIT applications through strong understanding of technologies and principles of Software Application Support, system administration, service delivery and operations. The job entails managing all aspects of systems management, administration, and operations of large-scale web and SQL based services by involving in design, deployment, management, Production Support and operations.

Primarily this role oversees the implementation of complex, mission and business critical systems in a production environment and manages application support to established service levels to facilitate the effective utilization of the systems

Responsibilities:

· Contribute individually in the implementation and support of systems in a production environment
· Responsible for maintaining the highest levels of systems availability, data delivery and availability, and customer satisfaction for all assigned systems
· Drive the implementation of continuous improvement activities including new support tools and automation
· Developing the road map for the applications by providing strategic insights into stability and availability of the applications.
· Responsible for end user satisfaction with complete accountability of meeting the defined Service Level Agreements (SLA & OLA).
· Act as escalations contact for mission critical & revenue processing applications and drive solutions with complete end-to-end ownership
· Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders.
· Strong documentation skills in documenting processes, procedures and tools descriptions.
· Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors
· Participate in and contribute to Release activities including Spec reviews
· Understand and contribute to effective Monitoring of the critical components of the System
· Align with standard process compliance including MOF/ITIL

Requirements:

· Should have 6+ years of experience in production support role supporting windows 2003/2008, SQL Server 2000-2005-2008, Internet Information Server (IIS5-7), in a large scale 24x7 operations/production web service environment.
· Must have SQL aptitude including ability to execute SQL troubleshooting procedures, analyze SQL code and results from SQL queries
· In depth knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure environments
· Experience in managing production systems and applications built on Windows servers and advanced knowledge of SQL Systems, Web technologies, Active Directory, TCP/IP protocols, system performance and IIS
· Strong ITIL and MOF knowledge and experience
· Strong analysis and customer service skills with sound problem solving, judgment and decision-making skills
· Excellent teamwork, communication, and documentation skills
· Knowledge of scripting languages and technologies (Powershell, VBScript, Perl, WMI etc.), Experience with programming (ASP.NET, XML, HTML, C, C++) is a plus

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to sridevi@crest.in with "SQL DBA " as the subject ...Include CTC details in your mail

SQL Database Developers - Chennai recruitment drive - Microsoft Corporation - Hyderabad

noreply@blogger.com (Crest Consultants) — Tue, 19 Oct 2010 07:13:00 +0000

Company : Microsoft Corporation

location : Hyderabad Development Center

Recruitment event for Chennai Location Candidates

1St round Telephonic

Face to face Interviews in Chennai on 30th Oct for those who clear 1st round telephonic Interviews

5- 13 yrs experience

STANDARD TITLE: SR SE DATABASE ENGINEER

Job Description Format

Introduction to group/job Join Microsoft’s fastest growing division and make the Digital Entertainment Lifestyle a Reality!

Entertainment & Devices Manufacturing & Supply Chain (E&D Mfg & SC) Systems improves business performance continuously by delivering world class systems solutions.

As Database Engineer for E&D Mfg & SC Systems based in India, you will be part of the team working in maintaining high performing and scalable SQL systems (Largely BI) to enhance the productivity and competitiveness of Microsoft Entertainment & Devices, you will be driving initiatives to design/build World Class BI/SQL platform to support our Business clients Long range plan and Enterprise Architecture Pillars. This position will own the E&D SQL stores by setting industry best practices, standards and procedures, and ensuring the SQL platform is highly scalable, available, and secure. You will act as E&D final point for escalation for any SQL related issues and questions. Currently our group owns 400+ physical servers with 5 different BI application focusing different business segment (XBOX Live BI, Manufacturing & Quality Analtyics, Sales & Marketing and Operational Data Warehouse etc.,), current storage foot print is ~80TB with huge growth projection.

The E&D Mfg & SC Systems group reports into E&D Mfg & SC, developing and supporting critical business systems for all functions of the division, from Manufacturing through Operations, Sales and Marketing and Finance, Business Performance and Strategy. Our systems support the extended retail supply chain not only for E&D products but for all Microsoft products sold at retail (e.g. Xbox 360, Zune, Vista, Office, Hardware products and Games for Windows etc). While embedded in the E&D Division we are also closely affiliated with the corporate Microsoft IT group, leveraging multiple shared services to deliver world class solutions to our demanding client base.

Roles/Responsibilities

· Work with Project team/Architects and provide technical expertise and support of database administration and tuning. Continue to seek improvements in product performance that can be achieved through changes in database schema, logical and physical data organization, and tuning & configuration.

· Work with Project team/Architects for new development efforts, and provide technical expertise and participate in the design and implementation of a database schema that conforms to industry standards yet meets all application specific requirements

· Apply the "Database-Specific Operational Best Practices Checklist"

· Perform design review of all database changes/projects

· Performance-tuning and optimization (review blocking, do root-cause analysis of performance bottlenecks and escalate appropriately).

· Plan future-state infrastructure (storage capacity planning, server SKU recommendations, newest SQL Server features, etc.)

· Setup database failover mechanism (DB Mirroring, log-shipping, etc.) and perform disaster recovery excercises.

· Maintain, review and implement the "SQL Server Configuration Standards Checklist" (Writing in Progress). Make sure all servers are in compliance.

· Fine tune SQL monitoring by ensuring that all SQL Errors are captured proactively.

· Create knowledge base articles for alerts/issues for DBA (Service operation) team to resolve issue without escalating to database engineering team.

· Plan for high availability through SQL Always on technology

BASIC QUALIFICATIONS:

- BSc in Computer Science or similar Engineering degree

- 5+ years of experience as a SQL Database Engineer

- 3+ hands on Production DBA experience in handling VLDBs, especially in areas like tuning, disaster recovery and high availability.

- Strong SQL skills (Level 400) and experience in database design, schema design, and SQL performance tuning and optimization

- Experience and knowledge in designing scalable and failover database systems

- Experience in configuring, implementing and supporting high availability strategies with SQL Always on technology.

- Outstanding customer service/focus skills Demonstrated ability in handling complex. technical issues and providing timely solutions.

- Demonstrated ability to define and follow best practices and business processes.

- Excellent written and verbal communication skills

- Understanding of multi-tiered application technology.

- Excellent understanding of Microsoft Windows 2000/2003 operating system

- Good understanding of OS and Infrastructure / Network layer is value added

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to ajith@crest.in .in with SQL Developer as Subject
...Include CTC details in your mail

SQL DBA with IIS - Microsoft Corporation - Hyderabad 6+yrs

noreply@blogger.com (Crest Consultants) — Thu, 02 Sep 2010 07:01:00 +0000

Company : Microsoft

Location : Hyderabad

Key Shortlisting Criteria

1. Strong SQL DBA experience
2. Strong IIS skills
3. Exposure to ITIL ( Good to have )

We are looking for Senior Software Operations lead to manage the systems powering MSIT applications through strong understanding of technologies and principles of Software Application Support, system administration, service delivery and operations. The job entails managing all aspects of systems management, administration, and operations of large-scale web and SQL based services by involving in design, deployment, management, Production Support and operations.

Primarily this role oversees the implementation of complex, mission and business critical systems in a production environment and manages application support to established service levels to facilitate the effective utilization of the systems

Responsibilities:

Contribute individually in the implementation and support of systems in a production environment
Responsible for maintaining the highest levels of systems availability, data delivery and availability, and customer satisfaction for all assigned systems
Drive the implementation of continuous improvement activities including new support tools and automation
Developing the road map for the applications by providing strategic insights into stability and availability of the applications.
Responsible for end user satisfaction with complete accountability of meeting the defined Service Level Agreements (SLA & OLA).
Act as escalations contact for mission critical & revenue processing applications and drive solutions with complete end-to-end ownership
Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders.
Strong documentation skills in documenting processes, procedures and tools descriptions.
Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors
Participate in and contribute to Release activities including Spec reviews
Understand and contribute to effective Monitoring of the critical components of the System
Align with standard process compliance including MOF/ITIL

Requirements:

Should have 6+ years of experience in production support role supporting windows 2003/2008, SQL Server 2000-2005-2008, Internet Information Server (IIS5-7), in a large scale 24x7 operations/production web service environment.

Must have SQL aptitude including ability to execute SQL troubleshooting procedures, analyze SQL code and results from SQL queries
In depth knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure environments
Experience in managing production systems and applications built on Windows servers and advanced knowledge of SQL Systems, Web technologies, Active Directory, TCP/IP protocols, system performance and IIS
Strong ITIL and MOF knowledge and experience
Strong analysis and customer service skills with sound problem solving, judgment and decision-making skills
Excellent teamwork, communication, and documentation skills
Knowledge of scripting languages and technologies (Powershell, VBScript, Perl, WMI etc.), Experience with programming (ASP.NET, XML, HTML, C, C++) is a plus
Ability to work in shifts in 24x7 support model

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to the leelakrishna@crest.in with "SQL DBA with IIS " ...Include CTC details in your mail

SQL Database Developer - Microsoft hyd

noreply@blogger.com (Crest Consultants) — Tue, 10 Aug 2010 05:39:00 +0000

Company : Microsoft Corporation

location : Hyderabad Development Center

5- 13 yrs experience

STANDARD TITLE: SR SE DATABASE ENGINEER

Job Description Format

Introduction to group/job Join Microsoft’s fastest growing division and make the Digital Entertainment Lifestyle a Reality!

Entertainment & Devices Manufacturing & Supply Chain (E&D Mfg & SC) Systems improves business performance continuously by delivering world class systems solutions.

Roles/Responsibilities

· Apply the "Database-Specific Operational Best Practices Checklist"

· Perform design review of all database changes/projects

· Performance-tuning and optimization (review blocking, do root-cause analysis of performance bottlenecks and escalate appropriately).

· Plan future-state infrastructure (storage capacity planning, server SKU recommendations, newest SQL Server features, etc.)

· Setup database failover mechanism (DB Mirroring, log-shipping, etc.) and perform disaster recovery excercises.

· Maintain, review and implement the "SQL Server Configuration Standards Checklist" (Writing in Progress). Make sure all servers are in compliance.

· Fine tune SQL monitoring by ensuring that all SQL Errors are captured proactively.

· Create knowledge base articles for alerts/issues for DBA (Service operation) team to resolve issue without escalating to database engineering team.

· Plan for high availability through SQL Always on technology

BASIC QUALIFICATIONS:

- BSc in Computer Science or similar Engineering degree

- 5+ years of experience as a SQL Database Engineer

- 3+ hands on Production DBA experience in handling VLDBs, especially in areas like tuning, disaster recovery and high availability.

- Strong SQL skills (Level 400) and experience in database design, schema design, and SQL performance tuning and optimization

- Experience and knowledge in designing scalable and failover database systems

- Experience in configuring, implementing and supporting high availability strategies with SQL Always on technology.

- Outstanding customer service/focus skills Demonstrated ability in handling complex. technical issues and providing timely solutions.

- Demonstrated ability to define and follow best practices and business processes.

- Excellent written and verbal communication skills

- Understanding of multi-tiered application technology.

- Excellent understanding of Microsoft Windows 2000/2003 operating system

- Good understanding of OS and Infrastructure / Network layer is value added

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to leelakrishna@crest.in with SQL Developer as Subject
...Include CTC details in your mail

SQL DBA with Release experience 6+yrs - Microsoft Corp - Hyderabad

noreply@blogger.com (Crest Consultants) — Fri, 06 Aug 2010 07:36:00 +0000

Company : Microsoft Corporation

Location ; hyderabad

( PS : Generic SQL DBA positions also available with Microsoft )

This position provides application change and release support for existing and new technologies in pre-production and production environments. Working closely with development, system test, analysis and service operations to ensure application revisions occur under controlled conditions to ensure code is successfully applied to the UAT/Pre-Prod/production environments.

This position has build automation, scripting, and release implementation responsibilities and requires a mix of technical abilities, coordination and problem solving skills. The Service Build Engineer interacts and partners directly with Development teams, Service Release Managers, Support Teams, and Program Managers, as well as Test groups.

The position is accountable to the Service Release Manager, and responsible for deploying changes effectively to the controlled environments. This includes all aspects of the end-to-end release process: plan, design, build, test, accept and deploy. Position coordinates, automates, deploys and communicates release implementation status and owns release implementation issues to resolution.

This role works with Service Release Manager to ensure appropriate environments are available and setup. This position is responsible for defining the workflow and schedule to implement the release in the Production/Pre Production environments, as well as performing the release implementation activities. Service Build Engineer establishes the release build approach, assembles and integrates release components.

Responsibilities include creation of service installation plans, procedures and scripts, creation of service release deployment and validation plan. Other responsibilities are to develop manual deployment procedures and/or automated deployment scripts, and interface with corporate procurement to order and acquire the necessary service release components. The Service Build Engineer has responsibility to validate the quality of all service components, including ensuring that components meet organizational standards, design specifications and documented baseline.

Position identifies automation needs and works with appropriate teams to drive the automation, and ensures the release is correctly defined in the Configuration Management System.

Who we are looking for:

Microsoft IT is looking for a highly motivated individual who wants an opportunity to make a difference using their experience to help drive the application build process across MSIT. This role is based in Redmond, will interface with colleagues in other regions, and be a part of a team working to constantly improve the build process and environment management. If you care about what you do and have a passion for innovation and quality, this is the role for you.

Excellent technical and communication skills are required.

A minimum of 5-7 years’ experience in IT or related fields is required and a BA/BS degree in computer science or related technical field is preferred.

Experience working with a mixed global offshore/onshore model preferred (some international travel may be required).

Experience with web-based applications, enterprise environments, and high-availability production concepts & implementations is required.

Expertise with Microsoft technologies including MS SQL Server, Windows Server, Internet Information Services (IIS), .NET is required, Experience with C#, ASP.net, and automation scripting preferred. Experience with the release management role and/or the Microsoft Operations Framework general concepts also preferred.

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to leelakrishna@crest.in with SQL DBA as the subject ...Include CTC details in your mail

SQL Database Developer - Microsoft hyd

noreply@blogger.com (Crest Consultants) — Thu, 15 Jul 2010 06:42:00 +0000

Company : Microsoft

Location Hyderabad

Title: IT Software Development Engineer 2

Job Description/Responsibilities:

This position is responsible for developing several units of functionality usually making up part of an application. Examples include designing and implementing process workflow, simple schemas, read only access etc. “Simple” is defined as a limited number of requirements, isolated or a limited number of interfaces, low transaction volume, and/or deployment in a single region. The position may include working on multiple development projects simultaneously ensuring that they are being developed in line with all internal standards and best practices. SQL and .Net experience as well as structured software development methodologies is required.

As IT Software Development Engineer 3 this person will be responsible for:

Code and test applications in accordance to design specifications and standards.
Code and test SQL Server database applications that support the requirements defined by users and analysts.
Design as per architectural directions simple to medium complexity modules/features
Responsible for developing major subsystems on high risk business systems under deadline pressure
Responsible for successful completion of development aspects of projects in conformance to project goals and requirements
Deliver assignments according to a schedule
Analyze applications and make necessary changes to optimize performance
Analyze and troubleshoot existing processes and optimize code in order to improve performance whenever possible
Develop and enforce coding practices designed to promote code reusability; assist in defining and updating the team standards to improve the development process and quality of deliverables
Participate in design reviews and code reviews
Assist Test and Production Support teams with installation of the application
Design and code database applications that perform efficiently, are operationally stable, and meet the business requirements.
Accurately estimates work/time required to complete tasks within their skill set
Assist with the creation of project plans.
Communicates and defends design, requirements, feature set, functionality and limitations of subsystem to team members and development lead.
Fosters proactive and cooperative relationships within the project team
Participates in project team activities and contributes to documentation requirements consistent with methodology.
When necessary, participates in the creation of new guidelines and procedures.
Act in lead role (if required), and oversees the design and development for smaller, lower risk business systems
Exercises independent judgment in selecting methods and techniques for obtaining solutions.
Ensures that team’s code meets specifications and is easily maintainable.
Participates in project team activities and contributes to documentation requirements consistent with methodology
Prepares presentations and status reports.
Fosters proactive and cooperative relationships exist within the project team
Proficient with and guides others in using development tools.
May make recommendations on staffing and hiring decisions.

Requirements/Qualifications and Previous Work and Related Experience (including educational requirements):

· Excellent English communications skills, both written and oral. Must be able to effectively communicate technical and business problems in a non technical manner to multiple groups (customer groups, project team, IT support groups)

· Understands networking

· Strong understanding of how to design applications for optimal network performance

· Very strong experience developing and designing SQL applications

· Proficient with advanced T-SQL and ETL concepts

· Ability to fine tune and optimize SQL queries, stored procs, etc

· Experience working with large databases and data marts is a plus

· Proficiency in multiple program languages, especially c# and vb.net, ASP/ASP.Net, n-tier development environment and HTML scripting languages (Javascript.Jscript,VbScript) or similar application structures is desirable

· A solid working knowledge of development practices for working with a team of developers.

· Experience working with client-server technologies

· Strong leadership skills

· Sound problem resolution, judgment, negotiating and decision making skills required.

· Strong analytical and organizational skills.

· Able to participate in a team environment, communicate effectively and promote cooperative relationships.

· Ability to work under pressure and be able to work to tight deadlines.

· Must have a strong understanding of software architectures and MS products.

· Demonstrated experience with a Software Development Life Cycle Methodology and information systems development. Experience with agile development methodologies and PSP/TSP would be an advantage.

· Strong knowledge and ability to apply latest technology, standards, capabilities and limitations of technology.

· Demonstrated knowledge of relational database and client-server technologies.

· Promotes cooperative relationships

· Ability to work with multiple people, resources and partners, remotely if necessary

· BS/BA in computer science or related field

· Minimum of five to eight years of related developer experience – or – An equivalent combination of training and related work experience

Microsoft certification desirable

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to leelakrishna@crest.in with " SQL Developer" as the subject ...Include CTC details in your mail

SQL DBA Hiring event - Bangalore City - Next weekend For the Same JD as given Below on the Blog

noreply@blogger.com (Crest Consultants) — Thu, 08 Jul 2010 13:41:00 +0000

SQL DBA - 6-10 yrs exp- Microsoft - Hyderabad

noreply@blogger.com (Crest Consultants) — Thu, 01 Jul 2010 12:21:00 +0000

SQL DBA _Microsoft Corp hyd

Location : Hyderabad

Job Title: Senior Software Operations (SO2)

We are looking for Senior Software Operations lead to manage the systems powering MSIT applications through strong understanding of technologies and principles of Software Application Support, system administration, service delivery and operations. The job entails managing all aspects of systems management, administration, and operations of large-scale web and SQL based services by involving in design, deployment, management, Production Support and operations.

Primarily this role oversees the implementation of complex, mission and business critical systems in a production environment and manages application support to established service levels to facilitate the effective utilization of the systems

Responsibilities:

· Contribute individually in the implementation and support of systems in a production environment
· Responsible for maintaining the highest levels of systems availability, data delivery and availability, and customer satisfaction for all assigned systems
· Drive the implementation of continuous improvement activities including new support tools and automation
· Developing the road map for the applications by providing strategic insights into stability and availability of the applications.
· Responsible for end user satisfaction with complete accountability of meeting the defined Service Level Agreements (SLA & OLA).
· Act as escalations contact for mission critical & revenue processing applications and drive solutions with complete end-to-end ownership
· Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders.
· Strong documentation skills in documenting processes, procedures and tools descriptions.
· Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors
· Participate in and contribute to Release activities including Spec reviews
· Understand and contribute to effective Monitoring of the critical components of the System
· Align with standard process compliance including MOF/ITIL

Requirements:

· Should have 6+ years of experience in production support role supporting windows 2003/2008, SQL Server 2000-2005-2008, Internet Information Server (IIS5-7), in a large scale 24x7 operations/production web service environment.
· Must have SQL aptitude including ability to execute SQL troubleshooting procedures, analyze SQL code and results from SQL queries
· In depth knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure environments
· Experience in managing production systems and applications built on Windows servers and advanced knowledge of SQL Systems, Web technologies, Active Directory, TCP/IP protocols, system performance and IIS
· Strong ITIL and MOF knowledge and experience
· Strong analysis and customer service skills with sound problem solving, judgment and decision-making skills
· Excellent teamwork, communication, and documentation skills
· Knowledge of scripting languages and technologies (Powershell, VBScript, Perl, WMI etc.), Experience with programming (ASP.NET, XML, HTML, C, C++) is a plus

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to the Id given below with "SQL DBA " as the subject ...Include CTC details in your mail

SQL DBA _Microsoft Corp hyd

noreply@blogger.com (Crest Consultants) — Sun, 23 May 2010 17:27:00 +0000

Job Title: Senior Software Operations (SO2)

Responsibilities:

· Contribute individually in the implementation and support of systems in a production environment

· Responsible for maintaining the highest levels of systems availability, data delivery and availability, and customer satisfaction for all assigned systems

· Drive the implementation of continuous improvement activities including new support tools and automation

· Developing the road map for the applications by providing strategic insights into stability and availability of the applications.

· Responsible for end user satisfaction with complete accountability of meeting the defined Service Level Agreements (SLA & OLA).

· Act as escalations contact for mission critical & revenue processing applications and drive solutions with complete end-to-end ownership

· Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders.

· Strong documentation skills in documenting processes, procedures and tools descriptions.

· Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors

· Participate in and contribute to Release activities including Spec reviews

· Understand and contribute to effective Monitoring of the critical components of the System

· Align with standard process compliance including MOF/ITIL

Requirements:

· Should have 6+ years of experience in production support role supporting windows 2003/2008, SQL Server 2000-2005-2008, Internet Information Server (IIS5-7), in a large scale 24x7 operations/production web service environment.

· Must have SQL aptitude including ability to execute SQL troubleshooting procedures, analyze SQL code and results from SQL queries

· In depth knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure environments

· Experience in managing production systems and applications built on Windows servers and advanced knowledge of SQL Systems, Web technologies, Active Directory, TCP/IP protocols, system performance and IIS

· Strong ITIL and MOF knowledge and experience

· Strong analysis and customer service skills with sound problem solving, judgment and decision-making skills

· Excellent teamwork, communication, and documentation skills

· Knowledge of scripting languages and technologies (Powershell, VBScript, Perl, WMI etc.), Experience with programming (ASP.NET, XML, HTML, C, C++) is a plus

· Ability to work in shifts in 24x7 support model

List of skills preferable for this position

· 4-year bachelor’s engineering course from the reputed institution

· Should be process oriented, should have good knowledge about SEI-CMM, Six Sigma and PSP/TSP, preferably from a CMM Level 5 company

SQL DBA - Microsoft Corp (New)

noreply@blogger.com (Crest Consultants) — Thu, 15 Apr 2010 05:43:00 +0000

Note: SQL Dev positions also available (10+yrs exp)

Company :Microsoft Corporation

Location : Hyderabad

Business Need:

This position is for Microsoft IT Production Support team which supports the applications and systems of ExD ICOE (see detailed description below).

Core Elements of the Job:

We are looking for a senior level operations engineer who would be maintaining the complex, mission and business critical systems of Feedstore and B2B Integration Gateway and drives support to established service levels and facilitates effective utilization of the systems.

Feedstore is the central repository of Microsoft IT data which collects data from 40+ internal Microsoft applications, processes using customer SQL code and replication and makes it available for 430+ applications which are business and revenue critical.

ICOE Gateway is the integration solution which connects the Internal Line of business applications(LOB) to external worldwide customers of Microsoft for the EDI data exchange.

This role is responsible for implementing operational strategy working with Production Manager to complement the overall business and IT strategies. This role also requires partnering with work group members, project teams, program management, and customer groups in implementing and driving the system and process improvements.

Responsible for maintaining the highest levels of: systems availability, data delivery and availability, and customer satisfaction for all assigned system.

Implements the strategies on production/operational guidelines, procedures, and standards to ensure appropriate consistency and quality in service level provided. Drives the implementation of continuous improvement activities including new support tools and automation. Monitors progress towards business goals/service level agreements and adjusts assignments as necessary. Responsible for ensuring each reported problem/question is resolved in a timely manner and tracked according to process standards. Exercises independent judgment in developing methods/techniques for obtaining solutions

Responsible for solving complex support problems and providing consistent, quality operational support for the systems and releases. Works closely with customer groups and business to ensure high levels of customer satisfaction are maintained and that service level agreements are consistently met or exceeded.

Partners with Program Management and Dev project teams to help ensure the supportability and quality of new application releases to production. Establishes and evangelizes production readiness and release criteria to project teams and program managers. Participates in project team activities prior to release and ensures documentation and staffing in place to meet support requirements. Serves as production support channel for Program Management/Tier3. Determines follow through and prioritization for development requests specific to support.

Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups (Infrastructure, Database Operations, Networking, Server Support, Systems Engineering, etc.) as required to maintain the highest levels of systems operations and availability for assigned systems.

Coordinates and manages the successful implementation of Production Support driven projects such as data fixes, point releases, minor enhancements, technology upgrades, and data delivery tools (batch, DTS, SQL replication, etc.)

Unique Job Responsibilities:

Drives resolution of customer requests, maintaining system integrity and uptime, reporting metric information about same systems and coordinating customer issues between all IT teams required to resolve.

Participates in projects that enhance the efficiency of support.

Decision Making: This position will have to decide on best course of action for issue resolution in order to resolve the customer issue as quickly as possible. Decisions that impact system availability or degrade end user support should be deferred to this positions manager.

Strategy Responsibilities: This position is responsible for the rollout and implementation of new licensing systems and periodic application and technology upgrades.

Methodologies Used: Standard support procedures are in place including methods of resolving issues, communicating with the customer and other IT teams, implementing new licensing systems, and maintaining system integrity.

Communications: This position will communicate with other IT teams in order to ensure new licensing systems do not negatively impact system integrity.

Cross-geography support: This position will entail working on a 24 X 7 model with the physical systems dispersed geographically across the world (within Microsoft facilities).

List the skills required for this position

· Strong written and oral English communication skills required.

· Demonstrated operational and/or development experience of the following software - Windows 2003 &Windows Server 2008; Professional and Advanced/Enterprise Server SQL Server 2005/2008;

· Exposure to Integration solutions like Biztalk or Gentran desired (not mandatory)

· Ability to participate in a large team environment and communicate effectively.

· Sound problem resolution, judgment and decision-making skills required.

· Extended coverage outside of normal work hours will be required

· Good knowledge of database design and implementation.

· Demonstrated ability to write and/or troubleshoot complex stored procedures.

· Must have a strong understanding of MS products, software lifecycle methodology and information systems development.

· Strong analysis and customer service skills required.

· Strong grasp of SDLC and Six Sigma or equivalent methodologies

· ITIL V3 Foundation Training

· Solid SQL experience required.

· Knowledge of IIS / and/or ASP.Net, SharePoint based applications, NLBS Clustering

· Prior experience in setting up BCDR systems

· Knowledge of .Net Languages a plus (specifically C# and VB.Net)

· Good knowledge of command/batch files.

· Good knowledge on the SQL performance analysis and experience on driving improvements.

Degree in Computer Science or related field and a minimum of 8-10 years of related experience. Specialized knowledge in multiple technical areas is a plus; specifically database technologies. Individual must have a strong understanding of MS products, software lifecycle methodology, information systems development. Strong analysis and customer service skills required. Sound problem resolution, team building, judgment, decision making, and risk management skills required. Strong written and oral communication skills are a must. Extended coverage outside of normal work hours is occasionally required.

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to the Id given below ...Include CTC details in your mail

6 New SQl DBA positions with Microsoft Corp Hyd - JD Similar to that posted below

noreply@blogger.com (Crest Consultants) — Wed, 24 Mar 2010 12:23:00 +0000

SQL DBA with IIS - Microsoft Corp

noreply@blogger.com (Crest Consultants) — Fri, 26 Feb 2010 14:55:00 +0000

Company :Microsoft Corporation

Location: Hyderabad

Job Title: Senior Software Operations (SO2)

We are looking for Senior Software Operations lead to manage the systems powering MSIT applications through strong understanding of technologies and principles of Software Application Support, system administration, service delivery and operations. The job entails managing all aspects of systems management, administration, and operations of large-scale web and SQL based services by involving in design, deployment, management, Production Support and operations.

Primarily this role oversees the implementation of complex, mission and business critical systems in a production environment and manages application support to established service levels to facilitate the effective utilization of the systems

Responsibilities:

* Contribute individually in the implementation and support of systems in a production environment
* Responsible for maintaining the highest levels of systems availability, data delivery and availability, and customer satisfaction for all assigned systems
* Drive the implementation of continuous improvement activities including new support tools and automation
* Developing the road map for the applications by providing strategic insights into stability and availability of the applications.
* Responsible for end user satisfaction with complete accountability of meeting the defined Service Level Agreements (SLA & OLA).
* Act as escalations contact for mission critical & revenue processing applications and drive solutions with complete end-to-end ownership
* Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders.
* Strong documentation skills in documenting processes, procedures and tools descriptions.
* Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors
* Participate in and contribute to Release activities including Spec reviews
* Understand and contribute to effective Monitoring of the critical components of the System
* Align with standard process compliance including MOF/ITIL

Requirements:

* Should have 6+ years of experience in production support role supporting windows 2003/2008, SQL Server 2000-2005-2008, Internet Information Server (IIS5-7), in a large scale 24x7 operations/production web service environment.

* Must have SQL aptitude including ability to execute SQL troubleshooting procedures, analyze SQL code and results from SQL queries
* In depth knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure environments
* Experience in managing production systems and applications built on Windows servers and advanced knowledge of SQL Systems, Web technologies, Active Directory, TCP/IP protocols, system performance and IIS
* Strong ITIL and MOF knowledge and experience
* Strong analysis and customer service skills with sound problem solving, judgment and decision-making skills
* Excellent teamwork, communication, and documentation skills
* Knowledge of scripting languages and technologies (Powershell, VBScript, Perl, WMI etc.), Experience with programming (ASP.NET, XML, HTML, C, C++) is a plus
* Ability to work in shifts in 24x7 support model

List of skills preferable for this position

* 4-year bachelor’s engineering course from the reputed institution
* Should be process oriented, should have good knowledge about SEI-CMM, Six Sigma and PSP/TSP, preferably from a CMM Level 5 company

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to the Id given below ...Include CTC details in your mail

SQL Database Developer -AND - SQL DBA Positions - Microsoft Corp Hyd

noreply@blogger.com (Crest Consultants) — Sun, 31 Jan 2010 06:52:00 +0000

LOCATION FOR BOTH POSITIONS IS HYDERABAD

COMPANY : MICROSOFT CORPORATION

POSITION:1

Title SQL DBA Dev / Lead

Are you ready to join the Engineering Delivery Integration group as a Senior Lead Production Engineer? Would you like to contribute to the building and managing of world class services supporting Xbox 360, Zune, Microsoft Games, and all other Microsoft products sold at retail? Join Microsoft Entertainment and Devices and make the Digital Entertainment Lifestyle a Reality!

As a member of the E&D Information Systems team, you’ll drive the supportability and manageability of our applications, guiding the product team through the release and deployment phase and help ensure the readiness of our Production Support team. You will interact with program and solutions management, development, and test to ensure we deliver quality applications that meet our customer requirements. You’ll play a key role throughout the product development cycle, collaborating on designs, features, and driving quality requirements and ensuring the product is ready for a high-availability production environment. You’ll design, develop and own appropriate monitoring solutions and provide Tier 3 Production Support. You will provide leadership and direction to junior Production Engineering team members and vendor staff.

Core job responsibilities:

· Facilitate and coordinate release management process driving increased Release agility, quality, and supportability.

· Deliver on key SLA’s and availability metrics.

· Provide Subject Matter Expertise for production and UAT environments and application(s).

· Lead or participate in individual, team or cross team projects that enhance the quality or efficiency of support.

· Troubleshoot issues independently and collaborate with project teams directly without guidance from others.

· Improve organizational learning through accurate recording of problem management data and trend analysis.

· Reduce the number and business impact of incidents, problems, and known errors as problem management resolves and eliminates the root causes of incidents.

· Deliver and drive continuous improvement of the ITIL/MOF disciplines including Release, Change, and Problem management.

· Provide clear and effective project status reporting on a periodic basis to systems team stakeholders (and clients).

· Provide leadership, supervision and guidance to a team of junior engineers.

Basic (Minimum) Qualifications:

· 6+ years of database-related experience in a production environment

· 2 years of technical team leadership experience

· SQL Server, OLAP experience and competency

· T-SQL stored procedure development, analysis, and troubleshooting, performance and tuning

· Knowledge of Windows 2003 / 2008 server and IIS

· BS in Computer Science, Information Systems, Engineering or related field (or equivalent additional industry experience.)

Preferred Qualifications:

· Experience with performance tuning, failover technologies and strategies

· SQL Administration including performance tuning and data analysis

· Database implementation, DB internals

· MCSE, MCDBA , MCPITDBA or equivalent work experience/training.

· In-depth knowledge of Microsoft technology and software including Windows, IIS, SQL, ASP/ASP .NET, BizTalk.

· MS in computer science, information systems or engineering

· Experience working in a 24X7 environment.

· 1 -2 years experience with Digital Asset Management technologies

· 1 -2 years experience with Adobe In-Design Server

· In-Depth knowledge of FTP

· Knowledge of software lifecycle methodology and Microsoft Operations Framework (MOF).

· A passion for customer support.

POSITION :2

STANDARD TITLE: SENIOR DATABASE ENGINEER

Job Description Format

Introduction to group/job Join Microsoft’s fastest growing division and make the Digital Entertainment Lifestyle a Reality!

Entertainment & Devices Manufacturing & Supply Chain (E&D Mfg & SC) Systems improves business performance continuously by delivering world class systems solutions.

Roles/Responsibilities

· Apply the "Database-Specific Operational Best Practices Checklist"

· Perform design review of all database changes/projects

· Performance-tuning and optimization (review blocking, do root-cause analysis of performance bottlenecks and escalate appropriately).

· Plan future-state infrastructure (storage capacity planning, server SKU recommendations, newest SQL Server features, etc.)

· Setup database failover mechanism (DB Mirroring, log-shipping, etc.) and perform disaster recovery excercises.

· Maintain, review and implement the "SQL Server Configuration Standards Checklist" (Writing in Progress). Make sure all servers are in compliance.

· Fine tune SQL monitoring by ensuring that all SQL Errors are captured proactively.

· Create knowledge base articles for alerts/issues for DBA (Service operation) team to resolve issue without escalating to database engineering team.

· Plan for high availability through SQL Always on technology

BASIC QUALIFICATIONS:

- BSc in Computer Science or similar Engineering degree

- 5+ years of experience as a SQL Database Engineer

- 3+ hands on Production DBA experience in handling VLDBs, especially in areas like tuning, disaster recovery and high availability.

- Strong SQL skills (Level 400) and experience in database design, schema design, and SQL performance tuning and optimization

- Experience and knowledge in designing scalable and failover database systems

- Experience in configuring, implementing and supporting high availability strategies with SQL Always on technology.

- Outstanding customer service/focus skills Demonstrated ability in handling complex. technical issues and providing timely solutions.

- Demonstrated ability to define and follow best practices and business processes.

- Excellent written and verbal communication skills

- Understanding of multi-tiered application technology.

- Excellent understanding of Microsoft Windows 2000/2003 operating system

- Good understanding of OS and Infrastructure / Network layer is value added

PREFERRED QUALIFICATIONS:

- Experience in Designing and Implementing enterprised wide BI solution

SQL Dev - Microsoft Hyd

noreply@blogger.com (Crest Consultants) — Sat, 12 Dec 2009 12:40:00 +0000

Location : Hyderabad

Company : Microsoft Corp

Title: IT Software Development Engineer 2

Job Description/Responsibilities:

As IT Software Development Engineer 3 this person will be responsible for:

Code and test applications in accordance to design specifications and standards.
Code and test SQL Server database applications that support the requirements defined by users and analysts.
Design as per architectural directions simple to medium complexity modules/features
Responsible for developing major subsystems on high risk business systems under deadline pressure
Responsible for successful completion of development aspects of projects in conformance to project goals and requirements
Deliver assignments according to a schedule
Analyze applications and make necessary changes to optimize performance
Analyze and troubleshoot existing processes and optimize code in order to improve performance whenever possible
Develop and enforce coding practices designed to promote code reusability; assist in defining and updating the team standards to improve the development process and quality of deliverables
Participate in design reviews and code reviews
Assist Test and Production Support teams with installation of the application
Design and code database applications that perform efficiently, are operationally stable, and meet the business requirements.
Accurately estimates work/time required to complete tasks within their skill set
Assist with the creation of project plans.
Communicates and defends design, requirements, feature set, functionality and limitations of subsystem to team members and development lead.
Fosters proactive and cooperative relationships within the project team
Participates in project team activities and contributes to documentation requirements consistent with methodology.
When necessary, participates in the creation of new guidelines and procedures.
Act in lead role (if required), and oversees the design and development for smaller, lower risk business systems
Exercises independent judgment in selecting methods and techniques for obtaining solutions.
Ensures that team’s code meets specifications and is easily maintainable.
Participates in project team activities and contributes to documentation requirements consistent with methodology
Prepares presentations and status reports.
Fosters proactive and cooperative relationships exist within the project team
Proficient with and guides others in using development tools.
May make recommendations on staffing and hiring decisions.

Requirements/Qualifications and Previous Work and Related Experience (including educational requirements):

· Understands networking

· Strong understanding of how to design applications for optimal network performance

· A solid working knowledge of SQL Server, Windows NT, and development practices for working with a team of developers.

· Experience working with relational database management systems and client-server technologies

· Strong leadership skills

· Sound problem resolution, judgment, negotiating and decision making skills required.

· Strong analytical and organizational skills.

· Able to participate in a team environment, communicate effectively and promote cooperative relationships.

· Ability to work under pressure and be able to work to tight deadlines.

· Must have a strong understanding of software architectures and MS products.

· Demonstrated experience with a Software Development Life Cycle Methodology and information systems development. Experience with agile development methodologies and PSP/TSP would be an advantage.

· Strong knowledge and ability to apply latest technology, standards, capabilities and limitations of technology.

· Demonstrated knowledge of relational database and client-server technologies.

· Promotes cooperative relationships

· Ability to work with multiple people, resources and partners, remotely if necessary

· BS/BA in computer science or related field

· Minimum of five to eight years of related developer experience – or – An equivalent combination of training and related work experience

Microsoft certification desirable

SQL+OLAP/ ETL- Microsoft BI

noreply@blogger.com (Crest Consultants) — Sat, 07 Nov 2009 17:17:00 +0000

Job Role: Senior BI Application Engineer/BI Architect (Microsoft BI)

Introduction

The Partner Integrated Reporting (PIR) Team at BI Engineering Group - MSIT (India) is looking for a well-qualified person who has prior experiencing in design and implementation of 2-3 end-to-end BI Solutions on Microsoft Technology Stack. This is an IC role. The BIE Team at MSIT India deliver BI solutions for key Microsoft Businesses e.g. Consumer, Partner, Sales and Marketing etc. The PIR Team at BIE is responsible for delivering BI capabilities to Microsoft Partner Teams for enabling key reporting capabilities around the Partner Business of Microsoft. The PIR Team is engaging in a new effort for the upcoming year to deliver enhanced BI capabilities to Microsoft Partner Teams (Next Generation PIR Effort). The PIR Team is looking for a Senior Technical Lead who can help drive the Technical and Architectural direction of the Next Generation PIR across the entire BI SDLC.

Job Position

• Should have excellent communication skills. Able to talk efficiently and effectively with the global development team and have the talent of challenging technically.

• Should have 7+ Years of IT Experience with at-least 4 years in the Design and Development of end-to-end BI Projects

• Should have exposure to complete SDLC for building a BI Application (Requirement Analysis, Design, Development, Deployment and Support)

• Displays high degree of Confidence and ability to work in ambiguous situations

• Should be able to Lead the Technical Architecture / Design for the BI Application

• Should be effective at Cross Group collaboration

• Should have capability to influence Architecture / Design for Medium to Complex components for the BI Application (within and across the Organization)

• Evangelizes Technology Patterns and Best Practices

• Must able to lead a project with less dependency and control the project with respect to schedule and quality.

• Displays great negotiation skills and displays ability to influence others

• Excellent Team Player

• Be an active participant on design, development and support of the project.

• Bring technical expertise based on development experience, and make sound technical decisions to deliver high quality projects

Responsibilities:

• Ability to drive Application Development Plans for Medium to Complex deliverables or for entire Release

• Dimensional Modelling (Physical and Logical)

• Design and develop ETL and relational Staging and Data Mart Databases.

• Design and develop multi-dimensional Schemas.

• Design and develop reporting systems for internal and external partners.

• Contribute to development methodologies and best practices in the BI space

• Active participation in technical investigations and prototyping

• Evangelize on Microsoft BI Platforms and build tools to enhance Team Productivity

• Define, Optimize and Manage the Version Control Strategy for the Project

Technical Skills:

• Strong Breadth in Microsoft BI Technology Platform (with Strong Depth in 2 Technology Areas)

• Essential: Strong SQL Server Fundamentals and T-SQL Skills (SQL Server 2005+)

• Experienced in Design and Development of Microsoft OLAP Cubes (SQL Server 2005+)

• Experienced in Design and Development of Application ETL based on the Best Practices leveraging Microsoft ETL Tools

• Experienced in Design and Development of Microsoft Reporting Technologies (SQL Server Reporting Services, ProClarity or Performance Point)

• Experience on Microsoft Tools for Project Planning – Microsoft Project

• Experience on Modelling Tools like ERWIN and Microsoft Visio

• Experienced in Performance Tuning specific areas of a BI Application (Database Code, ETL, Reporting, OLAP)

• Experienced in Version Control Tools and Collaboration like Visual Source Safe, VS DB Pro and VSTF

• Exposure to Microsoft Collaboration platform like Microsoft SharePoint Portal

How to apply

If you have received a mail from me Pls reply to that mail with the required details

If you have reached this site directly ...pls send in your resume to kurien@crest.in with SQL /OLAP as the subject . Pls mention ur Current and exp CTC details in the mail

Softwre Development Engineer 2 - Microsoft Corp hyd

noreply@blogger.com (Crest Consultants) — Tue, 03 Nov 2009 12:35:00 +0000

Company : Microsoft Corp

Location : Hyderabad

Good communication

- 5-8 years of exp.

- Strong on Sql, SSAS, SSIS, Integration skills

- Worked and hands on experience on .Net suite of technologies like C#, Asp.Net, VB.Net

- Working experience on Biztalk