Senior Database Admin
Aman -
Maadi, CairoJob Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Key Responsibilities:
- Database Management:
- Install, configure, and maintain PostgreSQL, Oracle, and MySQL databases.
- Monitor database performance and ensure high levels of performance, availability, and security.
- Implement and maintain database security (roles, privileges, etc.).
- Perform database tuning and optimization.
- Plan and implement backup and recovery strategies.
- Ensure data integrity and manage database replication.
- Database Design and Architecture:
- Design and implement database schemas, tables, and objects to support business requirements.
- Collaborate with development teams to design and optimize database queries, stored procedures, and indexing.
- Provide guidance on database design to ensure scalability, performance, and reliability.
- Performance Monitoring and Tuning:
- Monitor and optimize database performance using tools like pgAdmin, Oracle Enterprise Manager, and MySQL Workbench.
- Identify and resolve bottlenecks in database operations.
- Analyze and resolve complex database issues (locking, deadlocking, replication conflicts, etc.).
- Database Security and Compliance:
- Implement security measures to protect sensitive data and ensure compliance with industry regulations.
- Monitor and audit database activity to ensure compliance with security policies.
- Develop and maintain database documentation and standard operating procedures.
- Automation and Scripting:
- Automate routine database tasks using scripts (e.g., Bash, Python, PowerShell).
- Develop and maintain automation tools for database provisioning, backup, and monitoring.
- Disaster Recovery Planning:
- Develop and implement disaster recovery plans to ensure data availability and integrity in the event of a failure.
- Test and validate backup and recovery procedures regularly.
- Collaboration and Support:
- Work closely with the development and operations teams to support application deployment and performance tuning.
- Provide database support and troubleshooting to ensure minimal downtime and quick resolution of issues.
- Mentor junior DBAs and provide technical leadership within the team.
Job Requirements
Key Responsibilities:
- Database Management:
- Install, configure, and manage PostgreSQL databases.
- Assist in the management and maintenance of Oracle databases.
- Monitor database performance and perform necessary tuning and optimizations.
- Ensure data integrity, availability, and security.
- Implement backup, recovery, and disaster recovery procedures.
- Database Design and Development:
- Work with development teams to design database schemas, indexes, and optimize queries.
- Develop and maintain database scripts for automating tasks like backups, monitoring, and alerts.
- Performance Monitoring and Tuning:
- Monitor database systems regularly to identify performance issues.
- Optimize queries, indexes, and database configurations to improve performance.
- Security and Compliance:
- Implement and enforce database security policies.
- Perform regular audits of database systems to ensure compliance with security standards.
- Support and Troubleshooting:
- Provide support for database-related issues, including troubleshooting and resolving incidents.
- Work closely with application developers to resolve database-related issues.
- Documentation:
- Maintain and update documentation related to database configurations, procedures, and standards.
- Document and report database performance metrics and incidents.
Required Skills:
- Technical Expertise:
- Proficient in PostgreSQL database administration.
- Basic to intermediate knowledge of Oracle database administration.
- Strong SQL skills and experience with database scripting languages.
- Understanding of database security, backup, and recovery strategies.
- Familiarity with performance tuning and query optimization.
Experience and Education:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- A minimum of 3-5 years of experience in database administration, primarily in PostgreSQL, with exposure to Oracle.
