Sql Server Ms

SHERBU MOKTAN

S Q L / E T L D E V E L O P E R

+1-512-***-**** ***********@*****.*** Richmond, VA 23230

PROFILE

6+ years of experience as MS SQL Server Developer in various domains like Financial, Insurance, Retail, and Healthcare with expertise in MS SQL Server, SSIS, SSRS for versions 2020/2000/2019/2017.

Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database consistency checks using DBCC Utilities.

Designed Conceptual, Logical, and physical Models of database. Expert in Data conversion, Data modeling, Normalization, and SQL Server Enterprise manager.

Wrote complex Stored Procedures, User Defined Functions, Views, and created other database objects.

Expert in Migration of data from Oracle, Sybase, and DB2 to SQL Server.

Involved in creating ETL process, Data warehousing, Operations Data Store concepts, data marts, and OLAP technologies.

Studied Cloud Concepts and Services offered by Microsoft Azure, involved in the process of efficiently reducing capital expenditure and promoting minimum operational expenditure of overall IT assets and infrastructure.

Expert in Creating, maintaining, and Configuring DTS and SSIS packages.

Involved in working with heterogeneous data sources like Excel, Flat file, Oracle, DB2, and SQL Server.

Experienced in developing Azure Data Factory Pipelines, Integration runtimes, Linked Services and Data Sets using Data Factory Studio, JSON templates and C# APIs.

Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Copying files and tables from On Premise to Azure BLOB storage and Azure SQL Databases with Hot and Cold access tiers depending on the timely Partitions.

Collaborated with DevOps Engineers to prepare automated CI / CD pipelines using Azure ARM templates as per deployment strategies.

EXPERIENCE

SQL/ETL/BI DEVELOPER

Sentara Northern Virginia Medical Center, Woodbridge, VA

Dec 2022 - Present

Responsibilities:

Created new tables, wrote stored procedures and user defined functions for application developers.

Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.

Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts

Created various connection managers (OLE DB connection, flat file connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as SQL Server, flat files, excel.

Collaborated on ETL design and development maintaining Data integrity across on premise and Azure Data Lake storage.

Developed Azure Data Factory pipelines to orchestrate the entire On Premise to Cloud Data movement along with Power BI Workspace refresh at specified time of interval.

Handling real time data censoring through event messaging system, batched into group of data and sent into the Azure SQL Databases as a staging layer.

Developed SSIS Packages using fuzzy lookup transformation, file system task.

Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column etc. Deployed Packages in the file System.

Used SSIS Documenter for documenting SSIS packages

Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.

Design and develop ETL processes to extract data from diverse sources, transform it, and load it into data warehouses.

Designed and implemented ETL pipelines using Python and tools like Apache Airflow, automating data extraction, transformation, and loading from multiple sources into SQL databases.

Designed and implemented scalable and secure SQL database solutions on AWS RDS for high-performance applications.

Utilized AWS DMS to migrate on-premises SQL Server databases to AWS RDS, ensuring minimal downtime and data integrity.

Collaborate with business analysts and data stakeholders to gather and document ETL requirements. Create and maintain data mapping documents, data flow diagrams, and ETL job documentation.

Played an active role in scrum ceremonies, including daily stand-ups, sprint planning, and retrospectives, to align SQL development efforts with team goals.

Environment: SQL Server 2020 Enterprise, Windows Enterprise Server, Visual studio, SQL Server 2019 Azure Data Factory, Azure SQL Database

SQL/SSIS/SSRS DEVELOPER

Dallas Medical Center, Farmers Branch, TX

Dec 2020 to Nov 2022

Responsibilities:

Design and develop ETL processes to extract data from diverse sources, transform it, and load it into data warehouses. Monitored the database server performance and if required go for tuning of the T-SQL queries, stored procedures etc. Proven ability to handle databases of more than 500 GB in size.

Conducted root cause and analysis for database incidents and problems. Provide2nd and 3rd level support and rotating on-call support.

Troubleshoot and resolve ETL job failures, ensuring data integrity and minimal downtime. Implement automation scripts to schedule and monitor ETL jobs, improving workflow efficiency.

Participate in code reviews and collaborate with cross-functional teams to ensure data integration projects meet business needs.

Monitored data activities i.e. database status, logs, space utilization, extents, checkpoints, locks, and long transactions. Captured Plan information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance Advisor to provide a record of all plan changes and optimize queries based on results.

Experience in data migration using tools like DTS, Bulk Insert, BCP, and Replication between different homogeneous and heterogeneous systems and SQL Server.

Working knowledge of disaster recovery and high availability solutions like replication, transaction log shipping, mirroring, and clustering.

Developed and maintained ETL packages SSIS Packages to extract the data from various sources and was involved in debugging and upgrading several ETL structures as per the requirements.

Experienced in SQL development with AWS, including Glue and Redshift for optimized database management, migration, and ETL processes.

Developed and maintained ETL processes using AWS Glue and AWS Lambda to transform and load data into Amazon Redshift.

Collaborated with scrum team members to define user stories and acceptance criteria, ensuring clear requirements for SQL database features.

Environment: SQL Server 2019, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), VisualStudio

SQL/BI DEVELOPER

Prime Commercial Bank LTD, Kathmandu Nepal

Feb 2020 to Nov 2020

Responsibilities:

Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.

Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes. Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts

Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

Strong expertise in SSIS for data extraction, transformation, and loading. Experience with data profiling, cleansing, and quality assurance.

Proven ability to work with various databases, including Oracle, SQL Server, and MySQL.

Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams. Involved in requirements gathering, analysis, design, development, change management, and deployment.

Involved in complete Software Development Lifecycle (SDLC).

Developed complex SQL Queries, Stored Procedures, Triggers, Views & Indexes using DML, DDL commands, and user-defined functions to implement the business logic.

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, and views.

Configured and managed AWS IAM roles and policies to ensure secure access to SQL databases and other AWS resources.

Optimized SQL query performance and database indexing on Amazon RDS to enhance application performance.

Delivered SQL database components iteratively, integrating stakeholder feedback and continuously refining database models and queries.

Worked closely with the Scrum Master and product owner to prioritize SQL development tasks, ensuring the most critical features were delivered first.

Environment: MS SQL Server 2019, SSIS, SSRS, T-SQL, DTS, Windows XP

JR. SQL DEVELOPER

Nepal Mediciti Hospital, Lalitpur Nepal

Mar 2018 to Jan 2020

Responsibilities:

Involved in planning, defining and designing data and provided documentation. Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.

Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse

Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.

Designed and developed ETL processes to extract data from various sources, transform it to meet business requirements, and load it into data warehouses.

Collaborated with business analysts and data architects to understand data requirements and design data models.

Developed Python scripts to establish connections to multiple customer databases using SQLAlchemy, streamlining data access across different systems.

Implemented data validation and cleansing routines to ensure data quality and accuracy.

Involved in documentation for all kinds of reports, DTS and SSIS packages Designed and implemented stored procedures and triggers for automating tasks.

Maintained the table performance by following the tuning tips like normalization, creating Index and ensured best practices are applied and integrity of data is maintained through security and documentation.

Implemented automated backup and recovery solutions for SQL databases using AWS Backup and AWS Lambda.

Utilized JIRA for tracking and managing SQL-related tasks, providing regular status updates and ensuring transparency within the scrum team.

Environment: MS SQL Server 2017, T-SQL, SSRS, SSIS, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard

EDUCATION

Masters Degree

Contact this candidate