Overview:
**Responsibilities**:
- Expert Designer to build and implement high availability Oracle databases (RAC, Data Guard) Oracle 12G or plus. SQL Server Standard & Enterprise
Expert Designer to build and implement high availability SQL Server databases 2012 or higher
Manage Oracle and MS SQL RDS systems in AWS cloud. Manage Cloud SQL databases in Google Cloud Platform.
Lead various projects from the database side and execute all related responsibilities. Ability to train other team members as required.
Design and implement database in accordance to end users’ information needs
Use high-speed transaction recovery techniques and backup data
Minimize database downtime and manage parameters to provide fast query responses
Provide proactive and reactive data management support and training to users
Determine, enforce and document database policies, procedures, and standards
Perform tests and evaluations regularly to ensure data security, privacy, and integrity
Good knowledge in All in memory Process of Oracle 12g or plus
Excellent knowledge of data backup, recovery, security, integrity, and SQL. Conduct periodic tests to recover databases. Develop and manage processes for carrying out these tests.
Familiarity with database design, documentation, and coding. Ability to write scripts.
Previous experience with DBA case tools (frontend/backend) and third-party tools
Flexibility to work depending upon time-zone of geographically dispersed teams
Develop and implement database strategy for licensing on-prem and in the cloud for various databases including Oracle, MS SQL Server, MySQL and PostgreSQL.
Basic systems knowledge of Microsoft Windows and major Linux distributions
Learn and support Google Big Query from database perspective
Willingness to learn continuously and pickup newer skills as required by the job
Qualifications:
A Bachelor of Science Degree in computer discipline is required.
Proven working experience of 7 years of Oracle DBA management and as an administrator
Some Experience in the manufacturing industry.
Knowledge in Scrum or agile methodology and tools such as Confluence and Jira.
Excellent communication skills including in English to deal in a multicultural technology environment.
Oracle Database 12c: SQL Fundamentals
Oracle Database 11g Administrator Certified Associate (OCA)
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Real Application Clusters 11g Certified Implementation Specialist
Oracle Real Application Clusters 12c Certified Implementation Specialist
Oracle Database 12c Certified Implementation Specialist
Oracle Database Performance and Tuning 2015 Certified Implementation Specialist
AWS or Google Cloud Platform certifications preferred