- Featured in:
More Sql Database Developer Resumes
Use these Sql Database Developer samples as a guideline or visit our extensive library of customizable resume templates.
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Additional Data Systems Administration Resume Samples
Sql Database Developer Resume Samples
No results found
0-5 years of experience
Developed relational databases optimized to provide data to real estate websites. Analyzed and interpreted data feed sources (FTP connections, direct server queries, raw data files) to migrate data from various data formats into SQL Server databases using daily automated import processes (DTS and SSIS packages, etc.). Responsible for troubleshooting database issues and engaged in problem solving tasks involving data feed transformations. Worked with clients to address pressing issues by handling requests via internal ticketing system.
- Consistently met deadlines for database creation and implementation projects while working with software development and client service teams to further improve the product.
- Created T-SQL objects & scripts used to maintain data integrity across all databases throughout database servers (Stored Procedures, Triggers, Functions).
- Demonstrated ability to adapt to company's evolving environment by learning quickly & taking on expanded roles by implementing new procedures and improving existing ones.
0-5 years of experience
Re-Architecture schemas with 120+ tables each to enhance data mining & data integrity.
- Developed & Maintained database, maintenance routes and safeguards ( procedures, scripts, function, etc ..) to increase performance.
- Established robust techniques raw data exchanges, built & maintained SSRS, ETL package
- Streamlined backend servers (Unix & Win) for added data
0-5 years of experience
Designed, developed, tested and implemented relational databases and procedural database code
- Optimized query performance and populated test data
- Maintained the database using Procedures, Functions, Cursors and Triggers
- Performed quality assurance and testing of SQL server environment
- Assisted clients in using implemented software projects
0-5 years of experience
Designed, developed, tested and implemented relational databases and procedural database code
- Optimized query performance and populated test data
- Maintained the database using Procedures, Functions, Cursors and Triggers
- Performed quality assurance and testing of SQL server environment
- Assisted clients in using implemented software projects
0-5 years of experience
Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
- Designed database, tables and views structure for the application.
- Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages.
- Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
- Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files.
- Responsible for optimizing SQL queries, stored procedures to improve the performance time.
0-5 years of experience
Analyzed SQL server environment for quality checks. Build up applications on SQL server using Visio
- Used SQL to connect database with other oracle versions.
- Conducted data migrations from third party databases to create consolidated database system.
- Developed.NET applications utilizing SQL database system as per company requirement.
- Coordinated with the management to discuss business needs and designed database solutions accordingly.
0-5 years of experience
Created 5 data monetization revenue streams by combining Digital Engagement with Data Analytics.
- Performed data analysis on 150+ vendor product datasets and led the modeling and development of the initial Enterprises data loading ETL/ELT solution in SQL 2008 R2. Later, managing 2 SQL Developers and leading the development of the complex TSQL stored procedures and SSIS ETL processes utilizing XSLT and FOR XML queries to consume and translate the vendor XML and Excel data files into the supporting database feeding the enterprises sales advisor mobile application.
- Conducted interviews with the C-team and VP members of the top 10 key vendors performing the business analysis that led to the innovation and development of the new standardized data collection template and vendor data acquisition program saving the company over $360,000/year in existing data collecting efforts.
- Acted as Database Manager for collection of digital touch point data and director of the vendor data acquisition program and led data strategy recommendations to vendors including Rohl, Perlick, and California Faucets.
- Performed index and stored procedure tuning scaling for over one (1) million products from initial full vendor data import and continuing data feed.
- Created the weekly meeting BI SSRS reports on data acquisition and integrity progress to the Director of Information Systems, Director of Digital Operations, and Vice President of Business Development.
0-5 years of experience
Migrated and upgraded SQL Server 2005 database to SQL Server 2008 environment using upgrade advisor and tested their applications.
- Installed and configured the database server (SQL Server 2008) in production, development and testing environments
- Developed the Stored Procedures, Triggers, Functions, and T-SQL scripts
- Running synchronization process between production, staging, testing and development environment using Red Gate 6.0
- Writing new stored procedures and modifying existing ones and tune them such as they perform well.
- Implemented auditing using triggers and enforcing business rules via checks and constraints. Proper use of views to prevent unauthorized access to sensitive data.
0-5 years of experience
Developed backend SQL programs and application for KARVY HR functions.
- Designed and developed application in sending Emails of Daily Reports using DB Mail configuration to send Mails via SMTP Mail server.
- Developed Stored Procedures, Triggers, and created indexes.
- Created Database Tables and database views.
- Created batch job processing, scheduling and production support.
- Implemented batch job processing, scheduling and production support
- Installed & managed Windows 2000 servers.
0-5 years of experience
Developed backend SQL programs and application for KARVY HR functions.
- Designed and developed application in sending Emails of Daily Reports using DB Mail configuration to send Mails via SMTP Mail server.
- Developed Stored Procedures, Triggers, and created indexes.
- Created Database Tables and database views.
- Created batch job processing, scheduling and production support.
- Implemented batch job processing, scheduling and production support
- Installed& managed Windows 2000 servers.
0-5 years of experience
Created a system to manage the professional profiles of the researchers at [company name]
- Designed and developed SQL/PHP database that supports 1000 plus active profiles
- Programmed in a Ubuntu / Linux Debian environment
- Develop complex search queries and code
- Established secure connection to server
- Use SSH protocol to remotely access server using VMWare
0-5 years of experience
- Identified 30 requirements and business rules for the application
- Designed E-R model for the application and drew E-R diagrams using Visio
- Converted E-R model into relational schema
- Created a SQL script to create the tables, implement business rules, and populate the tables
- Developed queries and reports to illustrate features of the application
- Prepared opportunity evaluation and business report for the proposed application
0-5 years of experience
Duties include the development and support of numerous complex Oracle PL/SQL Processes. Responsible for the design and continuous development of the Data Migration projects (Jboss).
- Participated in the designing and development of Oracle Processes using agile development practices.
- Provide Go to Market support for all phases of the development lifecycle.
- Sole data support resource for the Order Capture, Admin and Order Management Teams.
- Provided analysis and development for the "Analytics" Database Reporting.
- Developed Oracle Scripts to support JBoss Phase 1 (Business Rules/Gate).
- Acted as Data Team Release Coordinator for major release.
0-5 years of experience
Collaborated with stakeholders to analyze data and plan and implement database migration strategies
- Analyzed existing Oracle database system to propose environment for mapping database tables
- Wrote Oracle PL/SQL scripts to test for and resolve data discrepancies between Oracle database and PeopleSoft environments
- Wrote advanced SQL scripts for data migration
- Developed XML-based communications interfaces to transport data between Oracle 10g database and PeopleSoft environment
0-5 years of experience
Wrote complex Stored procedures to fetch the data from the given Jobs.
- Created databases, tables, views, functions, and triggers using T- SQL.
- Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
- Loaded files into system using MS SQL Server 2012
- Created logical and physical database design, data structures, primary key, foreign key and implemented large databases
- Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, SQL Server automatic email notification and backup strategy
- Created and managed structured objects like tables, views, stored procedures, views and triggers all while maintaining Referential Integrity
0-5 years of experience
As one of the two member team to successfully design and develop a browser based Residential Construction Risk Assessment system with ASP, CSS, SQL Server 2000 in two months. The project saved BISYS/Tri-Cities Brokerage from a major lose of the time and money due to the early unsuccessful venture.
- Design, implement SQL server 2000 database for the system. Perform DBA and development task for the database.
- Extensive use of T-SQL programming and stored procedures to interactive with the database, and ASP to perform the calculation of the risk assessment modeling, etc.
- Using ASP and SQL server programming to produce a final assessment report which are rich with dynamic graphics and charts.
- Design the front end/presentation layer of user interface, and integrate the front end/presentation layer with and Admin system smoothly.
- Convert MS Access database to SQL server data for testing and redesign database structure and display of the website input form.
0-5 years of experience
- Analyze customer databases and import 10,000 to 20,000 new records daily.
- Normalize data sets and create customized indexes to ensure top server performance on ever increasing databases up to 600 million rows in size.
- Participate in bi- weekly code review exercises and assess project scope and output.
- Collaborate with Project Managers to ensure superior customer satisfaction and project completion deadlines are achieved on a consistent basis.
- Create or correct Trouble Tickets to resolve database and web operational errors.
0-5 years of experience
Principal architect of database upgrade, design and migration for corporation's national parts distribution website
- Automated ETL processes with SQL Server SSIS packages to maintain timely parts and transaction information between internal ERP application and on-line web services.
- Designed and automated data transformation processes to support concurrent operations between new, developing, and legacy systems
- Performed business analysis with subject matter experts to document requirements as well as translate legacy processes for continuous improvement
0-5 years of experience
Supported the KP Health Connect Epic System.
- Designed and developed a OLTP application supporting 100+ users. Application was developed using MS VB.Net (Visual Studio) and SQL Server 2008. Application is used to schedule and manage computerized training sessions for KP nurses, MDs, managers, etc. Used ETL/SSIS to bring in data from various sources including Access and Excel.
- Pulled training historical data from Kaiser's DataMart's and Access and Excel.
- SSRS was used for generating standardized reports.
- Used standard performance tuning principles and tools such as SQL profiler to optimize DB performance.
- Developed Access 2003/Excel based adhoc reporting tool for custom reporting and data analysis of class schedules, instructor load balancing and database querying. Excel tool used macros and VBA.
- Developed an Excel Template that was used to capture classes when users are offline and then synced with the SQL DB once connectivity was available. Template made extensive use of macros, VBA and ADO for data validation, processing and connectivity to the SQL DB.
- Trained new users and existing users on application features, best practices, etc.
10+ years of experience
Design, develop and implement all aspects of database solutions: database model, stored procedures, SSIS packages, ETL for reporting, archiving and performance monitoring.
- Develop, test and implement C#.net applications.
- Technical lead through the designing, testing, and implementation of projects.
- Technical expert to team on SQL design/coding standards, best practices and performance tuning tips.
- Created a C# application that executes SSIS packages to standardize logging and error handling.
- Performance tuned a SQL process taking 13 hours to run in 30 minutes.
0-5 years of experience
Backend developer for company Intranet, eCommerce, business contracts management, and data ETL processes using SQL Server Management Studio.
- Created & documented data processes using SQL, SSIS packages, C#, DTS packages data flow.
- Specialized in proprietary data process overhauls including validation of end results using SSIS, DTS, stored procedures, and C# programs.
- Interacted with clients and third party data venders to efficiently manage deliverables.
- Requirements analysis for iOS, eCommerce, SharePoint, Jira, and Intranet development.
- JIRA Administrator/trainer migrated from three different bug tracking/ workflow management applications. Specialized in workflow development and plugin modifications.
- Microsoft SharePoint developer/admin/trainer migrating Wss to SharePoint Foundation.
- Feasibility consultant for colleagues regarding iOS mobile apps development.
0-5 years of experience
- End to end development of the interface database for the original MSDN online Subscriber download tool launched by Microsoft in June of 1998. This included designing a database application to facilitate online registration control for MSDN Online subscriber area.
- Developed an Event tracking application for defining and handling subscription events to regulate user authentication and access to MSDN Online Subscribers Area.
- Developed a directed email tool which accepted numerous combinations of criteria for customer notifications.
0-5 years of experience
Benchmarked various databases using imports from Postgresql, MySql and Memsql.
- Used various configurations to get the import transaction rate from 4 per sec to over 14k per sec.
- Used the TDM Utility to process external and internal data feeds for processing/forecasting for the BU.
- Responsible for updates to the Sql 2008 databases using Management Studio and Query Analyzer.
- Promoted/analyzed/troubleshooted changes to existing Sql Server 2008 DTS/SSIS packages.
- Performed Dell PowerEdge SAN hard drive replacements, firmware upgrades and Volume/LUN
- Ran daily SAN IOPS captures which were then exported into daily reports for the testing team.
- Performed numerous Sql Server 2008 R2 installations and database migrations.
- Diagnosed deadlocking and blocking issues on Sql 2008 development databases using Sql Profiler.
0-5 years of experience
Programming and development in ASP, VB.Net, SQL and ASP.Net
- Troubleshoot, analyze, manage, monitor & optimize database systems - MS SQL
- Fairfield Getaways Travel Distribution System: B2C app to connect consumers to Travel Distribution Services via Cendant owned travel portals including Orbitz.com, CheapTickets.com, and Galileo International
- Executive Management Report Center: Online Real-Time Reports for executive managers for mission critical decisions
- Referral Management Site: Automated referral program to track and compensate referrers and sales
0-5 years of experience
- Developed and coded for an ETL solution. Implemented multi-stream scalable solutions for [company name] Sql 2008. Coded, Unit tested, bug documentation, bug resolution, in a full t-Sql development cycle.
- Worked with TFS and SharePoint in a agile team coding environment. Familiar with full [company name] deliverable process from sprints, to DIT, SIT, UAT, and production. Contract Employee
- Maximized the MS Advertising business value by proactively monitoring platform metrics, and using the resulting insights to drive improvement. Specifically worked for the CI/CIQ Business Operations team while working on a large scale email platform driven by the Epiphany software suite. The CI/CIQ email platforms are responsible for sending two thirds of all promotional and information emails sent by [company name], approximately 10 Billion emails per year!
- Supported analyst for data driven performance tracking and reporting. Strong cross team coordination and organizational skills to ensure fast and effective communication between multiple teams with focus on resolution and status tracking. Front line TFS report monitoring and escalation duties to cross team groups. Primary tool, SSMS and Add hoc T- Sql queries. Contract employee.
- Owner operator, of an art jewelry design and retail sales company. Design and implement Jewelry art projects in sterling silver.
- Design online web strategies, including online sales and online gallery presentation. Create, design product catalog and offers, including, and develop studio photography techniques, lighting and presentation for product online presentation. Process online customer inquiries, sales and special orders. All logistics, special orders and commission work projects. Manage all budgets, expenses and production cycles. Maintained customer database.
0-5 years of experience
- Designing and implementing relational database model as per business needs.
- Installed & Mantained Microsoft SQL Servers 2012, creating and managing users & permissions, desining relational Databases
- Workin with Failover Clustered enviroments and implementing replication database servers ( Merge )
- Creating indexes, Views, Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
- Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement
0-5 years of experience
Plan, design, and implement application database code objects, such as stored
procedures and views
- Perform quality assurance and testing of SQL server environment
- Testing of applications for performance
- Writing the stored procedure
- Used SQL to connect database with Visual Studio
- Developed.NET applications utilizing SQL database system as per company
0-5 years of experience
- Primarily responsible for processing and analyzing large volumes of data using SQL.
- Wrote SQL queries, designed VIEWs, Stored Procedures and DTS/SSIS packages to automate data interfaces, produce Ad Hoc reports, data analysis and complete quick processes
- Tested new/updated IVR survey scripts
- Documented standard procedures regarding physical data storage, maintenance, access, and security administration in order to standardize environments and improve efficiency.
- Authored reference guides and technical documentations on various internal and external metric and processes
- SharePoint development including custom InfoPath forms and custom workflows
- Managed user access to the web portals and communication sites
- Managed the relationship between business units and the development team
0-5 years of experience
Programming and development in ASP, VB.Net, SQL and ASP.Net
- Troubleshoot, analyze, manage, monitor & optimize database systems - MS SQL
- Fairfield Getaways Travel Distribution System: B2C app to connect consumers to Travel Distribution Services via Cendant owned travel portals including Orbitz.com, CheapTickets.com, and Galileo International
- Executive Management Report Center: Online Real-Time Reports for executive managers for mission critical decisions
0-5 years of experience
- Conversion of old ASP pages to new Visual Studio ASP.Net 4 pages utilizing C# and N-Tier development
- Conversion of all inline T-SQL Command scripts from ASP pages to StoredProcedures
- Conversion of all DTS packages to StoredProcedures to handle business rules and manage data utilizing C# for database creation
- Converted of SQL 2000 database to SQL 2008 r2
- Designed Dashboard project from scratch that tracked employee time clock monitoring, pay calculation, safety incidents, each hourly employee learning plans, and other employee information
- Conversion of Mainframe programs and database to Microsoft Visual Studio ASP.Net 4 in C# and conversion of Mainframe data to Microsoft SQL Server 2008 r2, developed conversion flow process with team.
- Developed WCF Services using C# to retrieve data from SAP/Oracle database that supported the Dashboard project, this WCF service is used to update various data upon leader access to hourly employee data
- Team lead in designing converting all ASP pages to ASP.Net pages utilizing Visual Studio ASP.Net 4 C#
- Created design specification documents for all phases of projects
- Designed a security strategy that met requirements for Aerospace employee data for both the SQL Server database and the .Net application
0-5 years of experience
Worked on multiple application using various Mycroft technologies such as Visual Studio, SQL Server, SSRS, SSIS
- Reviews, evaluates, designs, implements and maintains organizational database[s].
- Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
- Database backup and disaster recovery procedures.
- Writes codes for database access, modifications, and constructions including stored procedures, triggers, functions, synonyms etc.
- Optimizing database and ensuring the integrity of data repositories.
- Schedule and maintain jobs including database backup maintenance plans.
- Designed and deployed various SSIS packages for different databases.
- Designed and deployed various SSRS reports for different databases.
- Conducts regular day-to-day communication with development team.
- Served as bridge between Developers and management.
0-5 years of experience
- Backend developer for company Intranet, eCommerce, business contracts management, and data ETL processes using SQL Server Management Studio.
- Created & documented data processes using SQL, SSIS packages, C#, DTS packages data flow.
- Specialized in proprietary data process overhauls including validation of end results using SSIS, DTS, stored procedures, and C# programs.
- Interacted with clients and third party data venders to efficiently manage deliverables.
- Requirements analysis for iOS, eCommerce, SharePoint, Jira, and Intranet development.
- JIRA Administrator/trainer migrated from three different bug tracking/ workflow management applications. Specialized in workflow development and plugin modifications.
- Microsoft SharePoint developer/admin/trainer migrating Wss to SharePoint Foundation.
- Feasibility consultant for colleagues regarding iOS mobile apps development.
0-5 years of experience
Web & SQL database developer for the [company name] Network Dispatch Center. All data driven websites monitored 24/7 365 to ensure accuracy. Enhanced database performance by clustering and performance tuning. Scheduled daily differential back-ups, as well as, weekly completed back-ups to prepare for disaster.
- Created intranet applications using ColdFusion, HTML, CSS, and JavaScript. These applications pulled data from a SQL database to show details of all the installation orders under a specific supervisor. Users had the ability to select data from a previous date in a calendar format. The interface included controls to view previous and future months; to drill down into a multiple page display of all workload details with forms to update the data and to access HTML reports.
- Developed and designed a web based data warehouse in which users directors, managers, and supervisors could seek archived data.
- Developed and maintain a dynamic database driven web sites. This site utilizes ColdFusion, XHTML, CSS, JavaScript, DHTML, XML, and Microsoft SQL Server 2000.
- Used ColdFusion to build website applications and Dashboard.
- Programmed DTS packages to feed real time data to the dashboard; packages contained stored procedures which generated emails, and text messages to directors, managers, and supervisors.
- Enhanced end users understanding of the database systems and dashboard by conducting pre-implementation workshops, delivering group and individual training sessions, and creating user-friendly training materials.
- Clustered Database (Active/Active) to ensure critical applications will have little or no downtime if such a node ever failed.
0-5 years of experience
- Gathered requirements for migration of an old database structure to a new db structure. Designed, created, tested and implemented Oracle SQL migration scripts and PL/SQL stored procedures to build Oracle objects used by the SMT Intranet Work Request Tracking application. Reverse engineered the old data structure and studied its relationships to develop a source to target database mapping. This application was planned to be used by 100's of employees from Michigan Department of Transportation and Michigan Department of Information Technology (MDOT & MDIT). Organized and facilitated mapping sessions involving six developers to validate old source to new target mapping. Also, using Erwin and Model Mart, modified new data model to meet new system requirements.
- Experienced with stored procedures, functions, packages, user defined types, triggers, materialized views, and sequences.
- Even though I have no experience in FoxPro, I debugged a FoxPro program to find out where a logic error was occurring. In another FoxPro application, it was necessary for me to change a SQL query to handle the case when a input field was present or not. I have so much experience with so many programming languages; it is very easy for me to pick-up a piece of code and read through it with an occasional reference book lookup.
- As Business Systems Analyst and Database Designer, conducted requirements gathering sessions with Business Owner and functional SME for the Michigan Department of Transportation (MDOT) TMIS Traffic Study. Translated requirements into functional specifications. Built preliminary database design and then reviewed it with the Business Owner and functional SME then modified it over and over until we were all in agreement with it's correctness. I invited the web developers to the modeling sessions in order for them to gain a clearer understanding of the database layout they would be retrieving data from. Finally, I conducted data model walkthroughs attended by Business Owner, functional SME, DBA, developers, and project manager. Lead the group through the model by reviewing attribute dictionary definitions and walking the group through each piece of the data model, entity-by-entity and attribute-by-attribute until all were in agreement that the model represented the business needs. As a result of the walkthroughs, input from the DBA and functional SME lead to several improvements and changes, saving rework time later on.
- As Business Systems Analyst, planned and successfully implemented controversial cross-functional TMS Control Section Reduction pilot project to validate real savings before investing in the complete solution. Developed Scope Definition and Project's Business Requirements Document. Negotiated buy-in from all senior executives and application owners by passing the word slowly, and quickly addressing questions as they came up. Held informational meeting for senior executives and application owners. Presented very basic examples on what was being done and explained very simply how it would actually help MDOT be reducing confusion.
- For the data dictionary application, I developed a test plan in support of application requirements for the new application. Performed functional testing in accordance with the plan. Documenting thoroughly the errors as they occurred to make it easier for the developer to find and fix the problem.
0-5 years of experience
Involved in the enhancement projects for Invoice Processing System, Customer Web Portal, Vehicle Rental / Lease /Maintenance Appointment Process, User Security and Online Rental Application projects.
- Create SSIS packages and procedures to extract / update existing invoice from DB2 databases and AS400 into SQL on daily basis based on invoice number and invoice date for Lease, Rental, accident charges, maintenance, credit memos, miscellaneous charges [company name] Units.
- Involve in enhancement for Online Rental project, database performance and migration to new server. Create Customer hierarchy for CWP project with levels.
- Create SQL (using SSIS/ stored procedures) reports based on invoices for SAIA, Southern Wines, United Trans and Unite on weekly basis and upload into their FTP site.
Data Systems Administration Cover Letter Examples
