Sql Server Manager

SYED ‘KALEEM’ RAZVI

SUMMARY

SQL Server Administrator & Developer

Good practical knowledge of Azure Databases

Experienced in SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000

Expert in SQL Server Database Administration, Design, and Development

Highly skilled in Installing, configuring, upgrading, migrating, designing, and development of SQL Server Objects and Reports

Well rounded skills in creating various types of Reports using SSRS and writing procedures and packages using T-SQL

Experienced in ETL (Extract-Transform-Load) process using SSIS and basic knowledge of BI using SSAS

Expert in Clustering, Disaster Recovery technologies using Windows Clustering and SQL Clustering, Replication, Mirroring, and Log Shipping including AlwaysOn

Experienced in performance tuning SQL and SQL Server configuration using DMVs, Profiler/Trace, 3rd party, Perfmon, and built in performance advisors

Familiarity and experienced in AD, Kerberos, SQL Server Authentications, jobs, logins, linked servers, profiles, maintenance, RAID, and Windows NT 4 – Windows 2012

Excellent communication and problem solving skills using logical analyses and examples

Experienced in Oracle, DB2, and Sybase as well in Microsoft and UNIX environments with shell scripting expertise.

Expert in data modelling using Oracle’s SQL Developer Data Modeler, SQL Server Visual Studio and Diagram, and Erwin.

Expert knowledge and experience in programming with VB.NET, Python, ASP.net, and ADO.net

PROFESSIONAL EXPERIENCE

Academy Sports + Outdoors – Houston, TX May 2014 – Oct 2017

Senior DBA

Azure Database Administration.

oSubscribe SQL Server Azure Cloud Services.

oCreate Database(s) on SQL AZURE

oSetting up SQL Azure Firewall

oCreate, manage SQL Server AZURE Databases

oSetting up Connection Strings and connecting SQL Server AZURE Databases from locally installed SQL Server Management Studio(SSMS) for Developers

oMigrated SQL Server 2014 Databases to Azure Databases

Implemented Multiple Instance SQL Failover Clustering on Windows 2012 test & production environments.

Setup several servers and performed server upgrades from SQL Server 2008R2 to SQL Server 2012 and 2014. Practice installed SQL Server 2016 as well.

Some servers are replicated, so performance tuned transactional replication and implemented new.

Consolidated SQL Servers and worked very closely with Infrastructure Manager.

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

Wrote and improved packages, triggers, views, and other objects.

Created and refreshed SQL Databases using LiteSpeed and TSM Tivoli.

Established new Windows Server Security Policies and created reports for Auditing for SOX compliance.

Worked on various projects and tasks throughout my tenure.

Maintained and supported multiple Oracle 11g databases and servers.

Executed performance tuning regularly to Oracle 11g databases.

Managed and created/re-created Standby DataGuard on Oracle 11g database.

Performed Oracle on Linux and Windows backups and export dumps

Used Grid Control for various backups and target databases administration.

Produced and analyzed AWR, ASH, and ADDM reports.

Worked on SQL Developer Data Modeling for designing Logical and Physical data models.

Fixed and improved .NET (VB.NET and ADO.NET) programming and design.

Implemented advanced MS Excel 2013 applications for sports supplies and personnel management.

Created professional Word documents for the sales team and other personnel.

ARS – Houston, TX May 2013 – May 2014

Senior DBA

Implemented Multiple Instance SQL Failover Clustering on Windows 2008 test & production environments.

Setup several servers and performed server upgrades from SQL Server 2008R2 to SQL Server 2012.

These servers are replicated, so performance tuned transactional replication and implemented new.

Automated lower environment refreshes from production including Transactional Replication

Consolidated SQL Servers and worked very closely with Infrastructure Manager.

Migrated 3-nodes to 4-nodes, SSIS, and SSRS.

Installed and implemented SSIS, SSRS, and Freetext.

Created and modified SSIS and SSRS packages.

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

Utilized BIDS to create SSRS reports and SSIS packages and relocated some on demand.

Fixed and created queries in heavily dependent databases.

Created and upgraded SQL Databases for various application needs.

Rewrote procedures and codes to fix performance issues.

Fixed some of Windows Server Security Policies.

MIT/TGS – Houston, TX Oct 2012 – May 2013

Senior DBA

Evaluated all the servers, databases, storage and networks and produced a report to suggest the type of hardware and software needs to best implement Cluster Technology.

Implemented Always-On Failover Clustering using SQL Server 2012 on Windows 2008R2 Ent. Ed.

Migrated applications on single instance non-clustered environment to the clustered environment.

Upgraded SQL Server 2008 and 2008R2 to SQL Server 2012.

Applied patches related to security and other Microsoft recommended upgrades.

Created new databases for various 3rd party applications and home built applications.

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

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.

Created a stored procedure to migrate data from Oracle to SQL Server on on-demand basis.

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

Creation, patching, and installation of Oracle 10g/11g R2 and SQL Server 2008/2005

Wrote Oracle security application in k-shell script

Spark Energy – Houston, TX Oct 2011 – Sep 2012

Senior DBA

Implemented Multiple Instance SQL Failover Clustering on Windows 2008 test & production environments.

Installation, configuration and administration of IIS web servers.

Building new Windows/IIS servers (IIS6.0/7.5/8) and setting up .Net applications.

Utilized Power Shell Scripting to automate many tasks, Database Administrative, AD and MS Exchange.

Automated lower environment refreshes from production.

Consolidated SQL Servers and worked very closely with Infrastructure Manager.

Worked closely with Server team to backup LightSpeed backups to tape drives.

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

Utilized BIDS to create SSRS reports and SSIS packages and relocated some on demand.

Rewrote procedures and codes to fix performance issues.

