Sql Server Business Intelligence
Resume:
RAJKUMAR
*********.***@*****.*** 816-***-****
#DataProfessional #CloudDatabase #PerformanceTuning #DataMigration #DatabaseDevelopmet #DataManagement
PROFILE:
Experienced data professional with 10+ years in database administration, design, development, and support across industries like finance, healthcare, stocks, and utilities. Proficient in SQL Server (2022/2019/2016/2014/2012/2008 R2/2000), DB2, Oracle and cloud-based solutions, including Azure SQL Database and SQL Server on Azure VMs. Skilled in performance tuning, query optimization, high-availability solutions, replication, clustering, and database encryption techniques. Expertise in business intelligence tools (SSRS, SSIS, SSAS) and data transformation using BCP, DTS, Azure Data Factory and bulk insert. Strong background in process reengineering, release management, and integrating innovative technologies to enhance operational efficiency. Committed to delivering scalable, secure, and high-performance data solutions that drive business success and digital transformation.
CORE COMPETENCIES:
Database Administration & Optimization – Expert in query tuning, indexing strategies, replication, clustering, and Always On Availability Groups.
Cloud & On-Premises Migration – Led seamless database migrations from on-prem SQL Server to Azure SQL Database and SQL Managed Instances.
Performance Tuning & Security – Skilled in execution plan analysis, SQL Profiler, Dynamic Management Views (DMVs), and encryption techniques (TDE, Always Encrypted).
ETL & Data Transformation – Extensive experience in SSIS, Talend, DTS, and bulk insert for efficient data extraction, transformation, and loading.
Business Intelligence & Reporting – Expertise in SSRS, Power BI, and Excel macros for building real-time reporting solutions.
High Availability & Disaster Recovery – Implemented failover clustering, log shipping, mirroring, and replication models for zero-downtime solutions.
Development & Automation – Strong background in T-SQL, stored procedures, user-defined functions (UDFs), triggers, and dynamic SQL to streamline operations.
Database Design & Architecture – Proficient in designing scalable, high-performance database solutions with normalized and de-normalized structures.
Cloud Infrastructure & DevOps – Experience in Azure SQL Managed Instances, Azure Data Factory, and CI/CD pipelines for database deployments.
Data Warehousing & Analytics – Expertise in dimensional modeling, star/snowflake schema, and OLAP cubes (SSAS) for enterprise-level reporting.
Automation & Scripting – Developed PowerShell, T-SQL, and VB scripts for automating database maintenance, backups, and monitoring.
Disaster Recovery Planning – Designed recovery strategies using log shipping, mirroring, and point-in-time restores to ensure business continuity.
Cross-Platform Data Integration – Migrated and transformed data between SQL Server, DB2, Oracle, and cloud-based platforms.
Database Auditing & Compliance – Implemented GDPR, HIPAA, and SOX-compliant security policies for regulated industries.
Large-Scale Data Processing – Experience handling multi-terabyte databases, optimizing storage, and improving query execution plans.
Collaboration & Leadership – Worked closely with application developers, ETL developers, business analysts, project managers and stakeholders to drive data-driven decision-making.
Agile & SDLC Methodologies – Experience in Agile, Scrum, and Waterfall development environments, ensuring efficient project delivery.
Database Consolidation & Optimization – Expertise in merging multiple database instances, reducing redundancy, and improving system efficiency.
Hybrid Cloud Implementations – Experience in hybrid on-premises and cloud solutions, ensuring seamless data integration across environments.
High-Volume Transaction Processing – Designed high-performance indexing strategies for handling millions of transactions per second.
ETL Performance Tuning – Optimized SSIS and Talend ETL workflows, reducing data processing time and enhancing data pipeline efficiency.
AI & Machine Learning Integration – Exposure to AI-driven database insights, predictive analytics, and automation for data-driven decision-making.
TECHNICAL SKILLS
Functional Roles
●Database Administration
●Database Developer
●Data Modeling
●Database Migration
●DB Performance Tuning
●ETL Developer
●ETL Migration
●DB Reporting
●Data Virtualization
Cloud Platforms
Microsoft Azure (Azure SQL Database, Azure SQL Managed Instance, Azure Data Azure Storage)
AWS
Databases
MS SQL Server (2000 - 2022)
PostgreSQL
IBM DB2/AS400
Oracle 11g/10g/9i
Security
SQL Server authentication, SQL Encryption, Azure Active Directory
Database tools
SQL Server Management Studio (SSMS)
SSDT, Business Intelligence Studio (BIDS)
Enterprise Manager, SQL Profiler
Query Analyzer
Data modeling tools
Erwin, Red gate, Datadog, Lite speed, Visio
Programming Languages
SQL, T-SQL, PL/SQL
VB Script, VB6, VB.Net,
Python, C, C++
Design Tools & Utilities
Team Foundation Server, Github, Visual Safe Source, VISIO, EXCEL
ETL Tools
DTS, SSIS, Talend
Reporting Tools
SSRS, PowerBi
Crystal Report 8
EDUCATION
Bachelor of Engineering in Computer Science Engineering – Gurunanak Engineering College, Hyderabad, India - 2013
Master’s in computer information systems – University of Central Missouri, Warrensburg, MO - 2015
PROFESSIONAL EXPERIENCE
Client: Equiniti (Formerly AST), 48 Wall Street, New York Sep 2015 – Till date
Role: Lead SQL Administrator
Getting requirements from business for new enhancements
Coordinate with the offshore team for new development & maintenance related tasks
Lead SQL Server Administrator overseeing the performance, availability, and security of mission-critical SQL Server instances (2012–2019/2022) across production, staging, and development environments.
Led the migration of SQL Server databases to Azure SQL Database, ensuring a smooth transition to the cloud.
Led SQL Server migration projects using Azure Database Migration Service (DMS), SQL Server Migration Assistant (SSMA), and transactional replication, ensuring seamless data transfer with minimal downtime.
Designed and Led end-to-end migration of databases from Infrastructure-as-a-Service (IaaS) to Azure SQL Managed Instance (PaaS), optimizing performance, scalability, and cost efficiency.
Installed, configured, and maintained SQL Server (2012–2019) instances in clustered and standalone environments also supported Oracle 12c/19c environments for cross-platform needs.
Experienced in applying patches and cumulative updates to SQL Server to address vulnerabilities and improve stability.
Configured and maintained high availability SQL environments (Always On) on Windows Server with proper firewall, networking, and cluster settings.
Implemented Database Mirroring in SQL Server and extensively worked on Log-Shipping for keeping SQL databases in sync.
Implemented Transparent Data Encryption (TDE) in SQL Server to secure sensitive data at rest supported Oracle TDE and column-level encryption for compliance with data security standards.
Monitored database health using SQL built-in tools SQL Profiler & Performance Monitor and third-party monitoring solutions Redgate & DataDog, proactively identifying and resolving performance bottlenecks.
Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies and query optimization.
Perform performance tuning using Query Store and dynamic management views (DMVs) to optimize the efficiency of complex queries.
Assisted in the design and implementation of database structures, including tables, views, indexes, and stored procedures, leveraging both SQL Server and Oracle best practices.
Developed and automated CI/CD pipelines for SQL databases, enhancing deployment efficiency, data pipeline orchestration, and adherence to DevOps best practices.
Scheduled and automated ETL processes using Azure Data Factory for efficient data integration and migration from on-premises systems to Azure SQL Database.
Hands-on experience in developing and orchestrating complex ETL workflows using Azure Data Factory and SQL Server Integration Services (SSIS), enabling seamless data integration across on-premises and cloud environments.
Designed and implemented a SQL Server data archiving solution, optimizing storage, improving query performance, and ensuring compliance with data retention policies.
Completed the migration of SQL Server 2000 environment to SQL Server 2012/2016.
Created and maintained custom reports and dashboards using SQL Server Reporting Services (SSRS) for business intelligence, helping stakeholders make data-driven decisions.
Created complex SSIS packages to extract data from source systems, transform it as per business logic, and load it into target databases, ensuring data integrity and accuracy.
Converted and optimized legacy SSIS (SQL Server Integration Services) packages to run in the Azure Data Factory environment for cloud-based ETL processes.
Design and manage backup and disaster recovery strategies using Azure Backup and Point-in-Time Restore.
Utilized SSIS Performance Tuning techniques such as controlling data flow execution, managing memory utilization, and optimizing the SQL queries inside Data Flow transformations.
Converted DTS packages to SSIS packages, validating the packages, and migrating to SQL Server 2008 Integration services.
Developed and executed custom ETL processes using SQL Server Integration Services (SSIS) to transform and load data from DB2 to SQL Server.
Implemented automated data validation and error handling mechanisms in SQL code to maintain data integrity and improve system reliability.
Environment: MS SQL Server 2016, 2014, 2012, 2008 R2 and 2000, T-SQL, SSIS (ETL), VB Scripts, SSRS, Windows 2003 & 2008 servers.
Client: Medical Mutual of Ohio, Beachwood, OH May 2015 – Sep 2015
Role: SQL Database Administrator- Microsoft
Write and optimize T-SQL queries to extract, manipulate, and analyze data from multiple SQL Server databases, improving operational efficiency and providing insights into key business processes.
Conducted database migrations from SQL Server 2000 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 and SQL Managed Instances, improving scalability and reducing infrastructure costs.
Managed installation, configuration, and maintenance of Windows Server environments (2008/2012), including Active Directory and Group Policy.
Monitored server performance, configured SQL Server Profiler and Extended Events for identifying bottlenecks, and ensured consistent uptime with SQL Server Agent jobs.
Conducted pre & post-patch testing, including compatibility assessments, rollback planning, and performance benchmarking, ensuring seamless transitions and optimal database performance post-upgrade.
Extensive experience with native SQL Server tools such as SSMS, SQL Server Agent, Database Tuning Advisor, Activity Monitor, and Profiler for performance monitoring and management.
Designed and implemented robust backup and recovery strategies for SQL Server databases, including full, differential, and transaction log backups, ensuring minimal downtime and data loss.
Implemented index rebuilding and reorganizing strategies to optimize data retrieval speed and reduce fragmentation in large databases.
Configured SQL Server security by managing logins, users, roles, and permissions, ensuring appropriate access control and compliance with organizational security policies.
Implemented and managed SQL Server Replication (Transactional and Merge) for data distribution across multiple sites, ensuring data integrity and availability.
Conversion of DTS packages to SSIS.
Created new SSIS Packages and generated claim data flat files for various projects.
Scheduled Jobs and Alerts using SQL Server Agent.
Created ad hoc reports for different departments using SSRS and Excel, delivering insights that guided strategy and operations.
Optimized SQL queries and indexes, reducing query execution time by 25% and enhancing overall system performance.
Working with SQL Server Availability Groups - configuration and cut over.
Analyzed Execution Plans to troubleshoot potential performance issues. And created indexes when required.
Create standards and best practices for database design and development.
Makes recommendations towards the development of new code or reuse of existing code.
SQL Server (SSIS & SSRS) Development 2008 and 2012.
Providing 24*7 on-call support.
Solving Service calls on Daily basis for Production and test Server issues.
Environment: MS SQL Server 2012, 2008 R2 and 2000, T-SQL, SSIS (ETL), SSRS, Windows 2000 and 2008 servers.
Client: UMB Bank, Kansas City, MO Jan 2015 – May 2015
Role: SQL Developer/ ETL
Responsibilities:
Perform data analysis on source system data to understand gaps, inconsistencies, and other quality issues, and develop data quality improvement solutions.
Tuned complex queries and stored procedures to improve performance by optimizing JOINs, indexing strategies, and query structure.
Designed and implemented stored procedures and triggers to automate routine tasks, including data validation, data transformation, and auditing.
Implemented error handling in stored procedures using TRY & CATCH to manage exceptions and improve application reliability.
Automated the execution of SSIS packages using SQL Server Agent to schedule and trigger data loads at predefined intervals (daily, weekly, or real-time) and ensured data refresh accuracy.
Created custom SSIS job schedules and handled dependency management for ETL processes across multiple systems, ensuring smooth data processing workflows.
Extracted and transformed data from Excel, CSV files, and other flat files into SQL Server databases, ensuring seamless integration with other operational systems.
Works with other development teams to review database changes.
Created Stored procedure, Views, Cursors, and functions to support applications.
Created T-SQL scripts to perform complex queries and complex data manipulations.
Designing and Building ETL Solutions using SQL Server Integration Services (SSIS)
Assists in preparing project plans using project management tools.
Provides technical advice and assists in solving programming problems.
Environment: MS SQL Server 2012, 2008 R2 and 2000, T-SQL, SSIS (ETL), SSRS, Windows 2000 and 2008 servers.
Contact this candidate