Priyanka Kshatriya
Bellevue,WA
Summary
Over 15+ years of IT experience in Database Administration and Support of Azure SQL database /Managed instance, MS SQL Server 2019/ 2016/2008R2 in Production, Test, Development Environments. Experience in implementing high availability using Server clustering (Active-Active, Active-Passive) in Windows 2008/2012/2016 environment. Experience in RDBMS database design, performance tuning, optimization, backup, and recovery in SQL Server 2008-2016. Master in performing database files management, backup/restore, security management, mirroring, integration, compression, and synchronization. Extensive experience in Capacity Management and assigning storage for cloning environments. Extensive experience in setting up Cloning environments and troubleshooting issues. Hands on experience in Metal 3.1 and Informatica 9.0/9.1 a data warehouse tools used in EDW for ETL flow. Experience in supporting multi-instance SQL Server 2012 R2 – 2019 environments. Database security and hardening (TDE, encryption in transit, TLS)
Overview
17
17
years of professional experience
1
1
Certificate
Work History
Senior Data Platform Engineer
BannerBank
Bellevue, WA
07.2023 - Current
- Strong knowledge of database architecture, design, and performance tuning
- Work closely with stakeholders to understand their data management needs and requirements. Analyze the existing data systems and processes to identify areas that need improvement and recommend appropriate solutions.
- Designing database systems based on the requirements analysis and develop database systems that are efficient, scalable, and secure. Determine the appropriate database architecture, data storage, and indexing techniques.
- Managing data integration and training users on effective database practices
- Maintaining CI/CD pipelines, infrastructure as code, and automation processes.
- Created Bash /Curl scripts to automate deployments.
- Support Azure synapse data pipelines and powerBI
Azure Database Engineer
Microsoft
Bellevue, WA
09.2022 - 07.2023
- Drive to resolution for Azure SQL database issues/advisory for ACE customers
- Tracking issues and making sure resolutions are provided are on time with quality check
- Work with product teams on the releases and communicate with customers and manage issues around it
- POC on the new Azure features and conduct brown bag sessions to the team
- Help team as an escalation for the products Azure SQL database and Managed instance
- Collaborate various projects like Azure data factory/Data migration tools
- Advise customers on moving the workloads to Azure
- Optimizing the workloads post migrating to Azure
- Troubleshooting experience in Azure SQL Database or Managed instance.
Senior Database Administrator
Coinstar
Bellevue, WA
07.2015 - 09.2022
- Increased overall database performance, reduced fragmentations, and minimized failures by implementing various upgrades and migrations strategies
- Performed Datacenter migration from scratch in minimal downtime and consolidated environments to save cost on licensing
- Migrated all SQL servers from one datacenter to another with minimal downtime
- Maintained, restructured, and optimized databases by removing performance bottlenecks, devised and integrated solutions
- Developed and monitored standards and procedures for database environment and performed database software installs, configurations, patches, and upgrades
- Ensured all database systems met RPO & RTO policies
- Performance management of the application using various tools like New Relic and Data Dog
- Created alerts to keep the environment up and running 24/7 and performance tuning for the SQL server queries and optimization
- Effectively migrated SQL server MDS environment to MDS 2016 which effectively improved performance of the systems
- Set up and control user profiles and access levels for each database segment to protect important data
- Tested programs and databases to identify issues and make necessary modifications
- Wrote and maintained technical and functional specifications to document database intentions and requirements
- Planned and implemented the Azure migration.
SQL Server Database Administrator
C2S Technologies
Bellevue, WA
10.2006 - 06.2015
- Implemented high availability using Server clustering (Active-Active, Active-Passive)
- Set up HLB for IIS servers for load balancing using Active – Active clustering
- Implemented alerting systems for the applications
- Created customized monitoring tool using PowerShell scripts
- Used SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for applications
- Incident management and problem management
- Performed DBCC utilities and fixed data corruption in application database
- Monitored and modified performance using execution plans and Index tuning
- Ensured the packaging/processing deliverables are completed on time
- Automation in monitoring servers and databases
- Set up cloning & mount points for the application.
Education
Bachelor of Computer Science - Computer Science
BLDEA's Engineering College
Skills
- SQL database /Managed instance Cloning, Mirroring, Clustering, Replication, Always ON, Web Services, ETL, SSIS, SSRS, SSAS, Siebel 77 , Informatica ,Metal, ,SQL Azure T-SQL, PowerBuilder, PowerShell, VB Script, Python, Jupyter, Spyder, Anaconda, Java,Azure SQL Database /Managed instance/Synapse,DevOps Tools: Azure DevOps, Jenkins, Git, Terraform
Certification
- Data science, University of Washington
- Azure Database Administrator Associate (Microsoft)
- Certified in Azure SQL database and Managed instance (Cloud Academy)
Timeline
Senior Data Platform Engineer
BannerBank
07.2023 - Current
Azure Database Engineer
Microsoft
09.2022 - 07.2023
Senior Database Administrator
Coinstar
07.2015 - 09.2022
SQL Server Database Administrator
C2S Technologies
10.2006 - 06.2015
Bachelor of Computer Science - Computer Science
BLDEA's Engineering College
Similar Profiles
Hue NghiemHue Nghiem
Marketing Associate at Real Estate ManagementMarketing Associate at Real Estate Management
Wendy BlankWendy Blank
Pre-K Lead Teacher, Licensee at St. Louise Parish SchoolPre-K Lead Teacher, Licensee at St. Louise Parish School
Tyler ChoTyler Cho
Cashier at NordstromCashier at Nordstrom