ORACLE DBA

PROJECT OVERVIEW: EOHHS is looking for a Senior Database Administrator to join the team. 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. Oncall 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 handson 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

IT