Qualification: Graduate in Computer Science
Location: Chennai
Skills required:
- 5 years of Database Administration experience supporting data driven applications in hosted environments
- Advanced knowledge of MSSQL (2008, 2012, 2014) including SQL Server Reporting Services (SSRS), MySQL and Derby Database systems required
- Should be able to install the database software, setup databases from logical structures, and monitor and maintain the databases
- Must have experience in SQL performance tuning, query optimization, SQL Profiler, reading query plans and database security
- Must be proficient in developing procedures, functions and triggers, creating indexes and constraints, setting up backup and restore mechanisms, tuning the databases and capacity planning
- Knowledge of SQL Server high availability solutions such as Always On/Database Mirroring and administering databases in a network configuration
- Experience in Windows 2008 and 2012 Servers, MS Access, Excel, Java Development Environment, .Net Environment, MSSQL tools, VB Scripting, SSIS essential. Familiarity with Oracle, Powershell, VBScript, .NET, Java programming is a plus
- Data transfer technologies is desirable. SQL Server MCP/MCDBA certification is desirable but not required