Sunday, May 23, 2010

SQL DBA _Microsoft Corp hyd


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


Wednesday, April 14, 2010

SQL DBA - Microsoft Corp (New)

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

Friday, February 26, 2010

SQL DBA with IIS - Microsoft Corp

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


Saturday, January 30, 2010

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


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.

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



PREFERRED QUALIFICATIONS: 

-          Experience in Designing and Implementing enterprised wide BI solution 

Saturday, December 12, 2009

SQL Dev - Microsoft Hyd

Location :  Hyderabad 


Company : Microsoft Corp 


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
·         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
·         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