Description

Job summary and Responsibilities

1. 8+ years Oracle DBA experience on installation, testing, commissioning, trouble shooting on production and development servers.
2. The scope of this job is Oracle and MSSQL database administration, which is responsible for the installation, testing, configuration, trouble shooting and maintenance of Oracle 9i, 10g, 11g,12c and 19c technologies and Microsoft SQL Server (2012–2022)
3. Handle P1/P2 critical incidents escalated from L1/L2 teams.
4. Analyze AWR, ASH, ADDM reports for performance bottlenecks. Tune complex SQL queries and execution plans. Identify issues related to: CPU, I/O, memory contention; Locking/blocking sessions; Deadlocks and long-running queries
5. Additionally, resources will assist with disaster recovery (DR) designing, planning, and implementation processes.
6. Responsibility lies in configuring, managing, and reporting on all Oracle and MSSQL database Server environments including standalone and Clustered environments.
7. Make recommendations to improve performance or capacity of current environments.
8. Expertise on Disaster Recovery, Backup and recovery support.
9. Good experience on Oracle database migration.
10. Experience with Golden Gate is essential.
11. SQL Server Always On / Replication / Clustering and Investigate replication lag and data sync failures
12.



Positive experience on backup and recovery using RMAN integrated with Commvault/NetApp’s and SQL Server backups
13. Shell Scripting and automation with any tool is required.
14. Experience on PERL/Shell scripting knowledge will be an added advantage.

Primary skills (100%) / experience

Oracle and MSSQL Database administration

How are the primary skills / experience applied?

New installation, Upgrades, Automation scripts for Oracle/SQL Database, Troubleshooting Oracle/PSQL Large Scale Database issues. Supporting project teams for their data needs.

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 577932
- Project Location 1 : Pan India
- Project Location 2 : (No Value)
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : [email protected]
- Relevant Experience : 8+
- Mandatory skills : Oracle Administration + MS SQL Administration
- Desired skills : Oracle Administration + MS SQL Administration
- Domain (Industry) : Telco-Preferred , Service based
- BGC (Before onboarding / After onboarding) : PreOB
- Total Experience (Ex. 5-7 Years) : 8+
- BGC Details : NA
- BGC Vendor : NA
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : 2 PM -11:30 PM IST
- Shift Timings : Others

📌 577932_Oracle Administration + MS SQL Administration (India)
🏢 Trigent Software
📍 India