Tag Archives: Sharepoint

Provided technical support for back-end servers

Providing on-call technical support and routine maintenance and for their server environment. Acting in a DBA role for their Sql Server and providing support for the development team by redesigning quires and stored procedures for performance improvements. Redesigned data import stored procedures and reduced processing time from 48 hours to 14 minutes.

  • Investigated and developed key performance improvements.
  • Carried out a capacity planning analysis and recommendation for site upgrades.
  • Defined DBA role.
  • Developed a work plan and instructions for database versioning by the development team.
  • Constructed a number of DBA scripts to maintain database performance.
  • Investigated and made recommendations for re-architecting their main product into separate customer databases.
  • Defined a Server Upgrade Proposal and carried out the installation
  • Defined and carried out the migration of their product to Sql Server 2012
  • Redefined database architecture to separate customer data into separate databases.
  • Defined a Backup Strategy that included offsite to Amazon Glacier Storage.
  • Defined a process for database versioning, source control and automated builds and developed working procedures for development team.