My responsibilities are given below:-Business development and project huntingCommunication with clients to get clear requirementsDesign database for an application that meets business and performance requirements with an Entity Relationship (ER) DiagramCoordinate and work with other technical staff to develop relational databasesDiagnose and resolve database access and performance issuesPlan and coordinate data migrations between systemsDevelop, implement, and maintain change control and testing processes for modifications to databasesPerform work of high difficulty in writing, designing, deploying, modifying, tuning and debugging database indexes, queries, stored procedures, views, user-defined functions and other database entitiesProvide database related technical expertize to application development teamDevelopment and maintenance of Data WarehouseProvide support to QA department during both internal and external product testingUse T-SQL and SQL Server Integration Services to develop enterprise-level ETL processes that include process logging, data validation and data integrity checksDevelop SSIS packages to import data from different sources like databases, CSV, Text, Excel filesIncorporate appropriate tools, technologies, techniques and design patterns to create maintainable, scalable, high-performance database solutionsAutomate complex processes with SQL Agent jobsDesign, develop and troubleshoot permissions schema using advanced security concepts such as proxies and impersonationIdentify complex data patterns and inconsistencies through data analysis and data miningCollaborate with project managers and business analysts to develop solutions that meet client business requirementsManage code in a source control systemConduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development effortsSetup and maintain technical documentation and standards

Business Intelligence (BI) through SQL. My duties involve • Installation of SQL Server Software and Related Products.• Establish and Maintain Backups on Local and Remote Media.• Performance Monitoring Using Performance Monitor, DBCC Commands, Maintenance Plans• Use of Third Party Tools.• Analyze Applications Performance Using Query-Execution Plans• Index Utilization And Procedure Cache Utilization.• Performance tuning.• In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL and Stored Procedures. • Plan Growth and Changes (Capacity Planning) with Team.• Write Database Procedures, Functions and Triggers.• Tune Database Queries.• Optimization of SQL Server, Stored Procedures and SQL Scripts.• Monitor Application Related Jobs and Data Replication Activities.

My duties involve identification and understanding of three core dimensions of litigation system in Pakistan.After identification, ICT based interventions have to be installed in litigation system so that ever-growing burden on litigation system can be coped up.