DBA Administrator

JOB DETAILS

JOB BODY

• 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
• Define and implement administration and maintenance processes
• Write complex stored procedures and queries for various business requirements
• Mentor other individuals and develop your career ongoingly
• 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-6 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
• 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