SQL Database Administrator Job at Selby Jennings, Chicago, IL

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

H&H

Roadway Project Manager Job at H&H

 ...We are seeking a Project Manager with 10+ years of professional experience to be part of our Transportation Team in Austin. The position...  ...and technical writing skills Ability to train and mentor entry-level staff Applicants must be currently authorized to work... 

University of Alaska Fairbanks

Art Model (Nude and Clothed) Job at University of Alaska Fairbanks

 ...The UAA College of Arts & Sciences, Department of Art, is recruiting for both clothed and nude art models for the 2024-2025 Academic Year. All shapes and sizes are encouraged to apply! Please indicate in your application which type of sessions you wish to be considered... 

Rockstar Execs

Human Resources Recruiting Specialist Bilingual Job at Rockstar Execs

 ...needed Conducts job interviews Onboards new employees and enters into system Enters new hires into the HR System ~2 Years As A Recruiting Specialist ~ Experience Recruiting Hourly Paid Employees ~ Experience Using ATS and Time and Attendance Systems... 

Henpen Consulting Corporation

Electrical Engineering (Petrochemical) Job at Henpen Consulting Corporation

 ...Provide off-shift troubleshooting support as necessary to address urgent technical issues. Assist in the maintenance and support of Honeywell TDC systems. Contribute to the planning of routine shutdowns, recommending the scope of work to ensure efficient and safe... 

Vensure Employer Solutions

Butler - PA Job at Vensure Employer Solutions

 ...Position Summary In your role as Butler , it is imperative that you meticulously attend to all the personal needs of the esteemed guests that have been entrusted to your care. In preparation for their arrival, it is your responsibility to reach out to them and ensure...