Occupation:Database Administrator |
Location:Phoenixville, PA |
Education Level:Master |
Will Relocate:YES |
Description
SUMMARY: * Experienced in Database Administration, Design Development, and Support of MS SQL Server 2014/2012/2008R2/2005 in Production, UAT, Test, Development, and Cluster Server Environments. * Logical and physical planning of relational databases manage internal databases from planning and testing stages through implementation and support. Experienced with SQL Server Installation, Configuration, Migration, SSIS, SSRS and administration, applied periodic Service packs and hot fixes (cumulative updates) and complimentary third-party tools. * Solid experience and knowledge of SQL Server High Availability solutions - Replication, Clustering, Mirroring, and Log Shipping. * Expertise in implementation of security models Database authentication modes, creation of users, configuring permissions and assigning roles to users. * Experienced in implementing High availability solutions like Always on, Replication models (Snapshot and Transactional), Log shipping, dynamic management views, clustering, and mirroring on physical and virtual machine. * Experienced in Creating and Maintaining enterprise databases, Backup & Recovery. * Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and expert in tuning Complex Queries. * Solid experience and knowledge of SQL Server High Availability solutions - Replication, Clustering, Mirroring, and Log Shipping. Responsible for installing, configuring, managing, monitoring, and troubleshooting SQL Server 2014/2012/2008R2. * Involved in migration from MS SQL Server 2005 to MS SQL Server 2008R2 and MS SQL Server 2012,2014. * Implemented the new features of MS SQL Server 2008R2/2008 such as Policy Based Management, Backup Compression, and Transparent Data Encryption (TDE). * Worked on Change Requests (CRs), Work orders (WOs), Incident (INs) and Services Requests (SRs) by using IBM Maximo Ticketing Tool. * Experienced in improving SQL Server Performance using windows performance monitor. * Created backup schedule for production, test, and development servers. Worked with developers to do the database schema changes and database restore requests. * Involved in restore operations to refresh the data from production to test servers. Implemented MS SQL Server security policies and granted object level permissions. * Expertise in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard. * Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation. * Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement. * Experienced in Batch processes, SSIS, DTS, BCP (bulk copy), Bulk Insert, Import, Export, Database Monitoring tools and Application support. * Experienced in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. * Strong technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and ability to work on multiple technologies. * Expert in designing database and Storage Capacity Planning. Professional Summary: Client: Department of Labor and Industry, PA July 2016 - Till Now Role: Database Engineer * Involved in migration from MS SQL Server 2005 to MS SQL Server 2008R2 and MS SQL Server 2012, 2014 and 2016. * DBA for SQL Server Environment with over 50 Production Servers and 100 Development/ Test Servers and more than 1000 Databases. * Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications. * Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/troubleshooting. * Automated maintenance plan jobs in SQL Server agent and task scheduler: such as shrinking database, backup database, index rebuilding, creating filtered indexes, index reorganizing (Fragmentation), cleaning up, and updating statistics. * Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs. * Installed and configured latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers. * Create documentation for steps that need to be taken while upgrading the SQL server 2008/2012 to SQL server 2014. * Data backup/ recovery rollback planning and implementation and using Quest Litespeed for automated backups and restores * Worked on Change Requests (CRs), Work orders (WOs), Incident (PRB) and Work Requests (WRs) by using PAC2000 Remedy Ticketing Tool. * Worked with AnthilPro 5.0 tool through the process for building a project, setting up a continuous Integration Build and Deploying Artifacts. * Experience with improving SQL Server Performance using windows performance monitor. * Created backup schedule for production, test and development servers. * Worked with developers to do the database schema changes and database restore requests. * Involved in restore operations to refresh the data from production to test servers. * Implemented MS SQL Server security policies and granted object level permissions. * Database High Availability: Installed, Configured and Managed Database Mirroring, Replication, Always-On and Fail-Over Cluster Servers in SQL Server 2014 * Experience in upgrading SQL server and applying service packs and hot fixes. * Troubleshoot database performance issues using various tools including Spotlight, Foglight and SQL DMVs. * Worked with third party backup tools like SQL Lite speed to improve performance of backup and recovery. * Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. * Expertise in identifying, troubleshooting issues and documenting root cause analysis. * Configured Always-On with synchronous and asynchronous secondary replicas. Environment: SQL Server 2012/2008R2/2008/05, Windows 2003, 2008&2012Server, Spotlight, Active Directory, Lite Speed, IIS (Internet Information Services), Power shell, Unix, Microsoft SQL server Visual Studio 2005/2008, Quest, Idera, Dell