* Having 3.8+ years of IT industry experience as a Developer and Administrator in IBM DB2, MS SQL Server, and Oracle.
* Experienced on UNIX Shell, Batch & PowerShell Scripting and prepared database and file management automation scripts along with the email alerts based on the environment and client requirements.
* Expertise on the Installation and configuration of IBM DB2, SQL Server, Oracle products on Linux/Windows platforms.
* Had good knowledge on PostgreSQL Development and Administration.
* Creation of database users and assigning quotas, roles, privileges, and profiles.
* Have knowledge on Database Replication.
* Written Views, Triggers, Procedures, Functions and Complex Queries.
* Having good knowledge on Indexes and Table/Index partitioning.
* Have good knowledge in the Query Optimization, Explain & Advisory Plans.
* Good Experience in Performance Tuning.
* Have knowledge on SQL & PL/SQL, T-SQL and SSIS.
* Verifying and resolving the SQL Server Blocking issues, Finding and fixing the root cause.
* Experience in Creating and Scheduling the jobs and troubleshooting the failed jobs.
* Prepared Batch/UNIX Shell/PowerShell scripts to automate DB Maintenance activities like daily backups, disk cleanup, tablespace management, log cleanup etc.
* Knowledge on Creating Reports and ER Models.
* Having good knowledge on Team/Workload Management.
* Having a good knowledge on the database standards and the best practices.