Logical Oracle DBA

Overview

Contract - W2
Contract - 12 Month(s)

Skills

shell script
Oracle HCC. PL/SQL

Job Details

Amtex Systems Inc is an information technology and talent solutions company offering talent and BI consulting to the companies in US for over 25 years.

Our solutions are designed to fill resource gaps, by providing the right candidates who deliver value to the organization. Our propensity to nurture and build strong relationships with our clients helps us better understand their business demands and gives us the ability to provide services that are on time and rise above the rest.


Logical Oracle DBA

3 days onsite downtown Dallas

12+ month contract


Need PL/SQL and Shell Script

Preferred Oracle HCC/Advanced Compression

Database Administrator

Primary responsibilities of the Database Administrator include supporting database operations including but not limited to performance monitoring, query optimization, code deployments, access management, and database analysis. The candidate will be responsible for operating in Oracle, Exadata, and SQL Server platforms and supporting database re-platforming efforts to include proper database sizing estimates. They will be responsible for creating database objects, investigating performance issues, table partitioning strategies and setup and monitoring data retention. They will work closely with data architects, data analysts, and database owners to support work requests related to performance monitoring, query optimization, code deployments, access management, and database analysis. The candidate must have strong technical and communication skills coupled with the ability to convey their findings and recommendations to large groups.

Responsibilities

  • Working knowledge of how to investigate and optimize SQL queries in SQL Server and Oracle/Exadata environments.
  • Monitoring of database performance to include, but not limited to, memory usage, proper backups, active sessions, long-running queries, tablespace configuration, and space allocations.
  • Coordinate with data architects and analysts on creating schemas, tables (including partitioning), functions, views, stored procedures, database access and roles.
  • Coordination with the automation team for the scheduling of database.
  • Write scripts to enable DBA specific processing and monitoring.
  • Complete routine database administration efforts as defined by the team DBA Lead.
  • Attend Oncor DBA team meetings and follow Oncor standard DBA practices as defined by the Oncor DBA Function Lead.
  • Runbook documentation to support DBA processes setup.

Qualifications

  • 3+ years of physical DBA experience, including experience across Oracle, SQL Server, Exadata, Postgres, Microsoft Access database servers.
  • Working knowledge of all aspects of Database Data Movement and Processing.
  • Familiarity with JIRA workflow processes and Agile methodology.
  • Working experience with Microsoft SQL Server Management Studio, DBeaver, TOAD, or Oracle SQL Developer.
  • Good Communication skills.
  • Self-Motivated.
  • Ability to multi-task and re-prioritize tasks as required by demand.
  • Capable of presenting to all levels of audiences.
  • Works well in a team environment.
  • Experience with Hadoop/MongoDB a plus.
  • Experience with MDM methodology and tools a plus.
  • Cloud experience a plus.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.