Transform and load of data from remote domain to local DB (ETL).
Transform and load of data from multiple sources to local DB (ETL).
Load multiple files using SSIS and BI packages.
SSRS for reporting purposes.
Data analysis on Medical billing.
Data Archiving.
Triggers and SP writing.
Optimization of queries and SP.
Replication between different servers (Merge Replication)
Database Jobs for local and remote locations.
Administration for DB servers.
Being DBA my role include SP optimization to reduce the timeouts. Working on Tier 1 Dashboard with the other team for developing required queries.
Being Lead Database Project,my resposibilities include Data Migrations, Manual ETL from .CSV, SQL Backup Files and remote location Database servers through SQL Scripts and jobs. Server managment is also part of my job resopsibilities. Meeting with managment and other teams to get their requiremnts and produce SPs according to their requiremnt. Team managment and task/projects distribution among team member and complete within provided time.
Being a Sr. Database Developer my role to work on Data Transition from different platforms to our existing environment.
We move the data from .CSV or received in the form of DB backup.