SQL DBA Job at IPS Technology Services, Troy, NY

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

The Metalworking Group

Powder Coat Painter Job at The Metalworking Group

 ...MWG is looking to add a Powder Coater to our Pippin Location! ESSENTIAL DUTIES AND RESPONSIBILITIES: To ensure quality of the painting process. Able to run the paint booth and have full understanding of the powder coating techniques and equipment. This includes... 

Sterling Physician Recruiters

Pediatrician Job at Sterling Physician Recruiters

 ...Pediatrician Join a well established non-profit community health center in Tallahassee, FL, supporting a diverse underserved population. Currently 12 providers within a full service center providing primary care, behavioral health, dentistry, and pharmacy onsite.... 

Advocate Aurora Health

Customer Svc Trainee Job at Advocate Aurora Health

 ...from the electronic patient billing and medical records system including claims inquiry, account...  ...before they become escalated complaints. Works with appropriate departments to resolve...  .... Open to working remotely from your home if required. This indicates the general... 

Indiana University Indianapolis

Department Chair and Associate/Full Professor in Biomedical Engineering and Informatics Job at Indiana University Indianapolis

 ...Department: IU Indianapolis Department of Biomedical Engineering and Informatics - Luddy School Location Indianapolis Position Summary...  ...will be considered from all areas in bioinformatics, health and biomedical informatics, biomedical engineering, clinical informatics... 

Furniture Mart USA

Receiving Unloader Job at Furniture Mart USA

 ...Job Description JOB SUMMARY: Enjoy your nights & weekends! Work as a Receiving Unloader at our Ashley HomeStore Distribution Center in Fridley, MN! If you are motivated, productive, and enjoy working hands on in a clean warehouse environment then this may be the perfect...