Overview
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.
JOB QUALIFICATIONS
- 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.
- MCTS, MCITP, and/or MVP certifications a plus
