Oracle/SQL Server/PostgreSQL DBA

Skills:
8 Required In-depth knowledge of Oracle internal views, shell & SQL and PL/SQL scripting.
8 Required Experience managing Oracle databases versions on Linux systems including shell scripting and tuning.
8 Required Solid experience in managing Oracle version 19 databases, Real Application Clusters (RAC), and Active Data Guard.
8 Required Experience developing tools to administer large numbers of test & development database environments.
8 Required Experience with on-call and providing 24×7 coverage for supporting Production & Development database systems.
8 Required Experience designing, installing & maintaining large size databases.
8 Required Thorough knowledge and working experience in setting up infrastructure for databases in data centers at multiple sites including cloud infrastructure.
8 Required Working experience in moving live production, development and testing databases and applications hosted in different physical sites.
8 Required Experience with administration of Oracle database on Oracle Exadata database machine including configuration and patching.
8 Required Experience with administration of MSSQL Server, EDB PostgreSQL Enterprise databases.
8 Required Experience with migration, configuration and support of Oracle databases on AWS cloud infrastructure (others considered).
8 Required Experience perform Database refreshes/clones and provide support for building development and testing databases.
8 Required Experience troubleshooting the database software and its infrastructure and where necessary engage and support the software vendor with problem analysis and resolution.
4 Preferred Experience using Remedy, ITSM, PPM and ServiceNow.

Description:
TIERS project has increased demand due to Cloud Migration efforts. The increase in demand requires additional support with code releases in all environments, development, test, production, training and disaster recovery. Support is also required for improving the disaster recovery process to reduce the workload required to support Disaster Recovery. Duties include maintaining grid and database software, performance tuning, ASM/storage management, and administrating user/db security. This position will support Oracle database on Oracle Exadata systems. This position will also provide additional support for MSSQL Server Enterprise for a critical application in TIERS and this expertise does not exist on the team. The position is required to provide on weekends during a release and/or maintenance. The position is required to be Oncall. This position will also support for PSR Team including analyzing, troubleshooting, and executing data corrections production databases.