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

Chick-fil-A

Back of House Team Member Job at Chick-fil-A

At Chick-fil-A, the Back of House Team Member role is more than just a job; it's an opportunity. In addition to working directly for an independent Owner/Operator, Back of House Team Members gain life experience that goes far beyond serving a great product in a friendly...

On Point Staffing Group

Property Manager (Multi-Site) Job at On Point Staffing Group

...Property Manager (Multi-Site) Location: Orange, NJ Join our team as a dynamic and committed Property Manager overseeing multiple sites in Orange, NJ, including Ridge Gardens, Scotland Park, and Vose Ave. located in norther New Jersey. This role requires a proactive...

Matthews Bus Alliance, Inc

School Bus AC Install Technician Job at Matthews Bus Alliance, Inc

...Job Summary: Rifled Air Conditioning is currently seeking a skilled and motivated individual to join our team as a School Bus AC Install Technician. In this role, you will be responsible for installing and servicing air conditioning systems on school buses for...

Morris & Ritchie Associates, Inc.

Landscape Architect Job at Morris & Ritchie Associates, Inc.

...Morris & Ritchie Associates, Inc. (MRA) is looking for a creative and driven Landscape Architect/Landscape Designer with 5 - 8 years of experience to join our Land Planning & Landscape Architecture group in Towson, Maryland. This is a fantastic opportunity to contribute...

DSV - Global Transport and Logistics

Data Center Supervisor Job at DSV - Global Transport and Logistics

...Division:Solutions Job Posting Title: Data Center Supervisor Time Type: Full Time... ...accuracy Accountability Maintain service level agreements utilizing existing systems and... .... Knowledge and Skills:This is an entry level leadership role. Solid interpersonal...

SQL Database Administrator Job at Selby Jennings, Chicago, IL

S1h6QnpVSnFhZE5ybTVtS2FQMEtYeFBLNlE9PQ==