Sr. SQL DBA in Hollywood, FL at Consultis

Date Posted: 1/8/2018

Job Snapshot

Job Description

WE ARE UNABLE TO OFFER SPONSORSHIP OR THIRD PARTY REPRESENTATION FOR THIS POSITION

Consultis, a premier Technical Solutions Provider and Technical Staffing Firm with the single focus of pairing the right candidate with the right employment opportunity is currently searching for a Sr. SQL DBA for a Direct Hire opportunity (FTE) with our South Florida based client.

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.

Requirements/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
  • 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

Required Qualification or Skills:

  • Bachelor’s 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 

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

Additional Nice to have Skills (A PLUS):

  • Oracle experience is a plus

TO APPLY FOR THIS POSITION:

Please apply online through Consultis' application process. This will register you into our database allowing us to better qualify and present you with opportunities. Provide as much information as possible including telephone #s, email, local address, resume, skills, availability, relocation preferences, acceptable travel percentage, salary history, work history, references and job type categories.  Should you experience trouble please feel free to contact us directly at 561-750-8745

You may also email your resume to: KyleR@consultis.com

WE ARE UNABLE TO OFFER SPONSORSHIP OR THIRD PARTY REPRESENTATION FOR THIS POSITION