Sign In
 [New User? Sign Up]
Mobile Version

SQL Server DBA (L1, L2, L3)

Kolkata, WB
Job Code:
  • Teaching
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

JOB DESCRIPTIONResponsible for physical database architecture and design, development, performance tuning, implementation, and support of the applications from a database perspectiveDefine and implement database, SQL standards and best practicesExecute all changes of db schema and maintain controlled development database environmentWork closely with application developers to test, configure, and optimize servers based on application demands; work with large volume, heavy load databasesConduct T-SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issuesCreate database scripts for all objects and integrate them with source controlHandle database object deployment to Integration, QA, UAT, and ProductionGood in reading and writing complex stored procedures, views, and triggersExperience in writing technical documentationGood in T-SQL scripts-Has credible experience in supporting production databasesBackup / Recovery, Data Replication, Distributed databases, Data Migration-worked on replication , cluster , mirroring and log shippingExperience in resolving blocking and deadlock issuesTune the databases-Write Windows Scripts, Planning, Job scheduling, and MonitoringMonitoring & Troubleshooting Blocking and DeadlockExecution of DBCC Commands (OPENTRAN (DBName), SQLPERF (LOGSPACE) , checkdb , shrinkfile , shrinkdatabase , indexdefrag , dbreindex, etc)Create and update maintenance plan for database maintenance-Monitor and understand the error log and event log Monitor the disk space on the server and take action accordingly (Including Data files, Transaction log files, tempdb database)Understand how connectivity is established between servers (Remote Access)Connecting remote server using QA, EM, and TS)-Managing DB backups. Restoring database from Full/Differential/T-log backupProvide day to day support of high OLTP HA of SQL Server (2000, 2005,2008) databases-Identify root causes of production problems and work with developers to circumvent and resolve such problemsProvide technical services to monitor and maintain environments, (the SQL Server production, development, and test databases) running on firm's strategic platforms including periodic software upgrades and migration of the SQL Server productsDocument operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization-Create and maintain Windows and SQL scripts to automate tasks such as setting up and refreshing DEV, QA, and Production database environmentsLog, schedule and track all changes using change management system toolsResponsible for all corrections to the database infrastructure and for repairs to the system or database
Degree: M.Com. (Commerce) | M.Pharm. (Pharmacy) | M.Sc. (Science) | MA (Arts) | MBA/ PGDM | MCA/ PGDCA

Additional Degree: BA (Arts) | B.Com. (Commerce) | B.Pharm. (Pharmacy) | B.Plan. (Planning) | B.Sc. (Science) | BBA/ BBM/ BBS | BCA (Computer Application) | Diploma-Other Diploma | B.Ed. (Education) | BHM (Hotel Management)

Experience: 2-4


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


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