SUMMARY

• I am focused on a results - driven professional with eight years of experience in supporting organizations through reliable database design, maintenance, and optimization, equipped with vast hands-on experience in database migration SQL 2005 Database to SQL 2008, SQL 2012, 2014, and 2016 as well as administrative tasks including database management, back-up/restoration, security management, and data integration.
• Strong command of Microsoft SQL Server 2008, 2012, 2014, 2016 and, Consistent track record in logical and physical database design creation and database performance improvement, utilizing SQL Profiler, Trace Flags, Execution plan, and DTA. Capable of supporting and maintaining a complex environment with more than 15 production servers.
• A keen eye for risk with innovative approaches to mitigate or avoid them. I am organized and independent with a collaborative approach towards management and cross-functional teams.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows Server, Windows XP/Vista/Win7&8, 10, Cloud Computing/ Linux, AWS, MS Azur, MS Azur Data factory, Azure Synapse DW, Azur Security mgt.

Programming Language/Extensions: SQL, Transact-SQL, MYSQL Python, Java, Hadoop, NIFI, Hive, SparkSQL

Database Tools: SQL Profiler, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, Query Analyzer, Query Execution Plan, Counter

Data Models: SSDD (SQL Server Database Diagram), Toad Data Modeler, Erwin

High Availability: Log shipping, Replications, Mirroring, SQL clustering, always-on availability

Performance Monitoring Tools: Profiler, DMV, Activity Monitor, Execution Plan, PerfMon, Extended Event

Reports Development/Management Tool: SSRS, MS Access, Excel, Tableau, Power BI, SSAS, Informatica

ETL Tools: DTS, SSIS, Autosys Job

Other Tools: Microsoft SQL Server, MySQL, RDBMS, DTS/SSIS packages, PowerShell, SDLC, JIRA, Scrum master, Git, C#, Angular, and ASP.NET Core Web API MS SQL, ORACLE, /PLSQL

PROFESSIONAL EXPERIENCE

SQL / SSIS/SSRS/DW/ETL/ Developer

Confidential

Responsibilities:

• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Designed and implemented Microsoft SQL Server database systems and maintain enterprise-level database systems in a multi-server environment.
• Created and managed stored procedures, indexed views, user-defined functions, triggers, database constraints to meet business requirements and policies.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• I worked in an Agile team of .NET developers for a fast-paced software development firm.
• Experience as a Software Developer in software design, analysis, development, testing, and implementation of web and client-server applications using Microsoft Technologies
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2016 and unit test SSIS load processes for performance check.
• Created various complex reports and managed those using SQL Server Reporting Services (SSRS 2008-2016) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS 2008 to 2016 and deploy report from SSRS 2008 to 2016
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports, and interactive reports according to business requirements in a time-restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to the client's needs.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007.
• Experience in scale-out serverless data integration and data transformation using Azure Data Factory.
• lift and shift existing SSIS packages to Azure and run them with full compatibility in ADF
• Extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects in Azure Data Factory.
• Running packages deployed into SSIS catalog (SSISDB) hosted by Azure SQL Database server/Managed Instance (Project Deployment Model)
• Running packages deployed into the file system, Azure Files, or SQL Server database (MSDB) hosted by Azure SQL Managed Instance (Package Deployment Model)
• Migrate database and server objects—including user accounts, agent jobs, and SQL Server Integration Services (SSIS) packages—all at once with almost no downtime.
• Involve in Pre and post SQL server database migration Migrate MySQL to SQL Server

SQL and DW/ETL/ Developer

Confidential .NC

Responsibilities:

• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS /DTS, Import, Export Data, Bulk Insert, and BCP utilities.
• Hands-on experience with
• performing various SSIS data transformation tasks like Lookups, Fuzzy
• Lookups, Conditional Splits and Event Handlers, Error Handlers.
• Great Expertise in creating and
• managing Event Handlers, Package Configurations, Logging, System, and
• User-defined Variables for SSIS Packages.
• Analyze problems as assigned and provide solutions to address business needs.
• Add a Login role to a SQL
• Server, create a user account and manage SQL Server Agent, Configuring
• Server Level Settings and Configuring Database Mail.
• Perform data loads and routine updates on an ongoing basis. Created files, views, tables, and data setsto support Sales Operations, large data volumes and partitioning,
• Developed database application forms using MS Access in coordination with SQL tables and stored procedures.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using
• T-SQL to provide definition, structure, and maintain data efficiently.
• Experience with large data volumes and partition tables into smaller tables and then use views to handle the data manipulation using data partition.

