SanAntonioTXRecruiter Since 2001
the smart solution for San Antonio jobs

Database Administrator

Company: ConsultNet
Location: San Antonio
Posted on: June 10, 2024

Job Description:

Database Administrator 3 - Oracle
San Antonio, TX
12+ month contract
$53 - $54/hr

ConsultNet is seeking a Database Administrator with a focus on Oracle in San Antonio, Texas. 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. Develops databases with SQL, stored procedures, triggers, transactional modeling, dimensional modeling, normalization, indexing methods, constraints, and object usage.

Responsibilities

  • Builds and maintains the ongoing operational functionality and efficiency 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.
  • 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.
  • pplies understanding of modern networks and operating systems as they pertain to database system architecture and functionality.
  • Develops scripts to perform system maintenance, monitor systems, automate tasks, etc.
  • 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, views, etc.
  • 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.
  • Reviews project requests describing database user needs to estimate time and cost required to accomplish project.
  • On-call rotation is required to support 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.
  • pplies OEM (Oracle Enterprise Manager) for troubleshooting database performance tuning and generating reports using Information Publisher and BI Publisher reports.
  • Creation and configuration of Oracle Multitenant database environments. Required Skills
    • Bachelor's degree (or higher), or foreign degree equivalent, in Information Systems, Engineering, Computer Science or related field.
    • minimum of six years' experience in a Production Oracle ecosystem or higher education equivalent.
    • minimum of four years' experience with the following:
      • Hands on experience with Oracle database administration in UNIX and virtual environments.
      • Skilled in performing detailed performance analysis and resource utilization of systems.
      • Proficiency with Oracle backups, restores and recovery models.
      • Hands on experience with High Availability (HA) and Disaster Recovery (DR) options for Oracle (RAC/Data Guard).
      • Know-how in migrating code and database changes through the various stages of the development life cycle.
      • Skilled in troubleshooting and performance tuning skills with Oracle databases.
      • Experience in project management concepts, tools (MS Project) and techniques.
      • Hands on 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.
      • Installation, configuration and administration of Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.
      • OEM (Oracle Enterprise Manager) troubleshooting of database performance tuning and generating reports using Information Publisher and BI Publisher reports.
      • Skilled in using Recovery Manager (RMAN) and ASM (Automatic Storage Management) for backups and storage management.
      • Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.
      • Valid Class C Texas Driver's License.
        Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

        Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

        Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

        Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .

        We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

Keywords: ConsultNet, San Antonio , Database Administrator, IT / Software / Systems , San Antonio, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

San Antonio RSS job feeds