Database Administration Analyst/ Senior Analyst

Design, develop, and implement database structures based on organizational requirements. Create and maintain data models, schemas, and indexing strategies. Design, create, and maintain databases across multiple platforms (e.g., SQL Server, Oracle, MySQL) to meet application and business requirements. Perform database installations, configurations, upgrades, and migrations as needed. Implement and enforce data security measures, including user access controls, encryption, and authentication. Monitor and audit database systems for security vulnerabilities and breaches. Apply database security patches regularly. Perform regular backups and disaster recovery planning to ensure data availability and integrity. Apply patches and updates to database management systems (DBMS). Generate Reports daily for database backups and send to the head of Database Administration. Monitor and optimize database performance by analyzing query execution plans and indexing strategies. Identify and resolve bottlenecks and performance issues. Manage data migration between systems and perform Extract, Transform, Load (ETL) processes. Ensure data consistency and accuracy during migration. Forecast database growth and plan for hardware and software scalability. Allocate resources as needed to maintain optimal performance. Develop and maintain backup and recovery plans to minimize data loss in case of system failures or disasters. Test and document recovery procedures. Monitor database systems for anomalies, errors, and performance issues. Troubleshoot and resolve database-related problems. Maintain documentation of database configurations, procedures, and best practices. Generate reports on database performance and usage. Collaborate with developers, system administrators, and other IT professionals to support application development and integration.