Senior SQL Database Administrator in Work From Home by Bluegreen Vacations

Date Posted: 6/11/2021

Job Snapshot

Job Description

Purpose:
The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The successful candidate will be responsible for the development and sustainment of SQL Server environments (DEV, QA, UAT and PROD), ensuring its operational readiness (security, health, and performance), performance tuning and data modeling in support of multiple development teams and 3rd party vendor products. The environments support an enterprise application suite of OLTP and OLAP solutions. The individual must be capable of working independently and collaboratively with the ability to quickly understand complex data solutions and schema. Experience with all supported versions of SQL Server is required.
The DBA will isolate and resolve complex software problems involving the application, SQL, operating system, the communications infrastructure, the database storage or any combination thereof.  Collaborate with other IT Departments (Shared Service, Business Solutions, Governance, etc.) on projects requiring infrastructure support
Responsibilities:
•Ability to plan/architect a highly redundant database infrastructure for proper growth and performance •Analyze and trend database usage for proper growth and performance. •Lead and mentor contractor and service providers to reach teams goals •Installation, configuration and management of production, stage, uat, and development SQL server environment with multiple instances •Installation, configuration and Management of production SQL server clustered environments •Reviews of the database environment to identify consolidation of instances opportunities •Reviews of the database environment to identify virtualization opportunities •Definition of the business recovery processes in a virtualized environment •Identification of the process improvements via version upgrades, new tools or reengineering of existing solutions •Setup of the database systems and is responsible for operational efficiency •Implementation and verification of data protection processes •Monitoring transaction activities and assists in optimizing the performance and utilization of databases •Assisting vendors in improving application performance through index recommendations •Developing, executing, and maintaining SSIS packages to support ETL solutions •Managing SSRS platforms to support reports being executed through SharePoint / Web portals •Steps to ensure the data is available and maximizing all database uptime •Building robust, configurable database applications that employ both PC and thin-client or web-based user-interfaces for both new applications and building on existing applications •Full technical documentation of the applications of database support environment •Establishing deadlines, and provided on-going communication of progress, in order to keep projects on track and on time •Enforcement of SOX and PCI and other regulatory compliance for all database related projects or enhancements •Respond to audit requests as it relates to the database environment •Quarterly research and application of Oracle / SQL patches on all database servers •Definition of maintenance plans to provide optimal performance of the transactional and job level workload across the database environment •Definition of security configuration and controls access across production, stage and development environments to support smooth migration of changes while maintaining integrity •Implementation and maintenance of data base management policies and procedures •Capacity and performance analysis to identify improvements of the database processing using SQL native and industry toolsets •Debug and trace analysis to identify improvements database processing using SQL native and industry toolsets •Assistance to the development team in new projects •Support to the development team researching system related issues. •Implementation and administration of department-wide SQL Server  •Role of technical consultant for the department's development and integration teams •Execution of DDL and DLL related changes including the moving and dropping of databases, adding and changing SQL Server logins and users, updating data and creating and troubleshooting queries and stored procedures to assure correctness and performance •Support of the development of a web based/AS400/Oracle access to SQL Server databases •Assistance to the project leader, release coordinator, and/or engagement manager to establish project quality standards, monitor project status and maintain project plans on schedule •Reporting of hours worked on a weekly basis •Demonstration of a high level of professionalism, in all dealings with business associates and clients •Maintaining high moral and ethical standards in all dealings with clients and business associates •Assisting in the development of standards and procedures affecting data maintenance and management •On call rotation for off hours support for scheduled changes and issue resolution
Requirements:
•Bachelor's Degree or 5 years’ experience as a Sr. Database Administrator. •5 - 7 years’ experience in an operational production support role performing installation, configuration, and management of SQL servers in a clustered environment with multiple instances using Microsoft SQL Server (2012, 2016, 2019).  Experience in T-SQL and PL/SQL, SSIS / SSRS and in a MS Windows environment. Proficient with debug and performance tools, database replication, database backup & recovery, virtualization of database servers, data dictionary tools, SQL integration with SharePoint and Web based applications, scripting, schemas, stored procedures, and reporting tools to configure and support MS SQL. •Excellent written and verbal communication skills. Project management skills. Working knowledge of PCI compliance.  Microsoft database certification, Managed administration of SQL Server database environments.  Excellent knowledge of databases operating in a MS Windows environment.  MCDBA or MCITP certification a plus. •Detail-Oriented with strong analytical and problem-solving skills. Results oriented with strong motivation and able to work well as a team member.
Our goal is to improve the quality of work/life by providing equal employment opportunities for all candidates and team members. Bluegreen Vacations Corporation believes that diversity and inclusion is critical to our success, and we seek to recruit, develop and retain the most talented people from a broad candidate pool. We are a drug-free workplace, and if offered employment, candidate must be willing to submit to a background check/drug test. EOE/DFW  

Other details

  • Job Family Data Analytics & Business Intelligence (BI)
  • Job Function Bonus and Merit
  • Pay Type Salary
  • Telecommute % 100
  • Required Education Bachelor’s Degree
Apply Now