Confidential

SQL / SSIS/SSRS/ETL/ Developer

Responsibilities:

• Completed successful data migrations, backup and restoration, and bulk and batch processing with DTS, SSIS, Import/Export.
• Optimized application and system performance after a thorough analysis of long-running slow queries and tuning.
• Plan scale-up and scale-out, Plan for Capacity, Manage Database Growth
• Extraction, Transformation, and Loading of data from Multiple Sources to Data Warehouse.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases
• Index rebuild setup, configuration, concepts, techniques, and tools.
• Create new databases, tables, views, indexes, scheduled jobs, triggers, logins based on system specifications.
• pieces of knowledge in SSRS, SSIS, T-SQL, MS SQL Server 2008 R2 - 2016, networking concepts, and database design and development.
• Set up SSIS Security

SQL DEVELOPER

Confidential - Jacksonville, FL

Responsibilities:

• Designed and implemented the company's Disaster Recovery and High Availability Plans, including Log-Shipping, Database Mirroring, Replication, SQL Server Clustering, and Always-On to ensure business continuity.
• Increased network security by 85% through proper documentation of changes and creating the Database Maintenance Plan that enforced integrity checks, database statistics update, index rebuilding, and reorganization.
• Automated previously manual routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps, and Schedules with custom scripts.
• Developed and Optimized Stored Procedures and Functions using T-SQL
• Optimized queries with Windows Performance Monitor and SQL Profiler and resolved deadlock issues while enhancing database server performance.
• Efficiently migrated the database (utilizing different tools such as copy database wizard, detach & attach, SSIS, backup and restore), performed data conversion, and managed orphaned users.
• Effectively eliminated months of production server issues by systematically troubleshooting and resolving the problem without further downtime.
• Upgraded over 25 SQL servers to the latest service pack level (from SQL server 2008r2,2012 to 2016) within three months.
• experience in converting packages from legacy systems (DTS•SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Expert in automating the process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP, and SMTP.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Worked with end users/customers to understand business requirements, recommended technical solutions, and documented functional requirements.
• Ability to work on multiple tasks in a fast-paced environment independently and in a team and mentor other team members to follow the same techniques and standards.
• Formulated and documented ETL process design based on business requirements and system specifications, including source to target mappings, data dictionaries, and transformations.

SQL Database Administrator/Developer

Confidential,Jacksonville, FL

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created complex Stored Procedures, triggers, cursors, tables, views, joins, and statements for applications and developed complex T- SQL code for the application.
• Worked on designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Reduced the procedure duration by 60%, improving the efficiency of addressing vital processing jobs and allotting more time to address other concerns.
• Implemented new SQL Server features, including Policy-Based Management, Performance Data Collector and Transparent Data Encryption (TDE),
• Installed and maintained SQL servers 2014, 2012, 2008R2, 2005.
• Manage and Configure Databases mail for SQL server alerts.
• Developed the SQL Server Integration Services (SSIS) Packages for exporting the data.
• Patched all the DB Servers to the Latest Service Pack levels periodically, making them compliant with the Microsoft Support.
• Migrated the database from SQL 2008 R2 to SQL Server 2012 and 2014.
• Resolved replication issues and settled new replications that occurred after.
• Checking, repaired and prevented future fragmentation issues.
• Rebuilt indexes at regular intervals for better performance.
• Plan, design, and implement application database code objects, such as stored procedures and views.

SQL Server Database Administrator/Developer

Confidential .Jacksonville, FL

Responsibilities:

• Administered the upgrade, configuration, and maintenance of Four-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Installed and configured SQL server 2012 and migrated data from SQL server 2012.
• Recovered databases from disaster backup efforts, implementing Point-In-Time Recovery solutions.
• Extensively used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Applied the DBCC commands for database maintenance, indexing, and validation operations, enabling trace flags and removing DLL from memory.
• Adjusted Transactional Replication and Log Shipping with SQL Server Management Studio, then performed troubleshooting to address connectivity, security, and firewall issues.
• Managed Database High Availability Replication, Database Mirroring, Log Shipping.
• Restructured and monitored the indexes at regular intervals for better performance.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance using SQL Server Profiler, Execution Plan, and Performance Monitors.
• Plan, design, and implement application databases code objects such as stored procedures and views.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to define, structure, and maintain data efficiently.
• experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, using T-SQL
• Designed and developed packages to extract, transform and load data using SSIS (extensively worked on each loop, sequence containers, loop up transformation, derived columns, data conversions, row count transformation, event handlers)