Sql Server Windows

Mohiseen

Email Id: ********.******@*****.***

Phone: 248-***-****

PROFESSIONAL SUMMARY

Around 7+ years of IT experience as SQL Server DBA and Developer in Design, Development, Implementation and Administration of Client-Server Application and Database systems using MSSQL 2005/2008/2012/2014/2016 for both OLTP & Data warehousing applications in all SDLC environments.

Experience in installation and configuration of MS SQL Server 2005/2008/2012/2014/2016 on Windows 2003/2008/R2/2012R2 Servers, applying Patches, Service Packs and Hot Fixes.

Experience in Database Up gradation and Migration of SQL 2008 to SQL 2012 (in place/side-by-side) and SQL 2005 to SQL 2008 by running the Upgrade Advisor.

Experience in working with Windows 2000/2003/2008/R2/2012R2 & NT Servers-Administration &Installation.

Expertise in Database Design, Performance Analysis & Production Support for Large (VLDB) and Complex Databases.

Expertise in Database Creation, Managing Files (striping the files across multiple disks), Extents, Rollback, Redo Logs and stripping the temp db.

Sound Knowledge of Capacity planning and disaster recovery planning.

Well versed in Data Modeling using Erwin design tool.

Experience in Database Programming in writing T-SQL, Stored procedure, Triggers, Views and Indexes using various DDL and DML commands.

Experience in Clustered SQL servers in Active / Passive Environment on Windows 2003/2008/2008R2 enterprise servers.

Extensive experience in Database Backup, Restore, Moving of Databases and Disaster Recovery Management (including DR/Standby servers).

Extensive experience in Monitoring Daily Jobs, Scheduling Jobs, DB Maintenance Plans, Run DBCC jobs for Re indexing, check DB and Fragmentation etc.

Expertise in Database Maintenance by Managing Index Fragmentation, Managing Statistics, Shrinking Files and Using DBCC Commands.

Expert in Security Administration creating Users, Roles, Granting Privileges, Managing Schemas, handling Database Security for windows/ web applications.

Experience in creating Jobs, Sending Alerts using Database Mail.

Experienced in performing root cause analysis (RCA) and running SQL profiler for slow running store procedures and looking into the execution plans for performance.

Experience in Troubleshooting, Monitoring and Tuning SQL Server performance using SQL Profiler, System Monitor, Database Engine Tuning Advisor, Optimizing queries, tuning indexes and DBCC Checks using DBCC Utilities.

Experience in configuring, administering and maintaining Replication (Transactional, Snapshot, merge) log shipping for high availability fall back solutions.

Experience in configuring Linked Servers & handling distributed queries across multiple data sources.

Highly experienced in Implementing and Managing Database Mirroring in SQL Server 2008.

Experience in SQL Reporting services (2000/2005/2008) (SSRS), SQL Analysis services (SSAS), OLAP Cubes & Integration Services (SSIS).

Provided after hours 24/7 database maintenance and production support & on call Rotation.

CERTIFICATION

MCSA: SQL 2012 Administration

TECHNICAL SKILLS

Operating Systems

Windows Server 2003/2008R2/2012R2, Windows 2000 Advanced & Professional Servers, Windows NT 4.0, Windows XP/2000/98/95.

RDBMS

SQL Server 2000/2005/2008/2012/2014/2016, MS Access.

SQL Server Tools

SQL Server Management Studio, Query Analyzer, Enterprise manager, System Monitor /Performance Monitor, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Database Maintenance Plan, BIDS (SSRS, SSIS), Netezza.

Programming Languages

C, C++, C#, ASP.NET, ADO.Net, T-SQL.CSS, HTML, XML.

Web Technologies

HTML, CSS, Shell Scripting, Power Shell.

Microsoft Office Tools

Microsoft Word, Excel, Access and Visio, Visual Source Safe

Third Party Tools

Erwin, MS Visio 2003/2007, Rational Rose, Visual Source Safe, Team Foundation Server, Informatica 9.1.0, Lite Speed 6.0, Confio Ignite.

Reporting Tools

SSRS, Crystal Reports, MS Access,SSAS

PROFESSIONAL EXPERIENCE

Salesforce.com - Bellevue, WA - SQL Server DBA March 2014– Present

