What are the responsibilities and job description for the SQL Database Administrator position at DBI Staffing?
Onsite 5 days in Oyster Bay, NY Must be US Citizen or GC Holder.
- Maintains 115 SQL Server Databases associated to vendor-based applications
- Manages 14 instances among the four Server Clusters - MS SQL 2008R2, 2014, 2019 and 2022.
- Installs new databases on the SQL Server instances.
- Write SQL scripts for each SQL instance to automate the daily and weekly backups.
- Write SQL scripts to manage database index and disk fragmentation.
- Build new Server Clusters and migrate databases from old to new cluster.
- Monitor SQL activity logs across all SQL instances to assure proper database performance levels.
- Verifies load balancing for each of the four Server Clusters.
- Install and Configure SQL Server Reporting (SSRS) for creation and maintenance of Animal Management Shelter Reports.
- Create and maintain the Microsoft SSRS reports.
- Maximo Database subject matter expert.
- Create and maintain Maximo BIRT reports.
Salary : $45 - $55
