Database Engineer Resume Pittsburgh, PA - Hire IT People

SUMMARY

Strong background in Design, Modelling, Development, Normalization, Migration, Tuning, Administration and Testing of Relational databases using MS SQL Server.
Experience with other RDBMS such as PostgreSQL, Oracle, DB2, Informix and MySQL.
Comprehensive experience with Programming languages such as C#, Java, Python, R, VB.Net, JavaScript.
Strong Agile and SCRUM Team experience using tools like JIRA, TFS, GitHub.
Extensive involvement in all phases of Software Development Life Cycle (SDLC).
Excellent team player, takes ownership; self - starter and mentoring skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server, T-SQL, PostgreSQL, Oracle, DB2, Informix and MySQL

Reports and ETL Package Development: SSRS, Jasper, SSIS, SQL Server Broker

Programming languages: C#, Java, Python, R, JavaScript, VB.Net

Web and Windows development: ASP.Net, HTML, XML, JavaScript, JSON, AJAX, WCF, Web Services

Data Analysis and deployment: SSMS, SSDT, pgAdmin, SQL Profiler

IDE: Visual Studio, IntelliJ, Jupyter Notebook, Rstudio

Agile, SCRUM and source control tools: JIRA, TFS, GitHub

Operating systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Database Engineer

Confidential, Pittsburgh, PA

Responsibilities:

Successfully collaborated with Business Analysts, Project Managers and other stakeholders to convert business requirements into normalized relational database structure with Tables, Joins, Views, Stored Procedures, Functions, Triggers, and Constraints.
Implemented best practices like Normalization and Referential Integrity with design and coding of database to maintain data integrity, reduce Data redundancy and enhanced query performance
Designed and delivered complex Reports using SSRS. Significantly reduced run time of several existing reports by using SQL performance tuning techniques
Optimized SQL Queries using tools like SQL Profiler, Query Execution Plan, Database Engine Tuning advisor etc. to significantly improve query performance
Successfully troubleshot and resolved blocking, locking and deadlocking issues in production environment.
Implemented Index maintenance to reduce Index fragmentation resulting in enhanced performance.
Implemented Backup strategy using Maintenance Plans; Automated Backup and a combination of Full, Differential and Transaction Log Backup ensured enhanced reliability and reduced space requirements.
Successfully accomplished recovery of Production databases in disaster scenarios
Streamlined generation and maintenance of Database version release scripts by using Database Project deployment and SSDT features
Implemented Roles and least Privilege principle, masking and encryption to secure confidential data
Designed, developed and implemented Data Archival and Purging Tool to keep database size within control and thus achieved significantly enhanced performance.
Implemented Database documentation by using Extended Properties and Visio diagrams
Frequently participated in peer reviewing database code of team members and ensured best practices are implemented. Always mentored and helped team members in resolving complex database issues.
Cleaned up entire codebase to so that Database Project builds and deploys without any issue.
Implemented migration utility to upgrade old legacy databases using SSIS; this got rid of a lot of error-prone and time consuming manual processes.
Extensively involved in fixing and testing defects in the existing application
Successfully migrated databases from older to newer SQL server versions.
Automated business processes using SQL Agent Jobs with Email Notification.
Implemented Database Auditing to track changes in Production environment.

We provide IT Staff Augmentation Services!

Database Engineer Resume

Pittsburgh, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship