Database Administration Analyst (325196)
Information
| Information Technology | |
| Mid Career (2-6 years) | |
| Not specified |
Company
| Not specified | |
| Financial Services | |
| Mohandseen, Giza, Egypt Sheikh Zayed City, Giza, Egypt |
Description
- Design, develop, and implement database structures based on organizational requirements.
- Create and maintain data models, schemas, and indexing strategies.
- Design, create, and maintain databases across multiple platforms (e.g., SQL Server, Oracle, MySQL) to meet application and business requirements.
- Perform database installations, configurations, upgrades, and migrations as needed.
- Implement and enforce data security measures, including user access controls, encryption, and authentication.
- Monitor and audit database systems for security vulnerabilities and breaches.
- Apply database security patches regularly.
- Perform regular backups and disaster recovery planning to ensure data availability and integrity.
- Apply patches and updates to database management systems (DBMS).
- Generate Reports daily for database backups and send to the head of Database Administration.
- Monitor and optimize database performance by analyzing query execution plans and indexing strategies.
- Identify and resolve bottlenecks and performance issues.
- Manage data migration between systems and perform Extract, Transform, Load (ETL) processes.
- Ensure data consistency and accuracy during migration.
- Forecast database growth and plan for hardware and software scalability.
- Allocate resources as needed to maintain optimal performance.
- Develop and maintain backup and recovery plans to minimize data loss in case of system failures or disasters.
- Test and document recovery procedures.
- Monitor database systems for anomalies, errors, and performance issues.
- Troubleshoot and resolve database-related problems.
- Maintain documentation of database configurations, procedures, and best practices.
- Generate reports on database performance and usage.
- Collaborate with developers, system administrators, and other IT professionals to support application development and integration.
Requirements
- Bachelor's degree in computer science, information technology, or a related field from a reputable university.
- Minimum 2- 5 years of relevant experience.
- Proven experience as a Database Administrator or a related role.
- Proficiency in one or more database management systems (e.g., Oracle, Microsoft SQL Server, MySQL, PostgreSQL).
- Strong knowledge of database architecture, SQL, and data modeling. Familiarity with database security principles and best practices.
- Excellent problem-solving and communication skills.
- Ability to work independently and as part of a team.
- Relevant certifications (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator) may be preferred or required.
| Created on | 06 Nov 2024 |
| Last updated on | 06 Nov 2024 |