Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Responsibilities:

• Key responsibility of this 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 DOHs 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.