Sql Server Manager

Summary

System Administrator - SQL Database/ Windows Administrator – Network Engineer

Highly motivated, responsible individual with hands on experience in Information Technology within Fortune 500 companies. Experience with union and non-union employees. Strong consulting and listening skills with the ability to assess needs of business partners and arrive at practical solutions. Proven communication skills between multiple arenas to effectively unite individuals into one cohesive team, so focus can be directed to customer satisfaction, long term vision for future plans and bringing a greater return to the bottom line. Diverse experience includes:

Employee/Customer Relations

Dubugging Tools like Netmon, Processmon, AuthDiag and SSL Diag

Troubleshooting root causes

Training and Development

Profiler, Database Tuning Advisor, Performance Monitor

Networking, Authentication, Authorization

24/7 Environment with 99.99% SLA

Protocols like DHCP, DNS, TCP-IP,SNMP,SSL

APPLICATIONS

SQL, IIS, Power BI, HTML, Azure, PowerShell, SSRS, SSIS, SSAS, Microsoft (Excel, Word, PPT)

Education

MBA, Masters in Business Administration, Northwest University - Kirkland, WA (Pursuing- Graduation in May 2017)

MS, Masters in Computer Science, Arkansas State University - Jonesboro, AR

BS, Bachelor in Electronics and Communications, St. Mary’ College of Engineering and Technology - Hyderabad, India

Professional Experience

ThriveSoft, INC. Bellevue, WA 11/2015- Present

SQL DBA

Install and configure multiple Websites in IIS using different techniques and enable the web service extensions.

Implement different Load balancing methodologies to ensure the High Availability of ASP.Net and web applications in the Production environment.

Configure application logs, Systems logs, and Log rotation on timely basis.

HA techniques like Mirroring, Replication, Always ON and Clustering etc.

Worked in Customer-centric role, where customer interaction happens via Email, phone calls and direct reports.

Creating/deploying Reporting Services (SSRS), Data Transformation Services (DTS) and MS SQL Server Integration Services (SSIS) packages.

Ensure Microsoft SQL replication is performing optimally and all transactions are recorded locally and at the designated disaster recovery site.

Perform database indexing on a weekly basis, due to high volume of I/O.

Archive historical data from MSSQL data stores and LUNS. Move historical data to remotely located SANs.

On call rotation for after-hours support, as well as escalation support for priority and high profile issues.

Design and implement High Availability and Disaster Recovery (HADR) for highly critical databases.

Created and modified procedures, triggers and functions

Microsoft, Redmond WA 04/2015-11/2015

SQL DBA

Experienced in creating Tables, Views, Indexes and other SQL joins and other query Writing.

Expert in developing T-SQL (DDL, DML) statements, Data Integrity(constraints), Performance Tuning, Query Optimization and Validation issues.

Experience using Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning SQL Server Performance.

Worked on maintenance tasks like Patching, writing Scripts and scheduling them in Task Manager

Rebuilding the indexes at regular intervals for better performance.

Designed, Built ETL procedures and a data warehouse to meet client requirements using SQL Server Integration Services.

Administer Active Directory and Microsoft Exchange Server

Renewing SSL Certificates, Service account passwords for AppPools as well as Windows Services.

Monitor (on a daily basis) various Microsoft SQL databases for XBOX 3PP snap-shot success, standard SQL backup success, and transactions log backups.

Health checks on all databases are a daily task.

Oslo Solutions, LLC. Bellevue, WA 08/2014-03/2015

System/Network Engineer

Line 3 operations application support includes delivering key application support, resolve tickets as per the given SLA, proactively identify areas for improvement, and perform change management activities, standard production changes to new architecture customers/users to resolve critical application issues.

Design custom scripts to expedite database creation/maintenance. This includes, but not limited to: user audit reports, scripted table creations and data imports, database bulk inserts, and maintenance procedures.

Working directly with vendors to allow application integration with our environment between front-end users and back-end serves/databases.

General responsibilities include: Perform complex data analysis, create database descriptions, and interact with various types of end-users (customers, team leads, managers, vendors etc.) to provide service and support for database implementation and maintenance.

Keep the IT Director/Manager/Supervisor in touch with new technologies in database management, optimization and design.

Experience in working with ITSM.

Microsoft., Redmond, WA 02/2013-03/2014

SQL/Windows Administrator

Worked closely with operations, database programmers, and web developers to ensure database integrity and security.

Requested & Installed SSL certificates for the websites, to ensure a secured communication between the client and the server.

Worked on SQL Server 2008/2012 and Configured in around fifty servers which includes a fresh install and in place upgrade from 2005 and 2008 in Production and Preproduction environment.

Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Involved in technical discussions related to ETL development processes and contributed to progressive modifications to overall DW architecture as the project evolved.

Design and develop reporting tables and ETL jobs using SSIS, building towards a centralized datamarts on MS SQL Server platform supporting SSRS reports

Monitored connections, locks and performance of SQL server.

Responsible for creating tickets and resolving server’s issues on time

Provided Root cause analysis and fixing the Windows / IIS Web Server Related issues.

Oslo Solutions, LLC., Redmond, WA 08/2012-01/2013

Windows Administrator

Responsible for escalations coming from Tier 1 team and provide immediate resolution for Customer/Partner impacting issues.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Developed, deployed and monitored SSIS packages for new ETL processes.

Created different types of reports including Cross-tab, Conditional, Drill-down, Sub reports using SQL Server Reporting Services(SSRS).

Monitor and modify Performance using execution plans and Index tuning.

Lean ERP, LLC. Harrisburg, PA 05/2012-07/2014

SQL DBA

Modified store procedure for performance tuning

Used system stored procedures and DBCC commands

Maintain database performance and optimization enterprise wide.

Analyze and perform metrics on databases. Identify performance issues and implement changes to optimize performance.

Ensure successful database and transaction log backups are performed for each instance based on the application’s requirements.

Work Authorization: H1 B; Ready to transfer H1 if possible

Contact this candidate