Description
SUMMARY: MS SQL Server Administrator with around 9+ years of experience in the IT industry experience, challenging position in Server administration and technical maintenance with the state of the art technology where my managerial, analytical, problem solving skills and application knowledge can be put in for successful execution of projects. * Over 9 years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2016, 2014, 2012, 2008 R2, 2005 and 2000in Production, Development, UAT and SIT Environments. * IT Professional with 9 years of Administration and Development experience on MS SQL Server 2014/2012 / 2008R2 / 2008 / 2005 / 2000 systems in OLTP and OLAP environments * Extensive experience in installation, configuration, and maintenance of MS SQL Server 2014, 2012, 2008 R2/2005/2000. * Proficient experience in Upgrading and migrating from SQL server 2005/2008/200R2 to SQL server 2008R2 and SQL server 2012/2014. * Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing. * Worked with Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV's and DMF's for monitoring and SQL server native tool PerfMon. Counters and performance tuning. * Expert working in Virtual Environment using VMWARE for SQL Server. * Experienced in Database Backup, Recovery and Disaster Recovery procedures. * Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification. * Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2005/2008/2008R2 to provide robust database solutions. Including SQL Server 2012 Always On High Availability. * Expert in Active/Passive and Active/Active Clustering and also implemented ALWAYS ON in SQL 2014 environment. * Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary. * Expert in implementing log shipping and Expert in implementing database mirroring. * Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities * Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity. * Experience in Managing Security of SQL Server 2000/2005/2008/2008R2/2012 by creating DatabaseUsers, Roles and assigning proper permissions according to business requirements * Acquaintance in supporting Very Large databases (VLDB) and troubleshooting the problems in OLTP Environment. * Migration of Databases from MYSQL/ORACLE/SYBASE to SQL Server 2012 using SQL Server Migration Assistance (SSMA) tool. * Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP) * Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions. * Created maintenance plans to perform index defragmentation, re-indexing and update Statistics. * Proficient in troubleshooting database issues. * Expert in IDERA and SCOM Monitoring and writing T/SQL scripts. * Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks. * Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications * Team player with Good communication, interpersonal and business analysis skills. * Provided 24 x 7 Production support for the database and application issues. Professional Summary: GoDaddy, Tempe, AZ Feb 2016 - Till now Senior MS SQL SERVER DBA GoDaddy is a publicly traded Internet domain registrar and web hosting company. As of January 2016, GoDaddy was said to have had more than 61 million domain names under management, making it the world's largest ICANN-accredited registrar. As of December 2014, GoDaddy served approximately 13 million customers and had 4,908 employees worldwide. The company is known for its celebrity spokespeople, Super Bowl ads and as being an online provider for small businesses. Responsibilities: * Installed, Configured, and Managed SQL Server 2014, 2012, 2008, and 2005 in development, test, and production environment, on standalone and clustered servers. * Experience in Database Design activities including Data Files and File group organization, Capacity Planning and Data Normalization. * Migrated databases and database objects between multiple servers across production, QA and development platforms to SQL 2014/2016. * Applied SP (Service Pack) and HOT Fixes on SQL Server 2000, 2005, 2008 R2 2012 and 2014 and Windows Server 2003 R2, 2008 R2 and 2012 Enterprise Edition. * Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well. * Involved in Setting up Transactional Replication, Log shipping and Database mirroring. * Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS (SQL Server Integration Services) BCP (Bulk Copy Program) * Designed ALWAYS ON architecture and Setup ALWAYS ON for two different Clustered environments and also Standalone servers. * Involved in Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail. * Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery. * Involved in Monitoring Performance of different production servers. * Worked extensively on ACTIVE/ACTIVE and ACTIVE/PASSIVE 2 node clusters * Maintaining databases and schemas, adding users, roles and groups and implementing database security according to project requirements. * Created databases on SQL Azure. * Involved in the migration of databases from SQL server 2012 to AZURE environment. * Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS * Involved in Mapping data for safe and secure Data Transfer * Developed SSIS packages to load data from different source systems in to the data ware house with support from development team. Environment: MS SQL Server 2014, SSIS, SSMS, SSMA tool, BCP command, RED GATE Baker Hughes, Houston, TX May 2015 - Jan 2016 Senior MS SQL SERVER DBA Baker Hughes delivers solutions that help oil and gas operators make the most of their reservoirs. Collaboration is the foundation on which we build our business. We listen to our clients to understand their unique challenges and then develop solutions designed to help manage operating expenses, maximize reserve recovery, and boost overall return on investment throughout the life of an oil or gas asset. Responsibilities: * Managed PRODUCTION, DEVELOPMENT, QA and UAT environments * Worked extensively on Virtual and VMware Environments. * Involved in Planning for Upgrades and Migration of major systems from SQL Server 2000 to SQL Server 2008 R2 and from SQL Server 2008 R2 to SQL 2012/2014. * Involved in Mapping data for safe and secure Data Transfer * Involved in Quality Test (QA) of Data for successful Migration * Created SSIS packages for various Data Source and Data Destination Mappings for transfer. * Industry working experience in SQL Server and DB2 database management, maintenance, and troubleshooting. * Performed Administrative tasks in SQL Server using PowerShell. * Involved in Performance Tuning on Production, QA and Staging servers of the current project. * Worked on setting up and managing Snapshot, Merge and Transactional Replication * Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments. * Maintained various databases for Production and Testing using SQL Server 2012/2008 R2. * Planning the location of data, index and Transaction log files on the disk. * Performance tuning and optimization of procedures and queries. * Migration of Databases from MYSQL to SQL Server 2012. * extensive use of SQL Server DMV's for Performance Tuning * Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks. Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning. * Provided scripting services and production support services in UNIX environment. * Created the backup and restore strategy for production and development environment. * Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application. * Created extensive SQL Server Integration Services (SSIS) packages for ETL. * Extensive Data Mapping and Migration of Data for Production Environments * Created database logical/physical modeling with ERWIN * Managing schema objects such as tables, views, clusters, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications. Environment: SQL Server 2014/2012/2008 R2/2005/2000, VMware, Virtualization, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager Experienced with database sizing and capacity planning for production servers. * Worked on project-based directives for client CRM environments. * Conducted production environment developments, custom developments and reporting projects. * Performed troubleshooting of client CRM issues and maintained documentation of all reported issues. * Did technical research as needed for all reported issues and drafted reports. * SCRIBE for understanding the well challenges for the CRM integration. * Scribe Insight, a premise-based solution, and Scribe Online, a cloud-based solution, offer a range of pre-built connections and maps to jumpstart integration of your CRM system to a wide range of application Experienced with creating logical and physical database design for development projects. Experienced with improving SQL Server using windows performance monitor to improve the server performance. * Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers. * Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) * Expert in IDERA and SCOM Monitoring and writing T/SQL scripts. * Created the backup schedule for production, test and development servers. * Involved in database refresh from production to SIT/Dev and QA servers. * Experienced in troubleshooting production servers and fixed the user and application issues. Environment: MS SQL Server 2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, CRM software developer, SCRIBE.
Accomplishments
Highlights:
Keywords
