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

Similar Jobs