IndiGo - Senior Manager - Application Database

Job Description

  • Job Title IndiGo


Job Description :

Key Responsibilities & Technical Experience :


The SENIOR MANAGER - APPLICATION DATA BASE will be responsible for maintaining the integrity and performance of the company databases and guarantee the data is stored securely and efficiently. The SENIOR MAANGER- APPLICATION DATA BASE will also provide strategic guidance and implementation of the corporate data warehouse and the corresponding data feeds. This position is a techno commercial (60% Technical 40% Managerial) position of handling IndiGo's application's Database. SENIOR MANAGER-APPLICATION DATA BASE will be responsible for all Data Base Performance and 99.90% Availability. 80% of the DBs are implemented on SQL 2012/2017/2019.

SENIOR MANAGER - APPLICATION DATA BASE will be responsible for the following :

- Data modeling and database design. The SR.MANAGER-APPLICATION DATA BASE must possess the ability to create an efficient physical database design from a logical data model and application specifications. If the data resource management discipline has not been created, the SR.MANAGER- APPLICATION DATA BASE also must be responsible for data modeling, normalization, and conceptual and logical design.

- Metadata management and repository usage. The SR.MANAGER DATA BASE, or sometimes the Data Architect (DA), must collect, store, manage, and enable the ability to query the organization's metadata. Without metadata, the data stored in databases lacks true meaning.

- Database schema creation and management. An SR.MANAGER DATA BASE must be able to translate a data model or logical database design into an actual physical database implementation and to manage that database once it has been implemented.

- Backup and recovery. Implementing robust backup and recovery procedures is the insurance policy of the SR.MANAGER DATA BASE. The SR.MANAGER DATA BASE must implement an appropriate database backup and recovery strategy based on data volatility and application availability requirements.

- Ensuring data integrity. SR.MANAGER DATA BASE must be able to design databases so that only accurate and appropriate data is entered and maintained. To do so, the SR.MANAGER DATA BASE can deploy multiple types of database integrity including entity integrity, referential integrity, check constraints, and database triggers. Furthermore, the SR.MANAGER DATA BASE must ensure the structural integrity of the database.

- Performance management and tuning. Dealing with performance problems is usually the biggest post-implementation nightmare faced by SR.MANAGER DATA BASE. As such, the SR.MANAGER DATA BASE must be able to proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance.

- Ensuring availability. Applications and data increasingly are required to be up and available 24x7. The SR.MANAGER DATA BASE must be able to ensure data availability using non-disruptive administration tactics.

- SQL code reviews and walk-thru. Although application programmers usually write SQL, Therefore, SR.MANAGER DATA BASE must possess in-depth SQL knowledge so they can understand and review SQL and host language programs and to recommend changes for optimization.

- Procedural skills. Modern databases manage more than merely data. The SR.MANAGER DATA BASE must possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions that are stored in the DBMS.

- Data security. The SR.MANAGER DATA BASE is charged with the responsibility to ensure that only authorized users have access to data. This requires the implementation of a rigorous security infrastructure for production and test databases. And a database auditing capability to document compliance.

- Capacity planning. As data consumption and usage continue to grow, the SR.MANAGER DATA BASE must be prepared to support more data, more users, and more connections. The ability to predict growth based on application and data usage patterns and to implement the necessary database changes to accommodate the growth is a core capability of the SR.MANAGER DATA BASE.

- General database management. The SR.MANAGER DATA BASE is the central source of database knowledge in the organization. As such he must understand the basic tenets of relational database technology and be able to accurately communicate them to others.

- General systems management and networking skills. Because once databases are implemented, they are accessed throughout the organization and interact with other technologies, the SR.MANAGER DATA BASE must be a jack of all trades. Doing so requires the ability to integrate database administration requirements and tasks with general systems management requirements and tasks (like job scheduling, network management, transaction processing, and so on).

- ERP and business knowledge. For businesses doing enterprise resource planning (ERP) the SR.MANAGER DATA BASE must understand the requirements of the application users and be able to administer their databases to avoid interruption of business. Most ERP applications (SAP, PeopleSoft, etc.) use databases differently than homegrown applications. SR.MANAGER DATA BASE requires an understanding of how the ERP packaged applications impact the business and how the databases used by those packages differ from traditional relational databases.

- Extensible data type administration. The functionality of modern DBMSs can be extended using user-defined data types. The SR.MANAGER DATA BASE must understand how these extended data types are implemented by the DBMS vendor and be able to implement and administer any extended data types implemented in their databases.

- Web-specific technology expertise. For e-businesses, SR.MANAGER DATA BASE are required to have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications. Examples of this type of technology include XML, CGI, Java, Ruby on Rails, TCP/IP, Web servers, firewalls, SSL, and so on.

- Storage management techniques. The data stored in every database resides on disk somewhere (unless it is stored on one of the new main memory DBMS products). SR.MANAGER DATA BASE must understand the storage hardware and software, including how it interacts with the DBMS.

- Incidents. SENIOR MANAGER - APPLICATION DATA BASE will be responsible for bringing down the Number of Incidents of DB and providing permanent resolution along with RCA.

This position will be provided a team of DBAs - (On rolls and outsourced) , the SENIOR MANAGER - APPLICATION DATA BASE will be managing the team and see that 24x7 DB support is provided for all the applications connected with DBs. Apart from above BAU, SENIOR MANAGER - APPLICATION DATA BASE should perform following projects. These projects which will take IndiGo's Application Data Base Management to next level.

- Implementation of Data Base Monitoring tool for Example - Ops View, DB watch, Nagios, Solar winds DPM.

- Migrating current SQL DB Versions from 2012 to 2019 - This will boost Performance of Data Bases and Security Features like GMSA can be implemented.

- High Availability of Data Bases - Redesigning the Data Base technology of Always ON to have 100% availability of Data bases.

- Disaster Recovery Project - Designing the architecture of Data Bases for Disaster Recovery sites.

- Self-Healing of the issues - Self Healing tools of MS can be used after the AI/ML is implemented in Monitoring tool
- Bringing down the Number of Incidents of DB and providing permanent resolution along with RCA.

There is something wrong with this job ad? Report the error