YADAB POUDEL

MS SQL Server DBA

Email : acrx6b@r.postjobfree.com

Cell : 202-***-****

No visa sponsorship required.

Summary of Qualifications:

SUMMARY:

MS SQL Server Database Administrator with 4+ years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments

Expertise in Managing PRODUCTION Databases on MS SQL Server 2012/2008 R2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.

Worked with Hundreds of servers and Terabytes of data

Hands on knowledge in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering

Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Replication and Log Shipping.

Provided 24/7 On-call Support for PRODUCTION environment

Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Service.

Hands on experience in implementing Database Mirroring

Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups

Used third party tools like Redgate, SQL Litespeed for monitoring and and Backups

Used IDERA, FOGLIGHT and Zenoss for Monitoring and Performance tuning

Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2 and SQL Server 2012

Hands on experience in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN

Hands on experience use of SQL Server DMV's for Performance Tuning.

Created Basic SSIS packages SSRS reports and deployed the packages from development to different environments

Experience in performing database consistency checks and planning and scheduling Recovery Procedures.

Experience in resolving Database Performance, Capacity and Distributed data issues.

Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler.

Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS

Experience in migrating data center.

Experience in creating and implementing different database maintenance plan as per company policy.

Expertise in applying service pack and hot fix on both standalone and Clustered environment

Technical Competencies:

Operating Systems: Windows 2012/2008 R2/2003,

RDBMS: SQL Server 2012/2008 R2/2008/2005

Database Tools: Profiler, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, SSIS

Languages: T-SQL

Reporting Tools: SQL Server Reporting Services

Applications: Microsoft Office

Other Tools: Lite Speed, Idera Diagnostic Manager, Foglight, Redgate, Zenass

Professional Experience:

Client: Harland Clarke, San Antonio, TX May 2014 – Aug 2015

Role: MS SQL Server DBA

Industry: Finance

Played role of a Production DBA Providing 24/7 production support to crucial OLTP and DSS systems on standalone/clustered,physical/virtual, replicated environments.

Responsibilities:

Managed 100+ Production SQL Servers (SQL 2005/2008/2008R2/2012) in Virtual and Physical Environments

Involved migrating SQL Server from SQL Server 2000/2005 to 2008 R2/2012

Applied latest service pack on SQL Server 2008 and 2008 R2,2012 both clustered and standalone Environment.

Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2/2008/2005

Managed OLTP databases in Physical and Virtual Environment

Actively Supported building SQL Server 2012 active/active, active/passive cluster

Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)

Involved in Performance Tuning on Production, QA and Staging servers of the current project.

Worked on setting up and managing Transactional Replication

Worked with Log Shipping for disaster recovery.

Maintained various databases for Production and Testing using SQL Server 2012/2008 R2/2005.

Planning the location of data, index and Transaction log files on the disk.

Used SQL Server DMV's for Performance Tuning

Worked with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks

Created the backup and restore strategy for production and development environment.

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.

Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.

Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.

Created Linked Servers for data retrieval using OLE DB data sources and providers.

Actively involved in data center migration (6 data centers were migrated to newly built data center at Sanantonio)

Involved change management process and deployed changes in the server as per the company procedure.

Environment: SQL Server 2012/2008 R2/2005/2000, VMware, SSIS, SQL Profiler, Clustering, Replication Windows 2008 R2/2003/2000,Redgate, LiteSpeed Backup, IDera Diagnostic Manager, SQL Doctor Zenass.

Client: NICASIA Bank Limited, Kathmandu, Nepal Oct 2010 – Sep 2013

Role: MS SQL Server DBA

Industry: Finance

The role was to give Level II support for production, development and QA databases primarily on SQL Server environment. Supporting SQL Servers and using ticketing software for change management and resolving user issues

Responsibilities:

Installed Standalone and Supported Clustered SQL Server 2005/2008/2008R2 instances in Production, Development, Test, Staging environments.

Created databases and configured server level and database level configuration as per the best practices and company policy.

Provided support in setting up High Availability environments like Active-Active and Active-Passive Clustering.

Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Worked extensively on Database space management, performance monitoring and alert management.

Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Worked with Mirroring and log shipping environment.

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements

Suggested backup strategies, Scheduled backups and Performed restoration operations.

Worked with migrating database from SQL Server 2000 and 2005 to SQL Server 2008/2008R2

Created Jobs and scheduled jobs according to the requirements.

Created linked server between SQL servers.

Dropped and recreated the indexes on tables for performance improvements.

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Used SSIS to move data from text files to SQL Server.

Created packages using SSIS to transfer Data.

Applied latest service packs to different versions of SQL Server in both Stand alone and clustered environment.

Environment: Windows 2008 R2/2003 Server, MS SQL Server 2008 R2/2005/2000, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, SSIS, SSRS, BCP, SQL Profiler

Client: Prime Life Insurance, Kathmandu, Nepal Feb 2010 – Aug 2010

Role: SQL Server DBA

Industry: Insurance/Healthcare

Started as a junior DBA with prime life Insurance, primary role was to manage/support databases specially on DEV and Test environment.

Responsibilities:

Database and Transaction log backups & restoration, backup strategies scheduling backup system for test/dev Databases.

Refreshed DEV and Test databases with latest production database

Created logins and users in DEV and Test servers and granted necessary access as per the requirement.

Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Dropped and recreated the Indexes on tables for performance improvements.

Tuned SQL queries using Show Plans and Execution Plans for better performance.

Performing Data Transfer/Migration using Export/Import. Used SSIS packages to load the data.

Load data using Bulk Insert.

Creating and managing schema objects such as Tables, Views, Indexes.

Created and modified the database maintenance plans as per the requirement.

Created and monitored agent jobs making sure that they are running regularly as per the schedule.

Provided support to DEV and Test Users with their issues.

Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000, T-SQL, SSMS, Lite Speed, SSIS, SQL Profiler

EDUCATION:

BBS, Nepal

Contact this candidate