SUMMARY:

• Professional, detail - oriented Database Engineer with over seven years of experience, motivated to ensure high availability, scalability, and optimum performance of a database system as part of a dynamic team.
• Always strive to learn and implement cutting-edge technologies and best practices.

TECHNICAL SKILLS:

• Database Design and Development
• Installing, Configuring and Hardening SQL Server Instances
• Implementing MS SQL server security practices
• Database Backup and Restores
• Database Mirroring, Log Shipping & Replication
• Event log and Server error log troubleshooting
• T-SQL (DDL, DML): functions, views, triggers, stored procedures on an SQL Server
• SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Reporting Services (SSRS)
• Agile/Scrum
• Visualizations using Power BI
• Scheduling and Monitoring SQL server jobs and maintenance plan
• Index creation and rebuilding
• Update statistics
• Performance Monitoring and Tuning
• Query optimization
• Database migration
• ETL processes
• Design, development and implementation of SSIS Packages and Deployment Wizard.
• Parameterized, linked, matrix, drill down and aggregation reports with parameters and filters using SSRS.

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential

Responsibilities:

• Prepared, Modified and Maintained ETL package/scripts.
• Generated Reports using Data Source Views in Report Builder, created Drill Down, Drill through, linked and sub reports using SSRS
• Wrote different SQL scripts to reconcile Data from different sources and Database.
• Developed impactful reports using SSRS, MS Excel, and Pivot tables to solve the business requirements.
• Develop and maintain complex stored procedures and functions.
• Acquired Extensive business and system knowledge.
• Conducted performance tuning and database design.
• Very good knowledge and Experience working with large databases and performed table partitions.
• Performed performance tuning, query optimization and database design, dimensional analysis and modeling.
• Maintains and adds to an extensive set of SQL server Integration Service (SSIS) packages for Extract, transform and Load (ETL) data manipulation.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.
• Working on data migration across databases.
• Hands on experience in using Version Control software Rational like VSS, Clear Case and (TFS) Team Foundation Server.
• Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file.
• Created tabular, matrix, chart, drilldown reports, & parameterized reports according to business requirement.
• Built reports in SSRS for errors generated by SSIS Packages;
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions using SSRS.
• Inserted time logs for the packages, which gives start time and end time of the package
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
• Improved the performance of the SSRS reports by tuning the SQL server code and modifying the SSIS packages associated with the reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Work with the end users to ensure that the reports are working as per the Business requirements specified

Confidenial

Database Engineer,

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2014 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2014 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated Assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2014 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the Data Warehouse using Dimensional Modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2014 also validated the migration process to ensure that it has been successfully migrated.
• Performed various transformations like conditional split, union all, sorting and included data about the environment using the audit transformation.
• Designed Drill down, Drill through, and Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes and stored procedures.
• Worked with User Defined Functions and Triggers to store data into appropriate audit tables and created indexes to the tables that had the least update to improve the query performance.
• Participated in the SCRUM meetings and provided the updates and successfully delivered the work in the Sprint.

Jr SQL Database Administrator

Confidential

Responsibilities:

• Installation, configuration and administration of MS SQL Server
• Worked with developers in development of the database schema design using the Entity-relationship model as per user requirements
• Worked on planning and implementing MS SQL server security and database permissions wrote and reviewed T-SQL Scripts for creating tables, constraints, triggers, stored procedures, views and functions for critical business applications
• Established backup of SQL server 2012 by using SQL Server Agent Jobs for periodic backups
• Updated statistics and maintained index fragmentation on a weekly basis to make sure that the query optimizer uses the most recent query plan cache
• Used SQL Profiler, Execution Plan, Performance Monitor and dynamic views to find slow running queries and improved performance
• Implemented database Mirroring and always on to ensure high availability of critical databases.