• Used IAM(Identity and Access Management) for creating roles, users, groups and also implemented MFA(Multi-factor Authentication) to provide additional security to AWS account and its resources.
• Created S3 buckets in the AWS environment to store files, sometimes which are required to serve 
  static content for a web application.
• Created snapshots to take backups of the volumes and also images to store launch configurations of 
  the EC2 instances.
• Use workbench as Redshift database tool.
• Loading/Unloading data from Amazon Redshift.
• Managed Amazon Redshift access privileges.
• Created IAM(Identity and Access Management) policies using JSON script for users and groups.
• Use Amazon Simple Storage Service(S3) for Amazon Redshift data load.
• Involved in huge data migrations, transfer using utilities Bulk import export.
• Daily basis Data Loading (ETL) and verify data into Database. 
• Extensively worked using AWS services along with wide and in depth understanding of each one of 
  them.
• Highly skilled in deployment, data security and troubleshooting of the applications using 
  AWS services.
• Managed Amazon redshift clusters such as launching/saving the cluster.
• Implemented of the data analysis queries.
• Knowledge of Vertica, Amazon Redshift as Database Tools. 
• Possess a good quantity of experience and competency in C, Java, HTML, MS-Excel.
• Maintained the historical data of the client.
• Tested the database by inserting test data.

Possess high working qualities with good interpersonal skills, high motivation, fast learner, good team 
player and very proactive in problem solving to provide best solutions.
 

• More than 2 years of experience in IT having experience in Database Design, Development & Support of MS SQL Server 2008/2005/2000 for Production/development.
• Proficient in Relational Database Management Systems (RDBMS).
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• Developed User Defined Functions and created Views.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Created Triggers to maintain the Referential Integrity.
• Reviewed existing business procedures and recommended and implemented changes.
• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Experienced hands in Query tuning and performance tuning.
• Responsible for setting preferences for various ad-hoc requests and distribution of tasks.
• Trouble shoot problems with the various teams including network related issues
• Creating and automating the regular Jobs.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

• Used MS-SQL Server 2005, 2008 as Database Tool.
• Creating variable and Opening and fetching the values in the variables from tables.
• Deleting, dropping of the objects.
• Joining two or more tables and inserting data into table using PL block.
• Creating an SQL Server Database manually and through wizard.
• Did backup and restoration of smaller databases
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Provided disaster recovery procedures and policies for backup and recovery of Databases.
• Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.
• Installing SQL Server Client side utilities and tools for all the front-end developers/programmers
•  
• Possess a good quantity of experience and competency in C, Java, HTML, MS-Excel.
• Maintained the historical data of the client.
• Tested the database by inserting test data.
• Support to Database and other application support works.
• Support for loan modifications.
• Extensively worked using AWS services along with wide and in depth understanding of each one of them.
• Involved in huge data migrations, transfer using utilities Bulk import export.
• Daily basis Data Loading (ETL) and verify data into Database.