SQL Database Developer Resume Samples

Description :

1. Allied Telesis is a world class leader in delivering IP/Ethernet network solutions to the global marketplace.
2. Created innovative, standards-based IP networks that seamlessly connect you with voice, video and data services.
3. Worked as an SQL Developer with the Business analysts for requirements analysis and gathering, development, testing, Implementation and project coordination.
4. Involved in Database designing (physical and logical) to meet requirements using ERWIN.
5. Created data-related documentation like file descriptions and definitions, entity relationships and attributes.
6. Designed new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development environment.
7. Created T-SQL scripts and stored procedures for data validation and data process tables.

Experience

2-5 Years

Level

Executive

Education

MS

Description :

1. Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
2. Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
3. Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
4. Created database documentation for table and column dictionaries and other reference material.
5. Optimized SQL scripts using execution plans, indexes, partitions and using Database Engine Tuning Advisor.
6. Wrote complex store procedures for data profiling process needed to define the structure of the pre staging and staging area.
7. Created logical and physical model of DW in design software like ER-Win.

Experience

2-5 Years

Level

Executive

Education

Diploma

Description :

1. Work-Performed Redesigned database objects like stored procedures, tables, views and was successfully able to increase the performance of the queries.
2. Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from various heterogeneous sources such as Oracle, Excel, CSV etc.
3. Used Complex transformations in SSIS packages with properties like Check Point, package configurations, SSIS loggings as well as custom loggings (using event handlers).
4. Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
5. Created and implemented Data Warehouse on SQL 2005 Server Analysis Services.
6. Optimized MDX queries and expressions that were used for displaying several user defined reports/matrix in a front end BI application.
7. Created several KPI's, perspectives, and calculated members that were eventually used in the BI application for reporting purpose.

Experience

2-5 Years

Level

Executive

Education

Diploma

Description :

1. Actively involved in gathering business requirements and specifications for the project which need to be implemented in the project and participate in agile team activities with release management.
2. Responsible for creating different documentations like Product Requirement Documentation (PRD), User requirement Specification (URS) and Functional Requirement specification (FRS).
3. Extensively created all data base objects like tables, views, stored procedures and indexes with optimization in point of view in support of the databases.
4. Captured and documented data business rules and definitions.
5. Involved in designing and applying constraints and rules for data integrity.
6. Created Indexes and Views on various entities of the databases.
7. Worked on Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Experience

2-5 Years

Level

Executive

Education

GED

Description :

1. Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
2. Successfully installed and configured MS SQL Server 2005 on the production server.
3. Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
4. Generated assessment reports to analyze the scope and complexity of the migration projects.
5. Converted the Oracle DB objects to MS SQL Server 2005 DB objects like tables, views, and stored procedures.
6. Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
7. Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Combined data from multiple tables using Inner joins and Left Outer joins Created logical and physical database design, data structures, primary key, .
2. Created database objects like tables, indexes, synonyms, sequences, views.
3. Created and managed a datawarehouse as well as related ETL processes.
4. Analysed, understood and extracted structured data sources.
5. Designed and documented logical, physical and dimensional data model for a centralised data warehouse.
6. Created mySQL code from data model and create database, in close coordination with developers.
7. Developed, managed and monitored the ETL process and run related ETL tools.

Experience

2-5 Years

Level

Executive

Education

MS

Description :

1. Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
2. Experienced in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers along with in- depth knowledge in query optimization & performance tuning.
3. Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
4. Created Indexes based on requirements like Clustered index, Non-clustered to increase the query performance.
5. Implemented the business logic and processing of the payment by developing stored procedures and scripts.
6. Created Cursors to facilitate the users to scroll through the Queues to perform manual operations on the payment.
7. Experienced in using Data driven Subscription to prevent unforeseen circumstances.

Experience

2-5 Years

Level

Executive

Education

BS

Description :

1. Involved in tuning and optimization of SQL statements.
2. Created/modified the stored procedures and functions to support data conversion.
3. Modified the existing shell scripts to support conversion process.
4. Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
5. Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
6. Involved in the Data warehouse data modeling based on the client requirements Developed Logical and physical database designs for the transaction.
7. Reviewed the data model with functional and technical team and assist developers, BI team and end users to understand the data model.

Experience

2-5 Years

Level

Executive

Education

Bachelors

Description :

1. Created complex queries and special stored procedures for database auditing purposes.
2. Involved in performing database Tuning, monitoring, and Scalability Testing Involved in the creation and maintenance of index using database engine tuning advisor wizard and Query optimizer.
3. Developed various data exception reports for data clean up and submitted to the client.
4. Gathered data elements needed for analysis of the data, decoding flat file data and loading into database tables using import wizard and bulk load.
5. Assisted in implementing and maintaining security for Oracle databases and internal applications for risk mitigation.
6. Provided change management, schema management, version control and migration for all applications and database objects as it relates to strategic support.
7. Maintained the change log for the data model and ensure that data models and databases are in synch on an ongoing basis.

Experience

2-5 Years

Level

Executive

Education

MS

Description :

1. Installed and configured MS SQL Server and Clients.
2. Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity.
3. Performed Data migration (import & export BCP) from Text to SQL Server.
4. Managed Disk space, memory and User connections.
5. Established DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server.
6. Performed query tuning and reduced response time by 60%.
7. Performed query plans and enforced indexing in each and every query.

Experience

2-5 Years

Level

Executive

Education

Bachelors