Log In
Sign Up
br{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]>
Position description
Posting title
Data Base Administration – Oracle Expert M/F
Regular/Temporary
Regular
Job description
The incumbent will work on several project activities in Coordination with the different internal support teams here in STMicroelectronics, Greater Noida site.
Main activities to be performed:
- Installation, Upgrade of databases.
- Export/import of databases.
- Restore/rename of databases.
- Homogeneous and heterogeneous migrations
- Apply security patches, bug fixes and PSU
- Resolution of performance issue via good RCA
- Analysis of AWR/ADDM/ASH report.
- Homogeneous and heterogeneous migrations.
- Maintaining all SOX related compliance.
Profile
Qualification : BTECH (CS/IT/EC) and/or MCA
Experience : 8-11 Years of relevant experience in Database Administration (RDBMS: Oracle, MariaDB & PostgreSQL) + Knowledge of databases on Azure.
The candidate should possess in depth knowledge of the following areas:
Primary:
- Expert in Oracle Architecture.
- Installation/Creation of Oracle Software.
- Upgrade to latest version.
- Administration and troubleshooting of databases Servers running in Oracle.
- Offline/Online Backup of all production and non-production databases.
- Homogeneous and heterogeneous migrations for Oracle Databases.
- Recovery of databases.
- Expert in resolution of performance issues.
- Expert in instant tuning & resolution of Performance issue
- Shell scripting for automation of database jobs.
- Provide solutions of cases logged through Remedy Helpdesk ensuring SLA/MTTR is achieved as per defined objectives.
Secondary:
- Good knowledge of MySQL, MSSQL & Azure DBs.
- Installation/Creation/Upgrades of Databases.
- Administration and troubleshooting of databases.
- Backup & Recover
- Good in resolution of performance issues.
- Knowledge of Shell/Ansible/Terraform scripting for automation.
Skills and Experience:
- 6-8 years of work experience and strong knowledge in Oracle Databases.
- 1-2 years of MySQL, PostgreSQL & Azure Databases.
- Strong knowledge on RDBMS concepts & RDBMS Architecture.
- In depth knowledge of Oracle installation and upgrades
- Experience on resolving the performance issue & instance tuning.
- Good analyst of AWR/ADDM/ASH report.
- Good knowledge of scripting (Shell, Terraform, Ansible).
- Knowledge on backup & recovery of databases.
Qualification : BTECH (CS/IT/EC) and/or MCA
Experience : 8-11 Years
Position location
Job location
Asia-Pacific, India, Greater Noida
Candidate criteria
Education level required
4 – Bachelor degree
Experience level required
6-10 years
Languages
- English (2- Business fluent)
- Hindi (1- Basic)
Requester
Desired start date
01/08/2022
