SQL Database Administrator Job at Selby Jennings, Chicago, IL

S1h6QnpVSnFhZE5ybTVtS2FQMEtYeFBLNlE9PQ==
  • Selby Jennings
  • Chicago, IL

Job Description

We have a current opportunity for a SQL Database Administrator on a permanent basis. The position will be based in NYC.

Responsibilities:

  • Collaborate with business units to design innovative solutions and support new initiatives.
  • Assist with exploring and implementing new database technologies to enhance productivity and efficiency in database-driven applications.
  • Manage and support production, QA, and Dev databases using SQL Server, SSAS Cubes, and other NoSQL databases.
  • Create DBA administration scripts utilizing T-SQL, stored procedures, SSIS packages, and PowerShell.
  • Support the development and automation of reports for business analysis and compliance requirements.
  • Aid in developing ad-hoc SQL queries, stored procedures/views, and optimize them for better performance.
  • Troubleshoot database-related issues and provide solutions to improve database reliability and availability.
  • Administer and maintain database schemas using modeling tools and deploy schema changes across Dev, QA, and Production environments while adhering to change control processes.
  • Oversee database security and ensure data safety and integrity.
  • Ensure proper database backups are performed to meet RPO and RTO objectives.
  • Implement and manage data archiving and retention processes.
  • Document the database environment and administration procedures.

Qualifications:

  • 5+ years of experience supporting MS SQL Server or other OLTP databases as a DBA.
  • 5+ years of experience with T-SQL or other procedural programming languages.
  • 3+ years of experience with database monitoring tools such as SQL Profiler, Quest, RedGate, Idera, Foglight, PDBA, etc.
  • 3+ years of experience with at least two scripting languages: PowerShell, Python, Shell, Perl.
  • Must have administration experience with SQL Server SSAS, SSRS, and SSIS.
  • Must be familiar with Linux environments and able to use basic Linux commands and an editor.
  • Experience with OLAP and NoSQL databases is a plus.
  • Ability to work effectively in a team-oriented environment.
  • Strong communication and interpersonal skills.
  • Familiarity with Execution Services or Options-related product knowledge is a plus.
  • Self-motivated with the ability to work independently with minimal supervision.
  • Eagerness to learn new skills and embrace new challenges.

Education:

  • Bachelor's degree in Computer Science, Mathematics, or a related field in Computer Engineering or Science.

Job Tags

Permanent employment,

Similar Jobs

Bellows Plumbing, Heating, Cooling & Electrical

HVAC Service Technician Job at Bellows Plumbing, Heating, Cooling & Electrical

 ...Do you have extensive HVAC service experience? Are you a skilled and experienced technician looking for a family-friendly company to work for? Is your current job a dead end with no room for advancement? Does your boss provide in house training? Good pay?... 

Bechtel

Field Welding Engineer Job at Bechtel

 ...). Job Summary: In this role, you will lead, implement, and maintain global construction field welding programs and provide specialized welding engineering support. You will manage, inspect, and monitor the welding test lab, the rod room, the weld heat treatment... 

CBRE

Mobile Engineer Job at CBRE

 ...REQUIRED** .+ Excellent social skills, including oral and written communications+ Uses computer and / or PDA for work order system, email, and training.+ **Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or... 

Complete Homecare

Direct Support Professional (DSP) Job at Complete Homecare

 ...Direct Support Professional (DSP) Harrisburg, PA $16$18/hr | Full-time or Part-time | Flexible Shifts Job Title: Direct Support Professional (DSP) Location: Community and Home-Based Services Shifts Available: All shifts About the Role We are seeking... 

Adelphi Staffing

Licensed Specialist in School Psychology Job at Adelphi Staffing

 ...university Valid license granted by the Texas Department of Licensing and Regulation (TDLR) or Texas Education Agency (for Bachelor's-level SLPs) Valid drivers license and transportation Responsibilities: Perform evaluations, screenings, and therapy to...