Job Details

Email to Friend Save Back

Senior Database Engineer

NEW YORK-10002, NY, US
01/20/2020

-

Required Skills

ETL tools, powershell

Company

Infinity Consulting Solutions, Inc

Experience

5 to 10 Year(s)

Job Description

We are seeking a senior SQL server database administrator with Oracle DBA experience.

The candidate will work as part of the DBA team that works on cutting edge technologies to support our trading systems.

This includes real time Datawarehouse, Oracle RAC and Goldengate replication.

The candidate will also work on new cloud technologies as we migrate our applications to AWS cloud.

Responsibilities (including but not limited to)

Active experience in supporting SQL Server and Oracle environments.

Manage SQL Server/Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Independently analyze, solve, and correct issues in real time, providing problem resolution endto-end.

Refine and automate regular processes, track issues, and document changes.

Work with Goldengate to replicate data among different databases.

Assist development and reporting groups in optimizing SQL statements in applications, batch jobs, and reports and in designing and using databases and database applications and processes for maximum performance, security, reliability, and availability.

Provide 24x7 support for critical production systems.

Monitors performance issues on all production and non-production databases (as applicable) implementing performance monitoring and trending on all production and applicable nonproduction databases.

Perform scheduled maintenance and support release deployment activities after hours.

Skills and Qualifications

10+ years MS SQL Server Database Administration experience required

5+ years of Oracle Database Administration

Knowledge of Cloud platforms like AWS or Azure

Knowledge of Data Warehouse and ETL tools like SSIS

Experience with Performance Tuning and Optimization at the database as well at the application level

Experience with backups, restores and recovery models

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Excellent written and verbal communication skills

Ability to multi-task and context-switch effectively between different activities and teams

Proficiency with powershell and/or python

Bachelors degree in Computer Science or related field

Preferred

DBA certification is a plus

Track record in organizing and planning work independently

Experience working in a rapidly changing environment