Job ID: CO-57305 (910390629)
Local/Remote SQL Server DBA with SSRS, SQL, SSIS, ORM, Optimization, HA, Data Analysis and audit experience
Location: Denver CO (OIT)
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
Covendis Standard Resume Template.docx