Database Administrator
Government of Sindh
Total years of experience :12 years, 1 Months
Automation of Stamps & Registration Department, Government of Sindh, Karachi, Pakistan.
• Administration and maintenance of MS SQL Server and MySQL databases for department applications, ensuring high availability and data integrity.
• Oversaw database design, schema development, and table normalization to optimize performance and facilitate efficient data retrieval.
• Performed regular database backups, restorations, and disaster recovery procedures to safeguard critical data and ensure business continuity.
• Implemented security measures, including user access control, encryption, and auditing, to protect sensitive data and comply with industry regulations.
• Conducted performance tuning and optimization, identifying and resolving bottlenecks to enhance database efficiency and application performance.
• Collaborated with cross-functional teams together business requirements and translate them into effective database solutions.
• Provided technical support to developers and end-users, assisting in query optimization and resolving database-related issues.
• Creating Stored Procedures, triggers and views for reporting.
Performing additional assignments of development of web based large scaled modules in software application in PHP/Mysql CakePHP framework. The application is developed for registration of deed documents processed in multiple internal departments that includes following software modules:
o End-User Registration Panel with rights and privileges control system. o Rights and Privilege Management o Working Stations Management o Logs Management, Backup and Restoration System o Vendors and Vendees Registration Management o Taxes and Fees Collection System o Token Receipt System o Deed Document Registration, Inspection, Checking and Daybook Forwarding System o Dashboard and MIS Reports
• Provide technical solutions as needed by department.
• Coordinate with on-site users for support and updates.
• Meetings and technical discussion with higher management for running smooth systems.