Sr. SQL DBA

Description & Requirements

: The Senior Database Administrator is responsible for setup, support & management of SQL Server Databases in production, test & development environments.

The candidate will be responsible for creation and administration of SQL Server 2012, 2014, 2016, 2017, 2019, and 2022 databases in standalone, mirrored, clustered, and AlwaysOn environments.

He/she must have substantial hands-on technical experience in addition to strong conceptual knowledge about SQL Server database and underlying architecture and fundamentals.

Duties and responsibilities are focused on database management and administration, including infrastructure strategy, design, deployment, monitoring and maintenance of database systems.

Essential Duties and Responsibilities:

- Implement industry best practices for consistent modularized installation and configuration for production and non-production environments, including self-service options to service teams using a DevOps mindset and principles.
- Identify cost saving opportunities surrounding compute, storage, and other cloud resources.
- Troubleshoot, track, and resolve complex database issues, identify recurring problems, and apply fixes.
- Collaborate with key stakeholders to gather requirements and engineer solutions that meets business needs.
- Install, configure, and document high availability and business continuity solutions as per business requirements.
- Implement sound backup and recovery policies and procedures using cloud based backup solutions.
- Monitor production database systems and proactively mitigate performance and configuration issues.
- Lead the database deployments, tech upgrades, and approved changes.

- May provide guidance, coaching, and training to other employees within job area.

Install SQL Server 2016, 2017, 2019, and 2022 databases

• Support SQL Server 2012, 2014 2016, 2017, 2019, and 2022 databases

• Write and optimize T-SQL

• Setup and support AWS RDS/Azure SQL instances

• Build and support database replication using mirroring, clustering, log shipping, and AlwaysOn

• Establish and maintain sound backup and recovery policies and procedures using SQL Server maintenance plans

• Adhere and improve "best practices" documentation

• Perform health checks and proactive monitoring

• Establishes and enforces all database standards and integrity

• Be online during normal working hours and provide occasional after hours 24x7 support.

• Implement and maintain database security (create and maintain users and roles, assign privileges).

• Effectively demonstrate on performance analysis, tuning & improvements of SQL Server database based application systems

• Install and support SQL Server Reporting Services

• Install and support SQL Services Integration Services

• Database security and hardening (TDE, encryption in transit, etc), knowledge of TLS a big plus

Minimum Requirements

- Bachelor's degree in relevant field of study and 5+ year...