Salesforce Marketing Cloud Project – Marketing cloud manages data-driven email marketing campaigns on a secure and trusted platform from basic promotional emails to sophisticated cross-channel strategies. It aligns social and email marketing strategies to reach on-the-go customers providing users real time with SMS/MMS, OTT, push notifications, and Publishes to all social media accounts, and analyze the results in one easy-to-use interface. Marketing Cloud Integrate marketing with sales and service to create 1-to-1 relationships across the entire customer lifecycle and provides solution for collecting real-time Web behavior and responding with personalized recommendations for each customer automatically.

Responsibilities:

Worked on Installation and configuration of SQL Server 2008R2/2012/2014/2016 in production Environment.

Experience in applying Service packs, feature packs and hot fixes in Multi node Clustered environments.

Designed and implemented a SQL Server 2008 clustered solution comprising 10 nodes, 8 instances and 4 clusters based on HP Blade servers and NetApp Filers to consolidate the SQL Server environment.

Supported 1400 back-end databases across over 155 Production SQL Server instances covering SQL Server 2008R2 through SQL Server 2012.

Expertise in supporting high-concurrency transactional databases size varying up to 60 TB and troubleshooting SQL Server Failover Clustering.

Worked on an internal ticketing system which has over 20,000 users.

Experience in troubleshooting all kinds of general issues from SQL Server 2008 to 2012 and including backup and data recovery, installation/patch, connectivity and performance tuning.

Worked on security groups and provided administration and support on Microsoft Windows Server 2003 Active Directory Infrastructure.

Worked on performing SOX Audits.

Performed Service Account Password changes and Patching to maintain security compliance.

Worked on performance analysis and monitoring solution using Solar Winds Database Performance Analyzer (Confio Ignite) and custom scripts.

Worked on configuration of Transparent Data Encryption (TDE) using Advanced Encryption Standard (AES) 256 to secure databases and backup files.

Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans.

Partnered with development teams to provide support, troubleshooting and performance tuning advice to the development teams. This included analyzing deadlock, SQL wait times, indexes and slow performing queries and test teams to implement change requests.

Managed and provided support for the various SSIS, SSRS and SSAS solutions including deploying a front end SQL 2012 cluster with Analysis and Reporting Services.

Worked on database moves, disaster recovery, alerting, and data warehouse data collection and analysis.

Worked closely with team geographically to meet the deadline and resolving issues.

Worked closely with Network Engineers, System Administrators, Architects and Project Managers to plan and implement complex, technical solutions and architecture.

Participate in 24/7 DBA on-call rotation.

Environment: MS SQL Server 2008/2012/2014 Enterprise Edition, SQL Server Management Studio, SQL Profiler,SSIS, SSAS, T-SQL, MS Office 2003, SSRS, Windows Server 2003/2008/R2, Windows Active Directory, Confio Ignite, PowerShell Scripting.

ITT Technical Institute, IN - SQL Server DBA August 2012– March 2014

Responsibilities:

Experience in installation, configuration, and up gradation of MS SQL Server 2008 to 2012 servers.

Experience in applying Service packs, feature packs and hot fixes in Multi node Clustered environments.

Maintain Security compliance by regular Service Account Password changes and applying security patches.

Handling any user or business escalations directly and work with Engineering and Business teams to provide high – technical support for the resolution of escalations.

Provide analysis and troubleshooting for complex SQL Server and Analysis service applications.

Provide Problem Management, Release and change support for Microsoft’s internal business applications.

Involved in project team activities prior to and through release by analyzing testing, and Approval of the deployment to help define and drive operational best practices.

Validate system health and security check with monthly audits.

Experience with working on VLDB’s cube processing and cube publish for the business users to pull business reports in specified SLA’s.

Responsible in driving the implements of recovery exercises accordingly (Planned and Unplanned) in a year.

Working Closely with engineering and test teams to implement change requests, which should go live to production though DEV, SIT &UAT phases for the smooth releases.

Design automation techniques and monitoring methods to reduce manual efforts by identifying the scope of need.

Ensuring disaster recovery mechanisms are in place across all the systems (DEV, SIT, and UAT & PRODUCTION) and also being an expert in database and system support, involved in most of the meetings representing the team to understand the things technically and functionally.

