Job
Description
Key Responsibilities: 1. Administer, configure, and monitor database systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL, etc.) to ensure high availability and reliability.2. Perform database installation, upgrades, and patch management.3. Maintain and manage user access and security permissions.4. Implement and manage database replication, clustering, and backup solutions.5. Monitor database performance, troubleshoot issues, and optimize queries and indices.6. Identify and resolve bottlenecks in performance, improving response times and resource utilization.7. Analyze and optimize database structures for scalability and performance.8. Design, implement, and manage backup strategies to ensure data integrity and disaster recovery.9. Perform regular backup and restore testing to ensure data safety.10. Implement database security policies and procedures to ensure data confidentiality, integrity, and availability.11. Conduct regular security audits and vulnerability assessments.12. Regularly update and optimize database schemas and structures.13. Maintain data integrity through consistency checks, integrity constraints, and error resolution.14. Work with developers, data analysts, and other IT staff to ensure optimal database performance in development and production environments.15. Provide database support and expertise to other departments as needed.16. Maintain comprehensive documentation of database systems, configurations, and procedures.17. Develop operational procedures for backup, recovery, and system monitoring. Required Skills & Qualifications: 1. 3 to 5 years of experience in database administration or related field.2. Strong knowledge of SQL and experience with database management systems (e.g., SQL Server, MySQL, PostgreSQL, or Oracle).3. Hands-on experience with performance tuning, troubleshooting, and query optimization.4. Experience with database backup and recovery strategies.5. Familiarity with database security, data encryption, and access controls.6. Experience in configuring and maintaining high-availability database environments.
