Tuesday, February 1, 2011

SQL DBA @ Microsoft India - Hyderabad Center- Multiple positions

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

Tuesday, October 19, 2010

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

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

Thursday, September 2, 2010

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

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

Monday, August 9, 2010

SQL Database Developer - Microsoft hyd


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.

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 leelakrishna@crest.in with SQL Developer as Subject
...Include CTC details in your mail


Friday, August 6, 2010

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

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

Wednesday, July 14, 2010

SQL Database Developer - Microsoft hyd


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