SQL Programmers are responsible for writing, testing, and debugging code that is used to interact with databases. These programmers must be able to understand user requirements and design functional specifications for websites, applications, and databases. They also test their code to ensure that it works properly without errors or bugs, then train coders, document procedures, and train users. Customer service skills are needed in this role in order to communicate with clients or web designers who have questions on a project. Proficiency in a wide range of computer languages is required as well as an understanding of web programming. A bachelor’s degree in Computer Science is typically required for this position.
The Best SQL Programmer Resume Samples
These are some examples of accomplishments we have handpicked from real Programmer resumes for your reference.
- Designed and maintained a professional report generation program using VB 6, Access 2000, ActiveX, ADO, MS Query, OOP, ODBC, and SQL 7 in a client-server environment.
- Automated and interfaced MS Outlook with Excel and Access using Excel VBA.
- Trained employees on all levels in the use of customized software.
- Designed, tested, and implemented SQL-driven applications from the ground up, generating solutions for real-world problems.
- Converted disparate data silos into a unified set of SQL tables for analysis.
- Designed and implemented spend reporting solution (ASP.NET/MS SQL 2000) to provide upper management with user-customizable reports based on detailed Accounts Payable/General Ledger data.
- Participated in the decision-making process on projects goals, timelines, and milestones.
- Produced technical documentation, system design documents, technical specifications, CBT, and user manuals features.
- Oversaw the creation of a coherent application to streamline the workflow of product imaging software.
- Reorganized an unruly codebase with tons of spaghetti code and crappy OOP by using proper design patterns and SOLID principles.
- Developed and tested SQL Server Integration Services (SSIS) programs to extract, transform and load data from legacy Asset Management systems into multiple versions of Remedy running on Oracle.
- Created and packaged documents for releasing the SSIS packages to the Deployment team, which included Design, Test Strategy, Installation and Configuration, and Execution documents.
- Collaborated with global teams to gather requirements, determine which data fields to migrate, map fields between the systems, and transform the data to meet the new system requirements.
- Created an open-source SQL parser that includes parsing trees, syntax analysis (with errors), and run-time error detection; attracting 100+ downloads per day on GitHub.
- Refactored, updated, and programmed database to allow for a split database and over twenty new reports, functions, and administration utilities.
- Performed various database programming tasks such as the creation of views, stored procedures, and user functions on Microsoft SQL Server using T-SQL.
- Modified XSLT for use with SAP Business One Mobile integration scenarios.
- Lead SugarCRM implementations and training for new customers.
- Replaced and expanded an existing database system for two customers, and standardized the database and all of the application modules with the latest advances in SQL.
- Upgraded an existing server application that provided transaction processing functionality to handle multiple simultaneous client requests.
- Developed web-based application for Next Generation of Single Family Default Monitoring System (SFDMS) for reporting delinquent and default loans to HUD.
- Designed, Developed and Unit tested SSIS interface to extract data from the universal data source (ODS) and Load Next Gen server with various transformations.
- Coding of complex Stored Procedures (SPs), Views, and User-Defined Functions (UDFs) based on business requirements for reporting applications.
- Developed an Internal Rule engine to simulate the exceptions that are triggered at external agencies.
- Created a software component capable of using a single screen to provide multiple views of configuration properties related to sales orders.
- Modified PL/SQL procedures shell scripts previously run weekly to run daily.
- By restructuring the queries and optimizing the SQL, was able to cut the run time by 80%.
- Created tables and processes to produce customer contact lists based on customer activity and outstanding transactions to be used by the stores during promotions and sales events at each store.
- Wrote procedures to identify customers with open items such as loans or layaways and load them into tables to be used by queries to produce contact lists as stores relocated or closed.
- Developed queries and shell scripts to produce files containing store metrics and transfer them to the cloud for field management teams allowing them to view daily performance data on their mobile devices.
- Expertise in BI applications reporting tool SQL Server reporting services (SSRS) and SQL Server integration services (SSIS) and Pervasive Data Integrator (V.10).
- Created queries with Inner Join, Outer Join, left join, right join and Co-Related sub-query with Mathematical function, Aggregate function.
- Extensively used Joins, sub-queries for complex queries involving multiple tables from different databases.
- Used various SSIS tasks such as Conditional Split, Derived Column and Slowly Changing Transformation which were used for Data validation checks during Staging.
- Translated a complex business process into several lines of code allowing users without programming experience to create sales order requests through their own client applications.
- Developed back-end database stored procedures application for resources planning and daily Transaction using SSRS.
- Developed back end 2005 SQL Server Database using Stored Procedures, Triggers, Transact SQL, Views, and Queries.
- A developed an application named RBA (Role Based Access) for Upstream and Downstream oil drilling using SSRS.
- Coordinates with other IT departments to ensure implementation and monitoring of reports.
- Won the best Microsoft Visual Basic Programmer award in a private software company.
- Analyzed the client requirement of calculating the distribution losses and CVR losses of different customers.
- Developed a data warehouse project for loss calculations by merging meter and substation data from different oracle, MS SQL sources, and flat files.
- Analyze gaps in the SQL database and report to the client to maintain data integrity.
- Created complex queries based on weighted averages to approximate the customer usage in MS SQL 2016.
- Built efficient, robust, and stable programs for private clients; obtained naming rights to product names.
- Responsible for supporting large SQL Server reporting and analytical environment.
- Work on small to large projects and provide project documentation.
- Build ETL processes, stored procedures, and SQL jobs in a SQL Server database environment.
- Manage and protect data and data management principles (metadata, data mapping, data classification, data provisioning, etc).
- Created powerful databases to store valued personal data and to direct the flow of money; improved upon the efficiency of the company’s existing system.
- Write advanced SQL scripts and stored procedures and conduct query performance tuning.
- Develop and maintain SSRS reports on the report server and web application.
- Work with business stakeholders on data modeling and system design.
- Manage data loading, troubleshoot issues, and revise SSIS packages accordingly.
- Act as junior DBA, monitor daily Databases backup and restoration on multiple servers.
- Develop procedures to improve EDI system performance and provide feedback to the business when data issues arise.
- Support regional teams to ensure all pharmacy and facility data are complete and accurate.
- Monitor data transfers from multiple sources for timely processing on a daily basis.
- Create data pulls used for downloading into Excel for Pivot table trending analysis.
- Develop SQL code for work requests submitted by the business for analysis, reporting, and data maintenance.
How to Become a Successful SQL Programmer?
- A background in coding and technology is more important to employers than any specific level of education, but they will still typically want some kind of degree or certification to show you have a well-rounded grasp of the material. A certificate class will do if you have experience, but a bachelor’s will be needed if you’re starting new.
- Being hired will typically begin with a training period where more experienced employees will show you the ins and outs of the programs set up by the company, and paying careful attention during this period will help you better understand what will be required of you once you start working on your own.
- Being a programmer always requires very close attention to detail, as coding is a language where even a single letter or symbol put in incorrectly can throw everything off and create considerable work for you down the line. Making sure everything is accurate on the first try will make far less work for you later.
As the programming language in question is based around databases, one of the best ways to ensure that you’re succeeding at what you do is ensuring that all information can be retrieved as desired and is accurate. Being thorough and testing this often will make it much easier to find errors ahead of schedule.
Companies typically have a great deal of resources and information that needs to be tracked at any given time, and one of the ways they do so is with databases that hold the names and other such bits of information they need to know. An SQL programmer helps to make sure the program that allows easy communication and access to these databases is up and running.
Hope these samples gave you an idea of what your resume should look like and some tips on how to make sure that your resume stands out from the rest.