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

Watt Acquisition, LLC

Purchaser (Electrical Contractor) Job at Watt Acquisition, LLC

...Thank you for considering a position with us! We are Edge Electric and Stryker Electric, a group of leading electrical contractors in Texas and Florida. Job Summary: Stryker Electric is seeking a detail-oriented and proactive Purchaser to join our team at Stryker...

Guardian Proservices

Baggage Handler-LGA Job at Guardian Proservices

...currently recruiting experienced Baggage Handlers for Day and Night shifts. Here at Guardian Professional Services, we are looking for... ...job security training and the ability to receive all applicable airport security badges. Communicating effectively and clearly....

University of Southern California (USC)

Data Coordinator - BMT Clinic - Full Time 8 Hour Days (Non-Exempt) (Non-Union) | University of Southern California (USC) Job at University of Southern California (USC)

...regulatory agencies as determined by the hospital's management. The Data Coordinator is responsible for maintaining systems and clinical information for the purposes of clinical care, performance improvement and clinical research and evaluation. Works as a member of...

Clarifi Staffing Solutions

Now Hiring: Assistant Speech Pathologist (SLPa)! Job at Clarifi Staffing Solutions

...Join Our Team as an Assistant Speech-Language Pathologist! At Clarifi Staffing Solutions, were passionate about shaping the future of special... ...work collaboratively and follow guidance from the supervising SLP. Associates or Bachelor's degree in Communication...

Route Elite

FedEx Ground Delivery Driver Job at Route Elite

...We are hiringregular full time and part time FedEx Delivery driverswith work-related driving experience and a strong work ethic to... ...for UPS, Amazon, previous FedEx companies, DHL, Wal-Mart, Uber, Lyft or any other similar companies - that is a plus! We have a job waiting...

SQL Database Administrator Job at Selby Jennings, Chicago, IL

cGw3QUw1S2tEOE1wUWdhdGRDNHpPaXBYSEE9PQ==