Description
Summary of Experience: * I have Seven years of IT experience including 'SQL Server Database Administration' databases using SQL Server 2014, 2012, 2008R2 & 2008. * Excellent skills in Installation, Configuration & Maintenance of SQL Server, Server Planning & Design, Exposure to Active Directory, Creating & Manipulation of data, tables, views, indexes, using SSMS & T-SQL Scripts following RDBMS strategy, Following ER Diagram as Data Modeling. * Strong technical background includes performing tuning & optimization (PTO), Process Documentation, Using of T-SQL, DMVs, DBCCs, Stored Procedures, & Triggers etc. * Hands on working experience in Database Backups, Restore strategy, Determining Disaster Recovery model & setting Backup Retention for production & development environment. * Experienced in Configuring & Maintaining Database High-Availability/Recovery (DR) Solution of Mirroring, Log Shipping, Replication, SQL Clusters & have concepts on always-on etc. * Experience in Database Update, applying Service Packs & Hot Fixes, Upgrade and Migration within RDBMS as Oracle, DB2 or Flat Files through RDC/ODBC/OLEDB & Application Support. * Experiences working on BI Suites as MS SQL Integration Services (SSIS) & Reporting Services (SSRS). * Experience as User interface on MS SharePoint 2010 & 2013 * Worked on 3rd party software and Ticketing tools Jira/Solarwinds Web LLC Help Desk system * Experience in managing large database in 24/7 Environment & Available for On-Call Rotation * Flexible, Motivated, proactive, Team player, manage projects efficiently for on-time delivery. * Excellent verbal, written & presentation skills & Independent problem solving * Proven ability to manage multiple tasks working directly with different vendors. * Excellent coordination, organizational, interpersonal skills & collaboration. Experienced with Point-in-Time Recovery using transactional log backups, Restored Database from backups, backups verification etc. Database Monitoring/Performance Tuning: * Experienced on Database Monitoring, Performance Tuning and Optimization (PTO) & Troubleshooting Queries and Optimization, Transaction Error Logs & Disk Space Solutions * database Monitoring and Performance tuning, Monitor SQL Server Error Log, System engineering space usage, Server Activity, Maintenance Plans for monitoring. * Scheduled jobs to automate different database related activities, monitoring database health, disk spaces & utilization etc. * Used DBCCs to check database conditions, Rebuilding indexes and database Maintenance * Working with tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views * Installed SQL Server 2008R2 and SQL Server 2012 for testing different features and stability * Monitoring database health, disk space, Systems engineering in regards of I/O, Memory, HDDs, backup verification, database statistics, rebuild or reorganize indexes, Created notification/alerts in any failure, error, warning or disk issue to Services Account. * User interface on Microsoft SharePoint 2010 for documents sharing purposes Patch Management: * Managed security by creating Groups, Logins & users with proper authentication & grant appropriate permission on Server - Database - Object level. * Applied SP (Service Packs) & Hot Fixes on SQL Server 2008 and 2008R2. Database High Availability: * Configured & Maintained business continuity applying Database High-Availability/Recovery Solution of Mirroring, Log Shipping, Replication & Clustering & Concepts on Always On BI Suites Development: * Installed & Administered Business Intelligence (BI) suites using ETL tool for data movement within SQL Server Integration Services (SSIS) in regards of data integration, transformation, and loading. * Installed, Configured, and administered SQL Server Reporting Services (SSRS), Developed Reports using SSRS, Deployed Reports to Report Server or share within Shared Drives etc. Database Upgraded: * Hands on experience in upgrading SQL Server 2008 to 2012, SQL Server 2008R2 to SQL Server 2014
Accomplishments
Highlights:
Keywords
