Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Worked on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Troubleshoot performance problems, fine-tuning of databases and index Analysis.
- Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
- Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
- 24 X 7 Production Database on Call Support
- Responsible for the operation and administration of IIS web servers across Engineering, QA, Staging, Demo, and Production environments
- Responsible for the operation and administration of Application Deployment technologies for all environments
- Responsible for the operation and administration of Web Content Management Systems
- Maintains and monitors all IIS applications to ensure performance and availability.
- Performs troubleshooting and responses to all IIS related application issues.
Job Requirements
- FLUENT ENGLISH IS A MUST
- 4+ years of experience in Database Administration and Developer for large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
- Databases: MS SQL Server 2012, 2008, MS SQL Server 2005
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
- Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
- Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
- Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
- Expertise in T-SQL writing stored procedures, triggers and functions.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- DBA: database administration of MS SQL Server 2012,2008, 2005
- Operating System: Windows 2008/2003 Advanced Server, NT
- Other Software: Windows 2008/2003 Advanced Server, NT & Windows 9x
- Tools: Backup Utility, SQL LiteSpeed, Visio
- Working experience with IIS - websites, virtual directories, application Pools, etc.
- Familiar with basic IIS security
