Mindlance
Senior Database Administrator
Mindlance, Quincy, MA, United States
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
• 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