Sr SO Database Administrator

Job Description

Job Category:
IT
Location:
Hyderabad, IN
Job ID:
761312-46045
Division:
IT

This Job is eligible for the following work arrangements :Flex Time

Job Description Format


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


As a Sr Database Administrator on the Interactive Entertainment Business (IEB) Information Solutions team, you will be part of the team working in maintaining high performing and scalable SQL systems to enhance the productivity and competitiveness of Microsoft Entertainment Division. 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 ensure that IEB SQL stores are being driven to industry best practices, that standards and procedures are implemented, and ensure the SQL platform is highly scalable, available, and secure. You will act as IEB final point for escalation for any SQL related issues and questions.


Currently our group owns 2000+ servers with 5 different BI application focusing different business segment (XBOX Live BI, Manufacturing & Quality Analtyics, Sales & Marketing and Operational Data Warehouse etc.,).


Roles/Responsibilities

Provide leadership and guidance to the vendor DBA team.

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.

Deliver on key SLA’s and metrics.

Own SQL issues and escalations from DBA vendor team and service operation team.

Plan for high availability through SQL Always on technology


BASIC QUALIFICATIONS:

(absolute minimums, will not talk to anyone without these items. Typically the non-subjective items i.e. 3+ years C++ development.

- 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
Additional Information

Posted:
August 23, 2011
Type:
Full-time
Experience:
Not Applicable
Functions:
Other
Industries:
Computer Software
Employer Job ID:
761312-46045
Job ID:
1774819