الوصف الوظيفي
As a SQL Database Engineer responsible for providing technical support, troubleshooting issues, and optimizing databases to ensure the reliability and performance of our database environments.
Align with Business Goals
Familiarize with the company's mission, vision, and strategic objectives.
Work closely with other departments.
Clearly articulate technical concepts to non-technical stakeholders.
Forecast future network needs and plan for capacity expansion.
Install, configure, and maintain database systems (e.g., SQL Server, MySQL, PostgreSQL, Oracle).
Perform database backups and recovery operations.
Monitor database performance and implement optimization techniques.
Manage user access and permissions.
Diagnose and resolve database-related issues.
Troubleshoot performance bottlenecks and implement solutions.
Analyze and optimize SQL queries for improved performance.
Create and maintain indexes to optimize query execution.
Plan and execute database migrations.
Migrate data between different database platforms.
Database support and operations often require 24/7 coverage, so shift work may be necessary.
Being on call to respond to urgent issues outside of regular working hours may be required.
Maintain clear, up-to-date documentation on DB solution configurations, policies, and operational procedures.
Prepare reports on incidents, system performance, and solution effectiveness with a Root cause analysis.
Optimize performance and capacity.
Anticipate future needs and develop a roadmap for modernization.
Prioritize activities
Monitor and respond promptly to incidents.
Optimize Performance
Track metrics.
Fine-tuning
Keep abreast of the latest technologies
Understanding Level Designs
Maintain clear, up-to-date documentation on solution configurations and operational procedures.
Prepare reports on incidents, system performance, and solution effectiveness with a Root cause analysis.
Staying up to date with the latest technologies.