Job Description
Note: Vacancy for Night Shift
We are looking for an experienced, dynamic, hands-on and detailed Database Administrator to join our application development team. The ideal candidate must be energetic, quick, self-motivated, results oriented, flexible and independent with insightful judgment.
Job Specification
Strong experience in Database Administration in SQL Server (2005 and 2008)
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Experience in implementing operational automation.
Strong knowledge of indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools
SQL development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures.
SQL Database Operational support to tech users.
Knowledge and Experience of Data warehousing.
Knowledge and experience of Oracle Database, Programming and Different Reporting Tools.
ASP.NET, .Net, C/C++, ASP, PHP / MySQL, SQL Server, MySQL, .Net APIs, Visual C++, HTML, J2EE, PHP / MySQL, Programming LanguagesPHP, ASP.net, SQL, Flex, ASP, OWLToolsNDependDatabasesMySQL, OracleInterface Protocols & StandardsJ2EEOperating SystemsWindows