Database Manager

Position: Database Manager/Administrator IV (SQL Server - Senior Level)

Location: Denver, CO 80203 - Local Candidates

Duration: 8 Plus Months

Maintains data storage and access by evaluating, designing and implementing company database[s]. I Maintains Backups and Restores and space utilization, identifies data sources. Database Development Activities to include

All Object creation

Tables

Table Views

Functions

Stored procedures

Stored Procedure Development and Maintenance

This will execute SQL, which is written in the stored procedure

Executes on the Database server, as an objectYou

Takes the load off of the Application server

Removes the process of SQL Code being passed from server to server

Performance Reviews of embedded SQL within application logic

Where is the best place for the SQL processes to execute

Where does the logic live

If it lives here, makes it much easier for tracking down issues and slowness

· Tables

· Indexing

· Attribute (Field) creation and mapping

· Data Type setting

· Table Views

· Subset the data in the main tables

· For focused processing of data

· Functions

· Triggers

· Object Packages (EX: SSIS)

· Repeatable processing

· ORM Model

· Object Role model

· Outside SQL hitting the db

· Parsing is an issue especially when the bind variables are wrong or missing

· Object synching across all environments

· Optimization Tasks

· Database optimization

· Query optimization

Working with large databases/datasets

· Index maintenance

· Troubleshooting

· Transaction locks

· Process blocks

· Deadlocks

· Replication

· High Availability Setup

· Always On Availability

· SSRS (Reporting Service)

· Maintenance and synchronization of data

· Performance Tuning

· Active execution and monitoring of database performance, regarding query execution and throughput

· Real Time changes to running queries for optimal performance

· Architecture/Design

· Design of the database structure and systems.

· Analyze the needs of the business and produce the data structure to meet these needs

· Data analysis

· Determining effective data flow throughout the system

· Designing the data infrastructure to effectively store the data for access.

· From both internal and external sources

· Regular audits of database structure and logs to maintain quality

Job Type: Contract

Salary: $60.00 - $70.00 per hour

Schedule:

• 8 hour shift

Work Location: Multiple Locations

Speak with the employer
91 9695516162