Database Analyst

  • Not Specified
  • Gurgaon, Haryana, India
  • Permanent, Full time
  • BlackRock
  • 16 May 19

About BlackRock BlackRock helps investors build better financial futures. As a fiduciary to investors and a leading provider of financial technology, our clients turn to us for the solutions they need when planning for their most important goals. As of December 31, 2018, the firm

About BlackRock

BlackRock helps investors build better financial futures. As a fiduciary to investors and a leading provider of financial technology, our clients turn to us for the solutions they need when planning for their most important goals. As of December 31, 2018, the firm managed approximately $5.98 trillion in assets on behalf of investors worldwide. For additional information on BlackRock, please visit | Twitter: @blackrock | Blog: | LinkedIn:

Job Description:

Job Description:

The Aladdin® product unites the information, people, and technology needed to manage money in real time at every step in the investment process. Aladdin enables organizations to communicate better, work smarter, see clearer, and move faster in a changing landscape. Aladdin combines sophisticated risk analytics with comprehensive portfolio management, trading and operations tools on a single platform to power informed decision-making and create a connective tissue for thousands of users investing worldwide.

What is the Aladdin Product Group?

At the heart of BlackRock, the largest investment management firm in the world, is the Aladdin Product Group. Being a member of the Aladdin Product Group means working with the industry’s thought leaders to build innovative and forward looking products that shape the financial markets. The Aladdin Product Group creates next generation technology that changes the way information, people, and technology intersect for global investment firms. We build and package tools that manage trillions in assets, support millions of financial instruments and their risk calculations and process millions of financial transactions for thousands of users every day worldwide.

Team Overview

Database Operations team is a critical component of the Core Systems Operations group, responsible for every aspect of database technology, operations and strategy at BlackRock, across platforms such as SAP Sybase ASE/ Repserver / IQ, Oracle, Microsoft SQL Server, Apache Cassandra and GreenPlum.

The team provides 24/7 coverage in facing the sun model and is responsible for monitoring, operational support and administering production environments for all BlackRock businesses (including subsidiaries and BlackRock Solutions clients).

Job Purpose/ Responsibilities

The role requires providing operations, development and project support within the global database environment across various database platforms. Key responsibilities of the candidate are as follows:

Operational support of a wide variety of database technology

Provide database administration tasks such as:

  • Database set up & builds
  • Backup/restore
  • Code release
  • Monitor the health of database, replication servers & DR latency
  • Space management
  • Data migration
  • Performance & Tuning

Assess issues for severity, troubleshoot proactively and notify key stakeholders Focus on service impact and timely resolution of critical investment system issues Escalate outages until services is restored working in collaboration with Client Technical Services and other tech teams Coordinate with external vendor technology support when required. Once issues are resolved in the short term, focus on root cause and long term remediation

Project based participation

Participate in major upgrades and migration/consolidation exercises Creatively explore and implement new product features Actively contribute to the Performance Tuning and Engineering activities

Contribute to our software toolset

Contribute to the monitoring and maintenance utilities in Perl, Python and Java Contribute to data captures to enable more in-depth analysis of the system.


Skill and Qualification Requirements

  • Bachelor’s degree in computer science or related field preferred
  • Previous IT experience, preferably in a similar role
  • Keen enthusiasm for acquiring new technical skills
  • Ability to communicate effectively with senior management from both IT and business areas
  • Understanding of large scale enterprise application setup across Data centers.
  • Willingness to work during weekends on-site on DBA activities and designated shift hours

Database Technologies: - MS-SQL, Sybase ASE, and/or PostgreSQL

This includes

  • 5+ years of experience on Database administration primarily on MS-SQL Server is required. Proficiency with MS SQL Server 2012, 2016/2017 is required.
  • Hands-on experience with SQL server replication is required. Experience with Cluster and Always on Availability group is plus.
  • Some experience on different Cloud Platform offerings like Microsoft Azure, Amazon AWS, Google is plus.
  • Exposure on Database Migration between different RDBMS is plus.
  • In-depth knowledge on Windows and SQL utilities, PowerShell etc
  • T-SQL programming, Stored Procedures, views, ETL, SSIS
  • Hands on experience on Database Administration on SAP Sybase ASE, Replication Server and PostgreSQL is a big plus.
  • Strong Ability to analyze SQL query performance and suggest probable solutions.
  • Ability to write efficient and maintainable queries/code
  • Enjoys a high-pressure environment, troubleshooting time sensitive critical issues and working with people

OS: Familiarity with Linux/Windows

This includes

  • Well versed with all shell commands like grep, find, sed, awk, ls, cp, netstat etc.
  • Well versed with commands to check CPU usage, memory usage and disk usage on a Unix/Linux system using OS native commands
  • Good understanding of shell/Perl/PowerShell scripting.

Skills/Requirements: - Desired

  • Exposure or understanding of Big data technologies like Cassandra, Solr and Zookeeper.
  • Experience of working in financial markets
  • Exposure to AutoSys/Cron/Control-M tools
  • Experience on perl/python scripting.
  • Incident Management/Bug Tracking: Jira / Service manager etc.

Growth and development opportunities: Database training will be given, both on the job and formalized. Personal and technical growth is assured under the mentorship of a group of vastly experienced, technically focused colleagues

BlackRock is proud to be an Equal Opportunity and Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, national origin, religion, sex, sexual orientation, gender identity, disability, protected veteran status, and other statuses protected by law.

BlackRock will consider for employment qualified applicants with arrest or conviction records in a manner consistent with the requirements of the law, including any applicable fair chance law.