We provide IT Staff Augmentation Services!

Database Developer Resume

Denver, CO

SUMMARY:

I am dedicated with 4+ years of IT experience in MS SQL Server with extensive experience in Administration, Architecture and Development of SQL Server 2008/2012/2014/2016/2017/2018. Also, I have experience in database Administration for large and Complex Databases in MSSQL Server, data modeling, development, Installation, Configuration and Upgrading 2008/2012/2014/2016/2017/2018. I possess a solid background in SSIS and SSRS as well as experience working in production operations and with Agile Methodologies.

TECHNICAL SKILLS:

Programming: CSS, HTML, T - SQL

SQL Servers: MS SQL Server 2008/2012/2014/2016/2017/2018

Microsoft Tools: Microsoft PowerPoint, Microsoft Word, Microsoft Outlook, Microsoft Excel

Reporting solutions: Power BI, SSRS

SQL Server Tools: SSIS, SSRS, SSAS, Profiler, Query Analyzer, SSDT, Visual Studio

Operating System: UNIX, MSSQL, MSBI, Microsoft Windows

GUI: SQL Server Integration Services, Source Control, SSMS, TSF, Import/Export

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Database Developer

Responsibilities:

  • Involved in complete Software Development Lifecycle (SDLC).
  • Wrote complex SQL queries, stored Procedure, triggers, views & indexes using DML, DDL commands and user defined functions to implement the business logic.
  • Created logins, groups, users, roles, database devices, and databases, mirroring devices, checking for database consistency, monitoring error logs, transaction log space allocations and fine tuning SQL performance.
  • Advised optimization of queries by looking at execution plan for better tuning of database.
  • Wrote T - SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
  • Created SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server and designed and developed different types of reports like matrix, tabular, chart reports using SSRS and power BI
  • Experience using ER diagram, Dimensional data modeling, Logical / Physical Design, Star Schema modeling, Snow-flake modeling.
  • Hands on experience in writing T - SQL queries, procedures, views, indexes and worked on SQL query optimization and tuning.
  • Strong knowledge of data warehousing including, EXTRACRTING, TRANSFORMING & LOADING processes and developing reports using SSRS and power BI.
  • Hands on experience in Troubleshooting database issues.
  • Strong knowledge about Normalization & De-normalization on existing tables for faster query results.
  • Experience in MS SQL Server Installation, configuration, performance tuning, client/server Connectivity, query optimization, back-up/recovery, running database consistency checks using Database Consistency Checker (DBCC)
  • Sound knowledge and working experience in Agile and waterfall methodology.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and designs techniques.
  • T-SQL in constructing database objects such as Tables, Stored Procedure, Triggers, User Functions, Views, Indexes, CTEs
  • Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency Checks Using DBCC.
  • Performing and Monitoring Database Growth, Health and Consistency Checks, Maintenance plans, planning and Scheduling Backup & Recovery etc.
  • Creates, maintains, and optimizes a library of T-SQL queries and SPROCS
  • Models and designs new databases and reporting databases
  • Moving data from staging database in to CRM using Migration Tools
  • Understand Database Development Guidelines & Best Practices
  • Understand and work in an Agile development environment
  • Develop mapping specifications, Source to target mappings and ETL development Perform
  • Develop the workflow and dataflow of SSIS ETL processes to support many different file structures and business processes
  • Perform tasks related to performance tuning of ETL jobs
  • Data loading workflow design and custom enrichment development using leading ETL tools
  • Develop and manage business plans to achieve objectives
  • Working in an agile environment
  • Experience with normalized and dimensional data modeling.
  • Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.
  • Great ability to work both independently and in a team oriented
  • Strong experience in Software Development Life Cycle (SDLC)
  • Support IT staff and end users
  • 24/7 customer support in Production Development Environment

Confidential, Denver, CO

SQL/ETL Developer

Responsibilities:

  • Implement stored procedures and effectively query a database
  • Identify and test ETL solution
  • Maintained SQL scripts indexes and complex queries for analysis and extraction.
  • Performed quality testing and assurance for SQL servers.
  • Worked with stakeholder’s developers and production teams across units to identify business needs and solution options.
  • Identified SQL statement with poor performance using the MS performance Monitor and SQL Trace Tools
  • Model data and design database and access plans with ER/Studio
  • Developed stored procedures, triggers, views and added/modified tables for data load, transformation and extraction
  • Configured performance tuning and optimization in SQL server 2012 and 2016
  • Performed testing on stored procedures, indexes, and triggers
  • Performed data migration using bulk insert, bulk copy process (BCP) and SSIS and from SQL Server 2012 and flat files
  • Worked on different environment and a key resource for deployment of modified objects to production environments
  • Monitored jobs to make sure all scheduled jobs runs successfully every night.
  • Performed Technical Analysis, code reviews and Implementation
  • Create T-SQL code for designated projects
  • Ensure the best possible performance and quality in the packages
  • Provide support and fix issues in the packages
  • Performing and Monitoring Database Growth, Health and Consistency Checks, Maintenance plans, planning and Scheduling Backup & Recovery etc.
  • Creates, maintains, and optimizes a library of T-SQL queries and SPROCS
  • Models and designs new databases and reporting databases
  • Understand Database Development Guidelines & Best Practices
  • Understand and work in an Agile development environment
  • Develop mapping specifications, Source to target mappings and ETL development Perform
  • Develop the workflow and dataflow of SSIS ETL processes to support many different file structures and business processes
  • Perform tasks related to performance tuning of ETL jobs
  • Analyzed data collected in stores (DTS Package, T-SQL, jobs, stored-procedures and queries) and provided reports to the commercial team (Excel, VB Script, Macro)
  • Compiled lists of stores respecting criteria given by client services, while minimizing collection costs (T-SQL, Queries, Views)
  • Assured and checked the quality and the integrity of the data received from the store collectors (T-SQL, Queries, jobs, stored-procedures)
  • Optimized DTS, stored procedures and jobs into SQL Server to increase overall performance and time/server use of daily functions

Hire Now