Development of high quality database solutions
Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
Research required data
Build appropriate and useful reporting deliverables
Analyze existing SQL queries for performance improvements
Suggest new queries
Develop procedures and scripts for data migration
Provide timely scheduled management reporting
Investigate exceptions with regard to asset movements
Maintain and back up databases regularly
Perform SQL database indexing procedures as required to handle heavy traffic loads
Development, optimize, and implement stored procedures
Use database analytical tools to analyze performance and generate reports
Set Up Replications, Adding Tables into Replications and Manage replication issues during DDL changes over data in Production\development servers and Conflicts Resolution during Replication Process.
Convert DTS packages used to perform import of customer account and financial data into corporate databases to SSIS packages.
Perform all aspect of database administration, including backup, recovery, and replication for SQL server 2019/2014/2012/2008 R2.
Loading...
Experience
CareCloud
Dec 2022 – Present
Rawalpindi Pakistan
Database Developer
Creating and Manipulating Efficient and High Quality Databases in SQL. Database Administration, Tunning, Query Optimization, Stored Procedures, Views, Triggers, SSRS and Replications.
