Resume

Sign in

Sql Server Manager

Location:
Irving, Texas, United States
Salary:
120
Posted:
November 13, 2018

Contact this candidate

Resume:

Bishal Pandey

**** ********* **, **********, **, 75010

Phone No: 857-***-****

Email: ac7oox@r.postjobfree.com

Summary

Having 10+ years of experience of MS SQL Server 2000/2005/2008/2012/2014/2016 Database Administrator (DBA) in Windows environment.

Experienced in implementing and maintaining log shipping different types of Replication Models including transitional, peer to peer replication and HA Always ON up to four nodes.

Extensive knowledge of extracting and transforming data using tools like DTS Import Export data, Bulk Insert, BCP and SSIS Packages.

Familiar with different phases of project life cycle.

Excellent skills in creating and maintaining database backup, recovery and restoration and implemented Ola Hallengren maintenance solution .

Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.

Expert in planning and implementing MS SQL Server Security and database permissions/AD groups.

Experienced in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server

Performance tuning and query optimization. Extensive knowledge on creating Database maintenance plans. Experience in Database activities like Data Modeling, Database design, development, database creation and maintenance, performance monitoring and tuning, troubleshooting, enterprise level replication.

Working experience with high availability on clustering and mirroring and SQL Server Always On Availability Groups

Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills. In-depth knowledge of Transact-SQL (DDL, DML), Views, Stored Procedures, functions and Triggers.

Evaluate service packs and provide minimal risk-based strategy for implementation. Extremely attentive, strong team player with an ability to take new role.

Evaluate SQL version latest patch/CU/GDR and apply them on 2008 and above which is supported by Microsoft.

Experienced migrated on-prem SQL instance to AWS both RDS and EC2.

Technical Skills:

RDMS: MS SQL Server 7.0/2000,2005,2008,2012,2014,2016 MS Access 97/2000/XP, Enterprise Manager, Query Analyzer, SQL Profiler, Data, Red Gate, IDERA, Transformation Services, Upgrade Wizard, SSIS, Replication, LightSpeed, Jobs and task creating and scheduling, Analysis Service, Crystal Reports 9.0/10.

Programming Languages: SQL, TSQL, C, C++, VB 6.0

Operating Systems: UNIX, Windows 2000/XP Professional, Win NT/9X, MS-DOS

Web Programming: VBScript, HTML, and XML.

Internet Tools: MS-Front Page, Macromedia 6(Flash, Fireworks, Dream weaver), Internet Information Server (IIS), TCP/IP, LAN, MS-Outlook Express.

Utilities/Applications: MS-Word (97/98/00/XP), MS-Excel (97/98/00/XP), MS-PowerPoint (97/98/00/XP), Adobe Photoshop, and Acrobat Reader/Writer

Educational Background:

University of central Oklahoma (DEC 2001)

Bachelor of Science: (Major) Computer Science and (Minor) Mathematics

Amberton University 2003-2004

VISTRA ENERGY, TX MARCH 2016 – DEC 2018

SR SQL SERVER DBA

Energy Future Holdings Corp. is a Dallas-based energy holding company, with a portfolio of competitive and regulated energy subsidiaries, primarily in Texas, including TXU Energy, Luminant and Oncor. This project deals with supporting the business with all project related activities and maintain the production servers. The team supports all servers for any compatibility and performance issues.

Responsibilities:

Installed and setup SQL Server 2012\2014\2016 Enterprise\DEVELOPER STANDARD at corporate server and setting SQL AlwaysOn.

Migrated SQL 2000 and 2005 to 2012\2014\2016 to reduce the footprint.

Responsible for maintenance of database.

Responsible in creating user groups and databases.

Creating SSIS migration of data across different servers and Other Databases

Designing Backup/Restore Strategy. Setup backup and recovery scripts

Used update strategy, lookups, stored procedures and filter.

Studying the existing environment and accumulating the requirements by interacting with the clients on various aspects.

Scheduling Automated Jobs and Alerting using SQL Server Agent. Monitoring jobs and fixing them.

Identification of various Data Sources and Development Environment.

Responsible for running and maintaining business processes on daily / weekly / monthly basis.

Monitor performance against CPU, RAM, I/O and Storage to help determine performance.

Tuning the SQL script and add index as necessary. Assist Developers in tuning new procedures.

Login and User Management: Adding logins, roles, groups to the Window Server and MS SQL Server and maintaining proper security procedures.

Worked on cluster, mirror, window never failed and SQL Server Always ON Availability Groups.

Worked on TDE to encrypt the sensitive data in SQL Server databases.

Enhancing existing database services, fixing non-performing databases services and decommissioning old database services.

Resolving Remedy Incident Ticket which assign to SQL team

Everyday verify Backup Latency Report from different SQL servers

Respond to alerts messages from all levels of the Database.

Worked 24 x 7 for production support with multiple SQL Instances

Experienced migrating SQL Instance to AWS.

Setup the Ola Hallengren integrity\rebuild Index and backup solution On AWS for EC2 instance.

Set up the Idera to monitor the servers and SQL related issue.

Automated SQL backup process for AlwaysOn as well as standalone database server.

Michaels, Irving, TX April 2011-March 2016

SR SQL Server DBA

Michaels is an arts and crafts retail chain. It currently operates more than 1300 Michaels Arts and Crafts Stores located in U.S. states and in Canada. This project deals with transferring the order and catalog data from stores to corp. MDRS Replication is using to migrate the data from 1300 stores to corporate.MS Transition replication\peer to peer replication is used to replicate data from production to data warehouse.

Responsibilities:

