DOE Azure .NET Developer (698609) Apply
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
