Oracle DBA

IBA InfoTech Inc.

Durham, NC, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

3 years minimum

Working hours

Regular working hours

Job source

ibainfotech.com

Tech stack

Software Documentation Databases Data Infrastructure Database Applications Database Design Oracle Exadata PostgreSQL MariaDB Microsoft SQL Server Oracle Databases Oracle (Applications) Systems Development Life Cycle

+4 more

Query Optimization Standard Sql Data Processing Snowflake

Job description

Perform applications database administration( Oracle) functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support
Actively monitor databases servers and respond to any alerts
Work with development teams in the database design process and make suggestions/recommendations based on the data manipulation needs of the application.
Works with customers on fixing production issues
Provide database support in all phases of SDLC
Work with team members to come up with solutions in line with the group’s standards
Participate in 24X7 on-call rotation schedule for various production support, database maintenance, housekeeping and installs
Collaborate with Operations Database group, Systems Administrators and Capacity Planning groups as and when the situation demands
Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
Evaluation and recommendation of software products in the database management arena

Requirements

Should have strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time
Proactive with strong team, interpersonal and communication skills
Setup DR and HA strategy and support routine DR testing
Establish database standards for operations, upgrades, migrations, and onboarding new applications and/or clients
Write clear, concise, well-organized user documentation to maintain standards and procedures
Balance various database infrastructure projects

Skills and Knowledge:

10+ years of experience in Oracle DBA with Exadata and RAC expertise
3+ years of DBA experience in other DBMS systems ( Postgres, MariaDB, SQL Server, and Snowflake)
5+ years of experience in Distributed replication technologies ( Oracle Goldengate, EDB Replication, etc)
5+ years of experience in the Mutual Fund /Financial Services industry is highly desired
Ability to work well in a team environment, as well as maintaining a flexible attitude is a must
Ability to develop and drive database administration strategies and initiatives as per the needs of the team
Ability to quickly synthesize ideas, options, and thoughts into solutions to management to aid in decision-making