(Oracle) Setup 10g AS for forms and reports.

SunGard SGHE – Houston, TX Apr 2011 – Oct 2011

Senior DBA

Implemented SGHE Banner multi-tier application in Windows and UNIX test & production environments

Setup configurations for Banner applications and Oracle 10g SOA and the required patches

Troubleshoot installation issues with ODS & EDW

Remotely installed and worked on all the issues related to databases and Banner including Application Servers

SunGard SGHE Texas State University - San Marcos, TX Feb 2010 – Apr 2011

Senior DBA

Implemented SGHE Banner multi-tier application in UNIX test & production environments

Setup configurations for Banner application and SOA 10gAS and the necessary patches

Installed 10gAS and applied the necessary patches suggested by SunGard

Worked on BannerWare Products, Databases and administered Servers

Triad - Shell Trading – Houston, TX Oct 2008 – Feb 2010

Senior DBA

Worked on SSRS and design various report types to match the business needs

Used BIDS for various SSIS and SSRS projects for TB energy application

Primary on SQL databases 100+ from 2GB to 500GB

Applied latest patches to all SQL Servers and Oracle Database

Build an application using T-SQL procedures to archive old data

Filled in the gap for leaving DBAs very quickly and efficiently

Sped up the process of migrations and applied CPU and security patches

Met, planned, designed, and implemented new SQL databases

Comsys/JPMC – Houston, TX Aug 2007 – Oct 2008

DBA

Installed and configured CRS, ADM, RAC 10g Oracle databases for A/P cluster on Linux

Refreshed several databases on daily basis

Maintained physical remote standby

Applied changes and patches to databases

Fixed issues with Oracle databases after it is migrated from Sybase

Designed databases, by creating logical and physical data models using Erwin

Comsys/ERCOT – Austin, TX Aug 2006 – Aug 2007

DBA

Installation and upgrades of SQL Servers and Oracle databases 2TB

General Day to day maintenance of SQL Servers

Performance tuning partition tables of VLDB

Applied DST and CPU security Patches on Oracle

New database creations from ground up, going through complete cycle of planning, designing, testing, and implementing

Wrote shell scripts to manage monitoring of 2TB replication using Shareplex(TM)

Calpine – Houston, TX July 2005 – Aug 2006

DBA

SQL

Installed new servers on demand and created databases on demand

Maintained standby servers (Log Shipping)

Performed and maintained backup and recovery

Created auditing using T-SQL stored procedures

Wrote scripts to performance tune various tasks

Fixed and debug previously written scripts

Performed periodic refreshes of development and test databases from production

Fixed issues with slow queries and application server issues

Maintained Process Scheduler

Performed changes and upgrades of PeopleSoft and nMarkets databases and applied periodic patches

Oracle

Upgraded 9i to 10g (9206 to 10104) and created Standbys

RMAN refreshes of dev/test from production databases

Performance tuned databases, applications, and servers

Managed data warehouse and huge partition tables

VERITAS Software – Houston, TX Feb 2004 – Jul 2005

DBA/Contracted and Hired

Installed, configured, and troubleshoot i3 software for up to 30 companies worldwide

VERITAS i3 is an end-to-end monitoring tool used for performance enhancements of all the tiers involved

After the install monitored performance loopholes in the system and produce a report

The report also reflects the possible changes that will fix the performance issues

Finalize the engagement by knowledge transfer

Litton Loan Servicing, LP – Houston, TX Jul 1999 – Feb 2004

DBA

SQL Server

Upgraded to SQL Server 2000 from SQL Server 7.0

Installed new SQL Servers and maintained three other servers

Performed all aspects of database administration, including data modeling, backups, replication, OLAP, and backup & recovery

Besides designing and debugging DTS (Database Transfer Service) programs I used DTS import export wizard to import or export data to/from Access and to/from SQL Server

Created flat files to be SQL loaded to Oracle database

Maintained, debugged, and optimized existing data warehouse system and streamlined batch processes

Wrote stored procedures and Transact SQL code as well as VB scripts

Segmented several months of data from a 95 GB database and extracted specific information for statistical analysis

Not only served as technical advisor but also reduced the database to only the raw data required for the analysis

Also extracted all updated data from the other 2 months to extrapolate changes

Wrote SQL programs and stored procedures to accomplish all tasks

Provided stability in the IT department and made some emergency changes like security including the way logins and backups were made

Oracle

Setup OEM and OMS to monitor, manage, and plan databases

Setup high availability system and clustering

Designed, installed, and maintained complex functions of major database systems including access, allocations,

validity checks, security, documentation, and tuning

Wrote functional and technical specification documents explaining the new environment and instructions

Coordinated testing procedures with Q/A group

Troubleshoot and supported eight different 7x24 production systems including Oracle and SQL

Also handled ten other non-production databases

RAC 9x

Setup and administered 9iRAC and trained DBAs and developers

Created and maintained Physical Standby using Oracle Data guard resides on SunOS 440R machines for a backup and failover

Performance tuned distributed databases residing on SunOS and Win2000 using Statspack

Besides Standby Database I performed day-to-day maintenance, cloning, backup, and recovery using RMAN etc

TECHNICAL EXPERIENCE

SQL DBA 2012, Clustering and HADR, Oracle DBA 11g, Scripting PS, VB, SQL, UNIX Shell, Performance Tuning, Designer, Developer, SSIS, SSRS, IIS

EDUCATION

Punjab University 1984

BS in Mathematics

HCCS 1996

AS in Computer Science

Lamar University 2017

A Course in MS Applications

Accomplishments

Extension of contracts, Re-hires, and Raises

Cluster implementations

Perfect Migrations & Disaster Recoveries

Production problems fixed in minutes

Designed and Developed applications from scratch

Contact this candidate