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
- Takes the load off of the Application 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
- Where is the best place for the SQL processes to execute
- Executes on the Database server, as an objectYou
- This will execute SQL, which is written in the stored procedure
- Tables
- Indexing
- Attribute (Field) creation and mapping
- Data Type setting
- Table Views
- Subset the data in the main tables
- For focused processing of data
- Subset the data in the main tables
- 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
- Outside SQL hitting the db
- Object Role model
- 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
- High Availability Setup
- 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