Install, configure, and maintain database servers and associated software including backups and recovery.
• Design, develop, and optimize SQL queries, stored procedures, triggers, and functions to support application requirements.
• Monitor database performance and tune SQL queries, indexing, and server parameters to ensure optimal performance.
• Manage database security including user roles, permissions, and encryption measures.
• Perform routine database maintenance including patching, upgrades, and applying fixes.
• Set up and manage high availability solutions, failover, and disaster recovery processes.
• Ensure data integrity, audit compliance, and data migration processes from legacy systems.
• Collaborate with software developers, system administrators, and network engineers to implement end-to end solutions.
• Troubleshoot and resolve database issues in a timely manner.
• Participate in database design review and capacity planning.
• Implement data profiling, cleansing, and validation using ETL tools.
• Develop and maintain comprehensive database documentation. Certifications:- Essential certifications for a database administrator