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

Innovee Consulting LLC; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Innovee Consulting LLC is seeking a SQL Database Administrator to manage Oracle and MSSQL databases in a Brooklyn, NY environment. The role requires strong SQL, tuning, and cross-platform skills for a long-term engagement.

The position emphasizes high-availability databases, capacity planning, and collaboration with IT and vendor teams to maintain secure, compliant data systems.

Qualifications

• Minimum 6 years of SQL database administration experience.
• Experience with SQL Server 2016/2019/2022 and Oracle.
• Strong SQL querying, performance tuning, and plan analysis.
• Experience with Linux and Windows Server environments.
• Cloud experience with AWS or Microsoft Azure is a plus.

Responsibilities

• Create and maintain Oracle databases; ensure security standards.
• Develop and support SQL databases; maintain MSSQL infrastructure.
• Configure large, high-availability databases with replication.
• Design SQL queries, stored procedures, and data structures.
• Perform capacity planning and tuning; install upgrades/patches.
• Collaborate with system admins and vendor teams.
• Document database builds and changes.
• Provision databases for development, QA, staging, production.

Skills

SQL Server 2016/2019/2022

PowerShell

Windows Server 2016/2019/2022

Advanced SQL queries

Performance tuning

Tools

SSRS

SSIS 2016/2019/2022

Always On HA

Oracle tools

Job description

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.