19 Jan
Database Administrator
Vacancy expired!
Application DBAMadison, WILong Term Assignment
- 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.
Vacancy expired!