Designing databases and ensuring their stability, reliability, and performance.
Design, write and modify SQL Server database to improve application processing from mainframe to web-based application, data transfer to internal databases, and the processing of the application data.
Data architecture, creation of MS SQL tables, views, triggers and other objects required for web application using MS SQL Server 2014, 2016 and 2017.
Design better T-SQL queries with experience in query optimization & performance tuning. Use SQL Profiler, Execution Plan, Performance Monitor, Indexes and DBCC Commands
Achieve high application performance by performing some system administration tasks like developing shell scripts that solved frequent application hangs.
Develop complex functions, scripts, stored procedures and triggers to support application development using T-SQL.
Responsible for guidelines and standards for DB usage, manageability and maintainability
Build and support database models using SQL Server to support web application
Construct and design documents and documentation to aid in maintenance and code reuse in accordance with team processes and standards.
Develop strong working relationships with managers and analysts.
Analyze data needs and independently develop logical and physical data models.
Coordinate the implementation of database application components.
Interact with key partners and internal users regarding timelines, technical issues, and infrastructure integration.
Create and maintain Change Data Capture to keep track of the history of data on each table in SQL Server.
Coordinate and participate in application testing and quality inspections.
Modifying databases according to requests from managers and performing tests to identify ways to solve database usage concerns and malfunctions.
Construct C#.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL data sources.
Using C#.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object to access SQL Server 2014/2016/2017 databases.
Create class diagrams, sequence diagrams, implementing design patterns and write software architecture documents.
Schedule Ctrl M Jobs to run the SQL Stored procedures based on global parameters from COBOL Stored procedures.