Puneet Kaur
Senior SQL DBA Administrator at WTA Consulting- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Foundations of Cybersecurity
GoogleJun, 2023- Nov, 2024
Experience
-
WTA Consulting
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior SQL DBA Administrator
-
Mar 2023 - Present
SQL DBA • Migration of SQL Servers to cloud environment MS Azure . • Worked on Administration and maintenance of SQL Server Database systems for various applications. • Database administration activities as an on-call production support DBA for SQL Server. • Worked on SQL Server Always On to provide a high-availability and Disaster-recovery solution • Meetings with system architects, design analysts to understand business requirements. • Involved in SQL Server 2017, 2016, 2014, 2012, 2008 database installation (cluster\standalone), maintenance and follow guidelines as per Microsoft standards and SOX security guidelines. • Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows). • Resolved blocking and deadlocking issues in concurrent queries. • Implementation of best practices for Database modeling, Database architecture and normalization techniques. • Setup backup and recovery strategies for SQL server databases. • Administering Snowflake. Granting rights, Created SAS keys, implement the changes on snowflake. Show less
-
-
-
Grange Insurance
-
United States
-
Insurance
-
700 & Above Employee
-
Senior Sql Database Administrator
-
Oct 2019 - Jan 2023
SQL DBA • Migration of SQL Servers to cloud environment MS Azure . • Worked on Administration and maintenance of SQL Server Database systems for various applications. • Database administration activities as an on-call production support DBA for SQL Server. • Worked on SQL Server Always On to provide a high-availability and Disaster-recovery solution • Meetings with system architects, design analysts to understand business requirements. • Involved in SQL Server 2017, 2016, 2014, 2012, 2008 database installation (cluster\standalone), maintenance and follow guidelines as per Microsoft standards and SOX security guidelines. • Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows). • Resolved blocking and deadlocking issues in concurrent queries. • Implementation of best practices for Database modeling, Database architecture and normalization techniques. • Setup backup and recovery strategies for SQL server databases. • Administering Snowflake. Granting rights, Created SAS keys, implement the changes on snowflake. Show less
-
-
-
JPMorgan Chase & Co.
-
United States
-
Financial Services
-
700 & Above Employee
-
Senior Sql Database Administrator
-
Dec 2018 - Sep 2019
• Installed, Configured and Maintained SQL Server in development, test and production environment • Configured and Maintained Fail-Over Clustering • Maintained server and database security including database encryption (TDE) • Installed and configured SQL server Reporting Services (SSRS) • Configured and Maintained Replication, Log Shipping and Mirroring for High Availability • Upgraded/Migrated SQL Server instance/databases from older version SQL Server to new version • Performed database and SQL/TSQL Performance Tuning • Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification • Setup jobs, Maintenance plan for backups, Rebuilding indexes, check server health, alter notifications • Deployed and Restored database including Point in Time Recovery • Monitor Server Activity, Error Log, space usage and solving problem as needed Show less
-
-
-
GE
-
United States
-
Industrial Machinery Manufacturing
-
700 & Above Employee
-
SQL Database Administrator
-
Mar 2016 - Dec 2018
• SQL Azure, SQL Server (2008, 2012, 2014 & 2016 Versions), • Designing and Maintenance of data and database solutions • Migration of SQL server database from on premise to Azure IAAS/PAAS • Performance Tuning & System Optimization • Database Health, Security, Data Analysis, Problem Analysis • Database installation, backups, Replication, Server Procurement, validation, and Patching (as needed) • Configure & Maintain Always On, Mirroring, log shipping, Replication management, Linked Servers, and Security • Ensure and maintain a highly available and secure database environment • Deployment of Microsoft standard maintenance jobs for optimization of databases like re-indexing, index defrags, updates statistics. • Perform capacity planning and disk configurations for new hardware infrastructure. • Develop common reporting tool set to enable significant efficiency improvement in overall data management and reporting across the global material delivery, logistic cost allocation and budgeting. • Translate business goals into strategy and actionable objectives and Implement & configure DB appropriate to business requirements. • Perform analysis and determination of database performance characteristics, data relationships and attributes, data flow, data output and reporting capabilities. • Investigates and resolves technical database issues. Show less
-
-
-
CENTRAL OHIO PRIMARY CARE PHYSICIANS SPECIALTY SERVICES LLC
-
United States
-
Hospitals and Health Care
-
Senior Sql Database Administrator
-
Aug 2015 - Feb 2016
• Migration of SQL Servers to cloud environment MSAzure • Worked on Administration and maintenance of SQL Server Database systems for various applications. • Database administration activities as an on-call production support DBA for SQL Server \MYSQL databases. • Used VSTS for continuous integration and continuous deployment • Worked on SQL Server Always On to provide a high-availability and Disaster-recovery solution • Meetings with system architects, design analysts to understand business requirements. • Designing multiple SSIS packages for retrieving data from heterogeneous systems. • Involved in SQL Server 2017, 2016, 2014, 2012, 2008 database installation (cluster\standalone), maintenance and follow guidelines as per Microsoft standards and SOX security guidelines. • Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows). • Resolved blocking and deadlocking issues in concurrent queries. • Implementation of best practices for Database modeling, Database architecture and normalization techniques. • Setup backup and recovery strategies for SQL server databases. Show less
-
-
-
Big Lots
-
United States
-
Retail
-
700 & Above Employee
-
SQL Database Administrator
-
Jul 2013 - Jul 2015
• Configuring an AlwaysOn Availability Group for Read-only Routing and high availability on classic failover cluster and Geo-Cluster configuration. • Experience in creating new policies and facets to enhance security as per Microsoft best practices. • Performance recommendations which include Data compression, index recommendation and table partition strategies • Handle SQL 2012/2014 cluster installations and latest service pack and hot fix upgrade for Geo-Cluster configuration. • Manage database maintenance plan activities including backups, rebuild indexes, statistics check, integrity, and consistency checks, etc. • Experience with database monitoring tools including Quest Fog-light, EMC Networker, and Windows Perfmon tools. • Automation scripts using PowerShell. • Build ETL processes utilizing SSIS/DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting. • Develop reports using SQL server reporting services and utilizing SQL queries and stored procedures. • Experience with planning and disk configurations for new hardware infrastructure and performance tuning of large size databases of terabytes. • Performance tuning for slow running queries Follow SDLC, Change Control Management of the daily deployment of database code to UAT and production environment. • Work in rotating shift for on-call production support. Show less
-
-
-
Microsoft
-
United States
-
Software Development
-
700 & Above Employee
-
SQL Database Administrator
-
Jan 2012 - Jun 2013
• Database administration activities as an on-call production support DBA for SQL Server. • Involved in installing SQL server 2005 and 2008 single instance and multi instance Clusters with active/active or active/passive configuration. Built 2 node, 3 nodes and 4 nodes clusters. • Upgraded from SQL server 2000 and 2005 to SQL Server 2008 • Deployment of Microsoft standard maintenance job suite for optimization of databases like re indexing, index defrags, updates statistics and partitioning large tables. • Performed capacity planning and disk configurations for new hardware infrastructure. • Handling SQL 2008/2005/2000 Installations (Cluster and Standalone) and latest service pack and hot fix upgrade. • Troubleshooting and Diagnosis of SQL server alerts. • Performance tuning and optimization (rebuild index/index defrag/update statistics) of large databases up to 4 terabytes. • Setting up Mirroring, Replication and Log shipping for SQL Server 2005. • Disaster Recovery Planning, Backup, Restoration and Recovery in different scenarios. • Development of DTS and SSIS packages. • Creation of database schemas, managing user creations, assigning roles to SQL databases. • Maintaining database documentation at team site. Show less
-
-
Education
-
2003 - 2008
Kurukshetra University
Master's degree, Computer Science
Community
