Create database objects such as tables, views, stored procedures, Triggers etc.
as per business needs.Working over schema objects and implementing rules for
data integrity in the project.Writing server-side PL/SQL and client-side
procedural code that use SQL statements.Be aware of potential Long Running
queries, blocking, deadlocking and write code to avoid those situations.Endure
that the code is written keeping in mind any security issues such as SQL
Injection.Develops Complex reports from the databases as requested by
management.Identify and write best possible code in case of current deployments or
when rewriting code.Participate in discussions involving the project creation
and understand the requirements and provide the back-end functionality for the
applications.SQL Database monitoring using RadGate tool,Sentry, SQL Profiler
and other related monitoring and troubleshooting tools.Good in Database
Migrations, performance tuning especially tuning complex queries, procedure and
indexing strategies.Ability to develop database objects like Stored Procs,
Functions, Packages,
Triggers, using SQL & PL/SQL. Expertise in the creation of
databases, table spaces, tables, indexes, users, grants, etc.Mentoring the less
experienced team members and highlighting best practices.Evaluate Relation
databases other than MSSQL features and products.Establish and maintain sound
backup and recovery policies and procedures to avoid minimum data loss.Helping
clients to develop the latest state-of-the-art databases that are fit for
purpose.Giving expert advice on SQL optimization, and other Database
performance issues.Setup and maintain documentation and standards.Basic
knowledge of Database Administrator activity as well related to permission and
other.Expertise in perform Database maintenance activity to make database more
operational.Good Working Experience in database tools like SSMS, Profiler,
Toad, SSIS and etc.Database Certification a plus.Good Written and Spoken
Communication skills
📌 SQL Database Developer (Pune)
🏢 Delivery Units
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.