Database Administrator

Database Administrator

16 Jan 2024
Wisconsin, Madison, 53701 Madison USA

Database Administrator

Vacancy expired!

Application DBA
Madison, WI
Long 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.

Related jobs

Job Details

  • ID
    JC8249115
  • State
  • City
  • Job type
    Contract
  • Salary
    Depends on Experience
  • Hiring Company
    Encore Consulting Services
  • Date
    2020-12-29
  • Deadline
    2021-02-27
  • Category

Jocancy Online Job Portal by jobSearchi.