Job Details

Position: SQL Server DBA (Ref: 11058)
Location: Denver, CO 80246 USA
Duration: 1 Years 0 Months 8 Days - Contract
Openings: 1
Deadline: 06/30/2022
Pay Rate:Login

Description:

We are seeking a SQL Server DBA to maintain data storage and access by evaluating, designing, and implementing company database[s]. Candidate will maintain 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 object
- Takes the load off 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

Required / Desired Skills

  • Microsoft SQL Server (Required 3 Years)
  • SQL (Required 3 Years)

copyright @ www.ProfessionalTechIntegration.com.2011 All rights reserved
Professional Tech Integration, Inc., Computers  Sys Designers & Consult, Norcross, GA