Occupation:Database Administrator |
Location:Norcross, GA |
Education Level:Master |
Will Relocate:YES |
Description
PROFESSIONAL SUMMARY Almost Nine year of experience performing various jobs as a SQL Server database administrator. Have an extensive and exhaustive experience in providing day-to-day support which included issue resolution, backup and restoration, high availability techniques, user management, monitoring, performance tuning and documentation. * Extensive experience in working on both OLTP and OLAP environments. * Worked on multiple editions of Microsoft SQL Server including 2005, 2008, 2008 R2,2012, 2014 and 2016. * Hands-on experience in planning, installation and configuring of the above-mentioned editions with service packs and security patches. * Installation included planning and engendering collation, editions, licensing and service accounts. * Extensive experience on Always-On High Availability groups on SQL Server 2012 and 2014. * Experience in installing and managing virtual environments on VMWare running on ESX servers and interfaced using PowerCLI. * Also, performed migrations (both In-Place and Side-by-Side) from MS SQL Server 2005 to 2008, 2008 R2 to 2012, 2008 to 2012 and 2012 to 2014 respectively. * Also, performed installation of third party application from vendors like Red Gate, SQL Sentry, Idera, SQL Lite and several Microsoft native applications such as Log Parser, (Replay Markup Language) RML Utilities and Performance Dashboard Reports. * Also, designed database schemas, databases, normalized, established data types in an assistive capacity. * Used T-SQL extensively in my day-to-day operations to create views, stored procedures, functions, rules, constraints, tables, indexes, and to write simple and complex queries. * Experienced in managing 125 (VLDB) Very Large Databases with multiple instances spread across multiple locations. A few of these databases exceeded 1 terabyte of data. * Hands-on experience in creating backup and recovery plans, implementing them and periodically testing them. * Vast experience in taking backups on a regular basis Adept in all three types of backups, restorations and database transfer processes as per the maintenance plans. * Experience in installing and managing many High-Availability options such as Log Shipping, Database Mirroring, Replication, Clustering and Always-On. * Performed database Log-Shipping, Database Mirroring, Clustering and Always-On installation, maintenance and monitoring on various instances and databases on several machines. * Have extensive experience in authenticating, authorizing and auditing security tasks as per the security model of the organization. Authenticating involved setting user accounts, user group and roles. Authorization involved delegating ownership with roles and permissions to various securable objects. And Auditing involved ensuring compliance to laws and regulations. Security also involved data encryption at various levels and row-level security. * Proficient in many tools, including Management Studio, Enterprise Manager, Query Analyzer, SQL Server Agent, SQL Server Profiler, SSRS and SSIS. * Have vast experience is query and issue resolution and troubleshooting on a daily basis using both ticketing tool like Peregrine, mail and via issue escalation. * Have been actively doing performance monitoring and tuning using both native applications and third party applications. Adept at optimizing instance and database and tracking Memory pressure, Disk space and CPU usage. Monitoring windows events and transaction logs. Manage and maintain indexes, Databases I/O information. Monitoring Execution plan for current running queries. Locking, blocking, estimated execution plan, Actual execution plan and troubleshoot performance issue. * Acquainted with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and Agile methodologies including SCRUM and Sprints. * Hands on experience in creating various reports including drill through and drill down, Charts, Sub Reports and, Matrix reports on SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. * Have also worked handsomely on Bulk Copy Program utility, PowerShell, SQL and SQL command line utility. * Experienced in identifying memory bottlenecks and I/O, blocks and deadlocks caused by very complex queries using SQL Server Activity monitor and profiler, Dynamic Management Views (DMVs) and handling them by improving Query Execution plans. * Worked in a team-oriented, collaborative environment. Demonstrated ability to successfully manage, lead, and inspire a team of technical professionals. * Exhaustive experience in providing 24X7 on call support and troubleshooting in both stage and production environments.
Accomplishments
Highlights:
Keywords
