Senior IT Consultant

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.

Other duties as assigned.