Data Center Supervisor Engineer- Dba
CurrentCreate standard procedures to enhance scalability and performance of existing database architecture.Troubleshoot complex database issues in accurate and timely manner.Maintain database disaster recovery procedures to ensure continuous availability and speedy recovery.Supervise installation, migration and upgrade of databases.Ensure that database is developed according to business requirements.Prepare reports on database scalability and capacity planning as needed.Identify and resolve database issues related to performance and capacity.Develop best practices for performance and operational efficiency.Ensure database management and maintenance tasks are performed effectively.Conduct training programs for staff on database development and maintenance procedures.Perform regular audits to ensure data integrity and quality.Provide regular updates to management on database project status.Stay updated with new database technologies and analyze such technologies to bring into scope of existing infrastructure.Participate in new projects design , implementation and management vendor requirements for new databasesManage a team of professionals to design and develop database systems.Provide guidance to database team on database structures and features.Database managed - Oracle database 12c and 19c- IBM DB2 LUW 11.5 - 11.1 - 10.5 - MySQL - MSSSQL server 2014 , 2019 Achievements:Working with monitoring team to monitor Databases with their owned systems including preparing monitoring queries , provide warning and critical threshold alerts Working with backup team to schedule backup plans for all databases Apply high-availably strategies and technologies to meet every database provider best practiceHADR in DB2Data guard in Oracle Always on and Fail over cluster in MSSQL