Position: SQL DBA
Term: 6 Months
Location: New Brunswick
Provide technical administrative support for Microsoft SQL database environments including management of SQL cluster infrastructure as well as stand alone and Microsoft database servers.
Responsibilities:
Database troubleshooting and consulting with users, developers and support staff;
Investigating Database response time issues;
Investigating jobs and/or scripts over-utilizing system resources;
Investigating long running jobs and/or scripts;
Contacting Database vendor support (e.g., Microsoft);
Applying, implementing and migrating Database changes;
Restoring, recovering and backing up the Database when necessary;
Planning and preparing the change implementation;
Proactively identifying Database performance issues and implementing the solution;
Modifying Database procedures and/or guidelines;
Installing, configuring and optimizing Database software when necessary;
Implementing changes to accommodate new releases of Database software;
Recommending and implementing Database software fixes and patches;
Assisting with application installations, applications upgrade and patch management when necessary;
Performing regular Database maintenance;
Providing support for failed Database utilities, jobs and/or scripts (e.g. Backups, re-orgs, exports); Assisting with Database security and integrity issues;
Assisting in developing a strategy for the Database backup and restore;
Developing and testing the scripts and/or streams for backups and restores;
Backing up, restoring and recovering the Database;
Mentoring and consulting with users and application developers;
Software installation and upgrade planning and installation;
Proactively monitoring the Database/on-line environments - performance; Planning, preparing and executing patch implementation procedures;
Administration activities including Lawson time entry, e-mails administration, Support Magic and change management;
Monitoring space usage; and
Preparing estimates to predict Database growth.
Contact: rmacdonald@gsa-search.com
