Occupation:Database Administrator |
Location:The Colony, TX |
Education Level:Bachelor |
Will Relocate:YES |
Description
Summary * 8 years of DBA experience in SQL Server 2014/2012/2008/2005/2000. * Experienced in database administration activities like installation, configuration, backup & recovery, database Security and data transformation services. * Expert in installation, upgrade and configuration of MS SQL Server 2014, 2012, 2008, 2005 & 2000. * Experienced in Always On SQL Server 2012/2014. * Tested and implemented Log Shipping with SQL Server 2005/2008. * Successfully implemented Database Mirroring in SQL Server 2005, 2008 for high availability and disaster recovery. * Experienced in implementing Snapshot, Transactional Replication models. * Experienced in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster. * Experienced in creating maintenance plans, Jobs and sending alerts using database mail. * Experienced in installing Service Packs and Cumulative Updates for SQL Server. * Good Knowledge in preparing and updating cost cutting and disaster recovery documentation. * Developed backup and recovery strategies for production environment. * Experienced working with 24x7 Production support for 2014, 2012, 2008, 2005 and 2000 SQL Server. * Good knowledge of Relational Database Management Systems (RDBMS). * Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation Experience in working with high transaction OLTP systems in SQL Server 2000/2005/2008/2012. * T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures etc. * Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities. * Involved in Performance tuning of Stored Procedure. * Worked on partition table in SQL 2008/2012. * Worked on DMVs, System tables and Stored Procedures for performance tuning. * Extensively worked on Performance tuning of stored procedure. * Experienced in creating SSIS packages, Jobs, Sending Alerts using Database Mail. * Monitoring Event viewer, SQL Error logs for software and hardware related errors. * Experienced in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance. * Creation and maintenance of Databases, creating Roles and managing user permissions. * Experienced in implementing Various RAID technologies. * Experienced in SQL Server Integration Services (SSIS). * Experienced in Extracting, Transforming and Loading of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS). * Migrated DTS Packages to SSIS Packages. * Deployed SSIS Packages to MSDB and file system from development to Production environment. * Worked with Popular Third Party monitoring solutions like Red Gate and Ignite. * Management of users including creation/alteration, grant of system/db roles and permissions on various database objects. * Worked on backup tools like Red Gate. * Excellent communication skills. * Good team player with strong analytical skills. * Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs. Hardware/Software Skills
Accomplishments
Highlights:
Keywords
