Manager Social Media

IQBAL BUTT

832-***-****

******.***@*****.***

SUMMARY:

Microsoft SQL Server DBA with 6 years’ experience in Database Administration, Administer\Support MS SQL Server 2016/2014/2012/2008R2/2005/2000 in Production, Test, Development and Cluster Server Environments Install, configure, patch, upgrade, maintain and migrate databases.

Performed various data migration tasks for mission critical databases.

Worked with BI teams in the full development lifecycle of the SQL server 2005, 2008 and 2008r2 enterprise data warehouses and report servers.

Experience working Windows Server 2003/2008/R2 NT Server and Installation.

Experience with MS SQL Server 2008/R2/2005/2000 and their Installation, Configuration and Maintenance.

Experience in Data Migration from MS SQL server 2000 to 2005/2008/2012/2016 with service pack and patches.

Expert in back up strategies, Model (Full, Bulk logged, Simple), Database creation, Table, Indexes.

Worked with bi team and reporting group in generating the weekly, monthly, and quarterly report by using SQL Reporting Services.

Performance Tuning, Indexing, and monitoring SQL Server using Database Tuning Advisor, SQL Profile (dead locks/ long running queries), Windows Performance Monitor and Database Consistency Check using DBCC Utilities.

Experience in transforming data from different sources like Oracle, Excel, Flat file, Sybase to MS SQL Server by using BCP, DTS, Bulk Insert and SSIS.

Monitored and maintained appropriate disk storage requirements for the database.

Automated process by creating jobs, maintenance plans and error reporting using Alerts, SQL Mail Agent.

Experience in Disaster Recovery & Capacity Planning models for corporate databases.

Implemented different types of Replication Models, Database Mirroring modes and Clustering environment (active/passive and active/active) to further increase scalability and stability of business critical systems.

Implemented backup policy using Full, Differential, Transactional log and Recovery and Disaster Recovery Procedures.

Experience in implementing and configuring various RAID 1-5 & 10 technologies.

Monitored table, disk utilization, and database fragmentation on a periodic basis.

Expert in Creating, Testing and Implementing SSRS packages, SSIS packages.

Implemented change management controls, processes and practices to deliver quality services that increase client bottom line results.

Experience in developing reports using SQL Server 2016/2014/2012/2008/2005 Reporting Services (SSRS).

Worked with performance tune the complex queries using the Microsoft Query analyzer and used to support batch process.

A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.

Good communication and written skills.

Organized and co-ordinates daily operations and project delivery meeting to identified all possible problems and ensure they are rectified to keep project on schedule.

Managed the entire database environment visibility and accountable for every database decisions made.

Worked 24 x 7 for production support with multiple SQL Instances.

EDUCATION:

BS, University of Central Oklahoma, OK

TECHNICAL SKILLS:

Database: SQL Server 2016/2012/2008/R2/2005/2000 Enterprise, Standard Edition.

Data Migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

Tools: SQL LiteSpeed, Red Gate (SQL Compare), Net Back up, Quest Light Speed

Languages: SQL, PL/SQL, SQL Plus, My SQL.

MS-Office: Word, Excel, Access, Outlook, Outlook Express and Power point.

Operating Systems: Windows Server 2003 EE, Windows 2008 Server/Advanced Server and Windows Vista/XP/NT/2000.

Professional Experience:

SQL SERVER DBA

Landry’s, Houston, TX

Jan 2015- Present

Landry’s features over 600 locations nationwide, featuring the best in Dining, Hospitality, Entertainment, and Gaming. My responsibilities involved tune SQL Server databases, Backup and restore databases as appropriate, Upgraded SQL Server 2005, 2008/2012/2014 to 2016. Monitor all aspects of RDBMS environment and Support development, test, and production SQL Server database.

Responsibilities:

anaged all Production, Development Environments running MS SQL Server SQL 7.0/ 2000/2005/2008 R2/2012/2014, and 2016.

Implemented Always-On Failover Clustering using SQL Server 2008 on Windows 2008.

Applied patches related to security and other Microsoft recommended upgrades.

Sponsored meetings to bring all departments within the IT to the same level of understanding about new procedures and policies.

Consolidated SQL Servers and worked very closely with Infrastructure Manager.

Created stored procedure to automate reports on backups to be emailed on daily basis.

Created stored procedure to report on index usage, efficiency, reorganize and rebuild requirements.

Implemented SQL Defrag and Diagnostic Manager from Idera for performance monitoring and removing fragmentation.

