Remote position on Southeast Region ( EST / CST)
Could be asked to come onsite for critical meetings or all hands on deck type support (once in a while, ONLY if needed)
MUST have :
Candidates must have very strong working knowledge of IBM Power -AIX systems and support of Oracle DB's on AIX systems
Strong experience troubleshooting application issues and performance tuning (work closely with application teams supporting claims systems; previous exp supporting claims systems a plus).
Patching and upgrading of systems
Huge Plus : OCI exp and CMS audits
Preferred :
- Oracle Database Administration Certification.
- Prior working experience at GuideWell as Oracle DBA
- Added advantage of knowledge of administration of MongoDB Postgres, LDAP / OUD, MySQL.
- Working knowledge of Oracle cloud Infrastructure (OCI) and ATP databases.
Issued Equipment : Yes
Remote / Hybrid / Onsite : Remote
Background Requirement : Advanced v
Interview Comments : Supplier participation required for candidate introductions
Required :
year’s professional experience as an Oracle database Administrator with strong working knowledge of Operational / Systems DBA to setup and support Oracle c / c databases in RAC and Non-RAC environment on IBM Power (AIX) Systems.Must have knowledge of JSM / SOC / Hitrust audit requirements and working knowledge of DISA STIGSHands on working experience on Cloud infrastructure (OCI), supporting ATP databasesIn depth knowledge of the Oracle database architecture, hands on configuration experience.Working knowledge of Fleet Maintenance for OracleExperienced in installing, configuring, and upgrading Oracle databases and clusters. In vc.Experience in working container databases, Golden Gate.Experience in configuring and supporting Oracle Enterprise Manager.Experience in deploying Oracle on AIX Power - / Linux-RHEL / / and good understanding of operating system concepts of AIX and Linux (RHEL).Good knowledge of capacity planning and architecture design for database server deployment.Proven experience in working in a mission critical environment in a multi-terabyte database platform.Working knowledge of architecting, configuring, setting up data guard for HA solution.Experience in setting up backups using RMAN .Perform routine maintenance on several database environments including application of updates, patches, and hotfixesInstallation / configuration and implementation of custom scripts for monitoring and Performance Dashboard.Creating databases, migrating database objects from non-production to production environment.Designing and building data models, schemas, views, and tables to support application requirementsWorking knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.Extensive experience designing and executing backup and recovery concepts and proceduresMeasure database performance and troubleshoot complex database issues, I / O bottlenecks, SQL Tuning /Experience in using Splunk, Nimsoft for Availability and performance.Good understanding of licensing options and optimization.Experience in scripting languages (shell or python or Perl) for automating DBA administrative tasks.Experience with automation tools such as Control-M.Experience in implementing Oracle STIG implementation, testing, and other vulnerability remediation.In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.Provide x Support to Critical production systems.Knowledge of Project Management MethodologiesExperience in working closely with the application development teams to resolve any performance related issues and provide application support.Required Education : Bachelor’s degree in an IT related field or equivalent work experience.
Preferred :
Oracle Database Administration Certification.Prior working experience at GuideWell as Oracle DBAAdded advantage of knowledge of administration of MongoDB Postgres, LDAP / OUD, MySQL.Working knowledge of Oracle cloud Infrastructure (OCI) and ATP databases.Description :
The Adv. IT Database Administrator (Advanced DBA) provides consultation related to database management and administration. The Advanced DBA’s perform detailed data flow analysis ensuring the highest levels of efficiency in database and query design in distributed data flows. Advanced DBA’s administer database systems to protect the confidentiality, integrity and availability of data. The Advanced DBA is responsible for maintenance, control and testing of complex databases which provide orderly methods of data storage and controlled access to data. Advanced IT DBA’s also maintain complex query language for established database systems, design and execute backup and recovery schemes and implement disaster recovery procedures. The Advanced IT DBA serves as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.
Consults on database, architecture and related infrastructure technologies to all areas and levels within IT.Consults on exploiting opportunities involving multiple hardware and software systems, issue resolution, providing innovative business solutions, etc. to both internal and external customers and partners.Provides technical leadership on the implementation of leading-edge database technologies and the design and implementation of large-scale technical solutions based on business requirements.Develops and ensures compliance with all system, disaster recovery and security audit policies.Writes complex programming / scripts.Participate in disaster recovery design, testing and executionMonitor and evaluate database performance and adjust database configuration as appropriateProvide technical leadership to other DBAsDesign process for database change management issues related to environment migrationMake highly complex physical changes to current databases, often this requires working after hoursMaintain operational documentation (, procedures, task lists, architecture blueprints)Provide subject matter expertise to corporate projects and initiativesWork with users and IT partners to understand requirements for a physical database designProvide database consulting expertise to corporate projects and initiatives applying PMM and development life cycle conceptsAddress customer concerns and issues related to database managementEvaluate database performance and adjust configuration appropriatelyProvide production support for outages, restore / recovery eventsOptimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.Other duties as assignedEEO :
