Designation: Database Administrator
Job Summary: Responsible for performance, integrity, and security of the database.
Responsibilities Installing and upgrading the database server and application toolsAllocating system storage and planning future storage requirements for the database systemCreating primary database storage structures (tablespaces) after application developers have designed an applicationCreating primary objects (tables, views, indexes) once application developers have designed an applicationModifying 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
Planning for backup and recovery of database informationMaintaining archived data on tapeBacking up and restoring the database
Contacting database vendor for technical support
Generating various reports by querying from database as per need 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.
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