- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Sql Server Database Developer Resume Samples
No results found
6-10 years of experience
Defined technical requirements for the data warehouse. Directed and designed the ETL process involving data quality and testing. Developed and documented Conceptual/Logical/Physical design. Constructed entity relationship diagram (ERD) for data modeling. Documented logical and physical database design. Developed database object as T-SQL, stored procedures, user defined functions, triggers, views, complicated queries, indexing, etc
- Trained business and end user to create ad-hoc queries that decreased dependency on IT by 90%.
- Developed database batch process to move reference data of the Traders to the Trading System. Extensively used Crystal report.
- Created alerts for successful or unsuccessful completion of scheduled jobs. Developed ad-hoc queries for end users.
- Developed and designed the Registered Rep Systems to advance the ability of local management and compliance professionals in the process of supervision and compliance of registered representatives.
- Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc.
0-5 years of experience
Planned, developed, tested, implemented SQL Server db import/export process for HR department to external client.
- Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.
- Created additional ad-hoc reports using MS Access for Operations Director.
- Received MS Sharepoint 2010 application development training covering Visual Studio 2010, Sharepoint Designer 2010
- Developed plans for Sharepoint 2010 rollout by department.
0-5 years of experience
Coordinated meetings with subject matter experts to gather requirements for Xerox Contract Database
- Designed Contract Retention database using SQL Server 2008 technology
- Developed data mapping documentation to establish relationships between source and target tables including transformation processes
- Developed and implemented SSIS 2008 ETL processes to load data from source files to target tables
- Created complex SQL views and stored procedures to join multiple tables for contract data interface files
0-5 years of experience
Migrated and exported data from SQL Server 2000 to 2005.
- Facilitated server Defense Information System Agency’s (DISA) Security Technical Implementation Guide regulations on SQL Server database servers.
- Implemented database and operating system updates on 6 database servers on 72 databases in 3 different environments.
- Designed, implemented and maintained clustered and mirrored database servers.
- Created database link between Oracle 10g and SQL Server 2005.
0-5 years of experience
Served as a Project Manager/Technical Lead for the group of software engineers executing development projects oversees. Developed comprehensive work break down structure and project plan to identify and tract progress on all development projects.
- Develop DTS script to migrate data from SQL*Server database to Oracle database.
- Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
- Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity
- Developed and deployed graphical user interface using Forms 6i for the end user and implemented custom reports using Reports 6i/2.5
- Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
0-5 years of experience
Recommend and implement database structural changes, security policies and backup/recovery specifications.
- Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.
- Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.
- Experience writing complex SQL Queries and Procedures.
- Day to Day included manipulation of XML, CSV and XSL files.
- Extended knowledge of using VB.net and VBScript for data manipulation.
- Exclusively assisted supervisor in managing over 20 real estate clients including HGTV and NYTimes.
- Received in house training on Endeca and implemented the software into our systems.
0-5 years of experience
- Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
- Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
- Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
- Designed and developed data models for the data warehouse using star and snowflake schema.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
- Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
- Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
- Scheduled and executed SSIS Packages using SQL Server Agent.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
0-5 years of experience
SQL Server
- Created Stored Procedures, User Defined functions, & Triggers
- Created SSIS Packages in BIDS
- Created and Deployed SSRS Reports in BIDS
- Data Modeling
- Managed SQL Server Agent Jobs
- Creation of complex database queries, & indexes
- Design, development, automation, and maintenance of inbound and outbound data transformation solutions
0-5 years of experience
Supporting disaster recovery including database mirroring and replication
- Creating and maintaining jobs
- Designing and creating SQL Server tables.
- Assisting in SQL Server optimization including indexing and query optimization
- Assisting in transferring databases, including TempDB, to new servers using TSQL scripts
- Writing SQL Server stored procedures using TSQL
- Writing, updating and supporting reports using TSQL
- Analyze end user database needs and provide efficient solutions
- Editing XML