Database Administrator Position
The role involves installing, configuring and maintaining SQL database systems for optimal performance.
Maintenance includes monitoring database performance, troubleshooting issues and tuning for efficiency.
Security protocols and access controls must be implemented and maintained to ensure data integrity, security and availability through backups and disaster recovery planning.
Complex SQL queries are written and optimized for efficient data retrieval and manipulation.
Database configurations and indexes are tuned for improved query performance and response times.
Reporting databases and data warehouses are managed for business intelligence and analytics initiatives.
ETL processes are developed and maintained for transferring data from operational databases to reporting databases.
Automated reports are created and scheduled using SQL Server Reporting Services or similar tools.
PowerBI is utilized to create insightful and actionable reports.