Junior SQL Server Developer Resume Samples

Description :

1. Works with support personnel, developers and software designers in designing, developing, and troubleshooting new and existing software programs and applications.
2. Communicates with support personnel, developers and IT to assist in resolving issues with software applications.
3. Defines, develops, and documents the application’s business requirements, objectives, deliverables, and specifications on a project by project basis in collaboration with internal users and external clients.
4. Defines project plans, including scope, schedule, and implementation.
5. Writes and codes software programs and applications in accordance with business requirements.
6. Designs, runs and monitors software performance tests on new and existing programs for the purpose of correcting errors, isolating areas for improvement, and general debugging.
7. Provides verbal and written project status reports.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Involved in publishing reports and process information critical to running company's business.
2. Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, & Functions.
3. Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
4. Implement database systems based on solutions that are proposed.
5. Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
6. Used the CTE function of SQL extensively to write queries for retrieving important data.
7. Created standard tables and mapped columns from various client tables.
8. Created After and Instead of Triggers to enforce data consistency and referential integrity.

Experience

10+ Years

Level

Senior

Education

MBA

Description :

1. Implemented of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
2. Rebuilt / Monitored the indexes at regular intervals for better performance.
3. Recovered the databases from backup in disasters.
4. Implemented Point-In-Time Recovery solutions.
5. Performed SQL Server service pack and Windows Service pack upgrades.
6. Extensively worked on Enterprise Manager for managing the database.
7. Troubleshoot performance problems and fine-tuning of databases.
8. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Installed and configured SQL Server 2005 successfully on Windows Server 2003.
2. Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
3. Error handling using Try-Catch Block.
4. Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
5. Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
6. Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
7. Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
8. Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
9. Created Master Child package using variables and Execute package task in SSIS.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Designed to make basic healthcare available in these communities.
2. Installs and Configures of SQL Server on windows OS.
3. Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user input.
4. Participates in the creating tables, indexes, constraints, triggers, procedures, views, user defined data types and user defined functions.
5. Extensively uses joins and sub queries to simplify complex queries involving multiple tables.
6. Uses SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
7. Researches emerging application development software products, languages, and standards in support of procurement and development efforts

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
2. Validated change requests and made appropriate recommendations.
3. Standardized the implementation of data.
4. Promoted database objects from test/develop to production.
5. Coordinated and communicated production schedules within development team.
6. Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
7. Managed user access and Created new security accounts.
8. Performed Backup and restore of databases.
9. Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Experience

7-10 Years

Level

Management

Education

Bachelors

Description :

1. Catered to more than 2 million customers, Everest Bank Limited (EBL) is a name you can depend on for professionalized & efficient banking services.
2. Developed the nation corporately, agriculturally & industrially.
3. Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
4. Involved in development and implementation of SSIS application solutions for various business units across the organization.
5. Modified and transferred the data using SSIS packages.
6. Developed, monitored and deployed SSIS packages.
7. Scheduled Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
8. Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.

Experience

2-5 Years

Level

Junior

Education

Bachelors

Description :

1. Worked with various teams like Business Stakeholders, Business Analysts, Application Developers, and Production Teams to identify needs and followed by solution options.
2. Involved in login and user management tasks such as Adding Logins, Roles, Groups to the Window NT and MS SQL Server.
3. Extensively used Transact-SQL to implement the business logic.
4. Created and managed Complex Database Objects such as Stored Procedures, Views, User Defined Functions, Indexes and Triggers to meet business requirements and policies.
5. Created complex ETL Strategies to populate the Data Warehouse/Data-Mart Facts and Dimensions.
6. Involved in complete life cycle of database including designing of database, populating look up data, creating Stored Procedure as per the front end requirement and commercial transitions, writing Triggers, creating User Defined Functions, and creating views to simplify the complexity of data structure.
7. Created report to improve the performance of SSRS Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure report with error description.
8. Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Experience

5-7 Years

Level

Executive

Education

Master's

Description :

1. Involved in requirements gathering and converting them into database related components Involved in installing and configuring of the SQL Server.
2. Created Tables, Views, Stored Procedures, User-defined Functions and other DML, DDL statements.
3. Extensively used Joins and Sub-Queries to simplify queries involving multiple tables.
4. Involved in the basic database backup and recovery Implemented user login and security.
5. Involved in the development, design, and testing of the system Involved in administrative tasks of managing users, logs and profiles.
6. Documented all the processes involved in maintaining MS SQL database Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
7. Involved in Normalization of the database and bringing it to 3NF.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Identifies and understands business needs during requirements gathering to effectively design, develop, test, and deploy reports or applications.
2. Stress test and optimizes the system for efficiency in a distributed database.
3. Analyzes internal processes and make recommendations for automated workflow processes with eventual implementation.
4. Proposes technical solutions, new application design, process flows.
5. Builds custom data imports as required.
6. Troubleshoots and problem solve SQL database issues.
7. Implements and tests software/server upgrades as needed to gain better functionality.
8. Proposes and implements database architectural changes to make database infrastructure highly scalable and optimized.

Experience

2-5 Years

Level

Junior

Education

Bachelor's