• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Database Manager/Administrator IV

In United States

Save this job

Database Manager/Administrator IV   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Database Manager/Administrator IV

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Denver, CO United States

JOB DESCRIPTION:

Requisition ID 57305 Requisition Name Database Manager/Administrator IV Customer OIT Address Position Location Remote Address 601 E. 18th Avenue, Suite 250 Denver, Colorado 80203 Comment Candidate must be local.   Candidate Must Be Local     Additional Location Details (City, State) :     Estimated Duration 07/05/2022 - 02/10/2023 Description 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 Client Skill Matrix     Qualifications   Type   Category   Qualification           Candidate Years Of Experience       Skills   Database   Microsoft SQL Server            

Position Details

POSTED:

Sep 24, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16560000291571488

LOCATION:

United States

CITY:

Denver, CO

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Database Manager/Administrator IV    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Requisition ID 57305 Requisition Name Database Manager/Administrator IV Customer OIT Address Position Location Remote Address 601 E. 18th Avenue, Suite 250 Denver, Colorado 80203 Comment Candidate must be local.   Candidate Must Be Local     Additional Location Details (City, State) :     Estimated Duration 07/05/2022 - 02/10/2023 Description 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 Client Skill Matrix     Qualifications   Type   Category   Qualification           Candidate Years Of Experience       Skills   Database   Microsoft SQL Server            


Please wait..!!