SQL Database Administrator ( Need only NYC DSS/HRA Exp)

New York, NY, US • Posted 2 days ago • Updated 9 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • DSS
  • Reporting
  • Database Security
  • Microsoft SQL Server
  • Documentation
  • Stored Procedures
  • Systems Analysis
  • Database Performance Tuning
  • Customer Relationship Management (CRM)
  • Development Testing
  • RDBMS
  • System Administration
  • PL/SQL
  • Linux
  • Microsoft Windows Server
  • Microsoft Operating Systems
  • MySQL
  • PostgreSQL
  • Oracle
  • MongoDB
  • Cloud Computing
  • Amazon Web Services
  • Microsoft Azure
  • Database Administration
  • Microsoft
  • Windows PowerShell
  • Microsoft Windows
  • Operating Systems
  • Microsoft SSRS
  • Microsoft SSIS
  • SQL
  • High Availability
  • Performance Tuning
  • Performance Monitoring
  • Replication
  • Log Shipping
  • Database Mirroring
  • Database
  • Capacity Management

Summary

Role: SQL Database Administrator

Location: Brooklyn, NY

Duration: Long Term

Need only exp with NYC DSS/HRA

Responsibilities:
  • Create and maintain Oracle Databases. Report and make recommendations on database improvements. Ensure current database security standards are maintained
  • Responsible for SQL Database development and support.
  • Creates, maintains, and updates SQL Server Infrastructure and Standards DBA documentation.
  • Works with vendors to architect, design and configure large, complex databases with replication and high availability on the most current MSSQL versions.
  • Develops and maintains application, data, and execution architectures.
  • Provides input into overall development/implementation plan and documents database builds and changes, performs SQL designs, table designs, and stored procedures work.
  • Manages large tables, maintains schemas, and develops queries and utilities to assist users.
  • Installs upgrades and patches to existing databases.
  • Creates databases, tuning, cloning, copying, and data refreshes.
  • Performs system analysis and identifies solutions to technical problems
  • Identifies bottlenecks and performs database tuning.
  • Supports the activities required to build and maintain customer relationships.
  • Create and maintains all databases required for development, QA, Staging and production usage
  • Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
  • Performs the capacity planning required to create and maintain the databases and carry out tuning of database instances.
  • Work closely with system administration staff because Computers often have applications or tools on them in addition to the Oracle /SQL Databases
  • Experience with Linux and Windows Server environments
  • Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
  • Experience with cloud services (AWS, Microsoft Azure) a plus

Required Skills:

A minimum of 6 years of experience with the following skill sets:
  • SQL 2016/2019/2022 database management and related products
  • Microsoft including PowerShell, Windows 2016/2019/2022 Server operating systems.
  • Advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS-2016/2019/2022 packages
  • SQL 2016/2019/2022 Always on High Availability configuration, support, and troubleshooting.
  • Performance tuning, Performance monitoring, Replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTL939169
  • Position Id: 3170302f28476163ce2dc5349c903c4d
  • Posted 2 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

New York, New York

Yesterday

Easy Apply

Third Party, Contract

Depends on Experience

Hybrid in New York, New York

21d ago

Easy Apply

Third Party, Contract

70 - 90

New York, New York

Today

Full-time

USD 140,828.00 - 166,223.00 per year

New York, New York

Today

Full-time

USD 150,000.00 per year

Search all similar jobs