SUDARSHAN SHRESTHA

adkdfb@r.postjobfree.com 571-***-**** Woodbridge, VA

PROFESSIONAL SUMMARY

I add immediate value to a team and drive reliable system performance using my extensive 6 years hands-on experience working on a large, fast paced environment supporting MS SQL server. I add value by leveraging my in-depth technical and soft skills. My technical skills include installation, configuration, administration, maintenance, performance tuning, security, monitoring, implementing HA and DR solutions, and Business Intelligence (such as SSIS and SSRS). My soft skills also include being a good team-player with excellent analytical, detail oriented, interpersonal, problem solving, great communication and mentoring skills. In Addition, I am very proficient in Cloud (Azure & AWS) with experience of Cloud Computing Services, PaaS, IaaS, and Migrated from premises databases and Legacy products on Azure and AWS, deployed products on cloud platforms. I will use my technical and soft skills to foster quality, efficiency and productivity. As my detailed resume below reflects I have the skills and experience to add immediate and long lasting value to your team and organization.

RELEVANT EXPERIENCE

PSAV, Lanham, MD

Sep 2018 – Present

Role: SQL Server Database Administrator

Responsibilities:

oPerform SQL Server 2012-2017/2019 Database Administration duties, including database backup, restore, and database migration, Transparent Data Encryption (TDE), Always-On High Availability Groups and security configurations to conform to industry standards in support of domestic and internal SharePoint sites.

oInstall, maintain and update SQL Server Service Packs and security updates on physical and VMware virtual servers, on Windows Failover Cluster nodes (shared and dedicated storage).

oCreating, building and deploying SSIS packages, building and managing report server and users are other part of my daily responsibilities.

oManaging four nodes multi-subnet Windows Failover Cluster, AZ on RDS cloud computing platform. Working experience creating database on RDS and EC2, migration, managing security and review policy.

oDatabase maintenance such as health check, rebuild and reorganize indexes, troubleshooting issues for using SQL Server Profiler, Database Engine Tuning advisor and run DBCC or Dynamic Management Views for concisely troubleshooting & resolving performance issues.

oDesigned and developed a full-scale reporting solution for a multi-client environment using MS SQL Server and MS SSRS.

oGenerated multi parameterized reports in Microsoft SQL Server Reporting Service, configuring it and allowing users the ability to make selections before executing reports; thus, making them user friendly.

oDeveloped reports using SSRS, Data tools, Visual studio. Creating SSIS (ETL) packages, deploy, develop jobs and tasks to execute automatically or manually.

oPerformed SQL Server 2017 Database Administration (DBA) duties in a production environment, including security, configuration, developing maintenance plans for the backup and recovery of system and user databases.

oMigrated an Access database to SQL Server 2017 using Integration Services, stored procedures and SSMA tool.

oDeveloped data objects, forms and Reporting Services reports.

oMonitored and did performance tuning on indexes, queries and stored procedures on databases.

oRan database clean up scripts to ensure database performance remained high

oCoordinated any emergency database backups.

oConducted code migrations for various billing systems.

oAggressively pursued resolution SQL Server performance issues.

oSetup new user accounts with the appropriate application level security.

oTrack, monitor and prioritize service request to meet customer deadlines.

oRefined and automated regular processes, track issues, and documented changes.

Quantum Technologies Inc, Alpharetta, GA

Jan 2016 – Aug 2018

SQL Server Database Admin

Responsibilities:

oSQL Server 2012, 2016, Relational Database Management System (RDBMS); installing, managing, maintaining.

oMigration experience from on-premises to AWS and MS Azure.

oInstalling, configuration and creating a database instance on a cloud platform like AWS RDS and EC2.

oManaging security, review policy and roles and working experience of Identity Access Management (IAM) on the Amazon cloud.

oCreating SQL Server Integration Service, Export, Import, Data Migration and Upgrading.

oConfiguring Windows Failover Clustering, AlwaysOn and other high availability such mirroring, replication, and log-shipping.

oSetup, maintenance plan – backup, database health check, rebuild and reorganize indexes.

oUpdate and upgrade – Windows Server and SQL Server.

oMonitoring and administering DBMS security; adding and removing users, administering quotas, security audit, checking for security problems, and assigning user privileges.

oMonitoring system performance and constantly tuned databases for efficient performance.

oManaging Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

oDeveloped an effective backup and recovery strategy to maintain the integrity of the database

oWorked on the front-end and back-end application development team, vendors, and consultants.

Oswego, Aurora, IL

Mar 2014 – Dec 2015

SQL DBA/Developer

Responsibilities:

oData from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server. Installing SQL Server components, Configured, and Administered SQL Server in development, test, and production environment.

oWork experience and strong knowledge in disaster recovery rebuild databases using backups.

oEnsure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).

oTest backups to ensure we can meet the business Recovery Time Objectives (RTO).

oInstalled, Configured and Managed Database Mirroring, Replication and Log Shipping.

oConfigure & Maintaining Failover Cluster multi-node, different subnets, and configuring always-on high availability solution respective of DR & HA technologies.

oPerformed database monitoring and Performance tuning.

oMonitor Servers activity, and worked with clients to solve different problems.

oPerformed index and statistics management and monitoring Solar Winds application database.

oManaged SQL Server Error Logs, space usage, growth pattern.

oManaged lock, block and deadlock.

oMonitoring, troubleshooting any performance issues and apply tuning.

oUsed ETL tools like DTS, SSIS, and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases. Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages, OLAP, OLTP and SQL Server Analysis Service.

oPerformed T-SQL tuning and optimization of queries for reports that take longer execution time is using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2012/2014.

oCreated and Managed users, roles, security at object level, data encryption.

oApply updates, patching and service pack implementation.

oMigrated MS Access, MySQL, Oracle databases into MS SQL Server imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database.

TECHNICAL SKILLS

Platform

VMware, Cloud Computing

Operating Systems

Windows, Windows Server, Linux

RDBMS

SQL Server; basic on MySQL, MS Access, PostgreSQL, Oracle

Microsoft BI Tools, ETL & Reporting

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports 10.0 & Excel PowerPivot, Power BI, Tableau

Databases and Tools

Data Warehousing (OLAP, OLTP), Power-Shell, T-SQL, SQL Profiler, Visio, Database Diagram, Database Mail, Alert/Notification, SQL Server Activity Monitoring, Native Client (ODBC, OLEDB), SSAS, Netbackup, Service Manager, AppDetectivePro, Nessus Scan tool, Splunk.

EDUCATION

oMBA, Aurora University, Dunham School of Business, Aurora, IL

Specialized in Management and Leadership, IL, 07/2008

oMBA, Specialized in Business Management/Operation Management, University of Pune, 2000/2002

TRAINING & CERTIFICATION

oCompletion certification in Microsoft SQL Server Database Administration

oTraining completion: AWS Architect (AWS SA) on Cloud Computing

Hands-on training completed- RDS & EC2: creation database/instance, migration and managing services and policy

oCertified Practical Accounting Technician (PAT)

oCertified Computerized Accounting Technician (CAT) organized by Chartered Institute of Management & Accounting

CITIZENSHIP: USA

Contact this candidate