Sql Server Database Administrator
Resume:
UDAY KUMAR Mobile: +1-732-***-****
SQL DB Administrator Email: ***********@*****.***
SUMMARY:
10+ years of experience in managing MS SQL Server, and PostgreSQL databasesdatabase administration, development, and support for SQL Server 2022/2019/2016/2012/2008/R2 in production, test, and development environments.
Expert in Azure IaaS & PaaS for database deployments, maintenance, security, automation, high availability (HA), geo-replication, log shipping, and query performance tuning.
Proficient in SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS) for ETL, business intelligence, and reporting.
Strong hands-on experience in PowerShell scripting for automating database administration tasks, backup, recovery, and performance monitoring.
Experienced in database schema design, T-SQL scripting, and optimization, including stored procedures, triggers, functions, indexes, CTEs, views, and query tuning.
Deep expertise in performance tuning using SQL Profiler, Execution Plans, Extended Events, Activity Monitor, DMV, DBCC, and Performance Monitor to optimize CPU, memory, disk I/O, and query response times.
Experience in database security management, including role-based access control, TDE encryption, SSL encryption, and Active Directory authentication.
Experienced in high-availability (HA) and disaster recovery (DR) solutions, including AlwaysON Availability Groups, clustering, mirroring, log shipping, and replication.
Managed cloud-based SQL Server and PostgreSQL migrations to AWS and Azure, leveraging Amazon RDS, Aurora, and CloudWatch for monitoring and scalability.
Expert in deploying, configuring, and troubleshooting databases across Azure, AWS, and Google Cloud environments.
Expert in T-SQL development, including stored procedures, functions, triggers, views, and dynamic SQL for efficient data processing.
Strong experience in database schema design, normalization, indexing strategies, and partitioning to optimize query performance and storage efficiency.
Proficient in query tuning, using execution plans, indexing, and performance optimization techniques to reduce response times.
Strong experience in CI/CD, ITIL, and Agile methodologies for seamless database deployments, version control, and automated workflows.
Implemented and optimized Change Data Capture (CDC) for real-time data tracking and replication across environments.
Strong experience in Power BI and Tableau, developing real-time, interactive dashboards and visual analytics for actionable business insights.
Strong experience in database performance tuning and query optimization, using EXPLAIN ANALYZE, indexing strategies, VACUUM, autovacuum tuning, partitioning, and connection pooling (PgBouncer).
Experience in database security and compliance, implementing role-based access control (RBAC), SSL encryption, auditing, and data masking to meet industry standards (PCI-DSS, HIPAA, GDPR).
Experience with cloud-based PostgreSQL solutions, including Amazon RDS for PostgreSQL, Aurora PostgreSQL, Google Cloud SQL, and Azure Database for PostgreSQL.
Led successful migrations of on-premises SQL Server databases to AWS RDS and EC2, ensuring minimal downtime, data integrity, and cost optimization
Hands-on experience with ETL processes and data integration, using tools like PgBouncer, Sqoop, Talend, and Apache Airflow for seamless data movement and transformations.
Experience in backup and recovery strategies, using pg_dump, pg_basebackup, WAL archiving, and disaster recovery planning for business continuity.
Experience in SQL Server Reporting Services (SSRS) and Power BI, with extensive report writing experience.
Hands-on experience in SQL Server Clustering, Performance Tuning, and Business Intelligence (BI) solutions.
Experience with collaborating with Business Analysts and stakeholders to refine data requirements and ensure high-quality data management.
Experience in developing and maintaining database standards, best practices, and automation in BI processes.
Knowledgeable in ETL processes, data integration, application development lifecycles, and data transport protocols (e.g., SFTP, XML, JDXDML).
Expert in database monitoring and troubleshooting, utilizing tools like PgAdmin, Nagios, Prometheus, Grafana, and Datadog to ensure system health and uptime
Implemented and optimized star and snowflake schema data models for data warehousing and OLAP-based analytic
Experience in DevOps, CI/CD for SQL Server deployments, using Git, Azure DevOps, Jenkins, and automated deployment strategies.
Experience in T-SQL programming, including complex stored procedures, functions, views, CTEs, dynamic SQL, window functions, indexing strategies, and partitioning for high-performance applications.
Expert in SQL Server Integration Services (SSIS) for ETL pipeline development, data transformation, migration, and integration from diverse sources like Excel, CSV, Oracle, PostgreSQL, MySQL, DB2, APIs, and cloud platforms.
Expert in SQL Server patching strategies, including rolling updates, in-place upgrades, and side-by-side migrations, minimizing downtime and business disruptions.
Proficient in planning, testing, and deploying SQL patches and updates in production, development, and test environments, ensuring seamless upgrades and rollback plans.
Designed and optimized SSIS packages for high-performance data integration, migration, and transformation across heterogeneous sources (Excel, CSV, Oracle, PostgreSQL, DB2, Teradata).
Experience in Power BI and Tableau for building real-time, interactive dashboards and reports for data-driven insights.
Provided 24/7 on-call database support, troubleshooting critical production issues, optimizing resource utilization, and ensuring system stability.
Professional Experience:
Client: California Department of Housing and Community Development (HCD), Sacramento Feb 2023- Till Date
Role: SQL Server DBA
Deliverables:
Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2005, 2008(R2) and SQL Server 2012 in clustered and non-clustered environment on Windows 2003, 2008 (R2) and 2012 servers.
Involved in the database migration of SQL Server 2000/2005/2008 databases to SQL Server 2008(R2)/2012/2014/2016.
Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005/2008(R2)/2012/2014/2016
Involved in Implementation of the Always on Availability Groups in SQL Server 2012/2014/2016 Instances.
Manages and troubleshoot SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019 on Dev/UAT/QA/Prod environments.
Supports day to day operational activities for the databases platform like service requests, incident Change request, outage and Break fix, monitoring, performance tuning, troubleshooting long running queries, Lock, blocks, deadlocks, missing index, and performance issue CPU, Memory, and Backup/Restore, jobs, database optimization, Disk space, DB security.
Monitoring Server Activity using DPA/Fog light, SQL server log. Error Log, space usage, database health, failed job, critical alert, cleaning history and solving the problem as needed.
Review application SQL query and improve performance by creating missing index, remove unused index and recommending query design.
Configured and managed PostgreSQL replication setups such as streaming replication and logical replication for high availability and data consistency.
Implemented and maintained Point-in-Time Recovery (PITR), ensuring robust disaster recovery mechanisms.
Designed and maintained hot-standby servers and configured failover solutions to ensure uninterrupted service during outages.
Working on hoc request like DB refresh, code deployments, and user requests on daily basis.
Worked on monitoring project to send automated alert by Solar Wind DPA for SQL Server
Migrated Azure VM (IaaS) SQL Server 2012 databases to On-Premises to SQL Server 2016
Setup Replication to migrate data from On-Premises to Azure DB (PaaS) and manage Azure DB security
Migrated On-Prem SQL databases to Azure lAAS, PaaS using DMA, DMS, Replication, Log Shipping
Configured and managed on Azure Geo-replication for High Availability solution
Configured Azure Storage explorer for database backup and restore for database migration
Managed troubleshooting of Client connections, viewing error logs and applications.
Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005/2008/2012 and 2014 Reporting Services.
Performed on-call duties, system upgrades, and implementations during non-business hours as needed.
Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
Responsible for regular database maintenance process and disk defrag procedures in Production environment.
Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
Maintained and managed Change and Release Management process for all database related change controls and releases.
Environment: Windows 2012/2008/2003, MS-SQL Server 2016/2014/2012/2008R2/2008, Mirroring, Clustering, AWS, Aurora, PostgreSQL, Log Sipping, Replication, Backup, Restore, Azure, Recovery, Security, Performance Tuning, Indexes, Blocking, Deadlocks, Fragmentation, System Databases, PowerShell, MDS, SSIS, SSRS Oracle 10g/11g, SQL Toad, MySQL 5.0
Accenture Solutions Pvt Ltd Sept 2021-Jan 2023
SQL DBA
Deliverables:
Migrated and upgraded from SQL Server 2005 and 2008 R2 to 2012.
Created maintenance plan for regular scheduled Transaction log backup, Full back up (Separately in remote server), Check database, reorganize index, Rebuild Index, Update Statistics and Cleanup task.
Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor.
Setup Alerts, Notifications, Jobs, Job steps with automated response solution schedules.
Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard.
Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers.
Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
Set up security and access profiles and procedures for database system administrators.
Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor.
Setup Alerts, Notifications, Jobs, Job steps with automated response solution schedules.
Implemented compliance and auditing practices in PostgreSQL to align with regulatory standards such as GDPR, PCI-DSS, and HIPAA.
Set up audit logging and activity monitoring to ensure all changes to the database are traceable and meet compliance standards.
Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard.
Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers.
Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
Configured database software, associated database tools and performance monitoring software.
Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
Performed acceptance testing to verify that database changes perform without adverse consequences.
creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
Developed & maintained scripts, utility jobs or implemented needed software for database maintenance.
Environment: SQL Diagnostic Manager, Toad, MySQL 5.0, Azure, MS-SQL Server 2016/2014/2012/2008R2/2008, AWS, Aurora, PostgreSQL, Mirroring, Clustering, Windows 2012/2008/2003, Restore, Recovery, Security, Performance Tuning, Indexes, Blocking, Deadlocks, Fragmentation, PowerShell, MDS, and SQL Server Data tools BI, Oracle 10g/11g.
Client: Allyis Inc, WA Oct 2019-Sep 2021
Role: SQL DBA
Deliverables:
Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered and non-clustered environment.
Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2008(R2), 2012, 2014, 2016 and 2017 in clustered and non-clustered environment on Windows 2003, 2008 (R2), 2012 and 2016 servers.
Involved in the database migration of SQL Server 2008 R2 databases to SQL Server 2012/2014/2016/2017.
Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2008(R 2)/ 2012/2014/2016/2017
Involved in Implementation of the Always on Availability Groups in SQL Server 2012/2014/2016/2017 Instances.
Managed troubleshooting of Client connections, viewing error logs and applications.
Assist in cost optimization for AWS RDS and Aurora services by regularly reviewing resource utilization and scaling instances as required.
Work with finance and operations teams to estimate and reduce AWS database costs by rightsizing instances and leveraging reserved instances and savings plans.
Administer and manage SQL Server instances (2012-2022) across production and development environments, ensuring high availability, security, and optimal performance.
Oversee PostgreSQL databases in AWS, specifically managing RDS for PostgreSQL instances and implementing best practices for database scaling, backups, and disaster recovery.
Configure and manage Amazon Aurora databases for high-performance, fault-tolerant applications, ensuring seamless auto-scaling and automatic failover capabilities. Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005/2008/2012/2014 and 2016 Reporting Services.
Strong Working Experience in Clustered and Non-Clustered Environment.
Monitored SQL server performance on a regular basis and gathered data for trending analysis.
Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
Responsible for regular database maintenance process and disk defrag procedures in Production environment.
Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
I Worked on Password reset of the user accounts on Azure, and Analyzing and reviewing the Audit logs of user accounts.
Resetting and enabling the MFA authentication for user accounts, Managing VM’s on Windows virtual desktop Infrastructure environment, and Supporting the Internal Microsoft tools and applications.
Environment: Windows 2012/2008/2003/2000/NT4.0, Oracle, MS-SQL Server 2016/2014/2012/2008/2005/2000, PowerShell, NetApp, SSIS, SSRS, System Monitor / Performance Monitor, MySQL 5.0, MySQL Workbench, AHS Cloud, Azure.
Client: Unisys India Pvt Ltd, India Sep 2018-Oct 2019
Role: SQL DBA
Deliverables:
Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment
Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition
Expertise in database Performance tuning
Writing T-SQL and Stored-Procedures
Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views,
Stored Procedures, Triggers
Data Modeling, developing E-R Diagram using Erwin and SQL Server Data Diagram
Backward & Forward Engineering with data modeling tools mentioned above
Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP
Generated Report using SSRS and in Excel, html, text from Database as well
Working experience in Database Backup, Restore and Point-in-Time Recovery
Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space,
backup verification
Developed Different Maintenance Plans for database monitoring.
Installation and configuration of MS SQL Server 2005 and 2008R2 and 2012.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking.
Set up security and access profiles and procedures for database system administrators. O
Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
Implement and maintain database security as per business rules and requirements
Configuring and troubleshooting high availability scenarios like Log Shipping.
Implemented Database Mirroring with synchronous mode.
Maintained & Monitored Alert/Schedule to make smooth replication process.
Updating Service packs and Security patches for the Servers.
Creating and reviewing Security features for all the servers.
Configuring and monitoring the Database Mirroring and Log Shipping.
Installing and maintenance of Always on availability groups.
Deploying the packages to MSDB or Filesystem.
Environment: Windows 2012/2008/2003/2000/NT4.0, MS-SQL Server 2012/2008R2/2008/2005/2000, SSIS, SSRS, Oracle 10g/11g, System Monitor / Performance Monitor, MySQL 5.0, MySQL Workbench.
Client: Xchange Techs Star Alliance LLP, India Oct 2014 -Aug 2018
Role: SQL DBA
Deliverables:
Installation & Configuration of SQL Server 2005/2008/2008R2 on Local Systems
Continuously monitoring and updating the Backup & Recovery strategy and monitoring scheduled jobs of backup and restore procedure for database.
Maintenance work on different databases.
Having experience in database backup and restorations.
Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.
Identifying/resolving fragmentation resulting in improved performance.
Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication and Clustering
Monitoring SQL Server agent jobs/maintenance plans
Provided 7 x 24 Production support for the database and application issues.
Strong Working Experience in Clustered and Non-Clustered Environment.
Monitored SQL server performance on a regular basis and gathered data for trending analysis.
Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
Responsible for regular database maintenance process and disk defrag procedures in Production environment.
Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
Good experience of migration and up gradation of databases and Executing scripts in production environment.
Environment: Windows 2012/2008/2003, MS-SQL Server 2014/2012/2008R2/2008, PowerShell, MDS, and SQL Server Data tools BI, SSIS, SSRS Oracle 10g/11g, SQL Diagnostic manager, Toad, MySQL 5.0.
TECHNICAL SKILLS:
Databases
MS SQL Server, PostgreSQL from 8.4.x to 9.5.x, Oracle 10g,Oracle, MySQL, SQL Server, MongoDB, Dynamo DB, Cassandra, Snowflake.
SQL Server Tools
SQL Profiler, Database Tuning Advisor, Activity Monitor, SQL Server
Cloud Services
Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Synapse Analytics (SQL Data warehouse), Azure SQL Database, Polybase, Azure Cosmos NoSQL DB, Azure Key vaults
Frameworks
.Net 2.0,3.0,3.5, 3.5 SP1 and 4.0
ETL TOOL
SSIS, Informatica, Datastage, Abinitio
Reporting Tool
SSRS
Operating Systems
Windows 10/7/XP/2000/NT/98/95, UNIX, LINUX, OS
Visualization/ Reporting
Tableau, PowerBI
Educational Qualifications: Bachelor’s in computer science and engineering (CSE), India 2012.
Contact this candidate