The Senior Database Administrator (with a specialization in MS-SQL) will ensure the availability, reliability, security, performance and stable Operation of the Database Systems across the various computing environments. This includes maintaining, supporting and optimizing key functional areas, including but not limited to, Server Infrastructure and operating system, database Clustering, while refining and automating regular processes, tracking issues, and document changes. This role will work in a dynamic 24/7 online environment , and will be required to work on a fixed Shift rotation schedule with On call duties which may include weekends and holidays.
GENERAL DUTIES & RESPONSIBILITIES
Responsible for SQL Server, SSRS, SSIS, SSAS instances
Implements, optimizes and maintains SQL Server high availability technologies such as Failover Cluster instances, Database mirroring, Availability Groups
Perform performance tuning in MSSQL Server (DMVs, DMFs, Catalog views, DTA, SQL Profiler, Extended Events, etc.)
Administers security and disaster recovery of databases, including back up, restore, recovery, auditing, health checks and disaster recovery design and planning to meet business requirements
Performs SQL Server installations, configurations, patch updates, monitoring and version upgrades
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end with root cause analysis and focus in improvements to current operations and processes
Researches and tests new database technologies to ensure the database platform is optimized and utilizes new features that may be beneficial to business operations
Communicates effectively with various engineering and development teams making recommendations and working closely with them to optimize the platform
Works towards automation and gaining efficiencies and daily operational tasks
Handles deployment of database scripts efficiently through different environments and provides feedback to ensure deployments are reliable and optimized
Provides quick recovery solutions to ensure business continuity
Identifies inefficient database processes and provides feedback
Efficient Capacity planning and addresses hardware needs as well as documenting of database environments
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
10 years or more of experience administering SQL Server 2008/2008R2/2012/2014/2016
Expertise in architecting database solutions
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Expertise in Database capacity planning
Expertise in SQL Programming and execution plans
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Experience working with Windows server, including Active Directory
Excellent written and verbal communication
Strong analytical and problem solving abilities
Ability to work in a dynamic multi cultural environment
Ability to multi-task and context-switch effectively between different activities and teams
Ability to work independently with minimum supervision
Desirable Knowledge and Skills
Familiarity with Amazon AWS/GCP/Oracle (or any other Cloud provider)
Experience with database performance monitoring software
Experience with powershell and Ansible Scripting
Familiar with Automation and other Provisioning/Configuration Management Tools (i.e. terraform)
Worked in a CI/CD environment and is able to automate database deployments and database configuration changes as part of the delivery lifecycle.
firstname.lastname@example.org:~# Helloworld.rs koristi kolačiće kako bi ti pružao najbolje korisničko iskustvo. Nastavkom korišćenja
sajta smatraćemo da imamo saglasnost sa korišćenjem kolačića. Više o kolačićima možeš pročitati ovde.