SQL Database Developer Resume Samples

A SQL Database Developer takes responsibility for developing SQL databases and writing applications using SQL databases. The job description entails designing tables, storing procedures, functions, and views. A well-drafted SQL Database Developer Resume indicates the following duties – developing high-quality database solutions; developing and implementing stores procedures and functions using T-SQL; reviewing and interpreting business report requirements; researching required data; building appropriate reporting deliverables; suggesting new queries; developing procedures and scripts; providing timely scheduled management reporting; and investigating exceptions relating to asset movements.

Top skills that can highlight a resume include – excellent understanding of T-SQL programming; excellent understanding of MS SQL server, good knowledge of HTML and JavaScript; experience with transparent data encryption; experience with SQL server reporting services; and familiarity with NoSQL/NewSQL databases. A degree in the field of computer engineering or a related discipline is a must.

 

SQL Database Developer Resume example

Sql Database Developer Resume

Objective : SQL BI Developer with 8+ years of experience in Designing, Development and maintenance of database applications using SQL Server R2/2012 in OLTP/OLAP/BI environment. Experience in Data Modeling, Multi-Dimensional Modeling, and involvement in creation of Star Schema and Snowflake Dimensional Schema using ER-Win Tool.

Skills : SQL, Python, Data Warehousing, ETL, Shell Scripting, PL/SQL, Spss, Hive, Cognos, Java, Hadoop, Tableau, AWS, Regex.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Masters In Electrical Engineering


Sql Database Developer III Resume

Objective : Database Administration unit with establishing and updating the organizations Oracle databases to support KEMIs strategy and objectives and maintain the integrity of the information required to conduct business and mitigate risk.

Skills : SQL, Vb.Net, VBA, SSRS, SSIS.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Master Of Science In Computer Science


Sql Database Developer II Resume

Objective : More than 10 years of Progressive IT experience in Database Design, Development, and maintenance using MS SQL Server 2012, 2008R2, 2008, and 2005 in Production and Development Environments in various domains. Over 3 Month of Experience as Sales Force Developer on current project. Ability to take the ownership and responsibilities and work with minimum supervision.

Skills : Designing database tables and structures, Creating views, functions and stored procedures.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.S. In Computer Science

Sql Database Developer I Resume

Objective : Experienced in all the stages of Software Development Life Cycle (Agile, Scrum) and in the migration and up-gradation of databases. Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements. Working experience on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.

Skills : Business Intelligence, SQL, Reporting, SSRS, SSIS, .NET.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Master's In Supply Chain Management

Assistant Sql Database Developer Resume

Objective : Over 8 years' experience as a MS SQL Server Developer/.NET Technologies mainly in Object Oriented Programming (OOPs) using C#, ASP.Net MVC, LINQ, Entity Framework, lambda expressions Good working knowledge on Multi-tiered Web Applications and design patterns like MVC, MVP and Factory ,Repository Designed and developed the Presentation layer and Data Access layer.

Skills : Creating views, functions and stored procedures, Writing optimized SQL queries for integration with other applications.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Assoiate Sql Database Developer Resume

Objective : More than 10 years of Progressive IT experience in Database Design, Development, and maintenance using MS SQL Server 2012, 2008R2, 2008, and 2005 in Production and Development Environments in various domains. Over 3 Month of Experience as Sales Force Developer on current project. Ability to take the ownership and responsibilities and work with minimum supervision.

Skills : .

  • Master of Science in Materials Science - August 2011(State University of New York - Stony Brook, NY)

Description :

    1. Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
    2. Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
    3. Combined data from multiple tables using Inner joins and Left Outer joins Created logical and physical database design, data structures, primary key, .
    4. Involved in the Data warehouse data modeling based on the client requirements Developed Logical and physical database designs for the transaction.
    5. Created complex queries and special stored procedures for database auditing purposes.
    6. 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.
    7. Created database objects like tables, indexes, synonyms, sequences, views.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.S. In Computer Science

Assistant Sql Database Developer I Resume

Objective : Over 9 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server for various business domains like Pharmaceuticals, Constructions, financial services and Health Care. Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.

Skills : .

  • Master of Science in Materials Science - August 2011(State University of New York - Stony Brook, NY)

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Technology In Technology

Associate Sql Database Developer Resume

Objective : Over 8 years' experience as a MS SQL Server Developer/.NET Technologies mainly in Object Oriented Programming (OOPs) using C#, ASP.Net MVC, LINQ, Entity Framework, lambda expressions Good working knowledge on Multi-tiered Web Applications and design patterns like MVC, MVP and Factory ,Repository Designed and developed the Presentation layer and Data Access layer.

Skills : Creating views, functions and stored procedures, Writing optimized SQL queries for integration with other applications.

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. Combine data from multiple tables using Inner joins and Left Outer joins Created logical and physical database design, data structures, primary key, .
    7. Involved in the Data warehouse data modeling based on the client requirements Developed Logical and physical database designs for the transaction.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Sql Database Developer/Administrator Resume

Objective : More than 10 years of Progressive IT experience in Database Design, Development, and maintenance using MS SQL Server 2012, 2008R2, 2008, and 2005 in Production and Development Environments in various domains. Over 3 Month of Experience as Sales Force Developer on current project. Ability to take the ownership and responsibilities and work with minimum supervision.

Skills : Creating database triggers for use in automation, Maintaining data quality and overseeing database security.

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. Created/modified the stored procedures and functions to support data conversion.
    5. Gathered data elements needed for analysis of the data, decoding flat file data and loading into database tables using import wizard and bulk load.
    6. Assisted in implementing and maintaining security for Oracle databases and internal applications for risk mitigation.
    7. Provided change management, schema management, version control and migration for all applications and database objects as it relates to strategic support.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.S. In Computer Science

Sql Database Developer Resume

Objective : Over 9 years of DBA experience on Data Design, Development and Administration on SQL Server 2014, 2012, SQL Server 2008 R2, 2008 and 2005 system in OLTP/OLAP environment. Experience in Oracle Database and Administration AND Development database. Expert in RDBMS concepts and constructs to design relational databases model and implementation as per business needs.

Skills : Creating database triggers for use in automation, Maintaining data quality and overseeing database security.

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.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors