Oracle Database Administrator

Are you an Oracle Database Administrator looking to join one of the top companies in the Energy and gas industry?

Are you looking to further your career and grow?

Do you have experience in a Production Oracle ecosystem or higher education equivalent?

If you answered yes to those three questions, then apply today!

Acara Solutions seeks highly qualified candidates to work Onsite with our client in San Antonio, TX. Interested?

Here's what you'd do:

• The Database Administrator position is responsible for backup, recovery, server architecture, performance tuning, security, auditing, metadata management, optimization, statistics, capacity planning, connectivity, and other data solutions of mission critical database systems.
• Develop databases with SQL, stored procedures, triggers, transactional modeling, dimensional modeling, normalization, indexing methods, constraints, and object usage.
• Builds and maintains the ongoing operational functionality and efficiency of client's databases ensuring system performance, availability, reliability, security, recoverability, and efficient usage of server infrastructure resources.
• Performs the capacity planning required to create and maintain corporate databases and processing demands.
• Provides all facets of database administration to production, development, and quality assurance systems.
• Ensures database system security, change management, backup, and recovery are maintained in compliance with corporate, state, and federal regulations.
• Provides database solutions to solve complex business issues including data processing, loading, performance improvements, data storage, and data replication.
• Diagnoses, troubleshoots, and resolves database related issues including storage, performance, availability, data integrity, and database security.
• Performs and automates database management, maintenance, and data processing activities.
• Applies understanding of modern networks and operating systems as they pertain to database system architecture and functionality.
• Develop scripts to perform system maintenance, monitor systems, and automate tasks.
• Performs as technology subject matter expert for relational database management systems such as Oracle 10g, 11g, 12c, 18c and 19c.
• Modifies existing databases and database management systems or directs programmers and analysts to make changes with appropriate database objects such as indexes, tables, partitions, triggers, constraints, stored procedures, large objects, and views.
• Works as part of a project team to coordinate database development and determine project scope and limitations.
• Writes and codes logical and physical database descriptions and specifies identifiers of database to management system or directs others in coding descriptions.
• Review project requests describing database user needs to estimate the time and cost necessary to accomplish the project.
• Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
• Administers all database objects, including tables, clusters, indexes, views and sequences, packages, and procedures.
• Evaluates releases of Oracle and its tools, and third-party products to ensure that the organization is running the products that are most appropriate.
• Troubleshoots issues associated with databases, applications, and development tools and provides technical support to application development teams.
• On-call rotation is needed to support a 24/7 environment and is also expected to be able to work outside business hours to support corporate needs.
• Installs, configures, and administers Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.
• Uses Commvault to perform database backups, point-in-time restore and recoveries.
• Applies OEM (Oracle Enterprise Manager) for troubleshooting database performance tuning and generating reports using Information Publisher and BI Publisher reports.
• Collaboration with various technical/non-technical resources such as infrastructure and application teams regarding project work, POCs (Proofs of Concept) and troubleshooting exercises.
• Analyzes Operating System statistics and troubleshooting performance related problems on storage, I/O (Input/Output) throughput and OS (Operating System) kernel parameters.
• Upgrades Oracle databases using logical standby to minimize downtime to applications.
• Creation and configuration of Oracle Data Guard to use physical, logical, snapshot standby databases, and Fast Start Failover.
• Performs Unix (AIX) and Linux operating systems tasks associated with Oracle.
• Creation and configuration of Oracle Multitenant database environments.
• Performs other duties as assigned.
• Makes independent recommendations.

Here's what you'll get:

Pay: $82.14/hr

Hours: 40 hrs/week

Length: Temp (12 months)

Sounds like a good fit?

APPLY TODAY

About Acara Solutions

Acara is a premier recruiting and workforce solutions provider-we help companies compete for talent. With a legacy of experience in various industries worldwide, we partner with clients, listen to their needs, and customize visionary talent solutions that drive desired business outcomes. We leverage decades of experience to deliver contingent staffing, direct placement, executive search, and workforce services worldwide.

Required Skills:

• Bachelor's Degree in Information Systems or Engineering or Computer Science.
• Minimum 6 years of experience in a Production Oracle ecosystem.
• Minimum 4 years of experience with Oracle database administration in UNIX and virtual environments.
• Minimum 4 years of experience with Oracle backups, restores and recovery models.
• Minimum 4 years of experience with High Availability (HA) and Disaster Recovery (DR) options for Oracle (RAC/Data Guard).
• Minimum 4 years of experience with project management concepts, tools (MS Project) and techniques.
• Minimum 4 years of experience as technology subject matter expert for at least three versions of relational database management systems such as Oracle 9i, 10g, 11g, 12c, 18c and 19c.
• Minimum 4 years of experience with Installation, configuration and administration of Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.
• Minimum 4 years of experience with OEM (Oracle Enterprise Manager) troubleshooting of database performance tuning and generating reports using Information Publisher and BI Publisher reports.
• Minimum 4 years of experience in Microsoft Office Package, including word processing, spreadsheets, presentation software, electronic mail and scheduling.
• Minimum 4 years of ERP experience.
• Minimum 4 years of Oracle administration experience .

Preferred Skills:

• Master's Degree in Information Systems.
• Oracle certifications (Oracle Autonomous database, Oracle Cloud Infrastructure, Oracle Certified Associate, Oracle Certified Professional).
• Experience in administering, patching, upgrading Oracle databases based on SAP ERP applications.
• Utility Industry experience.
• Experience with Hyperconverged infrastructure.
• NERC (North American Electric Reliability Corporation) background and experience.
• Performed database tasks using BR *Tools SAP related Oracle databases.
• Skilled in performing detailed performance analysis and resource utilization of systems.
• Know-how in migrating code and database changes through the various stages of the development life cycle.
• Skilled in using Recovery Manager (RMAN) and ASM (Automatic Storage Management) for backups and storage management.
• Good ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.
• Skilled in troubleshooting and performance tuning skills with Oracle databases.

Additional Information:

• Upon offer of employment, the individual will be subject to a background check and a drug screen.
• In compliance with federal law, all persons hired will be needed to verify identity and eligibility to work in the United States and to complete the necessary employment eligibility verification form upon hire.
• Indoor work, operating computer, manual dexterity, talking, hearing, repetitive motion.
• Use of personal computing equipment, telephone, multi-functioning printer and calculator.
• Ability to travel to and from meetings, training sessions or other business-related events.
• Exerting up to 10 pounds of force occasionally, and a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.
• Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Aleron companies (Acara Solutions, Aleron Shared Resources, Broadleaf Results, Lume Strategies, TalentRise, Viaduct) are an Equal Opportunity Employer. Race/Color/Gender/Religion/National Origin/Disability/Veteran.

Applicants for this position must be legally authorized to work in the United States. This position does not meet the employment requirements for individuals with F-1 OPT STEM work authorization status.