Description
SUMMARY * 5+ years of extensive experience in development, analysis, design, implementation, testing, and maintenance with diverse collection of applications and Client Server environments. * Professional experience in Database Administration and Development for very large and complex databases in SQL Server 2014/2012/2008R2/2008/2005/ 2000. * Experience in installing, maintaining SQL SERVER 2014, 2012, 2008R2, 2008, 2005, 2000 updating with the hot fix and service packs on Physical/VM Ware Clustered and Standalone Environments. * Migration from SQL server 2000 to 2005, 2000/2005 to 2008, 2008/2008R2 to 2012, 2008/2012 to 2014 by using In-Place/side-by-side upgrade process, and documented the upgrade process. * Experience in implementing Disaster Recovery and High Availability concepts like Log Shipping, Mirroring, Always on Availability Groups Replication (Snap Shot, Merge and Transactional with Updatable Subscriptions), Clustering (Active/Passive, Active/Active). * Experience with administering Very large databases (VLDB), managed databases of size above 2 terabytes and Proficiency in Database Administration on Production Servers with server configuration, performance tuning, and change management processes security Management and maintenance with outstanding troubleshooting capabilities. * Good at SQL Server enhanced features like Filtered Indexes, activity monitor, Linked Server, Policy Based Management, data compression, Backup compression, resource governor, performance data collector, facets, and transparent data encryption, backup encryption. * Expertise in Database Backup and Recovery procedures by using Native SQL, Lite Speed, Foglight, Idera to/from Disk and Created effective Backup and Recovery plan by Transactional Log, Differential and Full Database Backups and utilized to recover data in point in time in case of disaster of the server. * Expertise in implementation of security models Windows Users and Groups, Logins, Roles, Trusted accounts, Database authentication modes, Users, Database Roles and Permissions. * Expertise in Performance Tuning, Client/Server Connectivity, Improving Efficiency of databases performing Database Health Check using DBCC Utilities, Rebuilding indexes, Updating Statistics, Partitioning Tables and Indexes, Scheduling Maintenance Tasks, Avoiding Locks deadlocks, Long running queries and Blocking. * Developed and Deployed SSIS packages for Import, Export and Bulk inserting data, Processing SSAS Cubes with multiple Transformations from various data sources. * Good experience in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS across various environments. Expertise in generating Ad-hoc reports, data driven subscription, drill down reports, parameterized reports, linked reports, sub reports in SSRS. Hands on experience working with analytical and diagnostics reports. * Experience in handling Partitioned cubes in SSAS both in star and snow flake schema. Experience in creating CUBES in BIDS with Fact and Dimension Tables. * Excellent team worker and ability to quickly adopt and work under minimal supervision. Good analytical, communication and interpersonal skills. 24x7 Production On-Call Support. Responsibilities: Installed Managed and Administrated SQL SERVER 2008/2008R2/2012/2014 highly transitive Production Environment and Active passive clustered on Microsoft Windows Server 2012 Enterprise * Worked on designing and implementing Always On for database environment to make sure we have 99.99% uptime and 24/7 High availability of applications as part of the DR implementation. * Migrated databases from SQL Server 2005 to SQL Server 2008R2 2008/2008R2 to 2012 and documented the process with Pre-Migration and Post-Migration steps.
Accomplishments
Highlights:
Keywords
