The job of Database Administrator Analyst is to maintain and manage databases deployed in Unix environment; developing, implementing and maintaining application databases; documenting system components and user instructions; and serving as a technical advisor.
Coordinates database activities (e.g. security, upgrades, populating, refreshing, repairing database systems, cataloging, access rights, etc.) for the purpose of ensuring data accuracy and availability and monitoring compliance with security procedures.
Assists in the testing of application updates, enhancements and changes for the purpose of ensuring that assigned applications and related systems function appropriately and meet objectives.
Designs a variety of databases (e.g. server configuration, security, disaster recovery and backups, structures, logical data model, scripts and stored procedures, etc.) for the purpose of providing end users with access to accurate data.
Develops a variety of database support processes (e.g. tech standards, monitoring utilities, tuning/optimization methods, etc.) for the purpose of ensuring the stability and performance of production databases and the availability of stored data.
Monitors assigned applications and related systems for the purpose of reducing application downtime and ensuring that assigned applications are available and meet objectives.
Troubleshoots malfunctions of database systems for the purpose of resolving operational issues and restoring services.
Define backup policy; archival/housekeeping policy; Define BCP Strategy
Implementation of Policies & SOPs ; BCP process
Ensure closure of tickets raised by L1 and other dept teams
System Performance monitoring and suggest solution for improvement
Ensure Closure of Incidences; Identify and implement RCA