Our client is currently seeking a SQL DEVELOPER ADMINISTRATOR.
Contract or PermSummary:
The role of Database Developer/Administrator is to manage and support all enterprise applications and to develop, test and implement integrations to third party applications or services. This position is also responsible for developing scripts used for updating data, migrating data, creating views, triggers, stored procedures and other database objects in order to efficiently manage university databases.Responsibilities:
Manages and supports enterprise administrative systems and databases including but not limited to Jenzabar EX, Jenzabar Internet Campus Solution (JICS), PowerFAIDS, and other applications that may integrate with the administrative and academic systems.
Plans, installs and applies upgrades and patches to Enterprise applications and SQL Server database management software.
- Develops, supports, and troubleshoots integration solutions between enterprise administrative systems and third party applications or services including the development of APIs and web services to facilitate the automated and seamless integration of data.
Reviews issues to identify, diagnose and resolve database and application related problems; interacts with third party vendors to help troubleshoot and resolve issues and attain knowledge needed to develop efficient integrations.
Reviews new features and change requests related to enterprise administrative systems and integrations and advises technical staff on issues or corrective measures relevant to reporting, usage, and performance.
Monitors performance of existing database systems and takes appropriate action to ensure availability, integrity, security and dependability.
In conjunction with Infrastructure Support, performs and maintains backups, develops and maintains recovery procedures related to enterprise databases and monitors error logs to ensure optimal operation or to restore operation after system failure.
Creates and makes use of defined change management strategies to mitigate risk and manage change.Education and/or Experience:
Bachelors degree from four-year college or university; or two to five years related experience; or equivalent combination of education and experience
Two or more years Database Administrator supporting Microsoft SQL server 2008, 2012
Working knowledge of.NET programming languages including C#,web tools, scripting languages (including T-SQL & Power Shell), database design, and application/systems integration development (API)Computer/Technical Skills:
Two years experience in database administration with MS SQL Server 2008/2012
Prior experience in data extraction, loading, and manipulation
Scripting experience with Transact SQL and PowerShell,
Windows Server 2003/2008 experience
.NET development experience using C#
Advanced skills with Microsoft Office SuiteOther Qualifications:
Experience understanding relational databases in a networked client/server environment
Experience with reporting tools and data integration tools preferred
Experience with applications such as Jenzabar EX, Sybase InfoMaker Reporting software, PowerFAIDS, and Active Directory highly preferred