Automatically apply for jobs with Zippi
Upload your resume to get started.
Database analyst/developer skills for your resume and career
15 database analyst/developer skills for your resume and career
1. Microsoft SQL Server
- Designed a comprehensive Database structures to include tables, views, triggers and stored-procedures using Microsoft SQL Server 2008.
- Designed, developed and supported the Production Scheduling System by using PowerBuilder with Microsoft SQL Server database.
2. ETL
- Created advanced ETL process including extracting and cleaning variety of data sources into data warehouse fact tables and dimension tables.
- Created the ETL process to compare three different credit scores from major credit reporting agencies and a based credit score.
3. Ssis
SSIC stands for Singapore Standard Industrial Classification. It is a national standard for classifying economic activities such as population censuses, household and business surveys, financial databases etc.
- Created Data marts and loaded data from Oracle Database and Oracle source files to SQL server 2005 database tables using SSIS.
- Converted several DTS packages into SSIS packages to improve performance of the package and to make it more sophisticated.
4. PL/SQL
- Created SQL, PL/SQL procedures, packages, functions, triggers, views specific for the application.
- Based on business requirements and rules, designed and developed software modules using Pro*C and PL/SQL.
5. Data Analysis
- Used Microsoft SQL database management system for data analysis.
- Perform complex queries, stored procedures and Materialized Views for reports and data analysis according to user requirements.
6. Database Design
- Created supporting documentation of business processes, database design, user and administrator training materials.
- Developed the Requirements Document, the Use Case Document, all UML diagrams and the Database Design and Data Models.
Choose from 10+ customizable database analyst/developer resume templates
Build a professional database analyst/developer resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your database analyst/developer resume.7. SSRS
- Worked several projects including Davis Furniture converting Crystal Reports into SSRS reports.
- Developed and built SSRS reports supporting more than 20 client company's general business reports and benefit plan administration processes.
8. T-SQL
- Created T-SQL queries, tables, Views, stored procedures(PL-SQL) and functions that are required for report generation.
- Design, code, test and debug business logic for software applications using T-SQL per defined technical specifications.
9. Database Objects
- Created database objects include stored procedures, triggers, indexes, tables, Replication Definitions, Function Strings, Subscriptions.
- Develop and modify database objects, develop reports, table structures, forms, and some functionality.
10. Data Warehouse
Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.
- Performed data extraction from different data sources and loaded into a centralized data warehouse environment.
- Gather requirements from business units for data warehouse and operational reports.
11. Database Development
- Established successful database development, consultation and training business.
- Support developers with database development and maintenance.
12. Web Application
- Assist in debugging code in websites and web applications to deliver high functioning products to clients.
- Designed and developed the web application G1 to provide metric visibility within the Army North Command.
13. BI
- Implemented the data modeling for BI environment using Erwin tool.
- Assist clients using BI Excel datasets, creation of Excel pivot tables, and calculations.
14. VBA
Visual Basic for Applications or, as it is commonly shortened to, VBA is a certain method of using Microsoft's event-driven programming language known as Visual Basic.
- Designed, developed, implemented, and maintained database applications using Microsoft Access, VBA, and Paradox.
- Utilized Data Transformation services, Transact SQL, VBA and stored procedures to automate data processing functions.
15. Windows
Windows is a chain of operating systems that controls a computer and is developed by Microsoft. Every version of Windows consists of GUI (graphical user interface), with a desktop that allows the user to open their files.
- Verified and implemented network configuration, customization and troubleshooting in a Windows Server environment.
- Design and implement event-driven Windows components and controls using Visual Basic.
5 Database Analyst/Developer resume examples
Build a professional database analyst/developer resume in minutes. Browse through our resume examples to identify the best way to word your resume. Then choose from 5+ resume templates to create your database analyst/developer resume.
What skills help Database Analyst/Developers find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want.
What database analyst/developer skills would you recommend for someone trying to advance their career?
Nikyra Capson
Assistant Professor, Idaho State University
List of database analyst/developer skills to add to your resume
The most important skills for a database analyst/developer resume and required skills for a database analyst/developer to have include:
- Microsoft SQL Server
- ETL
- Ssis
- PL/SQL
- Data Analysis
- Database Design
- SSRS
- T-SQL
- Database Objects
- Data Warehouse
- Database Development
- Web Application
- BI
- VBA
- Windows
- Java
- Unix
- Data Integrity
- XML
- SSAS
- Data Models
- Data Warehousing
- Teradata
- Database Systems
- Application Development
- Technical Specifications
- Data Extraction
- JavaScript
- SDLC
- SAS
- Toad
- Access Database
- DB
- DTS
- SharePoint
- Management System
- ASP
- Business Rules
- VB
- SQL Loader
- User Interface
- Load Data
- QA
- DBA
- Data Flow
- Oracle 10G
Updated January 8, 2025
