Description
Job Title: MS SQL Administrator
Location: Gdansk, Poland
Job Type: Long Term contract
Responsibilities:
- Provide database administration service.
- From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call supports on a rotational basis
- Pre-installation Tasks
- Installing SQL Server and Patch Mgmt
- Installing & Maintaining DB Tools
- Uninstallation
- Database Upgrade
- Database Migration
- Database Patch Installation
- Physical Database Design and Implementation
- Design Database, RAID configuration & Capacity Planning for Large Databases
- Setup and implement Cluster Setup in multiple nodes environment
- Generating statistics
- Implement ITIL processes & Maintain Transition Management Docket
Requirements:
- At least SQL DBA experience, 4+ years required
- Thorough Knowledge of Windows Operating System, Networks and Active Directory
- Knowledge of creating and maintaining standby/replication setup
- Strong in SQL fundamentals
- Knowledge of using Enterprise Manager and Query Analyzed for basic administration
- Knowledge of configuring and setting up maintenance activities for DB
- Knowledge of SQL statements tuning and DB Tuning
- Knowledge on DB structures (filegroups, Indexes - clustered/non clustered/fillfactor)
- Knowledge on Memory structures (configurable parameters)
- Knowledge of complete/differential/transactional backups and their recovery scenarios
- Knowledge on High Availability configuration like replication and log shipping, cluster setup