- 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 Developer Resume Samples
No results found
0-5 years of experience
Developed stored procedures, views, triggers using T-SQL that included all the current functionality and added additional functionality to calculate different types of Commissions, bonus amounts and advances.
- Debugged the processes, triggers, views, monitored the system and SQL server job schedule and recorded any errors.
- Monitored daily Processes for different Data Loads and resolved Issues.
- Integrated Employees information with their compensations, maintained all Employees information in one central database, maintained historical information of commission received and commissions paid to handle inquiries from Employees.
- Analyzed the performance, tuned and optimized, supported database objects to migrate to production level, executed stored procedures, index sizing.
- Prepared documentation for end user training.
0-5 years of experience
EAO project of Web Statistics and Analytics group of Global Wealth Investment Management. EAO project was to analyze the users behavior while they investing in ML products online; Which page investors had problem with and investor took more time to finished application.
- Data architecture, design and creation of MS SQL tables, views, triggers and other objects required for web statistics & analysis.
- Created SSIS Packages to Extract, Transform and Load (ETL) the data into Reporting instance to generate the reports easily and quickly.
- Identified and resolved data quality issues with Data Profiler.
- Created and troubleshot stored procedures and queries performances using SQL Server Profiler, Performance Monitor and DBCC Commands.
- Developed ad hoc and customized reports using SQL Server Reporting Services (SSRS).
- Converted DTS packages to SSIS packages, validating the packages, and migrating to SQL Server 2005 Integration services.
6-10 years of experience
Designed, developed and maintained new business reporting and asset management solutions on an interactive corporate application platform that incorporates sophisticated document search, navigation and bulk upload & download interface, financial data and reporting portals using ASP.NET C# 3.5/4.0, SQL Server stored procedures and views
- Created and configured standardized data feed templates for the on-going collection of monthly financial data into the database
- Configured the necessary table structures in the database to collect and normalize business data
- Resolved known issues and bugs in the corporate platform interface and back end database
- Designed and developed interactive user interface with rich user experience using Jquery, AngularUS, Infragistics/Telerik
0-5 years of experience
Designed and developed procedures to handle high-volume of data (100 million+)
- Created and maintained fairly complex SSIS packages pulling from multiple source types
- Implemented SSIS package configurations (Environment Variable and SQL Server)
- Developed loan portfolio data warehouse in team environment driven by SDLC
- Worked with business analysts and others to develop project specifications
- Maintained data model in Visio Architect (with some experience in Erwin)
- Conceived, designed, and developed SSIS solution to compare databases to data model
6-10 years of experience
Developed complex T-SQL stored procedures and views for customers’ highly customized
reporting demands
- Designed star and snowflake schema data warehouses for customer data using ROLAP
- Managed hosting/cloud facility setup and deployment
- Primary managed hosting/cloud facility DBA
- Recommended query and index improvements in application to increase performance
- Performed training sessions
0-5 years of experience
Migrated Data and SSIS Packages from SQL Server and BI tools from 2008 R2 to 2012.
- Developing custom web parts and component for SharePoint.
- Loaded data from various sources (MS Excel, MS Access, Flat Files to SQL Server using SSIS/DTS)
- Designed SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets.
- Deployed, monitored, scheduled jobs and maintained SSIS packages.
- Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them. Extensively worked on cross-tabbed and Matrix reports using SSRS.
- Integrated ASP.Net Webpages to the SQL Server 2012 as Back End.
- Constructed cubes based on data volumes mostly adhering to Star Schema
- Programmed user Defined Functions, Views and TSQL Scripting for complex business logic.
- Production Support, real-time performance and concurrency issues
- Authored technical design documents for the schema and stored procedure specifications
0-5 years of experience
- Performed data conversion from separate legacy systems into the data warehouse, designed stored procedures to converge the data into Universal Data Store, responsible for data conversion and facilitated testing with the business clients using SSIS for SQL Server 2000
- Prepare dimensional modeling and star schema design using Erwin modeling tools
- Develop funded loan data mart by extracting data from 8 source systems into the staging area. Transform extracted data by loading data into the star schema.
- Designed and built OLAP cubes, defined calculated members using MDX expressions, created Cognos Power Play reports for the business users
0-5 years of experience
Designed, Developed and Deployed sales reports in MS SQL Server environment using SSRS-2012.
- Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
- Designed packages to extract data from xml file and load into Data warehouse
- Created dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
6-10 years of experience
Developed 15 parametrized summary and detail reports including pie charts and sub reports for a new client in accordance with specifications provided. Report types included drilled down, click through, and linked reports. Worked closely with the client to verify the results, resolve issues and make changes as requested.
- Converted 20 VB6 reports to parametrized SSRS reports. Analyzed the results of the VB6 reports for accuracy before the conversion and worked with the business to fix any issues. All reports used stored procedures to access the data needed to develop the reports.
- Designed and developed SSIS packages for loading data from previous database schema versions into current schema versions. Converted extracted data as needed and created new data to ensure integrity.
- Loaded excel, text, SQL Server and other source data provided from clients utilizing SQL, DTS and SSIS into SQL Server databases. Applied data conversions using lookup, merge join, aggregation, derived columns and script tasks. Verified data accuracy, data completeness, data integrity and application functionality.
- Developed SSIS packages to extract completed sales order information for export to client applications.
- Created a scheduled SSIS package to integrate client’s customer and configuration data into a SQL Server operational database.
- Provided database administration including modifying the database structure from information given by application developers by creating change scripts to modify or add tables, columns, keys, triggers, stored procedures and views. Created scheduled database backup and maintenance plans. Created and maintained data archive processes utilizing store procedures and job scheduler. Create and maintain database security levels. Developed SQL queries to extract data from table(s) to be used for analysis, testing and decision making. Used SQL profiler to analyze SQL queries.
- Provided technical support and analysis to field implementation specialists during client implementations and system upgrades.
0-5 years of experience
Designed and developed Packages, Stored procedures, Functions and Triggers, Views and complex SQL statements for applications.
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Rules and Defaults.
- Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS).
- Created automated stored procedures for day end operations using SQL Server agent.
- Coordinated with front-end for implementing logic in stored procedures and functions.
- Created jobs, alerts to run SSIS packages periodically.
- Designed SSIS package to export and import data from SQL Server to Access, text files and Excel files.
- Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements.
- Performed Server installation and configuration using SQL Server 2005.
- Automated processes using SQL Server jobs.
- Environment: MS SQL Server 2005, MS Access, Windows Server 2003, HP-UX.
0-5 years of experience
Process client-provided doctor and patient health information for production releases.
- Create, modify and maintain customized Transact-SQL (T-SQL) scripts.
- Analyze data trends and resolve client functional questions in a timely manner.
- Create database backups and restore databases in preparation for production runs.
- Monitor and maintain disk space for SQL Server 2008.
- Gather and consolidate release notes for production releases.
- Assist with charting project milestones and provide input to project lead by creating and providing weekly status report.
0-5 years of experience
Designed, developed, and tested databases and processes using SQL Server 2000, SQL Server 2008 R2 databases to manage HealthX, Eligibility, Flex, Providers and Claims transactions.
- Plan, design, and implement application database code objects, such as stored procedures and views.
- Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
- Work with business stakeholders and application developers do identify business needs and discuss solution options.
- Support processes for healthx, eligibility, and claims groups by upgrading, troubleshooting and testing.
- Create stored procedures and SQL scripts to query databases, develop processes that simplified and made more efficient data entry and transaction processes to extract/load/update data in SQL Server database.
- Automate processes and create stored procedures that significantly decreased monthly and quarterly reports run time.
- Actively work on SQL Server upgrade project.
0-5 years of experience
Upgraded SQL Server 2000 to SQL Server 2005.
- Documented and setup log shipping, database mirroring as HA/DR solution and created run book for DR Failover exercise.
- Created Triggers to enforce data and referential integrity.
- Created stored procedures for maintaining SQL Server.
- Created partitioned view and partition tables for large tables.
0-5 years of experience
Participated in the creation of the replacement system that would facilitate the accurate and timely payments to banks from the FDIC for bad mortgage debt
- Maintained existing SQL Server databases and provided on-call support for production issues
- Troubleshot development issues, data analysis, loading issue resolution
- FDIC background check
0-5 years of experience
Creating SSIS Packages by using multiple transformations such as Data Conversion, Conditional Split, merge, data viewer, source and destination adapters, union all etc.
- Using Bulk Insert and T-SQL to insert large files. Using T-SQL/ store procedure to fetch, transform and merge data.
- Analyzing mapping document by identifying look ups and dictionaries. Re-mapping fields by using logic functions and backfilling production tables.
- Scheduling Agent jobs to run daily. Creating and modifying views, store procedure, Linked server, tables, schema and synonyms.
- Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
- Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the Client data from various source systems feeds using SSIS
- Environments: SQL Server 2008/2005, SSIS, SSMS, SSRS, T-SQL, .Net Framework 2.0, Windows 2003 Server, MS TFS, MS-Access, MS-Outlook, Microsoft office, MS-office, MS Visio 2007
- Monitoring sql server agent job and setting up jobs to run every fifteen minutes
0-5 years of experience
Integrations development: Scheduled ETL between Dynamics CRM and other systems including Dynamics AX, Dynamics NAV, Dynamics GP, Goldmine, Sage CRM, Sage MAS 500, and custom designed databases utilizing SSIS, Scribe, Dynamics Connector among other methods.
- BI/Reports Development: dashboards/reports/charts/gauges utilizing CRM Fetch XML, TSQL and OLAP datasources.
- Customization of Dynamics CRM components for client and demo CRM 2011/2013 On-Premise and Online. DBA Support for client SQL Server instances including backup and maintenance plans, modification of existing processes as necessary.
- Adherence to SDLC, Agile Methodology, Source Control/Creation of documentation/Client interactions/support as necessary
0-5 years of experience
Provide production support for the existing applications and clients; own the support process, documentation and implementation.
- Database architecture and design according to business rules.
- Developing T-SQL stored procedures, functions, triggers, views.
- Working on optimization SQL Server performance. Resolved performance issues using execution plan and SQL profiler.
- Creating daily, weekly, monthly reports in SRSS.
0-5 years of experience
Extensively worked on Billing Center, Policy Center and Claims Center.
- Worked with business analysts and data analysts to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI and applications
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data in and from GuideWire OLTP Data Warehouse and Data Mart.
- Debugging of SSIS packages, Stored Procedures and Functions and rewriting / adding necessary business logic to the scripts
- Frequent teleconferencing and e-mail communication with Guidewire team to understand business rules and data structures
- Configured product meta-data tables to support client data reporting needs.
- Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve slow running queries.
- Wrote complex SQL statements using CTE’s, joins, sub queries and correlated sub queries.
- Migration: copied production SQL Server databases to test server running Windows 2008 Server and SQL Server 2008
- Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
- Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Packages and SQL server environments across entire system.
0-5 years of experience
Developed solutions on Epiphany Customer Service, Outbound Marketing databases with ETL tools, windows scripts, and Web Services on .NET framework 2.0
- Led to build Enterprise Data Warehouse for Customers, Sales, Product and Pricing Master database systems, using SSIS/SSRS
- Work closely with DBAs on tracing/optimizations/tuning large SQL server databases (3-4 TB) using T-SQL, Management views and Profiler etc.
- In-depth understanding index structure, SQL Server query execution plan
0-5 years of experience
It is the oldest trust company in the U.S., and provides personal wealth management to some of the wealthiest individuals and families
- Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
- Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
- Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
- Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
- Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
- Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
- Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
- Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
- Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
- Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.
0-5 years of experience
Extensively worked on Billing Center, Policy Center and Claims Center.
- Worked with business analysts and data analysts to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI and applications
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data in and from GuideWire OLTP Data Warehouse and Data Mart.
- Debugging of SSIS packages, Stored Procedures and Functions and rewriting / adding necessary business logic to the scripts
- Frequent teleconferencing and e-mail communication with Guidewire team to understand business rules and data structures
- Configured product meta-data tables to support client data reporting needs.
- Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve slow running queries.
- Wrote complex SQL statements using CTE’s, joins, sub queries and correlated sub queries.
- Migration: copied production SQL Server databases to test server running Windows 2008 Server and SQL Server 2008
- Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
- Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Packages and SQL server environments across entire system.
0-5 years of experience
Supported & Implemented Database Replication spread across 4 regions round the clock (London, Bangkok, Singapore 2 centers in USA (NY, St. Louis).
- Implemented scripts to monitor 24 x 7 for production databases and send alerts to DBA.
- Having experience in supporting large databases sizes multi terabytes.
- Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for critical applications.
- Involved in Installations and Migrations of SQL Server Product and few databases are also migrated from Oracle into SQL Server.
- Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
- Responsible for Logical and Physical design of database for projects on basis of user requirement for OLAP & OLTP applications.
- Involved in tuning by query modifications, partitioning and hardware optimization etc..
- Automated several tasks and notify team regarding replication & DB failures.
- Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
- Upgraded all SQL Server 2000 to SQL Server 2005 and SQL Server 2008, without any service interruption.
0-5 years of experience
Design and implement Visual Basic applications and SQL databases for new system
- Evaluate requests for program modifications, systems to determine feasibility
- Upgrade, test and debug VB application and SQL stored procedures
- Automate data transfers using SSIS packages
- Manipulate data to generate adhoc client reports
10+ years of experience
- Development and Optimization of Stored Procedures, Views, Triggers and Functions
- Designing, developing, testing and troubleshooting SSIS packages that implement ETL processes, call third party web service & transmit data via XML to perform various tasks
- Design and develop various advanced level complex reports (SSRS)
- Troubleshoot performance issue, blocking & dead-lock issue
- Manage permissions, database back up, restore and log shipping process
- Migrated SQL Server 2005 to 2008, which involves migrating all the reports, SSIS packages and SSAS cubes.
- Worked in a small team for Data Migration project. Migrated data from in-house built much smaller database (about 50 tables) to much larger open source database (Ofbiz with about 500 tables)
- Designed and re-developed all the existing reports and SSIS packages based on new data model as part of Data Migration project
- Interact with the business users; analyze the issue or enhancement request, design the solution, full testing and implementation
0-5 years of experience
- Experience in developing Custom Report and different types of Chart Reports, Drill-Down reports, Cross-tab-reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services ([company name]) 2012/2008.
- Experience in utilizing MS SharePoint to distribute reports and to create attractive reports, dashboards, and scorecards using KPIs and Power BI Suite.
- Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
- Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.
6-10 years of experience
- MED3000 a Subsidiary of [company name] (Acquisition date February, 2013 )
- InteGreat Concepts a division or MED3000 (Acquisition date June, 2007 )
- Strengthen the effectiveness of the DBA team and reporting capabilities of InteGreat’s Electronic Medical Records application using SQL Server/SQL Reporting Services (SSRS) 2008 R2/2005/2000, Crystal Reports 8.5.
- Solely responsible for all SQL Reporting Services related responsibilities including; Conception, Design, Configuration, Development, Delivery and Deployment.
- Developed application based reports and custom reports for client, State, and Federal entities.
- Developed a complex set of reports to return a variety of Meaningful Use and Clinical Quality Measures. End-user can generate these reports for selected measure criteria, thus reducing development and maintenance efforts.
- Created a transformation file (XSLT) to run in conjunction with an SSRS report to generate a Federally required Clinical Quality Measure XML file.
- Created a DLL to call a Windows service and developed an SSRS report to interactively execute the DLL to generate Federally required Clinical Quality Measure XML files.
- Analyzed database integrity and developed batch and SQL scripts to resolve database referential integrity errors and bad data.
- Successfully developed and maintained reports/report queries in the Practice Management database with no previous knowledge of the database and with little assistance. Determined data relationships by reviewing existing stored procedures, views, and report queries.
0-5 years of experience
- 30% SQL Development (Dev) – 70% SQL Database Administration (Admin)
- Dev – Created 13 SSAS cubes for multidimensional analysis of [company name]’s maintenance, financial, and operational departments. These cubes helped develop over 100 reports via SSRS, spread evenly across the 3 different departments
- Admin – Developed 8 different SSIS packages for each of the 4 companies that totaled 32 different ETL processes. These allowed data to flow seamlessly between the 4 companies, as well as from our 4 different vendors, into their respective databases for easier reporting and analysis.
- Admin and Dev – Created, maintained, and altered over 250 SSRS reports for each of the 4 companies; this allowed myself and analysts to conduct in depth investigation on different company facets, resulting in actionable items for management.
- Dev – Created 8 daily dashboards which highlighted KPIs and trends, as well as both long-standing and newly developed deficiencies, utilizing both the data warehouse and legacy systems.
- Misc – Performed ad-hoc data analysis that helped set strategic direction.
- For example, I analyzed lane performance and pricing for 18 different bids that our company participated in. I advised the companies executives of how to price, and which lanes to avoid, when bidding to benefit the companies bottom-line.
- Dev and Admin – [company name]’s was unable to provide data-driven subscriptions (due to only have SQL Server Standard Edition) so I created a workaround by coding HTML structure and CSS styling within SQL and used a WHILE loop to cycle through customers; by doing so, this allowed me to deliver data-driven customer Freight Tracking on a 30-minute interval. In addition, I tracked all E-mails that were sent and at what times so that I could eliminate redundant E-mails based on our clients particular needs, whether it was an On-Time/Late delivery flag, a certain distance away, or even as specific as a particular time of day. All mathematic algorithms were designed by myself. This entire process took 2 months and 3000 lines of code.
0-5 years of experience
Project North Database Migration: This Project North (PN) project involves the sale of [company name] landline accounts to Frontier/Spinco and my roles and responsibilities to migrate COFEE Billing East & West , AMT, VDO, BOSS, Survey, Arbor to a separate database including Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing.Net backups configuration.
- Perform day to day Database Maintenance tasks — Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers
- Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas per, Sarbanes-Oxley Act. Ability to prepare for and participate in security audits and database encryption, and disaster recovery measures.
- Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server.
0-5 years of experience
- FA Databases and FA Customer portal administration
- Creating and maintaining database schemas (structures)
- Maintaining all company databases
- Implementing and maintaining data security and consistency for Customer portal
- Creating and maintaining systems to scrub data feeds (client units, industry supplied data)
- Developing, implementing and maintaining all database reports
- Development of SSIS Packages
- SSRS Reports
- Telerik Reports
- ETL Tools