Job Responsibilities:
Manages and maintains all production and non-production databases across multiple complex Oracle RDS DBMS implementations.
Sets standards and is responsible for design, creation, and monitoring of physical data storage, maintenance, access requests and security administration.
Performs backup and recovery on Database Management Systems, configures database parameters and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.
Optimize database access and allocate or re-allocate database resources for optimum configuration, database performance and cost.
Actively monitor existing databases to determine appropriate preventive actions to ensure high availability and optimal performance.
Understands the business drivers for multiple business units and ensures the database platform is appropriate to the business use.
Researches new technology and develops business cases to support enteric-wide database solutions. Works independently within a team, provides general direction with occasional work product reviews.
Accountable for quality, completeness, and on-time delivery of own work products.
Develop, manage and test database back-up and recovery plans for complex initiatives.
Install new applications and customize existing applications to be fit for purpose.
Recommend the appropriate database platform for the business use.
Proactively monitor performance and manage parameters to provide fast query responses.
Apply company policies and procedures to resolve complex issues.
Estimate efforts for assigned projects anticipating interactions across more than one team.
In depth knowledge of database concepts, designs, and architectures within multiple technologies.
Minimum Qualifications:
5+ experience with Oracle and 3+ years experience with Oracle RDS. Experience with AWS (3 yrs)components such as EC2, S3, RDS, Security Groups, Route 53, VPC , DMS in cloud infrastructure.
Benchmarking, Profiling queries to see where the time being spent.
3 + years experience using Jenkins, GitHub and Teraform.
Preferred Qualifications:
Experience with AWS RDS .
Experience with SQLdeveloper monitoring (3 years) and performance tuning
Experience with OEM Toolkit (5 years)
Any Graduate