I am a Microsoft certified SQL Server Database Administrator with more than six years of solid experience in Database Management System. I have a very rich experience in Database Administration, managing Security and access control, Database Design and Development, Server Configuration and System Administration. I am also a Mechanical Engineering graduated of 2004. SUMMARY OF SKILLS:
6 years of professional experience in Administering MS SQL Servers 2005/2008/ 2012 & 2014 both in Production and lower environments;
Expert in Installing, Configuring, Upgrading, Maintaining and Tuning of SQL Server 2005/2008/2008R2/2012 & 2014;
Proficient in T-SQL Programming in writing and optimizing Stored Procedures, Functions and Triggers.
Worked on migration of SQL server 2005 to 2008 and 2008 to 2012 & 2014;
Expertise in managing SQL server security via Creating User Logins with appropriate roles, monitoring the user accounts, creation of Custom roles and providing minimum privileges and implementing TDE;
Experience in setting up and maintaining various Disaster Recovery and High Availability technologies such as Always on high availability groups, mirroring, failover clustering, log shipping and transactional replication;
Expert in SQL Server Performance Tuning and Query Optimization using native tools including Activity Monitor, SQL profiler, Statistics IO/Time, Execution plan and PerfMon;
Experience in identifying and troubleshooting connectivity, extended Blocking & Deadlocking issues using SQL server error and windows application logs, profiler and trace flags;
Experience working on ETL using SQL Server Integration Services (SSIS); Knowledge of Relational Databases.
Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and SSIS.
Skilled in conceptual, logical and physical design using Erwin data modeler.
Configure of SQL Server 2012 and 2014 SSRS from scratch in new VMs
Skilled in Data Modeling, Decision Making, Reporting and knowledge of Data warehousing and Specification.
Skilled with third party tools including SQL Search Red gate and SQL DM Idera and Erwin data modeler, Software installation and Auditing.
Expert in creating Packages, Jobs and Sending Alerts using SQL Mail/Database Mail.
Excellent interpersonal, analytical and quick in learning new technologies.
Expert in troubleshooting and documentation of processes, installation and disaster recovery procedures. PROFESSIONAL EXPERIENCE:
Company Name – AT&T May 2016 Present
Worked on stand-alone and cluster installation of different version of SQL servers (2014\2012\2008R2) across critical & non-critical systems;
Involved in Capacity planning and Process automation to increase quality and consistent service delivery for customer;
Worked on upgrade and migration of SQL server from 2008R2 to 2012 and from 2012 to 2014;
Monitoring hundreds of Prod and non-Prod SQL Servers with different versions (SQL Server 2014\2012\2008R2) across the company using both native and third-party tools including IDERA SQL DM & SCOM;
Expert in performance tuning and query optimization using native tools (DMVs, Trace Flags, Execution plan, Statistics IO/time, profilers & PerfMon)
& third-party tools;
Expert in managing security & access control and implementing MS best practices in ensuring security and protecting the system from an unauthorized user;
Designed and implemented database maintenance solutions across production and non-prod systems and automated alerts and notifications;
Designed and configured various High Availability and Disaster Recovery solutions (AlwaysON AG, Mirroring & log shipping) to meet the company’s RPO & RTO;
Design, develop and deployed SSIS packages in 2012 and 2008R2 SQL servers;
Researching and applying latest MSFT recommended Security patches and avoid any security breaches and vulnerabilities;
Highly engaged in process establishments, procedure preparations and documentations; 1 P a g e
Involved in Architectural discussion, Designing and Implementation of IT Systems;
Review SQL Server license and generate report for management to engage with Microsoft; and
Provide 24X7 production on call support.
Company Name – Capital one Aug 2015 May 2016
Performed stand-alone and cluster installation and configuration of SQL server 2014\2014 both in production and lower environments;
Upgraded/migrated SQL server from 2008R2 and 2012 to SQL server 2014;
Monitor SQL server 2008R2 using native tools (Activity Monitor, SQL Server Profiler, Performance dashboards, DMVs/DMFs, system stored procedures and functions)
Monitor Server resources (RAM, CPU and I/O subsystem) using Performance and Resource Monitors to identify resource bottlenecks
Designed and implemented a robust backup strategy to meet the company’s RPO;
Designed and implemented various HA\DR solutions including AlwaysON AG, Log shipping and replication;
Deploy SQL Server and application solutions/releases into Production Environment
Involved in drafting and preparation of Database Administration and Development Guide Company Name - CBE April 2012 June 2015
Worked with database engineering team on solutions / enhancements for recurring problems.
Refined and automated regular processes, track issues, and document changes.
Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Shared domain and technical expertise provided technical mentorship and cross-training to other peers and team members.
Designed and implemented mirroring and log shipping;
Supported multiple servers and multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data.
Operating Systems Windows Server 2003/2008/2008 R2/2012/ 2012 R2, Windows XP/Vista/7/8/10 Languages T-SQL, C/C++
Scripting Batch (DOS)
Software MS SQL Server 2014/2012/2008 R2/2008/2005, AutoCAD, Data Services Database Technology SSRS, SSIS, Database Engine Tuning Advisor, SQL Server Profiler, Extended Sessions, Activity Monitor, Statistics IO/Time, Execution plan and Performance Monitor, BCP and SSIS, SQL Mail/Database Mail, Functions and Triggers, Monitoring Tools System Center Suits /SCOM, SCSM, SCCM/, IDERA Diagnostic Manager, PSSDiag, SQLIO Education
BSC in Mechanical Engineering /GC 2004/
Microsoft Certified Professional (MCP)
Microsoft Certified Technology Specialist (MCTS): SQL Server 2012
Microsoft Certified Technology Specialist (MCTS): SQL Server 2014 Conference: PASS SQLSATURDAY, Washington DC – Dec 09, 2017 2 P a g e