Sql Server Service

SUMMARY OF QUALIFICATIONS:

Over * years of experience mostly in the financial industry.

Solid experience in driving initiatives in operation stability, standardization, monitoring, hygiene, audit remediation, and security procedures, implementing\testing\building DBA monitoring tools for database services of global, complex organizations;

I am relentless in my pursuit of the best customer experience, the best employee experience, and the desired financial results to the business. Accustomed to fast paced environments where deadlines are a priority and handling multiple responsibilities is the norm

I enjoy challenges and will work hard to achieve your objectives.

I’m Professional at resolving critical breaks by analyzing most effective solution that properly brings BAU, investigating root cause and implementing permanent solutions when needed;

Skilled at leveraging SQL Server in development, testing and production environments. Background includes database configuration, maintenance, troubleshooting and managing day to day operation activities Co-ordinates Project implementations and migrations for business-critical applications

Installed and configured MSSQL 2012/2008R2/2008, applied patches, hotfixes and service packs

Implemented Side-by-Side Migration and in-place Upgrade of MSSQL 08 12

Extensively worked on Clustered instances of SQL 2008/2012 and Slip Stream installation for 2008R2

Worked on maintaining security (logins, users, database/server roles and granting/revoking permissions)

Maintained backup, restore the database manually and scheduling jobs and standards Plans

I’m Expert in configuring, implementing, monitoring all types of High Availability & Disaster Recovery solutions including Replication, Log Shipping, Mirroring and Clustering

Implemented Always-On Availability Groups in SQL Server 2012

Experience in using the DMVs, System Views and in-built global variables for analysis

Expert in Performance Tuning by analyzing blocking, index fragmentation, execution plans

Extensively used the native tools SQL Server Profiler, Activity Monitor, Query Plan, Database Tuning Advisor, Log Viewer and Event Viewer for performance analysis and errors

Experience configuring and working MSSQL Server 2008 on VMware Environment

Experience troubleshooting SQL Server jobs and job monitoring tools.

Extensive experience with Backup compression and data compression in SQL Server 2008/2012.

Experience Production Support for large and Complex Databases.

EDUCATION:

Bachelor of Commerce (B.Com.), 2003 Cairo University.

Business Management course; 2008 University of Pennsylvania Wharton School of Business

Database Administration; 2007 MCCC – Montgomery County Community College

MSSQL Server; 2007 MCCC – Montgomery County Community College

Microsoft Azure; 2016 Microsoft

TECHNICAL EXPERTISE:

Operating System

MS Windows Server 2008 2008R2 2012 (installed & explored windows 2016 trial edition on Azure)

RDBMS

MSSQL 2005 2008 2008R2 2012 2014

DB Technologies

SSIS SSRS SSAS SQL Profiler Azure LiteSpeed Net-Backup Clustering

Other Tools

GENEOS; ITPAM; PDPA; Tivoli; DB-Portal; HP Service Manager/Peregrine (ticketing); SCOM; CyberArk EPV (PW vault); TAMS; RSAM; ITSM; MS Office. Skype for Business, Word, Outlook, Excel, SharePoint

PROFESSIONAL EXPERIENCE:

JPMorgan CHASE & Co. July 2014 - Present

Sr. MSSQL DBA GSO L3 DBA

GTI GSO database service team are over 400 DBAs, identified as one of the largest DBA groups in the world supporting thousands of servers Globally. Worked as a part of L3 24/7 DB support team of Sr. DBAs supporting and managing all CCB LOB infrastructure (Chase.com, commercial card, Mortgage Banking, Auto Finance, student\personal Loans, Digital and Card services)

Present environment consists of ~1300 DB servers; ~50MB–8TB Databases and different DR, HA and performance strategies.

Duties and Responsibilities:

Projects

oDocumented SQL Server checklists, procedural guides, and standards

oProjected requirements for new builds and performed installation, initial configuration, Migration, DR setup, Pilots and GO Live for CAF\NON-CAF apps on Cluster\Stand-alone VM\PM servers.

oBackup/restore databases, perform data compression, DBCC, configure DR, sync logins, check for and remedy orphan users, set up mirroring and run mirroring DR tests for newly migrated databases

oDefine requirements for installation and configuration of SQL Server 2012, updating service packs and security patches for the dedicated and shared server environment, upgrading/migrating and consolidating databases from SQL server 2008/2008R2 to SQL Server 2012

oFacilitate/participate in database project meetings pertaining to database migrations and updates. Meetings involve frequent liaising with offshore and domestic teams which include PM, AD team, SME's

oImport/Export of tables and other database objects

oManaged and maintained security by defining roles and permissions

oCreate linked servers for Windows, Oracle and Progress platforms

oPerformed tasks such as shrink data/log files, and/or clear old backups to remedy space issues/alerts

oCreate standard templates for execution/implementation Plans

Production Support:

oManaged\Administered MSSQL database servers, on a 24\7 Rota and weekend on-call rotation.

oMonitored health, performance and activity of all UAT\PROD\DR servers using GENEOS dashboard;

oProcessed\owned daily auto-generated & User-submitted HP-service manager tickets (per priority\Order) P1S1,2,3, & P2,3,4 incidents\tickets for break-fixes

oManaged ITPAM for service requests; Implementing ITSMs for database changes

oFound solutions and Implemented changes to the DB engine and SQL components to achieve the best performance, availability and reliability of DBs,

oGenerated\compiled EOD-SOD Reports indicating status for shift hand-over

