SQL Engineer Resume Sample
Work Experience
- Project work to enable reporting to the regulators
- Tactical technical enhancements to solutions for improving the process
- Decommission of interim solutions and platforms in-line with the build out of the strategic architecture
- Development and optimization
- Configuration and monitoring
- Indexing and Database optimization
- Backup and recovery planning
- Be able to explain how they work down to the core
- Write complex ANSI SQL queries against a MySQL database
- Create, manage and optimize views and stored procedures
- Create and manage database tables, properties, meta data, etc
- Debug and manage database related issues
- Create sample data
- Create documentation for the development team to interact with the database to perform transactions
- React quickly to emerging customer requirements and technologies. Ability to anticipate future needs and design with reusability in mind
- Ensure quality in the production of data assets
- IT experience with 5+ years of hands-on experience in SQL development
- Highly experienced in writing complex ANSI SQL queries - required
- Strong Data modeling experience from conceptual to logical and physical - required
- Experience with data modeling tools, e.g. Erwin - required
- Development experience with Java - required
- Strong relational database knowledge/experience with MySQL v5.7+ is required
Education
Professional Skills
- Experience in data modelling with excellent SQL skills in at least several enterprise grade RDMBS
- Excellent Analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables
- Good team player with strong analytical, communication, and troubleshooting skills
- Strong problem identification / problem solving skills, capable of creating creative workarounds "on the fly"
- Proven Microsoft SQL DB Operations or Engineering skills
- Query optimization and performance tuning skills
- Strong development experience working with MS Excel Java APIs - required
How to write SQL Engineer Resume
SQL Engineer role is responsible for database, sql, design, compensation, trading, credit, securities, training, integration, security.
To write great resume for sql engineer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For SQL Engineer Resume
The section contact information is important in your sql engineer 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 Engineer Resume
The section work experience is an essential part of your sql engineer 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 engineer 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 engineer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative SQL Engineer resume experience can include:
- Demonstrate flexibility, versatility and an ability to manage multiple concurrent priorities to completion without significant guidance
- Experience in Cloud solutions for SQL Server - good to have
- Good working knowledge of Microsoft Windows systems, including DNS, Group Policy, and PKI
- Experience in Test/Behaviour-Driven Development (including test automation and mocking tools)
- Experience installing / deploying complex systems on Windows servers
- Experience performing automated functional testing
Education on a SQL Engineer Resume
Make sure to make education a priority on your sql engineer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your sql engineer 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 Engineer Resume
When listing skills on your sql engineer 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 engineer skills:
- Solid experience in core concepts such as indexing, partitioning, error handling and transactions etc
- Problem-solving skills (independently resolving complex issues)
- Strong practical experience working with MS SQL Server 2012
- Experience writing and troubleshooting T-SQL, relational databases, and reporting
- Experience with MySQL replication , clustering , load balancing and fail over
- Real experience with testing, code review, provisioning (Chef/Ansible/etc.) frameworks
List of Typical Experience For a SQL Engineer Resume
Experience For MS SQL Engineer Resume
- Experience working with Linux - required
- Experience with FTP - required
- Development experience with Node JS / JavaScript - nice to have
- Knowledge of and experience in Agile development methodologies (e.g. Scrum) and collaboration tools like Jira, Confluence, etc
- IT development experience with RDBMS
- Experience with huge data volumes & complex ETL processes
- Experience working with large databases of more than 1TB size
Experience For Senior Microsoft SQL Engineer Resume
- Experience working with an enterprise environment
- Run various complex validations and data manipulations (MS SQL)
- Excellent knowledge of MS SQL database technology stack
- Experience with SQL/Database development
- Knowledge of good database and query design
- IT development experience with RDBMS
- ITIL and Scrum experience
- Experience with Cloakware
- Making releases onto testing and production environments
Experience For Consulting PL / SQL Engineer Resume
- Programming knowledge of T-SQL & SSIS
- Understanding of cyber security concepts
- Be responsible for performance tuning and re-factoring of the existing DB processing routines
- Be responsible for performance tuning and refactoring of the existing DB processing routines
- Design and implement ETL processes, using SSIS services
- Establish reporting to the regulators on the project
- Implement tactical technical enhancements to solutions for improving the process
Experience For Hive SQL Engineer Resume
- Take participation in developing SQL objects, like stored procedures, functions, views, etc
- Take participation in developing SSIS packages
- Passion for process improvement and creating great data solutions
- Background in networking and systems administration
- Knowledge of REST APIs, and JSON structures and how to parse them - required
- Microsoft SQL 2000, 2008, 2012
Experience For Microsoft SQL Engineer for Mobility Resume
- In-depth knowledge of SQL Server database engine
- Design and implement changes to Risk Engine valuation results data store in SQL Server DB
- Design, review and implement a scalable data model for CR framework
- Be responsible for decommission of interim solutions and platforms in-line with the build out of the strategic architecture
- Total work experience in a relevant IT industry, or 1+ years of experience in technology for an Investment Bank including completion of a graduate program
Experience For Senior SQL Engineer Resume
- Receive feeds (pipe-delimited text files) from upstream systems
- Load those feeds into MS SQL database
- Provide WPF GUI for users to work with uploaded data in DB
- Run high-load distributed calculation using data from DB, customary build memory cache and quant library (DLLs supported by another team) using wrapper written in C#
- Provide last line support for production incident
Experience For Microsoft SQL Engineer for Mobile Resume
- Provide assistance to business users, in their custom requests
- Be familiar with MS SQL database technology stack
- Provide assistance in transformation business requirements into technical
- Design and develop B.I./database solutions from documented requirements and specifications
- Work with business analysts and project managers to determine project requirements
- Develop testable code and unit tests for assigned tasks
Experience For MS SQL Engineer Principal Resume
- Complete project tasks and non-project tasks with minimal supervision
- Identify and design solutions to problems within a given database system and architecture
- Understand all domain-level data within a given system
- Be an expert and take ownership in intra-system projects
- Answer system and project-level questions from business units
Experience For SQL Engineer With Top Secret Clearance Resume
- Learn about new technologies and make proposals to use them as appropriate
- Analysis of customer’s requirements
- Communication with customers (London and NY)
- Global 3rd level support
- Develop and automate MSSQL Server solutions (mainly in PowerShell)
- Troubleshoot production issues raised by Operations teams: it includes ability to read and modify “old code” in Perl and “new code” written in PowerShell
- Generate Excel reports
- Write functional tests
- Populate SSAS Cube
List of Typical Skills For a SQL Engineer Resume
Skills For MS SQL Engineer Resume
- Experience in Automation, Testing
- Hands-on understanding enterprise systems, infrastructure, software design and development, database design and development experience
- Experience delivering a shipped product with these technologies
- Experience in engineering of corporate application solutions
- Experience with Microsoft SQL on Microsoft Clusters
- Experience with Microsoft SQL in virtualized environments
Skills For Senior Microsoft SQL Engineer Resume
- Work Experience in International Teams
- Sybase and Oracle experience
- Min 3 years of experience as MySQL/ MSSQL DBA
- Hands-on experience with enterprise class Database architecture, focused on transactional environments w/focus around SQL 2012/2014
- Managing MySQL/ MSSQL in production environment including installation, configuration, backup, recovery, upgrades and schema changes
- Willing to improve current environment and processes
- Estimating project duration, effort, resource load and cost
- Creating processes to ensure data integrity and identify potential data errors
Skills For Consulting PL / SQL Engineer Resume
- Powershell or perl scripting (1+ years)
- Standard MySQL/MSSQL monitoring techniques
- Able to work under pressure and multi-tasking capabilities
- Microsoft SQL (2008 R2/R1) (2+years)
- Window and Web Services development
- Communicate between different time zones
- Understand dependencies between stakeholders and interact with them to deliver our solutions
Skills For Hive SQL Engineer Resume
- Diagnose server problems and employ preventive measures to maintain high availability servers
- Assistance in database daily operation
- Possess creative ability, credibility, self-confidence
- Work independently, as well as collaboratively with other staff members, to complete short and long-term projects
- Pro-active, dedicated, committed and responsible Willingness to reach beyond job description to accomplish company’s objectives
- Willingness and flexibility to learn new technologies
- In DB architecture/design and development with Microsoft SQL
Skills For Microsoft SQL Engineer for Mobility Resume
- Familiarity with SSIS and ETL
- BS/MS (or equivalent) in computer science or related field
- Automation/script /programmer (most preferably PowerShell) competency developed through practical experience in automation of various Microsoft solutions (preferably Microsoft SQL Server)
- Proficient in T-SQL, SQL Server Integration Services, and SQL Server Reporting Services
- Proficient in Microsoft C# .NET technology
- Lead the design, build, verify, implement and maintain the structure of databases to support company business needs including integration of vendor database solutions into the Department of State data environment
- Lead and Serve as a SME in the Database Design and provides technical direction for the development, design, and systems integration for client engagement from definition phase through implementation
- Established relationships with Department heads and/or stakeholders to ensure priorities are completed by the prescribed deadline or ahead of schedule
- Good working knowledge of SCCM, McAfee (Foundstone, EPO),ForeScout and Tenable and the environments in which they are deployed
Skills For Senior SQL Engineer Resume
- Follow good processes and practices, as defined by the team standards
- Troubleshooting and analysis of highly available database systems and maintaining best practice
- Accountable to establishing the standards and processes around providing level 3 support for databases and tools
- Liaise with Test Specialists to ensure testing activities are completed as per best practices and according to Agile standards
- Lead and Participate in Development, Coding Enhancement and the creation of all ETL Process
- Lead and Assist with the client and help the Business Analyst with requirement gathering and requirement analysis
- Drive the life cycle of multiple database tools by enabling smooth upgrades and/or installation and support of new capabilities; establishment and implement a data architecture practice
- Accountable for creating, implementing and maintaining reusable project and system related documentation consistent with standards and procedures outlined in the data architecture approach to ensure data quality, availability and reliability
Skills For Microsoft SQL Engineer for Mobile Resume
- Responsible for Maintaining of all version control of database
- Accountable for the processes to ensure reuse, recovery and maintenance
- Review and verify new applications data source for their ability to be integrated into the environment – specifically around data. This includes design around security, maintainability, reliability, performance and metrics
- Highly proficient in performance tuning of SQL statements and queries , performance monitoring of database systems ,
- Proven ability in creating standardized reports used for detailed analysis by various departments, assisting users by understanding their business reporting requirements and using technology to translate those needs into projects and reporting solutions
- Experience in designing and implementing Data warehousing and Business intelligence systems, including: Roadmap Definition, Solution Architecture, Well-versed in disaster recovery solutions, Security, Metadata Management, Data Modeling, and Data Quality
Skills For MS SQL Engineer Principal Resume
- Responsible for all technical documentation and polices relating to all Database deployment
- Created weekly and as needed project status reports, and also led Database demonstrations
- Lead and developed database design schema for integrating data source such as McAfee, NetIQ, SCCM, Symantec Anti Virus , Forescout and Tenable into data management systems
- In-depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for nationwide offices
- Liaise with the Design Authority and IT teams in other regions to ensure that all new components fit within guiding principles
- Implement and test technical solutions from user stories to both new and existing systems
Skills For SQL Engineer With Top Secret Clearance Resume
- Conduct peer reviews and providing documented constructive feedback
- Contribute to user story mapping of requirements and technical design where necessary
- CISSP, Security+ or DoD 8570 Certification required
- ITIL v3.0 or Foundation Certifications highly desired
- Provide KT (Knowledge Transition) to junior and new members of the team
- Understand the business case and benefit and ensure that the implementation being delivered is fit for purpose and capable of delivering against stated benefits
- Contribute as required to the business case, requirements and scope
- Work with the BAs to ensure acceptance criteria is clearly documented and technical implementation meets this acceptance criteria
- Provide input to release walkthroughs with the environment managers and teams
Skills For Senior MS SQL Engineer Resume
- Total work experience in a relevant IT industry, or 1+ years of experience working in technology for an Investment Bank including completion of a graduate programme
- In-depth experience on Microsoft SQL Server, with SQL Server 2008+ experience
- Advanced TSQL and database design skills
- In-depth experience in Microsoft SQL Server, with SQL Server 2008+ experience
- Excellent programming knowledge of T-SQL (writing stored procedures, indexes, views), relational database design and performance tuning
- Experience packaging using Windows Installer compatible methods and products
- Experience working on large databases of more than 1TB size
- Preferably hands-on experience with PowerShell or any other scripting language