Hard Rock International

Returning Candidate?

Senior Database Administrator

Senior Database Administrator

Job ID 
2017-2995
# of Openings 
1
Job Locations 
US-FL-HOLLYWOOD
Department 
Information Technology

More information about this job

Overview

We are seeking a Senior Database Administrator who performs high-complex database management tasks, i.e. monitors and manages the integrity of all enterprise databases.  He/she requires a high degree of expertise and specialized knowledge of data base management techniques which facilitate and expedite the usability, consistency, accuracy, integrity, security, timeliness and availability of enterprise data.  The position performs ongoing and in-depth database analysis and is responsible to continuously mentor and lead direct reports.

Responsibilities

 

  • Works with vendors, users, applications developers and management to obtain information and develop an understanding of the needs of the organization and to overcome significant operational and/or technical issues or problems.
  • Recommends potential solutions utilizing relational technology
  • Assesses and assigns DBA resources and oversees quality of work produced
  • Recommends reviews and approves the design of physical data models and structures
  • Provides advanced level database management, support and assistance
  • Collaborates with and supports data architects and application developers in the physical design of databases
  • Implements the physical database design and optimization strategies
  • Leads database conversion and migration activities
  • Analyzes, develops and supports disaster recovery plans
  • Provides back-up and recovery procedures as needed for all production and test databases
  • Provides technical consultation to the development staff and other IT organizations or groups
  • Works with management and user committees in setting performance objectives
  • Monitors and tunes database performance to meet performance objectives
  • Manages and monitors storage capacity
  • Evaluates, recommends, and participates in the installation of new storage media
  • Supports operations staff with their production databases
  • Works with programmers to tune data access codes
  • Participates in IT committees to create standards for database utilization
  • Maintains strong vendor relationships to keep apprised of new database products, versions, and releases
  • Escalates intractable problems to the vendor
  • Evaluates, recommends, and installs new versions and releases and new database tools
  • Develops plans to install, maintain, enhance, test and migrates DBMS products and supporting software
  • Coordinates with engineering staff to ensure consistency in planning and implementation efforts
  • Works with application developers and other organizations within the enterprise to evaluate database requirements for application software packages under consideration
  • Provides second level support to the database administrator
  • Responds to and assists with other problem tickets as required
  • Adheres to other defined SOPs as required
  • Performs other duties as assigned

 

Qualifications

  • Bachelors degree or equivalent work experience is required
  • 7-10 years technical database administration experience or combination of training and experience is required
  • 5-7 years’ experience in an IT organization and/or equivalent application or business experience is preferred
  • Requires strong knowledge of logical design and physical implementation
  • Requires knowledge of enterprise hardware and operations systems
  • Exceptional interpersonal and communication skills with the ability to deal with a diverse range of people, which includes the upper levels of corporate management
  • Self sufficient, requiring limited supervision over job knowledge, expectations and successful project completion

 

Technical Skills

  • Knows how to use SSMS to monitor jobs, view history, set job notifications, set operators, enable and set Database Mail up
  • Proficient with T-SQL
  • Knows how to use SSMS to monitor access to the server and database
  • Knows how to use SSMS to monitor the database server performance
    • Understands locking
    • Understands CPU time
    • Understands wait types
    • Understands physical reads and logical reads and writes
    • Understands sessions and requests
  • Knows how to use SSMS and T-SQL to verify availability
    • Understands database states and user access options
  • Knows how to operate and configure SQL Server services
  • Understands Windows Clustering
  • Knows T-SQL to troubleshoot errors
  • Knows SSIS to troubleshoot errors
  • Responds promptly to events
  • Knows how to use SSMS and T-SQL to create logins and users, and to grant permissions
  • Understands SQL Server security architecture
  • Knows how to use SSMS and T-SQL to create and modify databases
  • Understands application needs before implementing the database
  • Is familiar with Best Practices for database file structure, security, etc.
  • Is familiar with pre-installation, installation and post-installation steps
  • Is familiar with Best Practices as far as systems databases, security, etc.
  • Knows how to use SSMS and T-SQL to run backups and recoveries