Posted Sep 19, 2024 478 views
Key Responsibilities:
Database Design and Planning:
- Collaborate with application developers and architects to design and plan database solutions that meet business requirements.
- Define database schemas, tables, indexes, and relationships for optimal performance and scalability.
Installation and Configuration:
- Install and configure database software and related tools on various platforms.
- Implement and maintain high availability solutions such as database clustering and replication.
Performance Tuning:
- Monitor and analyze database performance using tools and techniques to identify and resolve bottlenecks.
- Optimize SQL queries, database schema, and configurations for improved performance.
Security and Access Control:
- Implement and enforce security measures to protect sensitive data.
- Manage user accounts, roles, and permissions to ensure data access control.
- Regularly apply security patches and updates.
Backup and Recovery:
- Develop and maintain backup and recovery strategies to safeguard data against loss or corruption.
- Test and execute backup and recovery procedures regularly.
Monitoring and Alerts:
- Set up monitoring tools to proactively detect issues and respond to alerts promptly.
- Establish and maintain database performance and health dashboards.
Capacity Planning:
- Forecast future database capacity requirements and plan for scaling as needed.
- Allocate and manage storage resources effectively.
Documentation and Reporting:
- Maintain comprehensive documentation of database configurations, procedures, and policies.
- Generate and share regular reports on database performance and utilization.
Troubleshooting and Problem Resolution:
- Investigate and resolve database-related issues, such as data corruption or performance degradation.
- Participate in on-call support and respond to critical incidents.
Collaboration and Teamwork:
- Collaborate with cross-functional teams, including developers, system administrators, and network engineers.
- Mentor and provide guidance to junior database administrators.
Qualifications and Skills:
- Bachelor's degree in Computer Science, Information Technology.
- 4 to 6 years of experience in database administration, with a focus on MySQL/ PostgreSQL / Microsoft SQL Server.
- Proficiency in SQL query optimization and performance tuning.
- Strong knowledge of database security best practices.
- Experience with database clustering, replication, and high availability solutions.
- Familiarity with scripting languages (e.g., Bash, Python) for automation.
- Excellent problem-solving and communication skills.
- Relevant certifications, such as MySQL Certified Database Administrator (CMDBA), are a plus.
Preferred Additional Skills:
- Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
- Knowledge of NoSQL databases (e.g., MongoDB, Cassandra).
- Familiarity with containerization and orchestration tools (e.g., Docker, Kubernetes).
Skills
Job Details
Aftab Currency Exchange Ltd
Aftab Currency Exchange Ltd. is a UK incorporated Company that is part of the well-established Aftab group companies and has been operating in the North West of England since 2002. Our head office was the starting point of the UK success story when we commenced business with retail clients and two business associates we now have our London branch in South West London and have over the past 9 years expanded our coverage through the use of agents across the UK and now boosts a network of more than 280 business associates and agents using the Aftab Currency Exchange name which we have worked hard to maintain our credibility and trusts within the Pakistani community.
What is your Competitive Advantage?
Similar Job Titles
Experienced Manager Database Administration (DBA)
Ali Aziz
CEO
Shopistan
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Aqib Irshad
Head of HR, Training & OD
FINCA
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
