Sr Oracle DBA

Durham, NC

Company Name :Ibainfotechinc

Type : contract

Primary Skills : Oracle DBA Postgres, MariaDB , SQL Server

Location : Durham

CTC : DOE

Job Description:

Primary Responsibilities:

  • 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
  • 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