SQL Server Database Developer Resume Sample
Gustave Bogan
1859 Hirthe Mountain,
Detroit,
MI
+1 (555) 848 4653
Work Experience
Senior SQL Server Database Developer
09/2016
-
PRESENT
Detroit, MI
- Lead database development by working with software developers
- Enhance and drive existing database development operations and processes
- Lead database and reporting development projects; ensure successful project delivery
- Conduct data architecture, design and code reviews and provide feedback on database engineering best practices
- Design and develop database and reporting systems and subsystems while taking into consideration business needs, integration, quality, and performance
- Assists with database monitoring, backup/recovery, indexing, platform upgrades, version migration, and new platform install/configuration
- Partner with senior staff to troubleshoot SQL Server outages and performance problems as well as Disaster Recovery testing and planning
SQL Server Database Developer
09/2012
-
03/2016
Detroit, MI
- Supports the development team in the implementation of new application features and system changes by scripting and checking in DDL changes to database objects (ex. tables, indexes, views, stored procedures, functions, synonyms, etc.) into source control
- Participates in peer reviews of T-SQL scripts and database objects written by other team members, identifying logic flaws and enforcing application design and coding standards and industry best-practices
- Provides performance tuning recommendations to other team members, and assists with the implementation of performance fixes
- Creates release package T-SQL scripts for data updates/fixes that need to be propagated to multiple environments and include them in the release deployment package
- Creates, tests, and executes “one-off” T-SQL scripts to correct application data in the appropriate environments
- Creates and maintains in source control “initial seeding” scripts of static and semi-static data used to initialize a new instance of the application
- Creates and maintains T-SQL script templates for the database and development teams
- Provides database design and coding standard recommendations to the team
- Documents the database environment
Temporary SQL Server Database Developer
02/2009
-
08/2012
Dallas, TX
- Creates, tests, and executes "one-off" T-SQL scripts to correct application data in the appropriate environments
- Creates and maintains in source control "initial seeding" scripts of static and semi-static data used to initialize a new instance of the application
- Optimize database design to meet user and performance requirements
- Design & create reports with Filemaker & SQL Server Reporting Services
- Create enterprise level ETL processes with SQL Server Integration Services
- Assist with data visualization in Tableau
- Assist with data provision to statistic/econometric modeling team
- Turn the desired business logic into SQL code
- Strong skills with SQL language in a Microsoft SQL Server environment
Education
Lawrence University
2005 - 2009
Engineer's Degree in Computer Science
Professional Skills
- Demonstrated analytical skills; strong ability to interpret analytical data
- Strong listening skills; ability to capture requirements expressed in design meetings
- Developing negotiation and persuasion skills; ability to facilitate consensus among a diverse group of stakeholders
- Demonstrated experience in refactoring, testing, debugging, and optimizing SQL code
- Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL
- Strong knowledge and experience using Transact-SQL including writing complex queries for ad-hoc requests and data analysis
- Excellent command and understanding of Dynamic and Advanced SQL queries in MS SQL Server 2012, and extensively experienced with SQL / T-SQL / SSIS / SSRS
How to write SQL Server Database Developer Resume
SQL Server Database Developer role is responsible for design, integration, database, procurement, security, payroll, architecture, reporting, research, modeling.
To write great resume for sql server database developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For SQL Server Database Developer Resume
The section contact information is important in your sql server database developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your SQL Server Database Developer Resume
The section work experience is an essential part of your sql server database developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous sql server database developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular sql server database developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative SQL Server Database Developer resume experience can include:
- Provide excellent customer service by responding to and assisting with help desk calls to resolve issues, including system outage
- Experience in analyzing, designing and supporting applications that interface with database
- Hands-on database tuning and troubleshooting experience
- B.S in Software Engineering or Computer Science with 5 or more years’ RDBMS experience in Microsoft SQL Server
- Skilled in database architecture and design principles including relational database design, views, indexes and joins
- Apply best practices analyzing, designing, developing, and supporting enterprise databases
Education on a SQL Server Database Developer Resume
Make sure to make education a priority on your sql server database developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your sql server database developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in SQL Server Database Developer Resume
When listing skills on your sql server database developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical sql server database developer skills:
- Strong experience in SQL / T-SQL (SQL Server 2008+) - DDL/DML/DCL/TCL, windowing functions, etc
- Working experience with the following core technologies: SQL Server 2008 R2/2012, Visual Studio 2010/2012, SQL Server Data Tools & Team Foundation Server
- Experience in Performance Tuning and Optimization using native monitoring and troubleshooting tools
- Experience developing ETL solutions utilizing SSIS including Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions
- Experience designing, developing, and maintaining the flow of data between systems
- Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization
List of Typical Experience For a SQL Server Database Developer Resume
1
Experience For Senior SQL Server Database Developer Resume
- Provide database analysis, design, development, and support of enterprise level applications
- Ensure security and privacy of data across people, process, and technologies of company databases
- Collaborate with the application development teams and Database Administrator to ensure standards for database development and databases
- Participate in multiple projects simultaneously as a development team member
- Design and develop new database schema objects such as tables, indexes, views, stored procedures, functions, triggers, jobs, etc. while supporting legacy database schema currently supporting production environment
- Designs, develops, tests and troubleshoots applicable software packages that implement complex ETL processes in accordance with business requirements and service level agreements
- Develops ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds. Develops and documents systems, processes and logic required to expose existing data sets in the warehouse to end users for reporting and analytical purposes
2
Experience For SQL Server Database Developer / Architect Resume
- Monitors ETL applications for performance and improvement opportunities. Ensures quality, consistency and security of company data and data warehouse systems. Troubleshoots and diagnoses complex software problems. Conducts packaging, release and change management
- Keeps informed of tools, techniques and components utilized in the industry through research and applies this knowledge to system(s) being developed
- Database modeling (ERD)
- SQL Server Profiling
- Works with application developers, business partners, management and Data Warehouse team. Extends the data model to house additional structures as needed to meet applicable regulatory requirements. Designs data warehouse or data mart fact tables, aggregate tables, and dimensions. Delivers quality data integration projects, standards, best practices and data dictionary
- Communicates open items and issues to key stakeholders, including management, development teams, and business areas. Reviews requirements, architecture and design components of ongoing and upcoming Tier 1 projects. Conducts and manages code review sessions between developers to review applicable software programs and packages, stored procedures, and views
List of Typical Skills For a SQL Server Database Developer Resume
1
Skills For Senior SQL Server Database Developer Resume
- Experience in designing and developing software applications
- Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
- Experience of test driven development and of continuous integration platforms
- Experience with T-SQL development in Microsoft SQL Server
- Experience in a BI/Data Warehouse environment with involvement in design and architecture
- Working with the Data Architect to identify and resolve system-level ETL issues
- Recognize and work with recursive data structures of different forms as well as an understanding of standard programming algorithms
- Maintain and troubleshoot existing processes with thorough understanding of interrelationships with other programs and processes
2
Skills For SQL Server Database Developer / Architect Resume
- Database schemas, designing, and creating database optimizations where applicable
- Knowledge in database partitioning
- Communicate and coordinate coding efforts with team members
- Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency
- Strong object oriented design skills and experience in identifying and applying design patterns. Experience in working with dependency injection frameworks is desirable
- Experience with Microsoft SQL Server 2008R2, 2012 or 2016
- Experience with Big Data (Hadoop, HDFS, Cloudera, MapReduce, Hortonworks, etc.)
- Professional experience with ETL
3
Skills For SQL Server Database Developer / Administrator Resume
- Experience with MariaDB, MySQL, or PostgreSQL
- Self-motivated and organized, with determination to achieve goals; ability to work autonomously when required
- Certification in Microsoft SQL Server
- Knowledge of DoD Property Accountability, Accounting Standards and Financial Reporting, Fleet Management, Supply Chain Management, and/or Weapons and Ammunition
- Microsoft Certified Solutions Expert (MCSE), Microsoft Certified Database Administrator (MCDBA), Certified Data Management Professional (CDMP) or a Business Intelligence designation
- Develop, test and document executable code according to functional and technical specifications using established development methodology and standards
- Knowledge of scripting languages such as C# and VB.Net
- The ability to generate, test and evaluate multiple approaches to problems before focusing on a solution
4
Skills For Temporary SQL Server Database Developer Resume
- Knowledge of various databases such as MySQL and Oracle
- Knowledge of Master Data Management (MDM) and Governance
- Knowledge of System DBA
- Accept ownership of problems at a high level
- Microsoft Visual Studio 2008 and above
5
Skills For SQL Server Database Developer / DBA Resume
- Payroll and Human Resources background
- T-SQL, Stored Procedures, Functions, Views
- Microsoft SQL Server 2005+ Databases
- Excellent understanding of Entity-Relationship/Multidimensional Data Modeling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server Analysis Services (SSAS)
- Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML/SQL/Oracle) to different targets (DB/Files)
6
Skills For Principal SQL Server Database Developer Resume
- Experience in creating master and child packages, package configurations, logging and in using variables and expressions in packages
- Worked with tabular reports, matrix reports, parameterized reports according to business requirements in time restricted environment using SQL server reporting services (SSRS)
- Highly committed, motivated and a natural team player with strong analytical ability
- Expert in developing Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2012/2008R2
- Experience writing technical specifications for work to be performed by other developers
7
Skills For SQL Server Database Developer Resume
- 3+ (SWE) or 7+ (Sr. SWE) years of overall IT/software development experience
- 2+ (SWE) or 5+ (Sr. SWE) years of recent and relevant experience as an SQL Server / Oracle developer or software engineer working on large-scale apps (ERP, CRM, etc.)
- Experience developing and utilizing temporal tables
- Experience in designing advanced SQL queries, stored procedures, user defined functions, views, triggers, scripts and cursors
- Experience with ER data modeling tools ( Embarcadero ER/Studio, ErWin etc.. )
- Informatica experience helpful but not required
- Keen eye for query tuning and optimization using indexing, partitioning, optimizer statistics, execution plans, profiler
- Knowledge of newer database architectures, tools and best practices for SQL Server including ORM mapping tools
- Work on cross-functional teams ensuring the delivery of software solutions as planned, within set budget and project timelines
8
Skills For Senior SQL Server Database Developer Resume
- Perform database and SQL performance tuning
- Develop and gain an understanding of full software development lifecycle
- Develop and gain an advanced understanding of Rates business, markets, products & flows
- Perform work with very large marketing databases (VLDB’s)
- Knowledge of locks, transactions and isolation levels
- Expert T-SQL development skills including query optimization, stored procedures, views, functions and triggers; ability to read, interpret and improve query execution plans
9
Skills For SQL Server Database Developer / Architect Resume
- Collaborate with developers, project managers and business analysts in conceptualizing, designing and developing new database applications, modules and enhancements
- Conduct research on emerging database and application development software products, languages, and standards in support of procurement and development efforts. E.g. SQL Server 2017
- Prepare and distribute work assignments, provide guidance, and/or review the work of local and offshore development team members
- Implement solutions that are reliable, scalable, and perform at a high-level to meet the service levels associated with mission-critical database solutions
- (Senior software engineer) - Lead a small team of developers through the development process
- Familiarity with SCRUM / Agile development methods
10
Skills For SQL Server Database Developer / Administrator Resume
- Direct the construction of appropriate database designs, procedures, and other SQL Server database objects for both batch oriented and online workloads
- Proven analytical and problem-solving abilities. Ability to assimilate information and quickly discern the most relevant facts and recommend the quickest, most practical design solution
- Mentors less experienced database / ETL developers
- Work with architects to define and implement migration strategies from legacy systems to new architecture and technologies
- Outstanding communication skills (verbal and written) and an ability to communicate with internal and external customers and all levels of management, including communicating technical information to nontechnical audiences
- Flexible and adaptable in regard to learning and understanding new technologies
- Attention to detail and the ability to manage several tasks at once
Related to SQL Server Database Developer Resume Samples
Dba-oracle Resume Sample
Work Experience
• Good Understanding of Storage, Network, server technology, operating systems for optimal application performance is required
• Understands the business requirements for applications and implements supporting database technical capabilities
• Performs database administration f...
Professional Skills
• PL/SQL development skills and coding skill...
• Strong data modeling and data design skills
• Excellent communication skills and ability...
SQL Server Database Administrator Resume Sample
Work Experience
• Installs and upgrades SQL Server Software
• Performs application security configuration and administration
• Performs logical database design and physical database implementation
• Instrumental in SQL Server database creation, monitoring and performance...
Professional Skills
• Demonstrate Skills at troubleshooting and ...
• Strong SQL Server database maintenance and...
• Excellent systems architect and design skills
SQL Server Developer Resume Sample
Work Experience
• BSc in Computer Science or an IT related discipline
• Excellent knowledge of SQL performance tuning
• Considerable knowledge of SQL Server 2008-2012 (R2 environment)
• Good understanding of SSIS, SSRS, SSAS
• An excellent working ...
Professional Skills
• Related experience which demonstrates a sk...
• Strong designing, development and troubles...
• Experience developing database processing ...
Senior Cyber Resume Sample
Work Experience
• Demonstration of deep technical understanding of Cyber/Network Security & Privacy, an Commercial and Technology Errors & Omissions, and Media. Utilizing risk expertise and knowledge of industry and insurance market place, reviews clients’ exposures and loss experience and develops solutions for complex clients’ n...
Professional Skills
• Passion for all things information technol...
• Project and case management skills
• Experience of using common security tools ...
Consultant CRM Resume Sample
Work Experience
• Identify the appropriate stakeholders for your area of work, considering the impact of your work and the broader cross-functional dependencies. Manage these relationships to meet stakeholders’ business needs and align expectations. Always strive to improve business partner satisfaction
• Implemente...
Professional Skills
• Strong Influencing skills and communicatio...
• Global team player, effective and reliable...
• Experience managing global CRM teams and w...
Lead SAP Resume Sample
Work Experience
• Application life cycle management for all Tate & Lyle’s application landscape including roadmaps and Software Asset Management where needed
• Comprehensive understanding of SAP’s customizing toolset
• Work independently as well as a part of a global team
•&nbs...
Professional Skills
• Experience in strong background in formal ...
• Business Analyst experience in functional ...
• Min of 6 to 8 years of experience required...