SQL DBA Job at IPS Technology Services, Troy, NY

YzZTRGVPbDFlR1RiYmg3SjdpREdVcGkrdFE9PQ==
  • IPS Technology Services
  • Troy, NY

Job Description

This is a remote position.

Job Role: SQL DBA

Job Location: Remote

Job Duration: Long Term

Responsibilities

  • Responsible for designing, building, installing, maintaining and tuning the databases that support the company's day-to-day operations. ·
  • Min 10+ years' experience in SQL server 2012 or later in an administrative role. ·
  • Must possess high-level of proficiency in SQL and T-SQL. ·
  • Must possess 3+ years of experience building, deploying and maintaining ETL packages using SSIS. ·
  • Must possess experience installing, configuring, and upgrading database software including HADR configurations. ·
  • 5 years' experience creating/updating/optimizing/troubleshooting - Stored procedures/functions, tables, views, triggers, indexes and constraints.
  • Experience with database object migrations across multiple database environments and keeping various environments in sync. ·
  • Must possess experience in troubleshooting and resolving job failures, performance issues, blocking/deadlocking issues, connectivity and security issues. 
  • Proficient in optimizing database workloads using Profiler/Extended Events/DMV's or other database monitoring tools. Experience with Solarwinds DPA is preferable. ·
  • Possess Good working knowledge of windows server operating systems (2012/2016) ·
  • Possess strong knowledge of backups, restores and recovery models. ·
  • Possess solid understanding of various Amazon Web Services especially AWS RDS, EC2 and S3. · Familiarity with other SQL/NoSQL databases such as Oracle, MySQL, PostgreSQL, MongoDB, etc. is a plus


Job Tags

Contract work, Remote work,

Similar Jobs

Adams and Reese

Accounts Receivable Specialist Job at Adams and Reese

 ...Reports to: Receivables Manager Department: Accounting Job Summary: Receive and record all monies received by the firm. Responsibilities: Write receipts for incoming checks and identify as fees, cost, trust, etc. Complete daily cash log. Post... 

Las Vegas Petroleum

Assistant General Manager (Sbarro/Del Taco/KFC) Job at Las Vegas Petroleum

 ...departments (e.g., marketing, district management) for promotions and operational improvements. Brand-Specific Adjustments: KFC: Focus on managing fried chicken preparation and ensuring quality control in the frying process. Oversee staff involved... 

Mangrum Career Solutions LLC

Family Law Attorney Job at Mangrum Career Solutions LLC

 ...candidate for this position must have an active Maryland law license and 5+ years of family law experience. About Our Client Our client is a...  ...law, and workers compensation. Their team of experienced attorneys and investigators is dedicated to achieving justice and... 

Achieve Beyond Pediatric Therapy & Autism Services

School Psychologist Job at Achieve Beyond Pediatric Therapy & Autism Services

School Psychologist-Suffolk, NY Job-Achieve Beyond Description:Apply to Achieve Beyond as aSchool Psychologistin Suffolk, NY and help children with special needs reach their goals. Explore our New York career opportunities and make a positive impact today. Come and join... 

Johns Hopkins Medicine

Public Safety Officer I - Day Shift Job at Johns Hopkins Medicine

 ...Public Safety Officer I Location: Johns Hopkins Bayview Medical Center Department: Public Safety Position Type: Full-Time, Non-Exempt, All Shifts About the Role The Public Safety Officer I plays a key role in maintaining a safe and secure environment...