SQL / Oracle DBA

Phaxis LLC

Jersey City, NJ

JOB DETAILS
SKILLS
Auditing, Change Management, Computer Science, Data Recovery, Database Administration, Database Architecture, Database Backup, Database Design, Database Recovery, Database Technology, Disaster Recovery, Linux Operating System, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Operating System, On Call, Oracle, Oracle DBA (Database Administrator), Oracle Database, Oracle PL-SQL, Performance Analysis, Performance Tuning/Optimization, Procedure Development, Production Support, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Security Monitoring, Software Development, Software Patches, Stored Procedures, System Architecture, Unix Operating Systems, Windows PowerShell
LOCATION
Jersey City, NJ
POSTED
3 days ago
Our client, a growing financial firm is looking for a DBA to join the team. This role is responsible for maintaining, configuring, and performance tuning database systems. The current platforms to support are MS SQL Server 2019 and 2022, as well as Oracle 19c. The primary duties include correcting issues, ensuring performance, availability, security, monitoring the health of all internally hosted database servers supported by the Production Support team.

RESPONSIBILITIES
  • Monitors daily processing, research exceptions and request items
  • Monitors database performance and performs database tuning
  • Establishes and monitors database backup, recovery, and replication processes
  • Participates in disaster recovery testing for databases
  • Designs and creates databases for applications developed by the firm implementing their standards
  • Designs and writes stored procedures in SQL
  • Adheres to policy regarding change management
  • Be part of the L2 production support team
  • Installs, upgrades, and patches both MS SQL Server and Oracle databases with ASM on Linux
  • Working knowledge in database systems architecture
  • Participate in the on-call rotation of the Production Support group
REQUIREMENTS
  • Bachelor's degree in Computer Science or equivalent
  • 5+ years of DBA experience (Windows for SQL) and (Linux for Oracle)
  • Ability to work with Windows, UNIX, and Linux operating systems
  • Knowledge of SQL, Transact SQL, PL-SQL
  • Knowledge of PowerShell or other scripting languages
  • Experience with replication services
  • Working knowledge of MS SQL Server native auditing
  • Experience with database monitoring tools - Solarwinds or Idera a plus
  • Experience with DataMasker tool is a plus

About the Company

P

Phaxis LLC

We stand for PERSEVERANCE, as we refuse to quit when the journey gets tough. Your gold is our mission, and we search day and night to find it.
COMPANY SIZE
50 to 99 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
2002
WEBSITE
https://phaxis.com/