Oracle DBA

InfoVision, Inc.

Posted Under: Irving, Texas jobs in IT / Software / Systems; IT / Software / Systems jobs in zipcode 75014
Posted On: 2020-08-03 00:00:00

JOB TITLE Sr. Oracle DBA JOB DURATION 12 month JOB LOCATION Irving, TX Database Administration team in Networks Systems IT Organization maintains all database systems. DBA team is responsible to manage all aspects of DBA roles ndash planning and designing cost effective, highly available, and scalable systems devising, implementing, and maintaining Backup, Archive, and Recovery strategies monitoring, troubleshooting, and tuning database systems for performance and analyzing system demand and ensuring capacity. This position is a Sr DBA in a centralized database administration team, which provides 7x24 support in devtestprod environments. Yoursquoll be mainly responsible for maintaining highly visible production databases. Plan, design, and build high performance database systems in the Network Systems. Partner with application teams to support databases for over 100 applications, many of them considered critical, complex, multi-terabyte OLTP database systems. Design next generation storage strategies around backup and recovery for complex database environments, physical structures, and specialized database appliances Uphold enterprise data security policy guidelines and recommend newimproved guidelines Partner with project teams and interact with application teams and technology vendors to customizefind solutions for projects and operational issues for existing and proposed databases Perform pro-active capacity planning, recommend and implement solutions to provide scalability, availability, security, stability, and performance Conduct benchmark tests to gauge hardware capacity and meet application capacity demand requirements Designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amounts of data (Terabytes) and high transaction rates. Capacity planning, SQL analysis, schema revisions, security administration and user account maintenance. Participating in an active on call rotation. Providing off hours support to avoid impacting database availability during normal business hours. Keeping up-to-date of new features and technical trends within the industry and being able to successfully communicate and apply those with application counterparts. What wersquore looking forhellip (Job Requirements) Yoursquoll need to have Bachelorrsquos degree or 6 yrs or more years of work experience. 6 yrs or more years of relevant work experience. Experience administering Oracle 19c12c11g RAC databases and PostgreSQL Solid working experience on Oracle Exadata and ZFS Storage Appliances. Experience on UNIXLinux and shell scripting Even better if you have Experience with planning, building, implementing, administering, and maintaining on High Availability (HA) Setup of Oracle Real Application Clustering (RAC) database on Oracle 11g12c19c RDBMS, Grid infrastructure (GI), Automatic Storage Management (ASM), Data Guard and applying patches of GI and Oracle 11g12c19c RDBMS software binaries on UnixLinux environments. Experience in Oracle multitenant architecture, Container database,PDB hot clones, PDB refresh, relocation, plugunplug and PDB level failover capability with Data Guard Broker. Strong Working knowledge in performance analysis, tuning, ensures optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring using Oracle Enterprise manager, SQL Tuning advisor, AWR, ADDM, ASH and other tools techniques. Experience with Performance Tuning Troubleshooting and find a quicker resolution. Experience with Software Products Oracle 12c19c, RMAN, Oracle Data Guard (Physical and Active), Golden Gate, Partitioning, Advanced Security, OEM 13c, Exadata with Extreme Flash Storage including patchingupgradeProvisioningmonitoring. Experience with PostgreSQL v9.x 10.x11.x12.x Experience with Operating Systems Linux (Redhat, CentOS, OEL), Solaris, HPUX, AIX. Experience with Hardware environments Exadata, AWS, HP, SUN, DELL. Experience with programming Language(s) SQL, UNIX and Shell Scripting. Experience with GoldenGate and numerous cutting Edge technologies. Experience with Amazon Web Services (AWS) technologies RDS, Postgres Aurora. Expert migrating databases to Cloud. Excellent analytical and communication skills. Solve complex problems, performance issues, and come up with innovative solutions. Proven teamwork collaboration skills to work across organizations and lead cross-functional teams. Proven problem solving skills to develop quick yet sound solutions to resolve complex issues. Nice to have Certification on OCP DBA, and AWSSDL2017

Apply for this job, view similar jobs, and more at!