Ascendion
Location
Chennai | India
Job description
General DBA skills (Must have):
Experience- 10-15 years (Strict)• Managing te database design and architecture, infrastructure management, ensuring high availability, security, and performing routine maintenance tasks (tuning, backup and recovery, and monitoring) • Create the objects in the database, such as triggers, indexes, etc. • Monitor the performance of the database and ensure optimum performance. • Identify potential issues in the database to solve them early. • Maintain backups and perform disaster recovery in case a disaster destroys the database. • Monitor security and prevent any unauthorized access to the database • Schedule consistent maintenance on the server • Maintain database schema. • Manage database availability. • Give best practice guidance to the development team • Resolve any production issues • Role management • Develop automation technologies to accelerate the process of data loading. • Develop relational databases • Ensure data integrity • Manage user access and permissions by adding and removing users as required • Exposure to relevant tools used specific to the RDBMS • Exposure to ITIL framework (Incident/Change/Problem/Availability mgmt. etc) • Production Support experience • Major Incident Management MSSQL: • Availability Group • Cluster setup • Replication • DR and Standby • Linked Servers Postgres: • Maintain database schema • Manage database availability • Tablespace management • Role management • Ensure data integrity. • Manage user access and permissions by adding and removing users as required. • Maintain the database using different utilities. This includes using like pg_ctl and psql.Job tags
Salary
