Sr. Oracle DBA

4 days ago


Dallas, United States Avance Consulting Full time

Job Description


Sr. Oracle DBA

Location: Miami, Florida or Dallas, Texas.


Shorter Version of JD:

A senior Oracle DBA is responsible for migrating, upgrading, designing oracle databases that meet the business requirements and specifications. This involves creating logical and physical data models, defining data structures and relationships, setting up database parameters and options, and implementing best practices and standards for database development. A senior oracle DBA also uses various tools and languages, such as SQL, PL/SQL, SQL*Plus, SQL Developer, and Oracle Data Modeler, to create, modify, and test database objects, such as tables, views, indexes, triggers, procedures, functions, and packages.

Detailed JD:

  • Assess database performance
  • Implement security measures for computer or information systems
  • Develop computer or information security policies or procedures
  • Update computer database information
  • Create databases to store electronic data
  • Set database parameters or specifications
  • Write computer programming code
  • Develop guidelines for system implementation
  • Develop performance metrics or standards related to information technology
  • Coordinate project activities with other personnel or departments
  • Read documents to gather technical information
  • Estimate time or monetary resources needed to complete projects
  • Train others in computer interface or software use
  • Coordinate software or hardware installation
  • Develop detailed project plans
  • Analyze data to identify trends or relationships among variables
  • Analyze market or customer related data
  • Develop models of information or communications systems

Key responsibilities of a Senior Oracle DBA:

Database Design and Implementation:

  • Architecting and designing new Oracle databases to meet business requirements, including data modeling, schema creation, and normalization.
  • Implementing database upgrades, migrations, and patching across different Oracle versions.

Performance Optimization:

  • Monitoring database performance metrics to identify bottlenecks and implement tuning strategies like index optimization, query optimization, and SQL tuning.
  • Analyzing database usage patterns and proposing performance improvements.

Backup and Recovery:

  • Developing and maintaining robust backup and recovery procedures for critical production databases.
  • Managing data replication and disaster recovery strategies.
  • Security Management:
  • Implementing and enforcing database security policies, including user access controls, data encryption, and auditing procedures.
  • Identifying and mitigating potential security vulnerabilities.
  • Capacity Planning:
  • Monitoring database storage usage and proactively planning for future capacity needs.
  • Analyzing database growth trends and recommending scaling solutions.
  • Troubleshooting and Support:
  • Diagnosing and resolving complex database issues, including performance degradation, data corruption, and application errors.
  • Providing technical support to application developers and other stakeholders.
  • Team Leadership and Mentorship:
  • Leading and mentoring junior DBAs on best practices, database administration tasks, and troubleshooting techniques.
  • Sharing knowledge and expertise within the database team.

Required Skills and Experience:

  • Deep expertise in Oracle Database Administration:

Extensive knowledge of Oracle database concepts, features, and administration tools.

  • SQL and PL/SQL Proficiency:

Strong ability to write complex SQL queries and PL/SQL procedures for data manipulation and automation.

  • Performance Tuning Skills:

Proven experience in identifying and resolving database performance bottlenecks.

  • Backup and Recovery Expertise:

Thorough understanding of Oracle backup and recovery mechanisms.

  • Database Security Knowledge:

Familiarity with database security best practices and implementation techniques.

  • Problem-solving and Analytical Skills:

Ability to troubleshoot complex database issues and provide effective solutions.

  • Strong Communication Skills:

Effective communication with technical and non-technical stakeholders to understand requirements and explain complex database concepts.


Job Insights


