Job Description
Job Description
Key Responsibilities:
- Database Installation & Configuration: Install, configure, and upgrade database software (e.g., SQL Server, Oracle, MySQL, PostgreSQL) and related tools.
- Performance Tuning & Optimization: Monitor database performance, identify bottlenecks, and implement tuning strategies (e.g., query optimization, indexing, schema design adjustments) to ensure optimal speed and efficiency.
- Backup & Recovery: Establish and maintain robust database backup and recovery procedures, ensuring data integrity and availability in case of system failures or disasters. Conduct regular recovery tests.
- Security Management: Implement and enforce database security policies, including user access control, encryption, and auditing, to protect sensitive data from unauthorized access.
- Troubleshooting & Support: Diagnose and resolve complex database issues, including connectivity problems, data corruption, and performance degradation. Provide expert support to development teams and end-users.
- Maintenance & Monitoring: Perform routine database maintenance tasks such as patching, space management, and integrity checks. Set up and manage database monitoring tools and alerts.
- Replication & High Availability: Implement and manage database replication, clustering, and other high-availability solutions to minimize downtime and ensure continuous operation.
- Capacity Planning: Monitor database growth and usage, performing capacity planning to ensure sufficient resources for future needs.
- Documentation: Create and maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.
- Collaboration: Work closely with developers, system administrators, and other IT professionals to support application development, deployments, and infrastructure projects.
Qualifications:
- Education: Bachelor's degree in computer science, information technology, or a related field; or equivalent practical experience.
- Experience: 5 years of proven experience as a Database Administrator, managing [mention specific database types, e.g., SQL Server, Oracle, MySQL] in a production environment.
- Technical Skills:
- Strong expertise in database management systems (DBMS) such as SQL Server, Oracle, MySQL, PostgreSQL, or others relevant to the organization.
- Proficiency in SQL and scripting languages (e.g., PowerShell, Python, Bash) for automation and database tasks.
- Experience with database backup and recovery tools and strategies.
- Solid understanding of database security principles and best practices.
- Familiarity with operating systems (Windows Server, Linux) as they relate to database environments.
- Knowledge of database performance monitoring and tuning tools.
- Soft Skills:
- Excellent analytical and problem-solving skills.
- Strong attention to detail and accuracy.
- Ability to work independently and collaboratively within a team.
- Effective verbal and written communication skills.
- Proactive and self-motivated with a strong sense of ownership.