Now you can Instantly Chat with Govind!
About Me
- Highly skilled AWS Redshift/ SQL Server developer with 2 years 8 months of experience.
- Expertise in Loading/Unloading data from Amazon Redshift.
- Expertise in managing Amazon Redshift access privileges.
- Expe...Amazon Redshift.
- Expertise in managing Amazon Redshift access privileges.
- Experience in IAM (Identity and Access Management) for creating roles, users, groups and also implementing MFA (Multi-factor Authentication) to provide additional security to AWS account and its resources.
Experience in creating S3 buckets in the AWS environment to store files, sometimes which are required to serve
static content for a web application. - Experience in creating IAM (Identity and Access Management) policies using JSON script for users and groups.
- Created snapshots to take backups of the volumes and also images to store launch configurations of
the EC2 instances. - Expertise in Amazon Simple Storage Service(S3) for Amazon Redshift data load.
- Around 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.
- 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.
Skills
-
Intermediate
-
- 3 Years
Intermediate
-
- 3 Years
Intermediate
-
-
- 3 Years
Intermediate
-
-
- 3 Years
Advanced
-
- 3 Years
Advanced
-
- 3 Years
Intermediate
-
-
- 3 Years
Intermediate
-
- 3 Years
Advanced
-
-
- 3 Years
Advanced
-
-
- 3 Years
Intermediate
-
- 3 Years
Advanced
-
-
-
- 3 Years
Advanced
-
-
- 3 Years
Intermediate
-
- 3 Years
Advanced
-
-
Portfolio Projects
Description
- Used IAM(Identity and Access Management) for creating roles, users, groups and also implemented MFA(Multi-factor Authentication) to provide additional securityto 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.
Description
- More than2 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.
- DevelopedSQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
- DevelopedUser 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.
Description
- 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.
- Provideddisaster recoveryprocedures and policies forbackup and recoveryof Databases.
- Performance Tuningin SQL Server 2000 usingSQL ProfilerandData 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 ofthem.
- Involved in huge data migrations, transfer using utilities Bulk import export.
- Daily basis Data Loading (ETL) and verify data into Database.