- Location: Chennai
- Job type : Fulltime
SUMMARY:
Responsible for performance, integrity and security of the database.
Exp:
Minimum 5 Years exp in DBA, in production environment specifically for portal technology / implementation.
RESPONSIBILITIES
- Installing and upgrading the database server and tools
- Monitoring, allocating system storage and planning future storage requirements for the database system.
- Creating primary database storage structures (tablespaces) after application developers have designed an application.
- Creating primary objects (tables, views, indexes) once application developers have designed an application
- Modifying the database structure, as necessary, from information given by application developers
- Enrolling users and maintaining system security
- Ensuring compliance with database vendor license agreement
- Controlling and monitoring user access to the database
- Monitoring and optimizing the performance of the database via query tunning and reducing long running quires
- Planning for backup and recovery of database information.
- Backing up and restoring the database as necessary.
- Contacting database vendor for technical support
- Generating various reports by querying from database as per need.
- Customer support for environmental issues and maintenance
- Creating data dictionary.
- Normalizing the database.
- Data conversions from different sources
Additional role requirements are likely to include planning, development and troubleshooting. Responsible for maintaining the consistency of data across database, maintains data integrity and data security. Also plan, design and developing database maintenance procedures and also help the development team to design the database based on business requirements.
Required Skill:
- SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure
- Knowledge of data modelling principles.
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities
- Be responsible for the development and documentation of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL).
- Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
- Maintain and improve already existing processes
QUALIFICATIONS
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools