Senior Database Administrator - LanceSoft Inc
Quincy, MA 02116
About the Job
Senior Database Administrator
Quincy, MA
12 Months
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
EDUCATION AND EXPERIENCE
Quincy, MA
12 Months
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.
Source : LanceSoft Inc