Returning Candidate?

Senior SQL Database Administrator

Senior SQL Database Administrator

# of Openings 
1
Job Locations 
US-NY-Syosset
Category 
Information Technology

More information about this job

Overview

Ranked among the nation’s top 20 Construction Managers by Engineering News-Record, The LiRo Group provides construction management, engineering, environmental, architectural, and program management solutions for a broad range of public and private sector clients. We are seeking talented and motivated professionals to join our multi-disciplined team.

 

 Due to our continued growth we are seeking a Senior SQL Database Administrator.

Responsibilities

 

SQL administration and application support in a VMWare Windows Server environment. hosting clustered SQL Servers.

The SQL Server DBA will be responsible for the overall SQL Server environment. Overseeing the implementation, configuration, security, maintenance, and performance of SQL Server RDBMS systems, as well as ensuring the availability and performance of enterprise applications. Maintain SQL database objects and perform database capacity planning, data modeling, data loads, troubleshooting, database backup and recovery. Support onsite applications with the assistance of vendors.

This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills

  • Manage SQL Server databases through multiple product life-cycle 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.
  • Ensure development and implementation support efforts meet integration and performance expectations
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Script automation
  • Manage database structures by monitoring and adjusting the internal structures (tuning) as required.
  • Defines, establishes and performs regular backups of databases.
  • Involvement in planning, designing, creating, installing, customization, upgrades and maintaining of databases to meet defined requirements.
  • Perform upgrades of the database and software to new release levels.
  • Documents databases and deployed applications.
  • Perform Database Security implementation and documentation.
  • Assist clients with Maximo user related issues.
  • Create and maintain reports and forms using BIRT Reporting Tools
  • Perform other duties as required.

 

 

 

Qualifications

Bachelor’s Degree from an accredited university in Computer Science or similar discipline is required. 10 years of directly related, IT experience may be substituted.

  • 10+ years MS SQL Server Administration experience required.
  • Experience with Performance Tuning and Optimization (PTO), monitoring and troubleshooting tools.
  • Experience with VMware and SQL Clusters
  • Experience with SQL backup and recovery.
  • Experience with SSRS (SQL Server Reporting Services)
  • Knowledge of High Availability (HA) & Disaster Recovery (DR) for SQL Server
  • Experience with Windows server 2008, 2012, 2016, including Active Directory
  • Excellent written and verbal communication
  • Ability to organize and plan work independently, self starter
  • Understanding of network architecture
  • Basic Project Management skills required
  • Ability to document project requirements
  • Ability to work flex hours
  • Strong application support experience
  • Perform other duties as required.

Preferred Qualifications:

  • MCSA SQL certification a plus
  • Solid understanding of GIS system integrations.
  • Experience in working with government a plus
  • 5 years of Maximo Administration experience
  • Maximo System administration and configuration; work-flow development along with end-user support.
  • Maximo Spatial Asset Management.
  • IBM WebSphere Server maintenance, configuration and troubleshooting.

 

Please visit our website for all of our career opportunities at:  https://careers-liro.icims.com

We offer a competitive salary commensurate with experience, a comprehensive benefits package and a positive work environment

 

Equal Opportunity Employer