Senior Database Administrator

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