Oracle/Snowflake DBA

Oracle/Snowflake DBA

02 Jun 2022
Florida, Jacksonville, 32099 Jacksonville USA

Oracle/Snowflake DBA

Our client is looking Oracle/Snowflake DBA for Long term project in Jacksonville, FL below is the detailed requirements.

Job Title : Oracle/Snowflake DBA
Location : Jacksonville, FL - Remote
Duration : Long term

Job description:

  • Daily maintenance, monitoring, performance analysis, trouble shooting, problem resolution, and user assistance required for all the Oracle/Snowflake database environments.
  • Work with a cross-section of internal IT organizations, including other DBA's, systems analysts, developers, outside consultants and the management team.
  • Participate in Information Technology projects as the primary DBA from inception of the project up and through the daily maintenance phase of a project.
  • Provide input into new and existing projects.
  • Responsible for the physical design and architecture.
  • Create, monitor, and maintain Virtual Data Warehouse(s) supporting various use cases.
  • Collaborate with the IDR Modeling team and DBA team regarding optimal clustering and partitioning of data.
  • Develop project estimates for database activities.
  • Develop database design documentation such as data decompositions and data flow diagrams.
  • Perform database, application and system architecture design.
  • Responsible for developing and maintaining scripts to create appropriate roles for the application teams, implementing Role Based Access Control (RBAC) and Row and Column Level Security (RCLS) for the Oracle/Snowflake objects.
  • Participate as Subject Matter Expert (SME) as required for design reviews and technology and tool selection.
  • Keep current on database systems and features, 3rd party tools, and industry standards.
  • Create and execute scripts for various database maintenance activities.
  • Provide guidelines for development and production environments.
  • Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases
  • Develop archival, backup and recovery strategy.
  • Plan, perform and monitor database backups.
  • Perform database recoveries as appropriate.
  • Serve as escalation point for database issues.
  • Extensive experience with Enterprise Data Warehouses and Data Marts required.
  • Capable of supporting and implementing technology projects as the primary DBA in support of business initiatives.
  • Ability to create and maintain positive and professional business relationships with both internal associates and external customers.
  • Diagnose database problems and implement solutions

Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.