Posted Sep 11, 2022 426 views
Qualification & Experience:
- Master or bachelor degree in Data Administration.
- Graduate (with a minimum of 5 years’ experience)
- Master degree in Data Administration (2 years’ Experience)
Job Description
To facilitate the ongoing development and maintenance of our company’s databases, database applications and business intelligence and reporting solutions, ensuring a programme of continuous improvement in all matters relating to our databases is put in place, including a rolling schedule of audit, revision, incremental improvement and development.
Database Development
- Assist the Solutions Team with SQL/MySQL logical and physical design, as well as performance tuning. Creating complex query definitions
- Examine project requests that detail database requirements in order to estimate project time and cost.
- Design, develop, test, and implement, new and changed database tables, views, and associated functionality, including risk and impact analysis.
- New and updated database tables, views, and associated functionality, as well as risk and impact analyses, are designed, developed, tested, and implemented.
- Plan, coordinate, and implement security procedures to protect information against damage, modification, or disclosure by accident or without authorization.
- Develop rules and guidelines for the usage and procurement of database-related software, as well as for the protection of sensitive data. Business Intelligence
- Establish and confirm reporting needs with end users.
- Create and implement a standardized report development, design, and delivery process. Perform Data Analysis and Trend Analysis across the breadth of the organization’s data.
- Create data tables, views, stored procedures, and functions to make reporting of essential business insights more consistent.
- To support business needs, create ad-hoc queries and reports (T-SQL).
- Use SSRS to create reports.
- Maintain up-to-date knowledge of the newest BI solutions and advancements, and provide business recommendations as needed.
- Maintain high availability solutions, such as Data Warehousing/Replication (SSIS), to assure corporate data continuity and reduce the impact of Data Analysis on live systems.
Support and Maintenance
- SQL Server environment administration on a daily basis, including proactive monitoring, analysis, and tweaking of the production environment.
- Ensure that all database systems work as expected by the company.
- Maintain, develop, and support current database tables, views, triggers, and related functionality.
- Implement data security standards, such as access rights and privileges control, to protect data integrity.
- Working with co-workers to administer and enforce SQL Server security, which includes coordinating and implementing security measures to protect data in databases from hackers.
- Damage, modification, or disclosure that is unintentional or unauthorized.
- Implement solutions for high availability, such as clustering and mirroring.
- In charge of SQL Server backups in all environments.
- Scheduled SQL Server jobs are managed on a daily basis.
- Creation of comprehensive technical documentation covering standard operating procedures.
Skills
- Database Applicatios
- SQL
- MySQL Data Base
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
Database Administrator / Network Administrator
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Ali Aziz
CEO
Shopistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Muzammil Baig
Digital Marketing Manager
IT Services Group
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Aqib Irshad
Head of HR, Training & OD
FINCA
