Database Developer

About the Company

Directi (www.directi.com) is a $300 million group of Business Units, that develop innovative mass-market Web Products serving millions of Customers worldwide. Several of Directi’s Business units rank amongst the fastest growing businesses worldwide in their corresponding industry segments.

Skenzo (www.skenzo.com), a Directi Business, is one of the world’s leading companies in the traffic monetization business. By revenue, we were the #1 fastest growing domain parking company worldwide for 2006 & 2007, and we currently feature amongst the world’s Top 3 largest domain parking companies. By headcount, we are the #1 largest domain parking company worldwide.

Job Description

We focus on building mass market products in the internet advertising space. The applications rely on making split second intelligent decisions using large amount of data. Most of our databases are hundreds of Gigabytes and some over a Terabyte in size. We currently use over 500 CPU and more than 500 GB of ram to run our database-based applications.

All our projects are RDBMS intensive. The job involves architecting and developing large database-centric applications, for deployment over a large and distributed architecture that heavily relies upon replication to distribute data updates across the multitude of servers.

Responsibilities

• Architect and manage complex, large, globally distributed databases as a member of high energy teams.
• Use Business Intelligence tools and OLAP to generate cubes and analytical reports on large volumes of data.
• 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.

Requirements

Educational Qualifications:

• Preferably from a Software Engineering/technical background.
• Microsoft Certifications in DBMS will be considered as an advantage.
• High Scores in all Major academic milestones.

Detailed Requirements:

• 2+ 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
• Knowledge of Query tuning Use of Query hints & indexes
• Experience with Multidimensional/Relational OLAP (MOLAP, ROLAP)
• Business Intelligence (BI) experience with a strong understanding of data warehousing concepts, data modeling concepts and design
• Ability to create and maintain complex DTS packages
• Ability to create Complex Queries (Joins, Nested queries, Unions etc)
• Excellent grasp of Database Design, Normalisation, Denormalisation
• 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