Logo
Mindlance

Senior Database Administrator

Mindlance, Quincy, Massachusetts, us, 02171


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