D A Email & Phone Number

Fort Worth, Tx, Us

Redmond, Washington, Us

• As a Microsoft SQL Server Engineer, I worked on technically challenging areas of Performance Tuning, Setup, High Availability, Replication and Log shipping to resolve customer problems on a timely manner.• Responsible for providing technical support to customer , on-premises and Azure. • Troubleshoot and solve customer technical issues, using troubleshooting and diagnostic processes• Escalate issues requiring higher-level support• Track and document all requests and work-notes• Support initiatives to optimize and identify opportunities for automation and customer self-service• Maintain service-levels• Innovative and collaborative with an entrepreneurial spirit.• Ability to work effectively and collaboratively in an evolving, dynamic environment• Provide SQL Server database support to Microsoft premier and professional customers on a wide range of issues across the product.

Philadelphia, Pennsylvania, Us

• Configured HA/DR strategies (AlwaysOn failover clustering, mirroring, log shipping, replication). Documented processes for installations, clustering, availability group setup, and patching. Configured and supported replication and log shipping in SQL. Used Quest Spotlight and Confio Ignite• Support with developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases• Responsible for SQL Server troubleshooting of all incoming incidents and performs requests for service, execution plan, index, long/slow query, locking, blocking, fragmentation and reorganize or rebuilding index• Design, install, configure, and support SQL Database instances• Work with a team of 6 in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in increase in efficiency and return on investments for clients• Assist application developers with query tuning and schema refinement• Provided mentor-ship and training for team members to fill skill gaps and ensure knowledge update• Contributed to technical research on new technologies and procedures• Worked with team members to ensure technology is effectively supporting the enterprise• Experienced in setting up encryption (TDE) using Advanced Encryption Standard (AES) 256 to secure databases and backup files• Provided 24x7 supports for critical production systems

Fribourg, Fribourg, Ch

Maintained client documentation including database topology, connection procedures, and special instructions. Performed all database managementresponsibilities in Microsoft Azure for production and non-production workloads. Installed, configured and maintained MS SQL Server Replicationfor production servers to provide high availability. Installed and configured a SQL 2008 clustered test environment. Experienced in RDBMS databasedesign, performance tuning, optimization, backup and recovery in SQL Server.• Experienced in T-SQL Scripts - Stored Procedures, Functions, Triggers and Automation of Jobs• Experienced in design, migrate and upgrade of different version of SQL server• Assisted with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist inthe design and implementation of development, testing, QA, and production environments• Installed and configured a SQL 2012 clustered environment with availability groups• Configured and supported replication and log shipping in both SQL 2008 and 2012• Installed, upgraded, configured and patched/Hotfix of SQL Server• Experienced working in Production 24/7 on call and also in Development Environment• Assisted in creating and maintaining enterprise databases, Backup & Recovery, Security• Experienced in configuration of TDE using AES 256 to secure databases and backup files• Worked in developing Standard Operating Procedures (SOPs), job aids, and hands-on training materials

Utilized a ticketing BOSS ticketing system to record and track user incidences while relaying information to Tier II staff and Network Administrators.Assisted with risk with risk mitigation. Supported Wi-Fi and LAN configurations. Provided excellent customer service in a fast and friendly matter toaggressive or upset users. Provided excellent written updates and notes within a ticketing system. Resolved service requests, such as account creationsand updates• Updated assigned tickets and continuously coordinated necessary work• Monitored the status and progress towards resolutions of site reports• Maintained accurate hardware and software inventory and configuration information• Assisted with troubleshooting and recording of possible issues• Worked knowledge of MS operating systems and operations• Administered installation of Personal Computers; software and peripherals• Assisted users with account access issues using Active Directory• Monitored and analyze servers and resolve any problems, maintain systems reporting, tuning• Created user and group accounts, network configuration, managed password and permissions and administered quotas• Performed daily system monitoring, verifying the integrity and availability of all hardware• Managed and maintained the file servers Operating the firewall for the organization• Monitored the internet connection for security risks• Employed the latest security protocols• Monitored the local area network (LAN) for threats or errors• Identified any problems in the system, anticipate potential issues and repair systems and software when necessary