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