Job Description :
Title: Database Administrator Duration: 1 Year + Location: Irving, Texas Job Description Database Administration team in Networks Systems IT Organization maintains all database systems. DBA team is responsible to manage all aspects of DBA roles - 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 dev/test/prod environments. Youll 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 new/improved guidelines Partner with project teams and interact with application teams and technology vendors to customize/find 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 were looking for (Job Requirements) Youll need to have: Bachelors degree or 6 yrs or more years of work experience. 6 yrs or more years of relevant work experience. Experience administering Oracle 19c/12c/11g RAC databases and PostgreSQL Solid working experience on Oracle Exadata and ZFS Storage Appliances. Experience on UNIX/Linux 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 11g/12c/19c RDBMS, Grid infrastructure (GI), Automatic Storage Management (ASM), Data Guard and applying patches of GI and Oracle 11g/12c/19c RDBMS software binaries on Unix/Linux environments. Experience in Oracle multitenant architecture, Container database,PDB hot clones, PDB refresh, relocation, plug/unplug 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 12c/19c, RMAN, Oracle Data Guard (Physical and Active), Golden Gate, Partitioning, Advanced Security, OEM 13c, Exadata with Extreme Flash Storage including patching/upgrade/Provisioning/monitoring. Experience with PostgreSQL v9.x /10.x/11.x/12.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 AWS.