|
|
|
|
Job Title:
|
Database Lead - Internet Advertising |
|
Job Category:
|
Info Technology |
|
Job description:
|
* Lead a team of people to architect and manage complex, large, globally distributed databases as a member of high energy teams.
* Guide the use of Business Intelligence tools and OLAP to generate cubes and analytical reports on large volumes of data.
* Lead teams and write complex stored procedures, functions and queries in T-SQL for various business requirements.
* Define and implement administration and maintenance processes.
* Mentor other individuals and develop your career continuously.
* Take active participation in Recruitment and Training processes.
* Participate in the entire lifecycle of the Product - design, documentation, coding, testing and deployment.
|
|
Skills:
|
* 8-12 years of experience in complex Database design, optimization and querying
* Good oral/written communication skills in English
* Experience in architecting, optimizing and maintaining large databases (hundreds of Gigabytes)
* Expert knowledge of SQL and T-SQL
* Expert knowledge of MS SQL Server and system tables and databases, certifications like MCDBA preferred
* Knowledge of Query tuning Use of Query hints & indexes
* Business Intelligence (BI) experience with a strong understanding of data warehousing concepts, data modeling concepts and design
* Experience with Multidimensional/Relational OLAP (MOLAP, ROLAP) and MDX scripting.
* Ability to create and maintain complex DTS packages
* Ability to create Complex Queries (Joins, Nested queries, Unions etc)
* Excellent grasp of Database Design, Normalization, Renormalization
* Excellent grasp of Database Optimization (along with System optimization)
* Thorough knowledge on working of indexes, types of indexes, and indexing algorithms
* Knowledge of database internals
* Knowledge of Database Replication and Clustering
* Programming skills in any platform
* Basic Networking knowledge
* Experience in using SCM tools like CVS, SVN etc and using issue-tracking tools like JIRA/Mantis etc
* Process oriented: Demonstrable commitment to following processes, commenting, documentation, testing etc
Bonus Points:
Certifications and recognitions such as MVP (SQL) would serve as a clear advantage. |
|
Employment type:
|
|
|
Salary Range:
|
Unspecified |
| |
| Other Information |
 |
|
| |
|
Degree:
|
Bachelors |
|
Experience (year):
|
8 |
|
Job Location:
|
--Maharashtra-Mumbai |
|
Post Date:
|
04/02/2009 |
| |
| Contact Information |
 |
|
| |
| |
| Apply Online |
 |
|
| |
|
|
|