Database Administrator at iQuasar LLC in NY-Brooklyn-11238

Responsibilities

• Create and maintain Oracle Databases. Report and make recommendations on database improvements. Ensure current database security standards are maintained  Responsible for SQL Server 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.
• Create and maintains all databases required for development, QA, Staging and production usage.
• Install new versions of the SQL Server and its tools.  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 SQL Server databases  Experience with Windows Server environments.
• Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)  Extensive experience with database replication (Qlik/Attunity) Experience with cloud services (AWS, Microsoft Azure)

Requirements

• A minimum of 6 years of experience with the following skill sets:
• SQL 2008/2008R2/2012/2014/2016/2019/2022 database management and related products.
• Microsoft includes PowerShell, Windows Server operating systems. BID-DSS-ITS-C-20260729-1.
• Advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS packages.  SQL Server Always on High Availability configuration, support, and troubleshooting.
• Performance tuning, Performance monitoring, “Live” and Scheduled replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring.

Skills

Required

• PowerShell
• Windows Server operating systems
• Performance tuning and monitoring
• Live and scheduled replication
• Log shipping
• Database Mirroring
• Database capacity planning
• Users and Role creation and monitoring

Benefits

• 401(k)
• Paid time off
• Compensation: $90.00 - $120.00 per hour