Senior IT Consultant

Nanosoft Consulting Talent Page; Trenton (NJ); On-site; USD 60,000 - 80,000; Full time

Job summary

A technology consulting firm is seeking a Junior Database Administrator (Jr. DBA) in Trenton, New Jersey. The successful candidate will provide Oracle Database Administration support for both production and non-production environments, assist in daily activities, and eventually conduct tasks independently. Responsibilities include installation, performance tuning, and ensuring database availability. Candidates should have experience with Oracle and SQL Server, as well as a capacity for scripting to support database operations. This role offers an opportunity for significant technical leadership.

Qualifications

• Experience with Oracle Database Administration for production and non-production environments.
• Ability to create and manage SQL Server and Oracle environments on both Windows and Linux.
• Skilled in database backup, recovery, and performance tuning tasks.

Responsibilities

• Provide technical leadership for the architecture and design of internal databases.
• Assist senior DBA in daily activities and perform tasks independently over time.
• Implement and maintain advanced security features for databases.
• Collaborate with internal teams and third-party vendors regarding database maintenance.

Skills

Oracle Database Administration

SQL Server Management

Database Backup and Recovery

Performance Tuning

Scripting (Bash/Shell)

Advanced Security Features

Tools

Oracle

SQL Server

Job description

Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems.

This role will extend well beyond the end date listed.

Key responsibility of a Jr. DBA includes assisting senior DBA in daily activities and eventually performing below listed tasks independently.

Provide Oracle Database Administration support for production and all non-production environments as per program' and application teams requirements.

Ensure the availability of databases on a continuous basis.

Responsible for production support tasks including installation, upgrade, migration, backup, recovery, administration, performance tuning, troubleshooting, High Availability, capacity Planning, security etc.

Manage SQL Server in Windows and Oracle database in both Windows and Linux environments.

Create database-related bash/shell scripts and programs to backup, recover and support development and production environments.

Periodically testing backup and recovery process.

Setting up data guard or standby environment for oracle and SQL Server databases.

Setting up production/development/test environments and refresh data as per application/program/developers requirements.

Setting up oracle Enterprise Manager Grid Control, Oracle Management Server and Oracle Management Agent.

Deploy Oracle Agent to target database servers.

Implement Oracle and SQL Server Advanced Security features like tablespace level encryption, certificates, TDE etc.

Creating and maintaining documents for all database related tasks.

Experience with advanced security features like TDE implementation.

Work with state OIT for DOH's database requirements' implementation and maintenance.

Work with third party vendors to set up, maintain the databases and their corresponding configuration on DOH servers.
Also, to work with them resolving technical database related issues.

Work with Oracle support teams to resolve problems in the database environments, create service tickets and following it up later until a reasonable resolution is found.
Also upload documents and information as and when Oracle Support requests for the same while troubleshooting.

Plan, test and implement migration of databases to other servers.

Creating specific DDL for migrating and transporting data from one instance to another or from one host to another host.

Plan, test, troubleshoot database patching for both oracle and SQL Server installations.

Plan and analyze space requirements on different servers for different databases.

Creating SSIS packages in SQL Server environments to automate tasks and dbms_scheduler jobs in oracle environments.

Work with the Network, Business System Analysts, Application DBAs and Internal Development teams on database related tasks.

Configuring APEX in oracle and Reporting Services in SQL Server.

Create database-related bash/shell scripts and programs to support development and production environments.

Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS and database tools.