|
Search Jobvertise Jobs
|
Jobvertise
|
State of NJ DOH Database Manager Administrator Hybrid Position Location: US-NJ-Trenton Email this job to a friend
Report this Job
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 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 team's 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/developer's 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. Required/Desired Skills Skill | Required /Desired | Amount | of Experience | Consultant Experience | Install and configure new SQL Servers and databases (SQL Server 2017 or above). Managing multi DB environment setup (Including production). | Required | 5 | Years | | Extensive experience ensuring that all database servers are backed up and recovery is time tested to meet business's Recovery Point Objectives. | Required | 5 | Years | | Prior experience assisting developers with query tuning and schema refinement. | Required | 5 | Years | | Extensive experience writing new and understanding/reviewing/fine-tuning existing Stored Procedures. | Required | 5 | Years | | Good command of Microsoft excel, data validations, data cleaning, manipulation, reporting and pivot features | Required | 5 | Years | | Experience with SQL Server Integration services and Reporting services (SSIS & SSRS). | Required | 5 | Years | | Extensive experience with configuration of SQL Server Reporting Service for setting up reports from SQL and Oracle data sources. | Required | 5 | Years | | Prior experience with either production or development teams | Required | 0 | | | Extensive experience with failover clustering, replication, and other high availability technologies. | Highly desired | 0 | | | Prior experience troubleshooting SQL Server service outages as they occur, monitor system's health and performance. | Highly desired | 0 | | | Extensive experience working with developers to review scripts, and support frequent DB deployment activities. | Highly desired | 0 | | | Experience with Unix and Python | Highly desired | 0 | | | Prior experience with refinement and automation of regular processes, track issues, and document changes. | Desired | 0 | | | Good knowledge of XML and JSON Data structures. | Desired | 0 | | | Experience with deployment tools like Red Gate SQL. | Desired | 0 | | | Experience with Azure SQL databases and Azure portal features. | Desired | 0 | | | Questions No. | Question | Consultant Experience | Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? | | Question2 | Please list candidate's email address HERE. | | Question3 | Where is the candidate currently geographically located? | | Question4 | If the candidate resides more than 1 hour from the client site, will the candidate relocate for the position? | |
RICEFW Technologies Inc
|