Sr. SQL Server Admin CO OIT

28 Jun 2024

Vacancy expired!

Job Id: 57305 Title: Sr. SQL Server Admin Location: REMOTE & IP address ping in Colorado - 601 E. 18th Avenue, Suite 250 Denver, Colorado 80203 Duration: 12 Months 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

  • ID: #43658632
  • State: Colorado Denver 80201 Denver USA
  • City: Denver
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-06-28
  • Deadline: 2022-08-26
  • Category: Et cetera