Customized and scheduled the jobs. Also used SQL Safe for backups and restores.

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

Involved in Migration of Production Database Servers from SQL Server 7.0 to SQL Server 2016.

Configured and Maintained Replications and Implemented Database mirroring for High Availability.

Used SSIS and Database Diagram for ETL and designing new databases and normalization.

SQL SERVER DBA

Hewlett-Packard Company, Houston, TX

Sep 2013- Dec 2014

HP provides hardware, software and services to consumers, small- and medium-sized businesses (SMBs) and large enterprises, including customers in the government, health and education sectors. My responsibilities involved Build/upgrade and tune SQL Server databases, Backup and restore databases as appropriate, effectively manage and monitor all aspects of RDBMS environment and Support development, test, and production SQL Server database. Assign Vertica access to the users.

Responsibilities:

Managed All Production, Development Environments running MS SQL Server 2005/2008 R2/2012.

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

Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server 2008/2012.

Configured and Maintained Replications and Implemented Database mirroring for High Availability.

Implemented and supported Log shipping, Replication and Database Mirroring.

Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

Extensive knowledge of using Package Configuration wizard to configure SSIS packages.

Strong knowledge in implementing Backup strategy using Complete, Differential, Transactional, files and file-group depending on Database Recovery Model Simple, Full, Bulk-Logged.

Monitoring and Managing use of disk space and connections and Analyzing and troubleshooting the SQL Server processes and jobs.

Implementation of Vertica database warehouse cluster.

Database design, partition, segmentation, schemas, tables, and cluster management.

Extract, Transport and Load data between different DW architectures.

Perform complex SQL queries using the VSQL tool.

Import and export Vertica tables between databases.

Create tables, Schemas and grant access to Vertica users.

ENVIRONMENT: WINDOWS 2008, MS SQL SERVER 2008 R2, MSCS, VERTICA, ORACLE, SHAREPOINT/SHAREPOINT LIST, BIDS, SSIS, VB, IBM RATIONAL, MS VISIO PRO 2002.

ITRISK Analyst

JPMORGAN CHASE & CO, Houston, TX

Jan 2011- Jan 2013

JPMorgan Chase & Co is a leading global financial services firm. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of databases in GTI production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse.

Responsibilities:

Act as project manager and liaison for Active Directory Shares remediation:

Execute remediation of 10Qtree over 2 week period, gathering shares data including classification, description, ownership, access, and user rights (read only, write, write only, no access).

Interface with Line of Business leads re shares data, assuring no discrepancies in rights given to users.

Validate permission details with all groups, meet with leaders to finalize and approve go-ahead.

Demonstrate extensive knowledge of Active Directory to update account, secure privileged data by granting explicit permissions to proper information owners, coordinate migration of share data, remediate network file share, and run reports on filers for thousands of accounts in multinational financial corporation.

Active participant in group discussions and decision-making processes for projects, created and modified various support tools to benefit project needs. Participated in application and system testing with developers; collaborated with personnel to jointly investigate and promote software distribution.

Monitored Active Directory for security threats and took necessary action to remediate, adhering to audit standards and maintaining Governance and standardization by creating process to eliminate excessive access.

Partnered with CTS and Active Directory Engineering to create ACE tool to be utilized for share permissions.

Assisted with newly designed tools for our project; tested tools like, SAM(Share Access Monitoring), ACE (Access Control engine), DO (Data Ownership) in both Development and Production environment.

Create and utilize Perl, ARS, Python, Local Admin, RoboCopy, and iCacl scipts to create, and permission files.

Migrated over 200,000 user accounts and identified 90% of information owners associated to data for successful completion of Enterprise Password Vault (EPV) project.

Classified data and partnered with LOB to identify functional accounts to be retained\off boarded.

Updated SharePoint with documentation, training materials, and other pertinent information for users globally.

Performed application support, analyzed and troubleshot Peregrine incidents and provided expedient resolution.

Effectively collaborated with team members and provided weekly accomplishments to Project Manager.

Environment: Windows Server 2003 EE, Windows 2008 Server/Advanced Server and Windows Vista/XP/NT/2000.

Third Level Technical Support Analyst

JPMorgan Chase

1111 Fannin Houston, TX

June 2004- Dec 2010

JPMorgan Chase & Co is a leading global financial services firm. My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of databases in GTI production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse.

Responsibilities:

Perform administrative tasks such as create, disable, and unlock user Windows/Novell accounts. Add group membership and creates new profiles as needed. Add applications, printers to user accounts, grant access to network folders, map drives, deploy group policies on to user NT and Novell accounts.

