SQL DBA Job at IPS Technology Services, Troy, NY

S1k5RzdnNllWQjBOMGpkekNvRHFRN2cvWkE9PQ==
  • 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

MIK Construction Inc.

Project Engineer (Construction) Job at MIK Construction Inc.

 ...Role Description This is a full-time on-site role for a Construction Project Engineer located in Los Angeles, CA. The Construction Project Engineer will be responsible for project coordination, construction engineering, quality control, and submittals. Effective communication... 

SchooLinks

New Grad Software Engineer, Data Job at SchooLinks

 ...such as OneRoster, Ed-Fi, and others Experience with modern software development and project management tools such as Git and JIRA...  ...work time as possible Remote- we have a small number of engineers on-site, but many distributed as well as much of our... 

PRO EM National Event Services

Tent Installer Job at PRO EM National Event Services

 ...heavy construction projects. The position may operate a variety of hand and power tools and may clean and prepare sites, dig trenches,...  ...Assist crew leads as needed. Setup tents, tables, chairs, & stages as directed by the Crew Lead or Project Manager. Construct temporary... 

Pattern Promotions

Public Relations Coordinator Job at Pattern Promotions

Public Relations CoordinatorCompany: Pattern PromotionsLocation:Atlanta, GA Salary: $18.50 - 23.00 per hourJob Type: Full-TimeAbout UsAt Pattern Promotions, we are a dynamic and innovative promotional products company dedicated to delivering quality solutions... 

Huntington Learning Center of Cincinnati/Hyde Park

3rd-6th Grade Tutor (Cheviot, Cincinnati) Job at Huntington Learning Center of Cincinnati/Hyde Park

 ...or grade homework ~ REQUIREMENTS : ~4-year degree required ~ Certified/License is a plus ~ Recent grads, current teachers and retired professionals encouraged to apply. ~ Able to commute to the school located in Cheviot, Cincinnati. ~ Hours: 9 am - 2 pm...