FMG


  • Oracle DBA Expert

    2 months ago


    Dallas, United States Diverse Lynx Full time

    Title: Oracle DBA Expert Location: Columbus, OH/Dallas, TX/Jersey City, NJ(Onsite from Day 1) Type: FTC/FTE Who are we looking for? A candidate with 10+ years of relevant experience in Oracle Database Administration. Knowledge of Goldengate and Real Application Testing (RAT) highly preferred. Technical Skills: • Strong experience administering...

  • Oracle DBA L3

    7 months ago


    Dallas, United States Omni Inclusive Full time

    Required Technical Skills - Primary • Extensive experience with Exadata Database Migration, Installation, Upgrades, and Patching. • Manage database objects like Table space, users, Indexes, roles, privileges, profiles, DB links, and synonyms. • Configuring and Administering the Oracle 12c, 18c and 19c. • Proficient in logical backup and recovery...


  • Dallas, Texas, United States United Software Group Full time

    United Software Group is seeking a highly skilled Senior Oracle Enterprise Database Administrator to join our team in Dallas, TX or Lake Mary, FL. The estimated salary for this position is $120,000 - $180,000 per year.About the JobThis is a full-time, permanent hire opportunity for an experienced Oracle DBA with a strong background in designing, installing,...


  • Dallas, United States TEKsystems co Allegis Group Full time

    DescriptionOne of TEKsystems' clients, an enterprise organization and leader in their respective industry, is looking for a Sr. Level Systems Analyst (Oracle SME) to join their team. The company has embarked on a large, enterprise-wide, digital transformation that includes a migration from Oracle on-prem to Oracle Fusion Cloud for many of their applications...

  • AWS Redshift DBA

    36 seconds ago


    Dallas, United States Mastech Digital Full time

    Job DescriptionJob DescriptionMastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking an AWS Redshift DBA for our client in the Energy domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a...


  • Dallas, United States Optomi Full time

    Oracle Functional LeadOptomi, in partnership with a building materials company, is seeking an Oracle Functional Lead in a hybrid position in Dallas, TX. This Functional Lead will support finance modules (General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Expense Management, and Cash Management) within Oracle Fusion. This candidate will have...


  • Dallas, Texas, United States SysMind Tech Full time

    Job Description We are seeking a skilled Sr. Oracle Hyperion Financial Management Expert to join our team at Pearson, working closely with TCS in the United States. As a key member of our Hyperion Development team, you will be responsible for developing and implementing Oracle Hyperion Financial Management solutions that drive business growth and efficiency....


  • Dallas, Texas, United States United Software Group Full time

    About the PositionWe are looking for a highly skilled Oracle DBA to join our team at United Software Group in Dallas, TX/Lake Mary, FL. This is a full-time, permanent hire position with a competitive salary range of $120,000 - $180,000 per year.Key ResponsibilitiesDesign, install, configure, administer, patch, upgrade, tune, backup and recover Oracle...


  • Dallas, Texas, United States CoSM Full time

    Job Title:Sr. Retail SystemsJob Description:We are seeking a highly skilled and experienced Senior Systems Administrator to join our team at CoSM. As a key member of our IT department, you will be responsible for designing, deploying, and maintaining large-scale Oracle Micros POS systems across multiple locations.Key Responsibilities:Design, implement, and...


  • Dallas, TX, United States Infosys Limited Full time

    Oracle HCM Cloud Techno-Functional Sr. Consultant Infosys is seeking an experienced Oracle Cloud HCM Techno-Functional Senior Consultant with multiple upgrade and implementation experience, covering all modules of Oracle HCM. This position’s primary responsibility will be to interface with key stakeholders, own end to end responsibility and accountability...

  • Sr. C++ developer

    2 months ago


    Dallas, United States Diverse Lynx Full time

    Role:- Sr. C++ developer Location- Dallas, TX / New York, NY /Salt Lake City, UT - ONSITE roles/No Remote Duration- Long Term Job Description: Strong programming skills in C++ with proficiency in object-oriented design principles Experience with Java frameworks such as DropWizard, Spring and Hibernate Familiarity with web development frameworks...


  • Dallas, United States InfoVision Inc. Full time

    We are looking for a Sr Salesforce Solution Architect who have been Have been actively involved in design and implementation of merging two separate salesforce instances into one single instance including object and data mapping. Required Skills/ Experience:Experienced in all the various modules, but specifically Sales and Service CloudHighly experienced in...


  • Dallas, United States InfoVision Inc. Full time

    We are looking for a Sr Salesforce Solution Architect who have been Have been actively involved in design and implementation of merging two separate salesforce instances into one single instance including object and data mapping. Required Skills/ Experience:Experienced in all the various modules, but specifically Sales and Service CloudHighly experienced in...


  • Dallas, United States Bridge Technologies and Solutions Full time

    Description: The successful candidate will be responsible for capacity planning in the (development, test, staging & production) environments in support of a number of critical applications for both SQL and Oracle databases. The role needs to ensure database availability, data integrity for multiple database instances across both platforms. DBA will be...

  • Sr. Accountant

    2 months ago


    Dallas, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are looking for a skilled Sr. Accountant to join our team in Dallas, Texas. In this role, you will ensure the accuracy and efficiency of customer credit applications, maintain customer records, and address customer queries. You will also monitor customer accounts and take appropriate action when needed.Responsibilities:•...


  • Dallas, United States Hireteq Solutions Inc. Full time

    Sr Application Support EngineerLocations: Coppell, TX, Jersey City, NJThis is a Full-time/Permanent Position with our Client (Visa sponsorship is not available for this role)Distributed application experience must have.Job description for Jersey City ,NJ:Hands on experience in distributed systems like Unix, Linux, Windows, SQL/PLSQL.Experience supporting...


  • Dallas, United States Hireteq Solutions Inc. Full time

    Sr Application Support EngineerLocations: Coppell, TX, Jersey City, NJThis is a Full-time/Permanent Position with our Client (Visa sponsorship is not available for this role)Distributed application experience must have.Job description for Jersey City ,NJ:Hands on experience in distributed systems like Unix, Linux, Windows, SQL/PLSQL.Experience supporting...


  • dallas, United States InfoVision Inc. Full time

    We are looking for a Sr Salesforce Solution Architect who have been Have been actively involved in design and implementation of merging two separate salesforce instances into one single instance including object and data mapping. Required Skills/ Experience:Experienced in all the various modules, but specifically Sales and Service CloudHighly experienced in...


  • dallas, United States InfoVision Inc. Full time

    We are looking for a Sr Salesforce Solution Architect who have been Have been actively involved in design and implementation of merging two separate salesforce instances into one single instance including object and data mapping. Required Skills/ Experience:Experienced in all the various modules, but specifically Sales and Service CloudHighly experienced in...

  • Senior Data Expert

    2 weeks ago


    Dallas, Texas, United States Genesis10 Full time

    Genesis10 is currently seeking a highly skilled Sr. Data Analyst to join their team in Dallas, TX.About the JobThis is a 6+ month contract opportunity for a Sr. Data Analyst with experience in data anomalies, ETL, and data management initiatives. The successful candidate will work closely with Business, DBA, ETL, and Data Management teams, providing analysis...