Sql Server Windows

KHALED OSMAN

***** ******* **, *******, ********, 22030, Phone: 646-***-****, Email: **********@*****.***, US Citizen

PROFESSIONAL SUMMARY

Approximately 5 years of production database administrator with a strong background supporting database life cycle management in different environments.

Maintain Security at server level and database level by installing patches implementing TDE compliance with CIS best practices benchmark.

Strong experience in Database Administration and experience with SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2014/2016 including installation, configuration, patching and upgrades enterprise environment.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Experience in performance tuning, query optimization, using performance monitor, SQL profiler and other related monitoring and troubleshooting tools.

Monitor for deviation in baseline system performance, and advise on and execute improvements to slow running queries

Automated scripts for data maintenance, back-ups, scheduling job and restoring onto lower database life cycle.

Strong interpersonal skills must be a team player, detail oriented and customer service driven.

Attend technical trainings to stay up to date on technical trends and new technologies.

Ability to learn and adapt to new database technologies from different vendors

Ability to be part of a 24x7 on-call rotation for after hour and weekend production support.

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator Chevy Chase, MD

Geico January 2015-Present

ACTIVITIES:

Extensive experience managing multiple MS SQL 2005/2008/2012/2014/2016 servers on enterprise-class server clusters running Windows 2003/2008/2012R2.

Installed Configured, and Managed SQL Server 2014 / 2012 and migrated databases from SQL Server 2008R2/2005.

Experienced with SQL Server 2008 R2 / SQL 2012 / SQL 2014 installation and administration

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Develop, test, document, implement, and maintain SQL infrastructure for departmental or Firm initiatives.

Ability to work under pressure to manage multiple tasks with accuracy and to meet demanding deadlines, possessing strong ethics and the ability to maintain confidentiality

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Refine and automate regular processes, track issues, and document changes

Configured and maintained transactional and peer-to-peer replication and troubleshoot replication issues.

Experience with installing and supporting a scaled-out Reporting Services environment (SSRS).

Experience with developing data flow processes and supporting using SQL Server Integration Services (SSIS).

Managed index usage and fragmentation and updated statistics in databases.

Involved in troubleshooting and fine-tuning database performance and concurrency and root cause analysis.

Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, and Activity Monitor and analyzing execution plan.

Experience in configuring transparent data encryption in production and non-production environment.

Checked Database Health by using DBCC Commands and DMVs.

Experience with table partitioning (horizontal and vertical) secondary file group, Common Table Expression (CTE).

Involved in Data Modelling, Normalization, developing Logical/Physical ER Diagram using Erwin and SQL Server Data Diagram.

Translated business requirements into technical design specifications and actively supported business users for change requests.

Work collaboratively with teams on database design and data modelling with a focus on improving SQL efficiency and for fast application performance.

Participate in the process of ensuring that identified Business Continuity measures are implemented, documented, and regularly tested, to enable continue operations of systems identified as requiring such protection in accordance with the corporate Disaster Recovery program.

Stay current with the database and related technologies.

Perform software upgrades and new software installation both pro-actively and in response to requests from users of systems, including any necessary patches to database systems and applications to ensure continuing stable and secure operation.

Manages SQL Server permission assignment and develops SQL Server database security strategy

Performs SQL Server service pack installations, version upgrades, and server migration

Promotes database objects to production environments

Provides database design consultation for agile development teams

Engages in the design of database solutions to support emerging business needs.

Experience developing and deploying SQL Server Integration Services packages

Experience with Microsoft Team Foundation Server for database source control.

Knowledge of SQL Server Cluster and Availability Group configuration for high availability and disaster recovery

Knowledge of SQL Server replication technologies.

Provided 24/7 on call support for all the Production Servers.

ENVIRONMENT

SQL Server Profiler, Database Tuning Advisor, Query Analyzer, BCP, DTS, Jira, SentryOne, PAL, SQLNexus, SQL Server 2016/2014/2012, SQL Server 2008 R2, SQL Server 2005, SQL Server 2000, SQL Optimizer, DTS, SQL Log Manager, Windows Server 2012, Windows Server 2008R2, Windows Server 2003, Java, ASP, ASP.Net, Microsoft Word, Excel, PowerPoint, Visio, SSIS, SSRS, Microsoft Sharepoint, IIS, Atlassian Tools, Jamz Enterprise Job Scheduler, Skype for Business, Lync, FogLight, Team Foundation Server, ASP.NET.

SQL Server Database Administrator Jersey City, NJ

Franklin Credit Management Corporation October 2012 – January 2015

ACTIVITIES:

Participate in regular database capacity planning related to database growth and system utilization, trend analysis and predicting future database resource requirements.

Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server2008/2008R2 which include installing of SQL Server.

Strong in developing, deploying packages using SSIS from OLTP to OLAP.

Worked on monitoring and tuning of SQL scripts.

Created upgrade scripts for production database and supported it.

Created and managed schema objects such as tables, views, indexes, procedures, triggers, and maintained Referential Integrity.

Performed Server & Application fine-tuning & troubleshooting.

Monitored MS SQL Server performance and network issues.

Helped Development Team in deploying and testing the application, which uses SQL Server as a database.

Monitoring and analyzing the performance of the various servers and troubleshooting based on the client requirements.

Backup databases and perform database restore and run consistency checks from SQL Server and application.

Monitor the status of maintenance jobs schedule to run daily and on weekends

Rebuilding the indexes at regular intervals for better performance

Monitored and modified performance using execution plans and Index tuning

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

Regular checking of the database consistency using DBCC commands to minimize complexity

Checking the OS Event Logs, SQL Server Logs, and Security Logs to identify the occurrence of any unusual events.

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

Verifying all scheduled jobs have run successfully

Monitoring the DB server disk space

Periodically monitoring the performance using both System Monitor and Profiler

Monitor and identify blocking issues using Enterprise Manager/Management Studio

Verifying the Backups and backup file size on weekly basis.

ENVIRONMENT

Microsoft SQL Server 2012 / 2008 R2 / 2008 / 2005, MySQL, SQL, T-SQL, Visual C#, C++, PowerShell, ASP.Net, XML, HTML, IIS, Java Script, SQL Profiler, DTA, PerfMon, Event Viewer, SSIS, SSRS, SSAS, CommVault, Crystal Reports, SQL Sentry Plan Explorer, Confluence, Atlassian JIRA, IDERA, Remedy, Hyper-V, Red Gate, Erwin Data Modeler, Foglight, QRM Software, VMware 5.5., Microsoft Word, Excel, PowerPoint, Visio, Windows Server 2003 / 2008 / 2008 R2 / 2012 / 2012R2 / 2016, Solaris 10/11

NOTABLE MILESTONES

Handled Administration of SQL Server 7.0, SQL 2000, SQL 2005, SQL 2008, SQL 2008R2, SQL 2012.

Part of a team that implemented and worked on MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node and AlwaysOn Availability Groups.

Created and maintained windows domain with 500 numbers of clients which spread crossed multiple locations.

Planned & executed of any upgrade such as Service Pack, Hot fixes etc.

Handled Fine Tuning Databases System in-coordination with Application owners to utilize the maximum resources for Database and Applications.

Leadership Skills/Members

Members of PASS and other SQL Server Database Administration communities.

Participates in SQLTuesday.

Member of SQLSaturday and participate in SQL Users group in Baltimore area.

EDUCATION

National University, Bangladesh

Bachelor of Accounting, 2001

Contact this candidate