Conduct global meetings online and offshore for the team sync up on change requests, new application designing and implementations and global trainings.

Monthly server auditing and regular server upgrade & patching activities.

Operations/Systems support.

Automation, Process improvement and documentation.

Work on High visibility monitoring systems that are in place to act upon any issues according to the set priorities. At any point of time, was available on-call depending on the criticality of the issues.

Coordinating with multiple teams like SAP, Non-SAP, Data protection management and Server support teams to get rid of any processing or infrastructure challenges during financial year end period.

Environment: MS SQL Server 2008/2012 Enterprise Edition, SQL Server Management Studio, SQL Profiler, Informatica 9.1.0, SSIS, SSAS, T-SQL, MS Office 2003, SSRS, Windows Server 2003/2008/R2.

Charles Schwab - Englewood, CO - SQL Server DBA

March 2010 – August 2012

Responsibilities:

Responsible for the Installation, configuration and up gradation from SQL Server 2005 to SQL Server 2008 and 2008 to 2012.

Involved in daily monitoring, maintenance of SQL Server 2008 A/A, A/P, A/A/P cluster installations in both the Production and Development using Microsoft SQL Server 2008 Failover Cluster in various datacenters for MSFT- Y! Needs.

Experience in handling over 150+ Production servers in production Environment.

Involved in applying service packs and hot fixes for SQL Servers in clustered environment.

Involved in Maintaining and administrating core databases and applications systems.

Experience in maintaining Ad center KPI Cubes 24/7 in terms of support and availability.

Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices according to the backup strategies and Recovery models to ensure data integrity.

Involved in setup of Database Mail for alerting purposes.

Performing Re indexing and Index defrag operations for large online tables.

Maintaining the Database Health by Doing DBCC CHECK DB.

Maintaining Security compliance by regular Password changes and Applying security patches.

Assist developers in the code Modifications and Deployments on production databases and KPICubes.

Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.

Managed the production and development databases for performance tuning, capacity planning and database security configuration.

Performed root cause analysis to track down problems & used SQL Profiler for troubleshooting.

Configured log shipping and support Log ship failures across servers in different Datacenters.

Setup data transformations and system high availability with Microsoft SQL Server Mirroring.

Configured and maintained transactional, snapshot replications.

Created a cloned environment of the production databases for Business end users reporting purpose.

Generated various database file growth / SAN usage reports using SQL Server Reporting Services (SSRS).

Providing 24X7 on-call system support.

Environment: MS SQL Server 2008/2012 Enterprise Edition, SQL Server Management Studio, SQL Profiler, SSIS, SSAS, T-SQL, MS Office 2003, SSRS, Windows Server 2003/2008/R2.

Deloitte - Santana, CA - SQL Server DBA

December 2008 - January 2010

Responsibilities:

Installed and configured SQL Server 2000 and 2005 on Windows server 2003

Involved in Database up gradation and Migration of SQL2000 to SQL2005 and co-ordinate all Upgrade activities.

Documentation of daily tasks and scripting them. Created documentation to install SQL Server, apply service pack, hot fix.

Migrated huge databases from SQL Server 2000 to SQL Server 2005 using attach/detach and copy database wizard.

Involved in Performance monitoring and performance tuning by Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.

Involved in troubleshooting dead lock issues and performance issues for optimal performance. Used the Index tuning wizard and rebuilt indexes for faster query response.

Worked on DTS/SSIS packages for transferring data from various data sources like Oracle, MS Access and Excel.

Configured the Log shipping and scheduled jobs to setup log shipping between production servers.

Suggested Backup Strategies and scheduled the Backups & Restoration for Databases and Transaction log.

Involved in Setup of maintenance jobs in all Servers schedule to run at various times.

Monitoring backup jobs daily and run the jobs manually in case of failure depending upon the necessity and prepared daily report on the job failures, backup failures and disk space.

Creating and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.

Implemented Database Mirroring for high availability of the databases in SQL Server 2005

Granted permission to user(s), role(s), and object(s). Support column level permissions. Administrate security for server’s logins (Windows and SQL Accounts).

Made Estimates for Database, table size growth and prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL Server 2000/2005, Windows 2000/2003 servers, MS Access, DTS, SSIS, Visio, Performance monitor, Query Analyzer and Enterprise Manager.

Contact this candidate