established in 2008 and situated in central london our client specialises in the provision of marketing services to international clients in the online gaming ecommerce industry they supply high level ecommerce and online marketing services and through an affiliated partner are also able to provide the facilities to support and supplement these operations which include administration multilanguage customer support payment processing fraud management it support service delivery as well as database and web development from a single employee in 2008 they now number and have further plans to grow organically in 2013 role reports to service delivery support manager role purpose responsible for the management and support performance integrity and security of all databases within the organisation implement design improve processes relating to the administration of databases in order to ensure that they function correctly ensure high availability of data to business develop tsql scripting and code in order to optimise and improve backend business processes key responsibilities administer sql server databases ie backups integrity checks performance monitoring optimise databases ensure databases run at optimum levels check locks on databases correct where necessary or propose changes where relevant tsql scripting and development on both new and existing business functions job maintenance scheduling ensure jobs run successfully and troubleshoot job failures replication administration set up replication between databases maintain replication backup monitoring ensure backups run on regular basis ensure integrity of backups optimisation of databases indexes schema add indexes recommend ways that databases can be optimised for increased performance security maintenance of databases ensure databases arent vulnerable to any security risks breaches query stored procedure and script optimisation maintenance of sql environment as per best practice standards education experience alevels mcdba andor mcts sql administration 3 years experience in sql as dba 3 years in it sql sql sql 2008 replication dtsssis packages reporting services indexingperformance monitoring database tuning backup and recovery database security sql job creation and scheduling understanding of stored procedures and triggers knowledge of reporting and query tools and practices windows server 2008 strong experience and knowledge of tsql scripting and must have sql migration experience ssas advantageous skills enthusiastic team player analytical problem solving good verbal listening written communication attention to detail high level of accuracy time management common sense confidentiality deadline driven process driven dynamic confident independent worker must be willing to work overtime where necessary other oncall every second week this job was originally posted as wwwcwjobscoukjobseekingsqldbajob