Sign In
 [New User? Sign Up]
Mobile Version

Database SQL Server - Principal Infrastructure Engineer

Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Responsibilities include installation, configuration and migration of MS SQL Servers, 2008R2, 2012, 2014 and databases in clustered and non-clustered environments.Performing SQL Server service pack /hotfixes/CU on clustered and non-clustered environment.Implementing DR Process like Database Mirroring, Log shipping, Replication, Clustering and troubleshooting issues.Creating and maintaining ETL packages with SQL Server Integration Services (SSIS).Rebuilding/Re-organizing / Tuning and monitoring the indexes at regular intervals for better performance.Recovering the databases from backup in disasters and implementing Point-In-Time Recovery solutions. Also required implementation of SQL User, Logins, Roles and Authentication Modes, schemas as a part of Security Policies for various categories of users.Monitoring and maintaining databases using DBCC utilities and DB Consistency with DBCC Commands at regular intervals.Scheduling jobs using maintenance plan and manually in SQL Server2008, 2012.Fixing issues related to SQL Deadlocks, Blocking and analysis of scheduled job failures.Doing SQL Server Configuration and analyzing the SQL files using Disk, memory and space related issues, TempDB issue, Log file Issue.Documenting all Project related works and created a central repository for SQL DB Production Server. SkillsShould have knowledge of skills such as DBA-SQL, DBA-Oracle DBA, MSSSQL Server Skills.Should have experience in using SQL Server Profiler, PerfMon, activity monitor, database tuning advisor, SQL Server Agent, BIDS etc.Must possess good knowledge of Oracle server skills.Should have excellent communication and interpersonal skills.Should have strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views.Should have knowledge on SQL database appliance (ODA).Strong database and ASM administration experience on Oracle 11gR2
Additional Degree: BE/ B.Tech (Engineering) | BCA (Computer Application)

Experience: 5-8


Application Programming | Database Administration (DBA) | Quality Assurance/Testing | System Administration
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News