Database Administrator 4

Job Requirements : 8+ years' experience

8+ years' experience

• Bachelor's Degree
• Please see all requirements that are needed in the attached position description. Candidates must meet these requirements.

Requirements :

• Experience in Oracle 19c / SQL Server Database Administration, Required 8+ years
• Experience with backups, restores and recovery models, Required 8+ years
• Experience in Oracle / BEA WebLogic 8.x, 9.x, 10.x,11 administration, Required 5 + years.
• Experience in High Availability (HA) and Disaster Recovery (DR) options, Required 5+ years
• Experience in Oracle WebLogic and Oracle Reports, Required 3+ years.
• Experience with Performance Tuning and Optimization (PTO) of Oracle and SQL server databases ,Required 8+ years.
• Experience in Implementing SQL Server / Oracle database security tools, Required 8+ years
• Experience in virtual environments, upgrading SQL versions, Required 8+ years
• Experience in Database administration including data modeling, configuration, security for versions, Required Oracle 5+ years, SQL Server 8+ years,
• Knowledge in design, development, implementation, and documentation of data systems.
• Experience in performance tuning, Required 8+ years.
• Vast experience in LINUX systems, Required 3+ years.
• Experience in using tools like Toad, Required 3+ years

Description of Work :

• Provide maintenance, support and assistance to database technologies including Oracle, SQL Server and Postgres databases with installation and configuration, database replication solutions, and database backup solutions.
• Install database management software and database patches on databases in any environment.
• Perform WebLogic installation, Configuration, Clustering, administration and user management.
• Review, install, analyze and implement security patches to be applied to remain CJIS compliant, Payment Cared Industry (PCI) compliant, and Michigan Cyber Security compliant.
• Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
• Calculate disk space requirements for existing and / or new installations and growth based on changing business requirements.
• Measure and / or forecast current capacity, gauge the growth of capacity over time, and factor in the anticipated capacity requirements to determine whether the existing infrastructure can sustain the anticipated workload.
• Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.
• Implement high availability and Disaster Recovery concepts like Always on, Clustering, Mirroring and Replication (Snapshot and Transactional).
• Set up (HA) High Availability solutions like Log shipping, Database Mirroring, Replication and Clustering as a part of Disaster Recovery (DR)
• Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.
• ctively manage, improve and monitor cloud infrastructure on Azure.
• Perform database tuning based on Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)
• Configure and manage secured environments using SSL and digital certificates.
• Experience in (ETL) Extracting, Transforming and Loading data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various SSIS / DTS packages.

Mandatory Skills :

SQL Server, Oracle 19c,TOAD, sql Developer, Postgres SQL, BEA WebLogic 8.x, 9.x, 10.x,11 Server, Apache http Server, Apache Tomcat Server