Oracle /PL SQL Database Developer

Tata Consultancy Services

pune,Maharashtra

Job Description

About the job

About the job

Greetings from TCS !!!

Role : Oracle /PL SQL Database Developer

Desired Experience Range: 6-8 years.

Location of Requirement : Pune.

Must Have :

• Experience in PL SQL Server and its different versions.
• DDL, DML, Trigger, Cursors, Materialized View, Packages, Permission/privileges, Schema, DBLinks, Various database objects
• Experience on Installing, Configuring, Managing, Monitoring, Upgrading and Migrations in Production Environment.
• Experience in Database Backup and Recovery procedures.
• ·Good experiences in resolving blocking/locking and dead lock Issues.
• Implement and maintain database security (Creating Logins/Users and also maintaining Roles/Securable(s)).
• Experience in Log Shipping, Mirroring and Performance tuning.
• Maintaining and troubleshooting Replication and knowledge on Clustering.
• Recovery of database at the time of instance/database crash.
• ·Work as part of a team and provide 24x7 production supports.
• Strong knowledge of service management, Incident, Change and Problem management processes

Good to Have :

• Customer facing experience – Excellent Good communication skills
• Knowledge on SQL Server BI, ETL
• MES or manufacturing domain knowledge
• Pharma domain knowledge
• Experience in Cloud migration project.
• Experience in Azure Date Engineering,
• Create ADF e2e pipeline
• Should have sound understanding different azure storage.

Background:

• Experience in SQL server
• ·Computer Science / Engineering

Others:

• Knowledge of databases like Oracle, NoSQL will be helpful
• Knowledge of Azure Cloud will be helpful.