Sign In
 [New User? Sign Up]
Mobile Version

Senior DB Architect

Secunderabad, Telangana
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Job DescriptionPrimary ResponsibilitiesCreating complex analytic queries on large data sets.Analyze query execution plans and optimize database for performanceDesign, Develop and Deploy SSIS Packages.Write unit test and automated testing scripts for SSIS packages.Creating stored procedures, triggers, and functionsGenerating code to extract, transform and load dataDevelop and design database objects, such as tables, indexes, constraints, etcBe able to work with development, business teams.Research and develop new ways to improve existing functionality.Research and develop new ways to improve existing functionalityProactively analyze and bring forth ideas for continuous improvementWhat You Need for this Position5+ years as a SQL DBA in a production environment3+ year experience with SSIS3+ year experience in database and ETL developmentExpert working knowledge of query, index and DB I/O performance tuninExpertise with configuring, implementing and supporting large highly available SQLServer environments, including experience with Failover -Cluster and database mirroringExcellent understanding of query execution plans.Experience and understanding how to scale database driven applications through refactoring logic out to cache based services.Experience with NoSQL databases including Mongo and Hadoop a plus.Experience with reducing DB read load to caching services with Elastic Search or Solr.Expert working knowledge of Stored Procedures and SQL codingAbility to proactively identify, troubleshoot and resolve live database systems issuesKnowledge of disaster recovery principles and practices, including planning, testing,backup/restoreThorough knowledge of current hardware systems disk subsystems commonly used infault tolerant production environmentsAbility to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.Experience running and supporting very large data warehouse databases (OLAP, Big Data)
Degree: MCA/ PGDCA | ME/ M.Tech./ MS (Engg/ Sciences)

Additional Degree: BE/ B.Tech (Engineering) | BCA (Computer Application)

Experience: 5-10


Data Warehousing | Database Administration (DBA) | Software Engineer | System Analyst/Tech Architect
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News