Occupation:Database Administrator |
Location:Orlando, FL |
Education Level:Bachelor |
Will Relocate:YES |
Description
SUMMARY: * 6+years of total IT experience mainly as SQL Server Database Administrator in Finance Industry, Telecommunication industries. * Proficient in managing OLTP and DSS environments and giving 24/7 production support * Expertise in SQL Server 2014, 2012, 2008 R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server Surface Area Configuration, Database Engine Tuning Advisor, BCP and Bulk Load. * Expertise in Database Administration (DBA) tasks like Backups and Recovery, Log shipping, Mirroring, Always On, space utilization, load balance, process scheduling, security, replication, etc. * Expertise in managing 100+ Server including SQL Server and application server. * Expertise in SQL Installation and Patching 2012 / 2008 R2/2008/2005 on all windows servers. * Knowledge with OLEDB (Object Linking and Embedding, Database) with SQL Server 2012 * Improving Database accessibility and modifying Dynamic Management Views and Functions in SQL Server 2012. * Knowledge with Always on feature which includes Failover Clustering and Database Mirroring in SQL Server 2012. * Proficient in Microsoft Standard Configuration. * Implemented CLUSTERING, Mirroring, Log Shipping and Replication for DR * Understanding of ETL Process using Partitioned Tables, SSIS and Deploying SSIS Packages using Package Configuration along with Deployment utility. * Using DMV's for performance analysis and Implementing Index Rebuild process for performance improvements based on Built - in SSMS reports. * Expertise in system trouble shooting in production environment and development environments. * Experience with VMware products. * Expertise in work with End users and solving the issues. * Expertise in work with Business Analyst and Developers to resolve the issues. * Expertise in work on 24/7 environment with all day-to-day activities. * Good knowledge of data ware housing project with knowledge of OLAP and OLTP. * Good Knowledge of SAN, LAN (local area network), WAN. * Experience in Sharepoint including Administration, Development & Configuration. * Expertise in developing stored procedure, Jobs and trigger in SQL Server 2008 R2 and 2005. * Upgrade/Migration from earlier / legacy version to SQL Server 2008 R2/2005 using suitable methods. * Expertise in supporting team of application developers for .Net web and OLTP database application. * Experience in the designing, developing, Implementation and testing on production server. * Involved in building data warehouse using ETL Tools for creating analytical reports. * Ability to perform all common Database Administration (DBA) tasks like performing database backups and disaster recovery, space utilization, load balance, process scheduling, security, clustering, etc. * Experience in Performance Tuning, Indexing and Query Optimization. Understanding of Query Execution Plans. * Used third party tools like IDERA, RED GATE, SQL Litespeed for Backup and Monitoring
Accomplishments
Highlights:
Keywords
