Oracle DBA-Hybrid-Inperson

Title: Oracle DBA-Hybrid-Inperson Interview

Location: Quincy, MA, USA

Length: 6 – 12 Months with a possible extension

Restriction: W2 or C2C

Description:

***Local Only from MA, NH or RI***Must have recent client experience from these locations***In-Person interview*** 6 – 12 Months with a possible extension***Mainly remote but hybrid 1-2 possible in future***

Responsibilities

The Database Administrator is responsible for planning, implementing, managing, securing, and documenting databases utilized by IT applications EOHHS. The primary work location for this role will be located at 100 Hancock Street, Quincy, Massachusetts. The work schedule for this position is Monday through Friday, 9:00AM to 5:00PM. On-call for offhours duties to support production issues and application releases is required.

DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:

Involve in designing and implementing Oracle SQL, PostgreSQL, and MySQL Databases.

Supporting RDBMS database administration on Windows and Linux platforms.

Configuration/instantiating databases on AWS RDS or EC2s

Performing database upgrades and migrations to maintain compliance with organization, industry, and security standards.

Creating/managing Windows, Linux, or Unix scripts to perform Database administration and automation.

Implementing various databases storage options including but not limited to File or Block storage.

Creating and manage users connecting to databases.

Setting up and managing database audits and compliance reporting

Installing Oracle Grid for managing standalone instances.

Installing, Configuring and Supporting Oracle Data guard for replication

Implementing DB security through Data encryption solutions and strengthening data security efforts.

Setup database backups and recovery process for Disaster Recovery (DR) situations.

Monitoring database health and taking preventive or corrective actions.

Generating and reviewing AWR reports to identify and resolve performance issues with databases.

Perform SQL Tuning to improve application performance.

Assisting various business with unification and collaboration of data.

Understand and translate business requirements into Datawarehouse solutions.

Create data models and designs to meet specific business needs that require sourcing data from multiple source systems.

Leverage ETL tools such as Informatica to solve business use cases.

Configuring DB alerts, notifications with performance thresholds

Be available for 24x7 production support on a schedule basis.

Building/scheduling periodical DB reports/stats to senior management.

EDUCATION AND EXPERIENCE

Bachelors Degree in Information Technology or Computer Science, related degree, or equivalent experience.

6+ years of database administration and hands-on database architecture experience

3+ years of oracle database administration and data warehouse experience.

Excellent problem solving, interpersonal communications and project management skills.

Ability to understand and articulate the importance of achieving goals and meeting deadlines.

Experience working with the Oracle or other DBA support and vendors.

Database admin certifications