10 Apr
SQL Database Administrator
Vacancy expired!
- Perform maintenance and upgrades of databases, providing recommendations of latest technology in Microsoft SQL Server
- Monitor and optimize the performance of all database production servers
- Backup and restore databases
- Manage data replication and automate repeating database tasks
- Write and troubleshoot SQL code and design stored procs, functions, tables, views, triggers, indexes and constraints
- Control and monitor user access and maintain system security
- Design and develop database solutions for company-wide projects
- 3 years’ experience as a SQL database administrator or related roles
- 3 years’ experience as a T-SQL programmer on Microsoft SQL Server 2012 – 2019
- Experience in design, development, and troubleshooting of ETL/CRUD transactions
- Experience in Performance Tuning and Optimization (PTO), using monitoring and troubleshooting tools
- Experience with backup and restore
- Experience of indexes, index management, and statistics
- Experience in troubleshooting and resolving database problems
- Experience in implementing operational automation using scripts
- Very good communication and documentation skills
- Bachelor’s degree in computer related field
- Experience with implementation of Enterprise Data Warehouse is plus
- Experience of programming using 3rd party systems, electronic data interchange of HIPAA (e.g., ETL of ANSI x12 834, 837) and Health Information Exchange (e.g. CCDA) systems is a plus
- Knowledge of SQL Server Integration Service (SSIS) with VB.NET (or C#.NET) is a plus
- Certification is a plus: MCSA, MCTS, MCITP
Vacancy expired!