The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

Sr. SQL DBA

Job Description

Great client of mine--I've placed multiple people with them through the years.

Full time Opportunity, Reporting to the Sr. Director of Data Warehouse Architecture

You will oversee all aspects of our database systems. Including both OLTP and Data Warehouse architectures.

Responsibilities:

  • Work with the application development teams to understand and design the SQL Server OLTP database schema.
  • Work with the data warehouse team to build and support the enterprise data warehouse.
  • Database Design, software installation and upgrade, database backup & recovery, overall performance monitoring, capacity planning, and database security.
  • Provide database support, including ad hoc data request, database query, index optimization, and stored procedure design. Using tools like SolarWinds and Redgate tools.
  • Documentation and monitoring of database maintenance procedures. Including: update statistics, rebuilding and reorganizing indexes, defragging tables, replication, linked servers and database maintenance plans.
  • Continually investigate methods to improve system reliability and performance.
  • Provide input on capacity planning, high availability solutions and upgrade strategies.
  • Enforce and document database policies, procedures and standards.
  • Set up replication and Always On availability groups for SQL server
  • Responsible for maintaining 24/7 database availability.
  • Design and test disaster database recovery plan.
  • Design and support high availability database configuration.
  • Work/collaborate with offshore vendors and consultants.
  • Work with the IT Security & Compliance group to establish security standards and maintain PCI, GDPR, and CCPA compliance.
  • Work with the Project Management team to track projects and help desk tickets.
  • Work with the Infrastructure team to manage licensing cost.


Skill and Experience Requirements:

  • BS/MS in Computer Science, or equivalent.
  • 8+ years of experience as a SQL Server DBA.
  • 8+ years of experience in troubleshooting and optimizing database slowness.
  • 3+ years of experience in AWS or other cloud.
  • Must be able to work on 24/7 on-call schedule.
  • Experience with SSRS, SSIS, table indexing, views, backups, SQL server log reviews, error corrections, database creation/changes, and scheduled replication of databases.
  • Understanding of ETL processes and tools.
  • Strong organizational and planning skills and process orientation.
  • Desired not required, experience in Postgres administration, AWS RDS, AWS Redshift.

Job Requirements

 

Job Snapshot

Location US-CT-Rocky Hill
Employment Type Full-Time
Pay Type Year
Pay Rate $115,000.00 - $140,000.00 /Year
Store Type IT & Technical
Other Compensation: Bonus
Apply

Company Overview

SNI Technology

SNI Technology® is one of the fastest growing technology recruitment companies in the country specializing in technical careers and temporary jobs. We uniquely align with our clients and the candidates we represent, because our staff is hired from the industry we serve. We offer technical talent and employment opportunities on a contract, contract–to–hire, and a direct–hire basis in a wide variety of disciplines from helpdesk professionals to the most cutting-edge software architects. Learn More

Contact Information

US-CT-Rocky Hill
SNI Technology
Snapshot
SNI Technology
Company:
US-CT-Rocky Hill
Location:
Full-Time
Employment Type:
Year
Pay Type:
$115,000.00 - $140,000.00 /Year
Pay Rate:
IT & Technical
Store Type:

Job Description

Great client of mine--I've placed multiple people with them through the years.

Full time Opportunity, Reporting to the Sr. Director of Data Warehouse Architecture

You will oversee all aspects of our database systems. Including both OLTP and Data Warehouse architectures.

Responsibilities:

  • Work with the application development teams to understand and design the SQL Server OLTP database schema.
  • Work with the data warehouse team to build and support the enterprise data warehouse.
  • Database Design, software installation and upgrade, database backup & recovery, overall performance monitoring, capacity planning, and database security.
  • Provide database support, including ad hoc data request, database query, index optimization, and stored procedure design. Using tools like SolarWinds and Redgate tools.
  • Documentation and monitoring of database maintenance procedures. Including: update statistics, rebuilding and reorganizing indexes, defragging tables, replication, linked servers and database maintenance plans.
  • Continually investigate methods to improve system reliability and performance.
  • Provide input on capacity planning, high availability solutions and upgrade strategies.
  • Enforce and document database policies, procedures and standards.
  • Set up replication and Always On availability groups for SQL server
  • Responsible for maintaining 24/7 database availability.
  • Design and test disaster database recovery plan.
  • Design and support high availability database configuration.
  • Work/collaborate with offshore vendors and consultants.
  • Work with the IT Security & Compliance group to establish security standards and maintain PCI, GDPR, and CCPA compliance.
  • Work with the Project Management team to track projects and help desk tickets.
  • Work with the Infrastructure team to manage licensing cost.


Skill and Experience Requirements:

  • BS/MS in Computer Science, or equivalent.
  • 8+ years of experience as a SQL Server DBA.
  • 8+ years of experience in troubleshooting and optimizing database slowness.
  • 3+ years of experience in AWS or other cloud.
  • Must be able to work on 24/7 on-call schedule.
  • Experience with SSRS, SSIS, table indexing, views, backups, SQL server log reviews, error corrections, database creation/changes, and scheduled replication of databases.
  • Understanding of ETL processes and tools.
  • Strong organizational and planning skills and process orientation.
  • Desired not required, experience in Postgres administration, AWS RDS, AWS Redshift.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Sr. SQL DBA Apply now