Job Description
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.
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 database's 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
- Bachelor's 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
30+ days ago