Jr. Database Administrator
CurrentI. Administration of SQL Server staging and MySQL Production environments.II. Understand the priorities and assigning the work-load efficiently to the team members and meet the deadlines.III. Analysis of historical data and generate scheduled/requested ad hoc reports for Operations & Police departments as per escalated requests received from RTA.IV. Auditing internally and provide assistance to external auditors on monthly & annual basis to ensure data integrity; moreover validating user access SOPs followed across all departments.V. Complete user administration and access control of functions and reports based on roles in various applications. Major accomplishments:i. Solely worked on design and implementation of departments’ technical documents that put together 100+ technical processes under one umbrella.ii. Created dashboards & efficient reports identifying workload and productivity easing work of 70+ users.iii. Automated 20+ reports that resulted in reduction of efforts by a whopping 30% man hours.iv. Built the Service desk requests’ process from scratch covering review, escalation and resolution.v. Chairman of the access control review sessions held every quarter of the year.