Database Developer/Administrator

Administrative Office of Pennsylvania Courts

1. • As a Sr. SQL Server DBA Provided Production Support 24/7 and On-call support.
2. • Created and maintained various databases for Development and Testing Environment using SQL Server and involved in actual Relational Database Design for high OLTP environment.
3. • Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
4. • Set up and controlled user profiles and access levels for each database segment to protect essential data,
5. • Creating, granting, and monitoring user access rights and privileges through roles and profiles.
6. • Developed scripts for creating Tables, Materialized Views, Stored Procedures, and User Defined Functions.
7. • Actively monitored performances of queries on SQL server using SQL Profiler, Query Plan and optimized them by creating appropriate indexes using Index Tuning Wizard.
8. • Updated OLTP database statistics and re-indexed tables using DBCC commands.
9. • Rebuilding the indexes at regular intervals for better performance.
10. • Experience in onboarding new data sources and integrating these data into the existing database structure.
11. • Developed and executed strategies for migrating on-premises SQL Server databases to the cloud.
12. • Azure automation (cloud and on-premises) solution development for Microsoft POC engagements.
13. • Creating and Customizing SQL Azure Dynamic Data Masking
14. • Set up Distributed Always On Availability Groups on Azure VMs.
15. • Experience in implementing multi-node windows/SQL HA
16. • Experience working with Azure SQL Database Import and Export Service.
17. • Setup trust between on premise and cloud server using ACS and ADFS in Azure.
18. • Performance tuned store procedures using dynamic SQL, temporary tables, and different optimization methods like OLTP, DSS.
19. • Responsibilities include but not limited to upgrades applying patches and database changes for all major releases.
20. • Created several reports based on user requirement by creating reporting procedures.
21. • Regularly monitored database logs for any errors or performance improvement opportunities.
22. • Implemented Transactional Replication for high availability.
23. • Created data warehousing (SSIS) packages for data extraction, transformation, and loading.
24. • Responsible for migrating data from Sybase to SQL Server creating SSIS packages.

Arkansas tech university

Information Technology