Duties and Responsibility
|Ÿ Manage SQL Server databasesŸ Configure and maintain database servers and processesŸ Ability to design and implement HA solutions.Ÿ Ability to support migrations from other DBMS solutions. (mainly SYBASE)Ÿ Ability to work with developers to configure, tune and implement MS SQL as an imbedded database in packaged solutions like SharePointŸ Design standards for monitoring, backup, recovery and alerting.Ÿ Ability to design scripts to automate key database management functions.Ÿ Work with application developers and system integrators to review data models, database objects, stored procedures and partitioning strategies.Ÿ Monitor system’s health and performanceŸ Ensure high levels of performance, availability, sustainability and securityŸ Analyse, solve, and correct issues in real timeŸ Provide suggestions for solutionsŸ Refine and automate regular processes, track issues, and document changesŸ Assist developers with query tuning and schema refinementŸ Provide 24×7 support for critical production systemsŸ Perform scheduled maintenance and support release deployment activities after hoursŸ Tune queries, write Stored Procedures, perform indexing, and other database elements.Ÿ Database design, coding, testing, debugging, and installing.Ÿ Follow software development methodologies.Ÿ Working through business requirements and designs with IT collaborates.|
|Ÿ Ensure all contact and interaction is of the highest standard (written/phone/face to face)Ÿ Communicate clearly and appropriately to all stakeholders|
Technical capabilities:Experience with Stored Procedures, Triggers, etc.Experience with data and batch loading processes.Strong Data Modeling and Database design skills.Experience with Data warehouses and transnational databases.Proficiency with optimization techniques.Thorough understanding of software development life cycle.Experience administering a large enterprise database environment.Proficiency in design, administration, implementation, upgrades, monitoring and database.