* Design, implement, and maintain complex relational databases, including schema definition, stored procedures, functions, and triggers.
* Develop and execute SQL queries for data extraction, manipulation, and reporting, ensuring accuracy and efficiency.
* Monitor database performance, identify bottlenecks, and implement optimization strategies (indexing, query tuning, etc.).
* Perform routine database administration tasks such as backups, restores, replication, and security management.
* Collaborate with application developers and business stakeholders to understand data requirements and translate them into effective database solutions.
* Troubleshoot database-related issues, including performance problems, connectivity errors, and data discrepancies.
* Develop and maintain documentation for database designs, procedures, and best practices.
* Ensure data quality and integrity through regular audits and implementation of data validation rules.
* Participate in capacity planning and performance testing to ensure scalability and reliability of database systems.
* Stay current with emerging database technologies and recommend appropriate solutions to enhance system capabilities.