oMonitored GENEOS dashboard and SCOM for alerts and breaks

Morgan Stanley, New Jersey city, NJ Jun 2012 - May 2014

Sr. MSSQL DBA

Installed stand-alone and clustered SQL Server 2012 and SQL Server 2008R2 for scale up\out projects, migrated MSSQL Server 2005 to SQL 2008R2 and SQL 2012 using in-place upgrade and other migration strategies while participating in on-call shift rotation and daily PROD support of business-critical applications and maintain healthy GREEN status

Responsibilities:

oImplemented and maintained Database Mirroring, Log Shipping and Replication for Disaster Recovery solutions

oImplemented Always-On Availability Group as a High Availability solution on SQL Server 2012

oManaged and administrated SQL Server 2012/2008R2 on production and non-production servers

oParticipated in a Failover drill to check the High Availability solution

oWorked on setting up the SQL Server Configuration to resolve various resource allocation and memory issues for SQL Server databases and to setup ideal memory, min/max server options

oConfigured Database mail by creating accounts and profiles

oMonitored database status including CPU, memory, I/O, space, and blocking issues using SQL Server Utilities

oProactively monitored\checked Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors

oImplemented Partitioning on large tables to improve the performance

oSuccessfully implemented capacity planning for different servers

oUsed table hints in the queries to avoid Locks and improved the performance

oResolved Locks and Deadlocks by using DMVs and Activity Monitor

oPerformed day-to-day activities including full, differential and log backups (scheduled backups for databases and transaction logs) to disks and restored the databases

oWorked on point in time recovery and point of failure recovery

oModified Stored Procedures and complex T-SQL queries to improve query execution

Bank of America, Bridgewater, NJ Apr 2009 - May 2012

Role: SQL Server DBA

Responsibilities:

oInstalled SQL Servers on 64 bit and 32 bit systems.

oManaged and administrated SQL Server 2008R2/2008/2005 on production and non-production servers.

oInstalled SQL Server 2008/2008R2 and service packs on Windows Server Clustered and stand-alone environment.

oMigrated SQL Server 2008/2005 databases to SQL Server 2008R2/2008 databases.

oUpdated statistics and performed database integrity checks.

oPerformed backups using backup compression and data compression in SQL Server 2008 on clustered environment.

oImplemented and managed Log Shipping as a Disaster Recovery solution.

oDesigned and developed SSIS packages using control flow tasks and dataflow tasks.

oCreated maintenance jobs for performance of SQL Server which includes updating statistics, database integrity checks and Index Rebuild.

oFixed Missing Indexes and Excess Indexes.

oWorked closely with development team to assist team in various problems solving and troubleshooting Web based applications which includes stored procedures, functions and triggers.

oMonitored SQL Server performance using profiler to find issues like blocking and deadlocks.

oCreated backup and scheduling strategies for Very Large Databases (VLDB).

The Salvation Army, Philadelphia, PA Feb 2008 - Mar 2009

MSSQL server DBA

Installed, managed, upgraded and administrated SQL Server 2008R2/2008/2005 on production and non-production servers; Migrated MSSQL versions; created jobs to update statistics and performed database integrity checks; configured and monitored Database Mirroring on PROD\DR\UAT servers and troubleshoot any errors; Implemented and managed Log Shipping as a DR and\or HA solution.

Responsibilities:

oPrepared, maintained and modified SQL server installation and configuration documents

oDocument SQL Server checklists, procedural guides, and standards

oManaged Disk space, memory and User connections

oCreated Logins, Users and Proxy accounts with appropriate permissions and performed security management and audit remediation

oPerformed backups using backup compression, created maintenance jobs for managing SQL Server which includes updating statistics, database integrity checks and Index Rebuild

oWorked closely with development team to assist team in various problems solving and troubleshooting Web based applications which includes stored procedures, tables, functions and finding\creating missing Indexes for better performance

oMonitored SQL Server performance using native and vendor tools to find issues like blocking, deadlocks and I\O

The Salvation Army, Philadelphia, PA Aug 2007 - Feb 2008

Role: Senior Program Accountant (Non-Profit)

Managed, organized, prepared and directed all monthly general ledger accounting activities including transactions related to assets, payables, taxes, payroll, cash and monitoring budgets Generated financial statements, conducted analysis, and created other management reports.

Responsibilities:

oMaintained accounting systems to ensure the proper accounting and recording of company resources. Prepared cash flow reports and monthly department analyses. Managed and administered admin cost allocation plan and Coordinate funder reviews and audits.

oHave Designed reports in Financial Edge and Excel. Prepared periodic and ad-hoc reports. Review and assist in the preparation of annual budgets and modifications. Coordinated year-end audit review for external audit staff and worked directly with auditors.

Oman-Tel, Muscat, Oman Dec 2003 - June 2007

Financial Analyst

Oman-Tel is one of the largest telecommunication companies in the Middle-East, Generated financial analysis reports for multiple strategic decisions. Served on due diligence team to audit and analyze a target acquisition.

Responsibilities:

oGenerated monthly, quarterly, and yearly forecasts with a 95% accuracy rate. Produced financial and operational projections (i.e. revenues per region and product, expenses per department and project, capital expenditures).

oAnalyzed and evaluated financial statements, explained variance and identified trends. Prepared and developed ratio analysis (i.e. profitability, liquidity and solvency). Carried out analysis of return on investment, P&L and balance sheet impacts of capital expenditure projects.

oResearched competitors and developed comprehensive analysis of industry data.

Contact this candidate