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