Senior Software Engineer
First American Corporation
Total des années d'expérience :6 years, 9 Mois
• Involved in development cycle including high-level design, data design, coding, testing, and creation of functional documentation.
• Involved in Database Designing.
• Installing and maintaining SQL Server database systems. Maintaining the database systems.
• Perform the tasks of creating logical data models and translating into physical database structures that integrate with existing database structures.
• Responsible for monitoring relational databases to optimize database performance, resource use, and physical implementations of databases.
• Developed large number of objects for database operations.
• Tune and Optimize long running queries.
• Created indexes to improve database performance.
• Designed SSIS packages to load the data into Data Warehouse.
• Extracted data from flat files and from RDBMS sources like Oracle and SQL Server.
• Created & published reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Involved in development cycle including high-level design, data design, coding, testing, and creation of functional documentation.
• Involved in Database Designing.
• Responsible for managing the complete aspect of design, development and delivery of data and database solutions.
• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Developed large number of stored procedures for database operations using T-SQL.
• Involved in the performance tuning and optimization of T-SQL queries.
• Created Views to enforce security and data customization.
• Created Ad-hoc queries for Search functions.
• Migrating database from SQL Server 2000 to SQL Server 2005.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Interaction with client on regular basis to track the project status.