We are seeking an experienced SQL database administrator (DBA) to work in our IT department. Key

responsibilities will include monitoring, updating, and fine-tuning the performance of existing technologies,

as well as recommending and implementing new technologies when they become available. The ideal

candidate is a self-starter with excellent communication skills who can work in a dynamic environment

with minimal supervision.

Responsibilities

  • Provide all levels of database support during normal business hours and off-hours
  • Monitor, update, and fine-tune the performance of database technologies.
  • Troubleshoot and resolve database issues and problems
  • Strong T-SQL scripting abilities and understanding of complex stored procedures, views, data aggregation and manipulation through table joins and queries, database design, normalization and de-normalization techniques, database analytical functions, In-Line queries, and Sub-Queries.
  • Manage database backups, restores and recoveries, when needed.
  • Recommend and deploy necessary solutions upon receiving approval from management
  • Demonstrated experience in data extraction and manipulation, ETL techniques required using
  • Visual Studio 2013 and above
  • Knowledge of SQL and data warehousing concepts.
  • Strong knowledge of TSQL, PL/SQL for SQL Server and Oracle
  • Performance tuning experience
  • Understanding of data integration issues (validating and cleaning) familiar with complex data structures.
  • Requires strong analytical, conceptual, and problem-solving abilities.
  • Possesses strong oral and written communications skills, clearly and accurately communicating complex and or technical information to both technical and non-technical audiences.
  • Ability to manage multiple priorities and assess and adjust quickly to changing priorities.
  • Ability to work in a team environment.

Qualifications

  • 6+ years of professional Database Administration experience and a Bachelor of Arts/Science or equivalent degree in Computer Science or related area of study. Without a degree, four additional years of relevant professional experience (9+ years in total)
  • Recent experience in MS SQL Server versions 2017/2019
  • Expertise with SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Services (SSAS)
  • Experience in Performance Tuning and Optimisation (PTO), using native monitoring and troubleshooting tools
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server 2017/2019
  • Experience with Virtualisation and Always On availability
  • Experience in implementing operational automation using scripts
  • Knowledge of indexes, index management, and statistics
  • SQL and relational DBMS knowledge, including data modelling and ERD
  • Well disciplined in work-in production environment
More from Emorphis Technologies
DevOps Engineer
Emorphis Technologies 12 days ago
Dot Net Lead
Emorphis Technologies 2 days ago
iOS Developer
Emorphis Technologies 13 days ago

Database Administrator

Apply On Company Site
Back to search page
;