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

Nexxen

Paralegal Job at Nexxen

 ...postings, and we urge all job seekers to remain vigilant. Please be advised that Nexxen will never request payment (whether in cash, cryptocurrency, or any other form) as a condition of employment, offer positions that require you to invest in vague or dubious financial... 

Royal Bank of Canada

Analyst, Global Investment Banking, GIS Analyst Job at Royal Bank of Canada

 ...Job Description Opportunity: RBC Capital Markets Energy Investment Banking platform is seeking an entry-level GIS Analyst. The successful candidate will play a critical role in analyzing spatial data and providing insights that inform investment strategies and decisions... 

Prime Car Wash Jacksonville

General Manager Job at Prime Car Wash Jacksonville

 ...Paid time off Profit sharing Training & development POSITION: GENERAL MANAGER SALARY RANGE: $70,000 - $85,000 Based on experience, plus profit sharing. Prime Car Wash is seeking General Managers to embark on a highly rewarding career. If you have strong... 

Royal Bank of Canada

Research Associate, Biotechnology Job at Royal Bank of Canada

 ...Job Description What is the Opportunity? Research Associate responsible for fundamental analysis of companies in the Biotechnology...  ...research experience in biotechnology, pharma, or specialty pharmaceuticals is a plus ~ Good understanding of financial/stock market... 

TechNix LLC

Project Manager Job at TechNix LLC

 ...City Attorney, Compliance, or Oversight entities Familiarity with CJIS or criminal justice data controls Experience with Tableau or Power BI (oversight level) Scope of Work Serve as day-to-day engagement lead Coordinate analytics activities...