- Featured in:
-
More SQL Developer Resumes
Use these SQL Developer samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Looking for cover letter ideas? See our sample SQL Developer Cover Letter.
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Computer Software Resume Samples
SQL Developer Resume Samples
No results found
0-5 years of experience
Developed PL/SQL stored procedure, functions and style sheets for a leading US based Insurance Company.
- Analyzed requirement and impact by participating in Joint Application Development sessions with business
- Collaborated with multi-vendor global teams like business analysts, front end developers and testers.
- Received Client Champion Award as a PL/SQL developer.
0-5 years of experience
- Designed, implemented and integrated a new repository of Chapter 13 bankruptcy information from the trustee point of view.
- Created the schema, implemented all stored procedures and 4 SSIS packages Created the deployment scripts and managed the code in Microsoft Team Foundation Server.
- Performed unit tests on all code and packages.
- Additional projects included automation of a manual process as the start of a data warehouse project.
- Updated existing and created new reports using Microsoft SQL Server Reporting Services. Team consisted of 2 developers.
- Performed front line code reviews for other development teams.
0-5 years of experience
Reviewed, evaluated, designed, implemented and maintained company databases.
- Monitored and tuned database resources and activities for SQL Server databases.
- Performed and automated SQL Server version upgrades and patch installs.
- Designed, developed and maintained relational databases.
- Developed, implemented and maintained enterprise business information systems.
- Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients
- Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
- Maintain existing Crystal Reports against legacy system and rewrite these reports in SSRS against new data warehouse
0-5 years of experience
Worked as a SQL Developer responsible for creating SQL stored procedures, functions and triggers.
- Developed and Optimized Stored Procedures and Functions using T-SQL
- Participated in several projects and interacted with peers
- Gathered business requirements and converted it into SQL stored procedures for database specific projects
0-5 years of experience
Produced daily sales reports for the executive team and managed markets team
- Daily reconciliation of pharmaceutical industry data sets
- Created a sophisticated Inventory analysis report for vice president of commercial operations and the sales operations department head
- Designed query accessing JD Edwards Oracle database to pull information for government Sunshine act compliance
- Created files, views, tables and data sets to support Sales Operations and Analytics teams
- Researched and resolved data issues related to existing data and processes in place before my tenure
0-5 years of experience
- Provided support and enhancement of national rental property listing database applications
- Performed production system software installations
- Created and scheduled SQL Agent jobs and maintenance plans
- Gathered software requirements from clients and end users
- Derived and documented process application business rules
- Modified and maintained SQL Server stored procedures, views, ad-hoc queries, and SSIS packages used in the search engine optimization (SEO) process
0-5 years of experience
Part of a team involved in writing Business Intelligence Reports for a reputed Gaming company
- Created reporting to provide security group visibility to suspicious online user behavior (hacking, bots)
- Designed tools & processes to move from a system of querying data from log files to aggregated data stored in persistent tables. Scheduled loading of persistent tables on hourly basis
- Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic Sql, Merge statements.Built and monitored indexes to bring down processing times from minutes to seconds
0-5 years of experience
Developed SQL Server database with that was used for piece tracking through the production process
- Prototype and develop web app to capture and report production data
- Conduct meetings with stakeholders throughout development to gather system requirements from users and ensure user acceptance testing was performed
- Migrated databases from Oracle and Access to SQL Server to preserve historical data
- Collaborated with team members to transition and optimize legacy software from Oracle to SQL Server
- Developed reports in SSRS and QlikView for executives and managers
- Document code changes and UAT before deployment to production systems for SOX compliance
- Managed user access via Active Directory for centralize access control
0-5 years of experience
Gathered requirements from Business and documented them based on functional specifications.
- Designed and implemented complex SSIS package to migrate data from multiple data sources.
- Created SSIS package to extract, validate and load data into Data warehouse.
- Extensively worked on creating SSIS packages and have used For each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
- Created Stored procedure, Views, Cursors and functions to support application
- Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
- Implemented multiple grouping into several reports using visibility and toggle options.
- Actively supported Business users for change requests and provide support to team members.
- Provided support by troubleshooting and solving the issues.
0-5 years of experience
Designed complex DTS data pump between crawled web data-dump text files to a normalized
relational database used by the production web site.
- Wrote several stored procedures, functions and cursors to build consistent reports for the sales
- Migrated all Guidester databases from SQL 2000 to SQL 2005.
- Configured SQL jobs and maintenance plans to ensure database stability and integrity.
- Deployed critical Microsoft patches to all SQL Servers in development and production.
0-5 years of experience
Responsible for all database development and administration on company’s ERP platform.
- Streamlined data replication from application to web environments.
- Developed an automated shipping process to allow for multiple packages on one order.
- Coordinate and install all releases, upgrades, and installs of all corresponding software.
- Created a data warehouse, along with reporting services with company-wide, secure access.
0-5 years of experience
- Created Stored Procedures applying to complex business scenarios.
- Designed SSRS reports providing data visualization.
- Maintained data integrity and database structure including tables, views, and triggers.
- Generated SSRS report subscriptions.
0-5 years of experience
Created, tested and implemented stored procedures, functions and packages using Oracle 10g for a front end Java server page application.
- Created PL/SQL scripts to analyze data, modify data, import / export scripts, and execute stored procedures.
- Created complex queries for use in web based reports
- Tuned existing PL/SQL code for efficiency by using DBMS_SQLTUNE and analyzing explain plans.
- Updated and implemented Java scripts that called PL/SQL code using Eclipse / Apache Ant.
0-5 years of experience
Write SQL queries, such as stored procedures, views and functions, to generate eCommerce Metrics statistics and analyze web extraction data
- Create SSIS packages to do data transformation and conversion for data cleansing purpose
- Convert SQL report into Excel and format the report through Pivot Table
- Prepare drill-down and drill-through reports using SSRS
- Present the top online retailers websites’ data to management team on weekly basis
- Communicate potential problems existed in operations to management team by analyzing the generated statistics
0-5 years of experience
[company name] is one of the leading health care providers in MN. It has more than 300,000 members in the system. [company name] offers a wide range of health plans for people of all ages and stages. [company name] is implementing Affordable Health Care Act.
- Developed eligibility reports and Dashboards using OBIEE Presentation Services.
- Merged new RPD, dashboard and Answers requests with existing OBIEE content.
- Performance tuned Interfaces, queries through use of indexes, ranks, Oracle hints.
- Wrote detailed design specs for ETL. Converted the functional specs written by Data Modelers into the detailed design spec for ETL.
- Created PL/SQL Stored Procedures, Functions and Triggers for accumulator process.
- Create Scripts for automatic reports and error emails to the business users.
- Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
- Worked closely with the Project Manager and Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to Target Mappings.
- Involved in end to end system Testing, Performance and regression testing and data validations and Unit Testing.
0-5 years of experience
Developed ETL specification based on Business Requirements/Mapping Document.
- Maintained the existing ETL (SSIS Packages and Store Procedures) accordingly to populate the new Metrics and Developed a new SCD.
- Created SSIS packages for extracting data from databases like SQL, Oracle and load those data into tables in SQL server. Created package to handle reject data in customer tables. The package extracts reject records in those tables if the records are older than certain days.
- Designed and Developed analysis reports, charts, scorecards, and dashboards.
0-5 years of experience
Writing ETL procedures to move large data sets from legacy systems into the new system schema using Oracle SQL Developer.
- Created SAS modules that used SQL to extract data from the company’s data warehouse.
- Creating ad-hoc reports using SQL written SQL Developer.
- Creating and reviewing documents that mapped data to be moved from source table to target table.
- Provided technical support for Business Objects users
0-5 years of experience
Design/develop/support PL/SQL packages/triggers to dynamically generate HTML web pages used by electric power companies (eDart system)
- Create the tables/views/indices/constraints/grants needed for the eDart system
- Re-design the UI layout for several of the screens, implement the code changes
- Tune much of the code, re-write as needed to utilize newer features, such as bulk collects/DML, function-based indices, convert from dynamic to static SQL when possible
- Recommended and supported transition from interpreted to native PL/SQL compilation
- Assist other developers writing SQL and PL/SQL code
0-5 years of experience
Uploaded [company name] Customer Care data from Oracle databases and Teradata Data Warehouse to Vendor.
- Developed Automation of Oracle and Teradata SQL scripts of [company name] Customer care data to Vendor.
- Designed Device by OS, Enterprise by OS, and Device Swap Type [company name] Customer care reports in MS Excel.
- Provided Call Center and Customer Specialist Retail Store customer data for Pulse initiative.
- Developed Customer Survey data automatically to [company name] management in SSIS package and T-SQL scripts.
- Designed and automated Teradata Fast Export scripts exporting [company name] Care data to Vendor location.
- Developed Procedures, Stored Procedures in Oracle and MS SQL Server for automation of SQL/data tasks.
0-5 years of experience
PL / PG SQL Development – Set up Recursive functions to piece together a complex data base
- Created a web interface for this data. This included stored procedures and triggers
- SQL Development – wrote simple and complex queries to have data available for the web interface using POSTGRES SQL
- Java development – Wrote interface code and did web development for a legacy hospital application database.
- Worked in Java and POSTGRES SQL to optimize the interface for a frontend on a hospital database.
0-5 years of experience
Data conversion team migrate data from one database to another that means migrating data from existing database to the new database or up gradation of Facets database from previous version to new one. In [company name] (Client) Data Conversion module, we are migrating data from Legacy database to Facets Database. I am working on [company name] Client CVS, UHC and HAP.
- Conversion of Clients Data from old existing database to the new database which consists of 50 million records.
- Analysis of mapping fields, creating PL/ SQL stored Procedures, views, functions, packages; MS SQL SERVER 2008 stored Procedures, DML, DDL and functions using Rapid SQL and SQL Server Management Studio.
- Working on ETL development using PL/SQL, T-SQL to migrate data into (Facets) application having importing, scrubbing, mapping and translation of the Oracle data.
- Core Coding and unit testing using the old Oracle database and running batch jobs for loading database tables from Flat Files using SQL*Loader.
- Performance Tuning of the data using indexes, views, GRAPHS in SQL Server, increasing servers, PGA and SGA and Spooling out the data in the .dat format.
- Analysis of System (Facets) Requirement which was on Membership, Billing and Provider.
0-5 years of experience
Data conversion team migrate data from one database to another that means migrating data from existing database to the new database or up gradation of Facets database from previous version to new one. In [company name] (Client) Data Conversion module, we are migrating data from Legacy database to Facets Database. I am working on [company name] Client CVS, UHC and HAP.
- Conversion of Clients Data from old existing database to the new database which consists of 50 million records.
- Analysis of mapping fields, creating PL/ SQL stored Procedures, views, functions, packages; MS SQL SERVER 2008 stored Procedures, DML, DDL and functions using Rapid SQL and SQL Server Management Studio.
- Working on ETL development using PL/SQL, T-SQL to migrate data into (Facets) application having importing, scrubbing, mapping and translation of the Oracle data.
- Core Coding and unit testing using the old Oracle database and running batch jobs for loading database tables from Flat Files using SQL*Loader.
- Performance Tuning of the data using indexes, views, GRAPHS in SQL Server, increasing servers, PGA and SGA and Spooling out the data in the .dat format.
- Analysis of System (Facets) Requirement which was on Membership, Billing and Provider.
0-5 years of experience
Generate reports with the data from the Data Warehouse using SSRS with Microsoft Share Point Integration.
- Migrate the data from the appropriate databases to the end databases.
- Maintain batch log files.
- Create performance guarantee reports for clients through MS Access
- Implement elements of Access queries and enhance business logic using User Defined Functions
- Create indexes on the database tables and generate trace event to improve the query performance and optimize data access
- Involved in creating T-SQL objects like tables, stored procedures, indexes, user defined functions, common table expression (CTE), Temp table, etc.
0-5 years of experience
Optimized internal SQL database using SQL server 2014.
- Integrated between Route Manager database and Route warrior database using TSQL. Achieved synchronization of 23 tables within 6 seconds total.
- Developed 21 SSRS reports using SSRS 2008 R2.
- Developed Windows services for external integration with the clients. Using VB.net and Threading.
- Developed WCF services to receive or return data.
- Improved performance by converting in code data processing to SQL store procedures.
- Taught some of our colleagues how to write optimized SQL queries.
- Integrated between an OCR tool and our product to auto import invoices as records.
- Created Setup and upgrade MSI packages using Visual Studio.
- Created a secure TCP tunnel between our branches. Deployed single user access across our domains.
0-5 years of experience
- Excellent experience in creating complex queries Stored Procedures, View, Triggers, Union and Join Functions.
- Designed SSIS packages to extract data from different sources like SQL server 2012, MS Excel, Flat Files, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
- Experienced in developing and extending SSAS cubes, Data source, Data source views, Dimensions and deploying and processing of SSAS objects.
- Developed and generated various Matrix Reports, Drill-through reports, parameterized reports and linked reports with multiple formatting using SSRS on data sets imported from SQL server Database and then deployed them on server.
10+ years of experience
Web Application – International Titanium Association
- Developed an extensive MS SQL Server based application for member based associations. Worked with ITA to develop a public searchable website, connecting suppliers, research, market analysis and buyers.
- Extensive CMS capabilities
- Extensive ETL from numerous sources and formats to facilitate a 4 color, 500 page printed catalog and 350 page printed conference books printed annually.
- Extensive GUI Developed to collect, manage, display and output data for further analysis.
0-5 years of experience
Report Writer
- Involved in full life cycle development from building requirements to development to testing and implementation
- Worked on SQL Server Data Warehouse environment to build report using SSRS
- Created reports in a number of business areas including merchandise Planning and Audit
- Responsible for working with co-developers in designing packages in SSIS/ETL
- Migrated data into the new data warehouse using SSIS
- Developed complex Stored Procedures to support various parameterized reports
- Generated scripts for data import and export
- Involved in performance tuning of T-SQL queries
- Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems
0-5 years of experience
Write complex SQL queries for validating the data against different kinds of reports.
- Worked with Excel Pivot tables.
- Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
- Involved in extensive DATA validation by writing several complex SQL queries and Involved in back- end testing and worked with data quality issues.
0-5 years of experience
Principal designer and developer of SSAS and SSRS, SSIS packages to provide customized analysis cubes and reporting to senior management.
- Design and development and maintenance of multiple interface transaction processing systems.
- Development of large library of custom and ad-hoc reports developed in Access, Excel and Crystal Reports.
- SQL stored procedure development.
- Extensive internal and external client negotiations.
- Training and system documentation.
0-5 years of experience
Worked in Integrated Corporate Warehouse group which provides centralized repository for comprehensive data utilized for Contract and Pricing in Sanofi. This data mart is implemented using Oracle PL/SQL processes.
- Requirement analysis, design, development, testing and documentation
- Develop new Oracle PL/SQL procedures, functions, packages and reports
- Tune SQLs to improve performance
- Used SQL*Loader extensively to load legacy data into tables
- Modify existing Unix scripts and create new scripts
- Debug production issues and fix code
0-5 years of experience
Created SQL Server 2008 databases for test applications
- Implemented Quick Test Professional, version 2.0, in order to establish automated regression testing of ASP Web application with SQL Server back-end.
- Maintain the database for the company
- Monitor the database
0-5 years of experience
Analyzed the data structure legacy and CRM Dynamics systems.
- Define and document process of data migration.
- Mapped entities from legacy system to Microsoft CRM 2013 according to different logics and structures.
- Migrated data from legacy system to CRM with SSIS
- Created tools with JQuery and JavaScript to speed up CRM forms development
0-5 years of experience
Created various Tables, Constraints for the Application.
- Developed Packages, Database Triggers, Indexes and Synonyms.
- Created Stored Procedures, Functions in PL/SQL.
- Created Complex Views using joins for generating Reports.
- Performed Backend Testing for the entire application
- Written Complex Joins and Queries.
- Worked on oracle RDBMS.
- Modified and Created user interface using forms 6i.
- Develop Reports using Reports 6i
0-5 years of experience
Design SSRS implementation and deployment.
- Write custom .Net Assemblies for extending SSRS report functionality.
- Develop SSRS reports to be used within an application.
- Develop VB.Net reporting interface for existing VB6 application.
- SQL performance tuning.
- SCRUM development process.
0-5 years of experience
Developing, managing and optimizing approximately 50 SQL Server and Access databases for the medical market research industry, including T-SQL, ETL and process refinement
- Troubleshooting of database and application-related issues, including query and server performance tuning
- Routine database administration tasks, including backup and restore and user management
- C# development using ASP.Net, VBA development in Access and Excel
0-5 years of experience
Consultant, project completed
- Member of the [company name] Business Intelligence/Analytics team (28 individuals).
- Developed several ETL SSIS packages to load data into data marts.
- Create SSRS reports from several BI Analysis Cubes in data warehouse
- Automated several large reports taking hours each day to create manually from other reports.
- Converted several Crystal Reports to SQL Server Reporting Services 2008 R2 report format.
- Create data mart combining three different help tickets systems to create open ticket and change ticket reports across all systems.
- Utilizing T-SQL skills, created stored procedures, temp tables, common table expressions to generate complicated reports and charts.
- Created a new BIDS solution to contain all SSRS projects and implemented Team Foundation for source control.
0-5 years of experience
[company name] is industry’s first thin-client, browser-based toll solution suite for Toll Industry used for several organizations including NTTA.
- Responsible for supporting applications by developing using oracle sql procedures/scripts
- Providing support to the daily activities for monthly statement generation
- Work on the code fixes and support the product releases
- Providing the reports using sql queries
6-10 years of experience
Write C# code to create windows forms and speed up processes for client data loads
- Created a personal ASP.net web page using SQL server stored procedures
- Develop SQL scripts to modify and analyze data
- Create SSIS packages to move data between servers and populate tables
- Build MRS reports using Microsoft Reporting Services
- Load and analyze hospital data on a quarterly basis for external clients
- Use Agile methodology to organize tasks and communicate with other team members
- Train associate database developers on HealthGrades data model
- Meet with business users to determine requirements for MRS reports
0-5 years of experience
Main function includes provide production support and maintenance of existing database infrastructure which is built around SQL Server 2005. Additional responsibilities consist of implementing requirements for new functionality from business users, offering developing, testing and implementing these requirements utilizing SDLC knowledge. Working directly with new hires to train and communicate any changes in financial compensation logic.
- Develop complex T-SQL queries for data-analysis and data extract utilizing knowledge of joins and understanding database landscape.
- Develop new and maintain existing store procedures for financial compensation logic written in T-SQL utilizing database knowledge of store procedure development, financial knowledge and understanding of relational database.
- Develop unit testing plans prior to implementing data or development changes.
- Understand disparate data holding environments utilizing knowledge of ad-hoc or permanent commands for accessing data through linked servers.
- Understand separation of development, quality assurance and production environments.
- Interpersonally savvy to ensure being on “same page” in regards to business logic with Quality Assurance team.
- Develop, implement, and maintain change control processes for modifications to databases.
- Develop training documents for new hires utilizing MS Word skills and Visio.
- Communicate changes in business logic to team members utilizing functionality knowledge of MS Outlook, creating meetings and reminders.
- Responsible for validation of tickets and their distribution to the rest of the development team.
0-5 years of experience
- Application Development – Developed a project tracking application in VB with an Oracle 11g backend to handle all read/write using database procedures and 0040 Oracle objects on the application side. All data integrity was maintained at the database using foreign keys, table constraints and triggers for complex rules and synchronizing data. Error and audit trail logging was also included as part of the database design. This application is used by Cisco to manage large internal projects for budget planning, resource allocation, expense tracking and transfer.
- Data Virtualization – Setup a data service for reporting using Cisco Data Virtualization software formally Composite Software. This involved creating an ETL process to validate and load Excel data into a MySQL database and combining with Oracle data using a single view to serve-up data to Tableau reporting.
- Data Validation and Reporting – Created routines in MySQL to validate data load processes from flat files into the database. Developed a reporting application in Excel to pull data from a service and dynamically build charts and display data using VBA code.
0-5 years of experience
Researched ADHOC request for South Carolina and Puerto Rico coverage.
- Developed SQL queries for reporting purposes internal and external.
- Developed Access forms for tracking new providers as part of Puerto Rico project.
- Developed tables, queries, and triggers as part of Puerto Rico project.
0-5 years of experience
Key words: SQL 2008 R2, T-SQL, SSIS, ETL, SyBase, Change Control, Data warehouse, Data mart
- Designing and creating data warehouse loads
- Create, Modify and Tune Stored Procedures and Views
- Setting up users for Reporting
0-5 years of experience
Creating, enhancing and maintaining SQL Server solutions for our largest clients. This includes working with TSQL to build stored procedures, building and maintaining SSIS processes, performing data analysis and ad-hoc reporting.
- Perform response analysis to determine ROI on marketing activities.
- Data mining activities to rank customer to allow for better selections for campaigns.
- Performing location based data visualization of customer/store location.
0-5 years of experience
Analyzing business processes of the client in terms of both current and future requirements
- Designing the flat file format for import of invoice, debit and credit memo and adjustments
- Mapping client requirements onto Oracle from technical and functional standpoint
- Importing legacy data into Oracle by SQL*Loader and Control files using Shell Programs
- Using Configuration in defining model in BOM and defined items, sub-inventory, locators in Inventory
- Developing Packages, Procedures, Functions, PL/SQL Table, Ref Cursor, Triggers and SQL Reports and alerts as part of customizations.
- Defining Business Process for calculating Deferred Revenue
- Defining Transaction Types, System Parameters, Order Types, Standard Value Rule Set, Banks, Profile Options, Document Sequencing, Memo lines, Responsibilities and Batch Sourcing
- Designed Flexfields to accommodate the customizations.
- Worked with Discoverer so users would have the ability to generate ad-hoc reports.
- Implementation support and User training.
0-5 years of experience
- Perform database back-ups and proactive maintenance. Responsible for ensuring space availability, monitoring activity, disaster recovery, and documenting problems, changes, and solutions.
- Design robust views, complex queries, functions, stored procedures, clustered and non-clustered indexes and triggers. Ensure consistency and integration with existing data warehouse structure.
- Optimize and tune data to increased functionality and ensured data integrity by using the multi-dimensional star schema data warehouse style to ETL data.
- Test programs and databases; correct errors and makes necessary modifications to enhance ETL processes.
- Implementing end user interfaces as required for interaction with SQL databases related to reporting and analysis. Tune and customize existing SSIS SSRS packages and T-SQL for performance.
- Analyze and interpret client project specifications to simplify and build custom applications to automate processes in Visual Basic, FoxPro, and Microsoft Access.
0-5 years of experience
- Build and develop direct marketing campaigns processes using T-SQL.
- Build and maintain data warehouse and data infrastructure solutions.
- Build and maintain business contingency processes.
- Automate scheduled tasks through SSIS packages and MOVEit central.
- Manage database space and performance tuning.
- Analyze and report direct marketing campaigns results using Excel and SSRS packages.
- Analyze marketing data to assess effectiveness, identify new possible channels, and plan targeted campaigns.
0-5 years of experience
- Develop and support data management strategies for sales and marketing initiatives
- Build, edit, and review challenging and complex SQL procedures
- Troubleshoot existing import/export processes to detect problems and inefficiencies, and develop solutions
- Support database management functions for databases
- Work closely with a team of other professionals in the field of data management
- Perform data analysis and research and to farm and mine data from both a technical and business point of view
- Create a report as business needs.
0-5 years of experience
Responsible for SQL development and Automation.
- Built and automated multiple SQL jobs for field facing reporting.
- Wrote SQL code to find turn time, schedules, junk out percentages, number of redo’s and cancels.
- Automated PCMS data extraction for daily reporting.
- Automated the process to slot new MarketPlace items to Bestbuy.com
0-5 years of experience
Specializing in detailed data analytics, application support engineering and features enhancements in a multi-tenant enterprise web application utilized by all major banks and lenders processing billions in distressed and bank owned properties.
- Responsible for resolving complex transactional database processing issues on MS SQL Server 2010 – complex joins/queries, stored procs, views, T-SQL – and advanced custom reporting.
- Isolate problematic software components in production break/fix scenarios: ColdFusion, JavaScript, CSS, XML, AJAX and web services.
- Analyze existing OLTP database schemas to support users reporting requirements including data drill-down and data aggregation.
- Code SQL scripts to correct production data issues requiring complex joins and queries.
- Translate break/fix issues into change requests and routing fixes through the escalation paths.
- Work closely with database architects to optimize throughput and reduce latency of production OTLP systems.
- Technical liaison to business units, core development, release team, network team and generating KB documentation on issues resolution.
- Simultaneously file, track and follow through on dozens of defect tickets from development to release.
- Effective communication and partnering with other teams is essential for routing and tracking issues through the organization and expediting customer service requests – being a team player is a must.
SQL Developer Duties and Responsibilities
Developing and maintaining SQL databases requires many tasks, and based on job listings we analyzed, these duties are typically assigned to SQL developers:
Develop SQL Databases The main responsibility of an SQL developer is the development of SQL databases for a wide variety of applications and business uses. This can include developing backend data for web applications, data storage for large businesses and organizations, and relational databases for educational institutions or libraries. An SQL developer uses their experience with data architecture and management to develop and scale SQL databases based on their organization’s needs.
Write SQL Queries Along with developing SQL databases and tools, the SQL developer writes SQL queries to store, sort, and retrieve data. These can range from basic commands like read, write, create, and update to complex commands that fetch and manage data across multiple tables. The specific SQL needs can vary based on the organization and application, but the ability to write and optimize these codes is essential in this role.
Conduct Database Troubleshooting The SQL developer is also responsible for conducting troubleshooting on databases and applications. This can be a long and time-consuming process, involving data validation and extensive testing to ensure that the database systems and access programs meet the end-user’s specifications and requirements. When data is migrated to a new server, the SQL developer needs to ensure that the information is intact, correct, and accessible.
Perform Server Maintenance SQL developers may also be responsible for server maintenance, which can also involve troubleshooting database programs and operations. In this aspect of the role, the SQL developer needs to manage data and log files to ensure that they are stored separately, eliminate any instances of file or index fragmentation, and check for data corruption. This is a highly time-intensive part of the SQL developer’s role and requires great attention to detail.
Gather Requirements Another important responsibility of the SQL developer is gathering requirements and specifications from the end-users. This helps them understand how the database and its information will be used and can contribute to the way an SQL developer structures data and grants access to users. SQL developers frequently meet directly with end-users or IT professionals to gain familiarity with their specific SQL and data management needs.
Enhance and Improve Systems SQL developers need to constantly seek out methods to better handle data and increase system efficiency. This can mean writing more complex and optimized queries, changing the way data is stored or structured, or bringing data onto a new server that can better meet the needs of the organization. SQL developers may propose and develop new methodologies and institute best practices to further enhance database performance.
SQL Developer Skills and Qualifications
The SQL developer’s role is highly analytical and detail-oriented, requiring extensive familiarity with data management and access principles. Companies typically hire applicants with a bachelor’s degree in a related field, along with the following skills:
- Data Management – SQL developers need extensive familiarity with data management principles and best practices in order to properly store, migrate, and structure data for multiple applications
- Software Programming – Software programming is an essential skill for SQL developers since they need to write complex operations, scripts, and triggers to support database access and frequently need to address software bugs
- Server Development and Maintenance – Familiarity with server development and maintenance is also vital for SQL developers since this helps with troubleshooting and data migration tasks
- Problem-Solving – SQL developers are excellent problem-solvers and can isolate and resolve database issues and maintain access and data integrity
- Written and Verbal Communication – Communication skills are important in this role because the SQL developer needs to gather requirements and specifications in collaboration with IT professionals and end-users while reporting on database issues
- Process Enhancement – SQL developers are skilled at developing more efficient processes for handling and accessing data and performing routine maintenance
SQL Developer Education and Training
SQL developers should have at least a bachelor’s degree in a related field such as computer science. In addition, SQL developers can receive certification from a number of organizations, such as Microsoft, Oracle, and MySQL. These certifications can help expand a developer’s knowledge of SQL principles and can help them find a position in this field.
SQL Developer Salary and Outlook
Glassdoor estimates a salary range from $61,000 to $102,000 for SQL developers, with an average annual salary of $81,714. These estimates are based on 679 reported salaries, with most falling slightly below that average. PayScale estimates that SQL developers earn a median annual salary of $71,530 based on 1,465 reported salaries. Their estimates indicate that the lowest-paid 10 percent of SQL developers earn $48,000 per year, while the highest-paid can earn over $106,000. The Bureau of Labor Statistics estimates that software development will continue to be a rapidly-growing field between 2016 and 2026, with 24 percent employment growth. SQL developers can expect to continue to be in high demand as companies hire individuals to help them manage increasing data loads.
Helpful Resources
We found many resources on the web if you’re interested in learning more about becoming an SQL developer: Microsoft SQL Certification – Learn about the certification process for Microsoft SQL, and how it can advance your career as an SQL developer.
SQL: Easy SQL Programming & Database Management for Beginners – This beginner-friendly guide by Felix Alvaro explores principles and practices for SQL developers.
“Future Growth of a SQL Developer” – Read about what sets SQL development apart from other information technology and
database development roles, and how this position is expected to grow.
Learning SQL: Master SQL Fundamentals – Learn the skills and techniques behind SQL development, along with essential information about data architecture and management in this book by Alan Beaulieu.
Computer Software Cover Letter Examples
Rate This Article
[SQL Developer]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