Installed and setup SQL Server 2008 R2 at stores and SQL 2008/2012 enterprise at corporate server. Install gold load/SQL for new stores and set the replication and tested test before going live.

Designed and developed user interactive interfaces.

Responsible for Design and Normalization of the database tables.

Responsible for maintenance of database.

Created database triggers to implement complex business rules and automatic background processing.

Responsible in creating user groups and databases.

Creating SSIS migration of data across different servers and Other Databases

Designing Backup/Restore Strategy. Setup backup and recovery scripts

Used update strategy, lookups, stored procedures and filter.

Studying the existing environment and accumulating the requirements by interacting with the clients on various aspects.

Scheduling Automated Jobs and Alerting using SQL Server Agent. Monitoring jobs and fixing them.

Set up a MS transitional Replication from production to data warehouse

Identification of various Data Sources and Development Environment.

Responsible for running and maintaining business processes on daily / weekly / monthly basis.

Setup replication between store and corporate database to replicate the orders from the store.

Use spotlight to monitor performance against CPU, RAM, I/O and Storage to help determine performance.

Tuning the SQL script and add index as necessary. Assist Developers in tuning new procedures.

Login and User Management: Adding logins, roles, groups to the Window Server and MS SQL Server and maintaining proper security procedures.

Worked on both cluster and mirror.

Performed De-Fragmentations Techniques of most complex indexes.

Performed Backup and recovery & Automation of Backups using maintenance plans.

Resolving Remedy Incident Ticket which assign to DMB SQL team

Worked 24 x 7 for production support with multiple SQL Instances

VERIZON, TAMPA, FL MAY 2007 – DEC 2010

SR SQL SERVER DBA

Verizon is a major telecommunication and Telecom solution providers. The project, which I worked, is Icollect. The purpose of this project is to collect money from the customers. All the data used to come from mainframe and we used to load them into SQL. SQL Server 2005 and 2008 is used to store all the Data related to Development, Testing and Production Environment.

Responsibilities:

Create and maintain various databases for Development and Testing Environment using SQL Server 2005 and 2008.

Monitor batch process job nightly

Monitor CPU usage

Perform Daily Backups and Develop recovery procedures.

Create and Modify procedures, Triggers and functions.

Creating new procedures using Dynamic SQL.

Troubleshooting log shipping Errors and handling Logs.

Creation of Schema owner and Database Users.

Creation of schema objects, Rules and granting of roles to the users.

Assist Developers in writing and tuning new procedures.

Setting up backups for the newly created databases.

Scheduling Jobs and Alerting using SQL Server Agent. Monitoring jobs and fixing them.

Setup and maintains database logins, users, roles and permissions

Created Linked Servers between SQL Server 2012/2008/R2/2005

Scheduling transfer of Backup and Log files to different Server.

Assist Clients for Data issues and provide solutions.

Active-active clustering environment experience

reporting skills using SQL Server Reporting Services (SSRS)

Tuning the SQL script.

Resolving Remedy Incident Ticket which assign to DMB SQL team

Resolving Remedy Incident Ticket which assign to SQL team

Worked 24 x 7 for production support with multiple SQL Instances

Verizon, Grapevine, TX July 2006-2007 FEB

SQL Server DBA

Verizon Communications is one of the world's leading providers of communications services. The project on this company is creating or updating data of product catalog using SQL server 2000 and 2005. The, PLM (product line manager) will make decision on new product, package and market and developer will developed the program and (DBAs) need to load on SQL server and maintain using different scenarios. Installed and Configured SQL Server 2005 Enterprise Edition.

Responsibilities:

Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.

Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases

Installation of service packs and security patches or hot fixes using third party tools attires or using SQL server manually. Analyzing scope and benefit of patch deployment in server.

Database creation; writing database performance tuning scripts, backup planning and implementation with Database restore activity.

Capacity planning in estimating and sizing of tables.

Login and User Management: Adding logins, roles, groups to the Window Server and MS SQL Server and maintaining proper security procedures.

Scheduling Jobs and Alerting using SQL Server Agent. Monitoring jobs and fixing them.

Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.

Resolving Remedy Incident Ticket which assign to SQL team

Worked 24 x 7 for production support with multiple SQL Instances

Sunsations, Ocean City, MD USA Jan 2005 –2006 June

SQL Server DBA

Customer & Inventory Management System (CIMS)

Sunsations, being one of the biggest eastern beach department chain stores, have branches in MD, NJ, VA, TN, CA, NC and FL. They have their main office located at Ocean City, MD. Other remote offices and warehouses are scattered in the states mentioned above. Before implementation CIMS, most of the work were done in isolation between each remote office and did not provide the environment to provide up to date customers purchases and inventory stock.

Responsibilities:

Installed and configured MS SQL Server 2000 Enterprise Edition in the main office at MD and MS SQL Server 2000 Personal Edition in all the eastern shore warehouses.

Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs.

Developed and created logical and physical database architecture for servers at main office and warehouses. Some tables in database were normalized up to third normal form.

Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS.

Set up transactional replication on each remote (warehouse) server that pushes subscription to the central Subscriber (main server) in an hourly basis. This eliminated the overnight shipping of copies of customer invoices to the home office from the warehouses.

Set up some tables, like Customers, in the main server as a snapshot publication and push them to the warehouse server (Subscriber) on the nightly basis. This eliminated the old way of emailing spreadsheet on the weekly basis.

Implemented automated jobs for database backup on a daily, weekly and monthly basis based on the percentage updated on the tables and indexes.

Designing Backup/Restore Strategy

Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.

Created Linked Servers between SQL Server 2012/2008/R2/2005 for Monitoring SQL Server Status.

Developed partitioned views and tables for the purpose of security and fast upload.



Contact this candidate