Resolve user workstation issues using remote tools like LANDesk ISS Remote Control, Windows Remote Assistance, sametime, and R Push.

Setup VPN connections (Site to Site / Client Initiated) for remote clients.

Troubleshoot remote user connectivity problems with remote access on high speed cable, satellite DSL, Wi-Fi, Configured Odyssey Client connections over modem or router.

Troubleshoot issues with Blackberry & Palm pilot and synch up with Lotus Notes and outlook.

Added knowledge to company knowledge base platform used for resolving issues with JPMorganChase applications.

Participated in application and system testing with developers, collaborated with peers and other business units to jointly investigate, test and promote software distribution and fix them in timely manner.

Participated in one of largest and most successful mergers in IT industry between Chase and Bankone as well as mergers with Bear Stearns, Bank of New York and WaMu.

Provided support for installation, maintenance, upgrade of common office applications, LOB applications, softwares and clients typically found on desktop PCs.

Demonstrated effective use of time management skills. Interacted and communicated effectively with customers, team members and management.

Environment: Windows Server 2003 EE, Windows 2008 Server/Advanced Server and Windows Vista/XP/NT/2000.

Technical Support Analyst

Convergys

Houston TX

Nov 2003 – June 2004

Troubleshoots problems with printers, copiers, plotters, LAN and WAN connectivity.

Contacted Customer to ensure receipt and satisfaction of product and review key accounts- check on current standing of accounts and credit availability.

Wrote letters to key account customers and developed promotional material.

Answer customer questions and provided technical information..

Responsibilities:

Provide Tier1 technical support; assisted users facing network problems. Performed advanced troubleshooting, diagnostics and provided tier/level-1 solutions to network failures.

Analyze customer need for LAN computer networking systems.

Design and present recommendations for required hardware, software, and system configuration.

Diagnosed and resolved hardware, software, and networking issues.

Trained users on computer, voice mail, and other networking equipment.

Diagnose and resolve technical software issues involving internet connectivity, email, VOIP, fiber.

Interact with customers to provide and process information in response to inquiries, concerns, and requests about products and services same to optimize application and system performance.

Environment: Windows Server 2003 EE, Windows Server and Windows Vista/XP/NT/2000.

Technical Support

Telvista, Plano, TX

Jan 2002 – April 2003

Telvista specializes in providing superior customer care solutions to Fortune 1000 companies. Our services include contact management, social media services, interactive voice response, web-based support, and many others. We are proud to be a vital part of our clients' success by offering customized programs that enable them to do more with less while maximizing their bottom line.

Responsibilities:

Responsibilities include Helpdesk support, configuration, implementation, maintenance, and troubleshooting for end users.

Assist in the maintenance and expansion of the internal network and MIS environment (mail, file service).

Daily Support of Local area Network (LAN) consists of primary server, backup server, and File server.

Build servers, workstations, Laptops; installed software configured the systems TCP/IP, DHCP etc.

Responsible for supporting Full Serve and Self Serve Dell computers and Laptops.

Troubleshoots problems with printers, copiers, plotters, LAN and WAN connectivity.

Support of wide range of software installed on Dell Computers.

Responsible & performed Desktop/Helpdesk support to the developers.

Responsible for translating customer needs project plans and assessments.

Environment: Windows Server 2003 EE, Windows Vista/XP/NT/2000.

Exchange Server Administrator

Software Spectrum, Garland, TX

Dec 2001 – Jan 2002

Company provider of technology solutions including hardware, software and services to business and government clients in North America, Europe, the Middle East, Africa and Asia-Pacific

Responsibilities:

Configured and set up complicated Exchange server organization; designed and implemented multiple exchange sites connectors and replications.

Provided solution on backup procedures, database corruption problems and disaster recovery procedures.

Supported public folder replication, corruption and security issues, along with setting up site connectors and exchange migration.

Set up and troubleshot connectivity options such as X400 connector, site connector, IMC (Internet mail connector).

Diagnosed LAN/WAN problems, TCP/IP issues and router configuration problems that prevent mail flow.

Assisted customers with exchange installation and upgrades, database/log file management and disaster recovery.

Mentored and trained junior level support engineers and second level escalations. Implemented enterprise platforms in multi-domain environment including: NT server, Terminal server and Cluster server, Proxy, NT workstation and Windows 95/98.

Environment: MS Exchange Server 3.5, 4.0, 5.5, and Exchange Server 2000, Windows 2000 Server.

REFERENCES:

Available on request

Contact this candidate