Senior SQL Server Database Administrator

#jobbjustnu


Job Title: Senior MS Sql Server DBA- L3
Location: Stockholm or Malmo, Sweden
Experience: 8+ years

Job Description:
Provide database administration service.
Following standard team processes and defines new ones with corrections.
The individuals will be expected to be fully-functional DBA’s who can perform traditional DBA activities independently and guide team members too.
Able to provide escalation support whenever required.
From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call supports on a rotational basis. Pre-installation Tasks
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
Database Setup in 32 and 64 architecture
Database Clean-up / Removal
DB Cloning
Design Database, RAID configuration & Capacity Planning for Large Databases
Setup and implement Cluster Setup in multiple nodes environment
Implement High Availability configuration like replication and log shipping
Start up and shutdown of Database instances
Maintaining Database replication / standby / clusters
Job scheduling
Verify all Instances and dependent services are running
Look for any new error log entries
Session / Process Monitoring
Query or Transaction monitoring
Lock and Deadlock monitoring
Activity / Transaction Log monitoring
Job monitoring and Purging Job history
Replication / Log shipping monitoring
Monitor Space usage /growth of Database objects
Verify free space in file groups / databases
Monitor transaction log growth and truncate schedule
Reorganization of DB to remove fragmentation
Update Stats for hot objects
Purging of DB logs and trace files
Schedule maintenance plans for maintenance like DBCC REINDEX / INDEX DEFRAG
Creation and schedule maintenance plans and jobs for update stats , defragmentation, checking database integrity
Verify that Server has enough resources for acceptable performance
Periodic Report Generation on Database Health
Identify bad growth projections
Identify space-bound objects
Review contention for CPU, memory, network, and disk resources
Generating statistics
Look for objects that break rules.
Ensure that all indexes use an index table space
Ensure that all tables have unique primary keys.
Look for harmful growth rates
Examine tuning opportunities.
Look for I/O Contention
Verify that the database backup was successful
Backup execution and monitoring
Define Backup policy and retention policy for complete/differential/transaction backup
Conduct Backup , restoration drills for backup verification in different scenarios
Database Connectivity issues
Slow response
Operations timed out
Dead locks
Database Hangs
Database incident and error resolution
Transaction Log Backup Stuck for Space
Database incident and error resolution
Vendor Management
System Performance Monitoring
Maintaining Environment details and change management
Windows Scripting for automations of DB related work
SSIS and SSRS
Implement ITIL processes & Maintain Transition Management Docket
Adherence to Change Management Process
Presales knowledge / experience is added advantage.
Implement ITIL processes & Create Transition Management Dockets
Presales knowledge / experience is added advantage.


Required Skills:


At least SQL DBA experience, 6+ 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
Knowledge of DTS and bcp and other data load tools across same and different RDBMS
Knowledge on database design and storage recommendation and NTFS file systems & capacity planning
Knowledge in making scripts for automations , writing procedures and functions
Knowledge of ITIL processes & Transition Management
Provide on-call support as and when required
Ability to handle pressure



Additional Qualification / Skills :


MCSE MSSQL Certification is added advantage.
Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on
In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014 Versions