My major job responsibilities as database administrator include:
Development and Administration in Microsoft SQL Server 2008/2008 R2, 2012 and SQL Server 2014.
Good expertise in creating stored procedures, triggers, indexes,functions,cursors and other, scripts to support application development.
Import data in the system from different platforms.
Optimize database systems for performance efficiency.
Perform data base back-ups for all servers.
Ensure data quality and integrity in databases.
Identify any issues related to database performance and provide corrective measures.
Taking ownership of data related problems and provide their solutions.
Assist other teams in database design and data model decisions.
Carrying out database tuning and maintenance activities to ensure optimal performance.
Enforcing high database standards..
Query optimization.
Well knowledge about OLTP and Olap systems.

Senior Database developer – June 2016 till to date
MTBC (Pvt.) Ltd – www.mtbc.com
Rawalpindi
Responsibilities:
My major job responsibilities as senior database developer include:
Development and Administration in Microsoft SQL Server 2008/2008 R2, 2012 and SQL Server 2014.
Good expertise in creating stored procedures, triggers, indexes, functions, cursors and other, scripts to support application development.
Import data in the system from different platforms.
Optimize database systems for performance efficiency.
Perform data base back-ups for all servers.
Monitor jobs and replication on different sites as well as create new jobs as per new automation requirements.
Ensure data quality and integrity in databases.
Identify any issues related to database performance and provide corrective measures.
Taking ownership of data related problems and provide their solutions.
Assist other teams in database design and data model decisions.
Carrying out database tuning and maintenance activities to ensure optimal performance.
Enforcing high database standards.
Query optimization.
Successfully complete two big projects (web based invoicing and MTBC forecasting) with web team to automate finance reporting.
Provide guidance to junior team members when they needed.
Look after all database servers on all sites and monitor space alerts.
Well knowledge about OLTP and Olap systems.