Sign In
 [New User? Sign Up]
Mobile Version

Database SQL Server Sr Principal Infrastructure

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

Job Details

Job descriptionEssential Duties and Responsibilities include the following. Other duties may be assigned-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.Be a mentor for L1 and L2 team members and provide required training to the team.Skills Should 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 11gR2Oracle Streams deployment and administration is an added advantage.High availabilitysetup and administration.
Degree: MCA/ PGDCA | ME/ M.Tech./ MS (Engg/ Sciences)

Additional Degree: BE/ B.Tech (Engineering) | BCA (Computer Application)

Experience: 7-10


Data Warehousing | Database Administration (DBA) | Software Engineer
Applying for this job will take you to an external site


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