SUMMARY

• Certified Microsoft Professional with 7 plus years of experience in SQL Database Administration.
• Experienced on creating, maintaining database objects, managing MSSQL in development, testing, and production environments. Proficient with performance monitoring, troubleshooting, security, database migration, high availability and DR solutions up to windows failover clustering and sql server Always On configuration.
• Excellent understanding of coding with Microsoft T - SQL and stored procedures. I do have confidence in my excellent work ethic and willingness to put in significant extra time as needed. Along with my strong Database Administration background, I have good communication skill, Works well under pressure, strong team-oriented work ethic, and Skilled at learning new concepts quickly.

AREAS OF EXPERTISE

• Installation/Configuration
• SQL Server Migration
• PowerShell
• Automation
• Database Encryption
• Unix/Linux OS
• Database creation and
• Replication
• Platform maintenance
• Backup and Restore
• Unix Shell/Perl
• Database testing
• Performance scripting and
• Troubleshooting monitoring
• Automation
• Virtualization-
• Database Security
• Mirroring and Log
• Index Tuning shipping
• VMware/ Hyper-V
• Always On
• Linux/VM platform
• SQL Profiler
• Clustering
• AWS
• SQL failover clustering
• T-SQL

TECHNICAL SKILLS

RDBMS/DBMS: MSAccess2013/2007, MS SQL Server 2016, 2014, 2012 /2008 /2005

Native Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, SQL, Alerts, SQL Jobs, replication monitor tools, ETL, Performance MonitorActivity Monitor

Third Party Tools: Sqldiagnostic manager, light speed, Quest Spotlight, Solar Winds, SCCM, SQL Safe

Programming: T-SQL, SQL, PowerShell

Microsoft: Microsoft office tools, SharePoint, TFS

IDE: Visual Studio 2013/2012/2010

PROFESSIONAL EXPERIENCE

Confidential, Hoover, Alabama

SQL Database Administrator

Responsibilities:

• Install, configure, and manage multiple SQL server environments with high availability and disaster recovery
• Ensure all database servers are up and running.
• Working on the daily database related incidents\ requests and resolve it.
• Perform changes on production databases based on change order requests.
• Execute, manage, and validate database server backups
• Support the performance of functions, such as, applying patches, interfacing with application vendors, and assisting the application administrators
• Testing and implementing changes or new database designs
• Performance tuning of Index rebuild setup, configuration, concepts, techniques and tools.
• Performed troubleshooting, root cause analysis, workaround, and deploy resolutions.
• Deploy database change scripts provided by Developers or third party vendors.
• Working on Windows failover clustering and configuring AlwaysOn SQL server 2016 and sql server 2017
• Assessed database security vulnerabilities, identified and implemented remediation.
• Working on Column store indexes, In-Memory setup, Query store setup, Resource Pool setup and configuration.
• Participated in monthly database patching maintenance.
• Troubleshoot performance issues including after-hours and weekends
• Perform tests and evaluations regularly to ensure data security, privacy and integrity.
• Advanced knowledge of IBM Integrated Analytics System (IIAS ) security implementation.
• Monitor IIAS performance in addition to managing users and security.
• Advance knowledge of BLUDB\schema backup with script and using console

Environment: - Windows Server 2008/2012R2/2016, MS SQL Server 2008R 2/2012/2014/2016/ 2017 , T-SQL, SQL Profiler, Performance Monitor, Activity Monitor, SQLDIAG, ETL, PowerShell, Hyper-V, Data Warehousing, High Availability/AlwaysOn, TFS, Visual Studio, SharePoint, DB2 WLU. IIAS and Others.

Confidential, Sterling, VA

SQL Database Administrator

Responsibilities:

• Expert in performing installation, configuration, optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments
• Supporting and maintaining DB2 UDB ESE with DPF data warehouse BCU environment loads via Ab Initio ETL tool
• Routinely patched SQL servers using PowerShell scripts.
• Worked with SQL server profiler and generated traces to optimize the performance of the database.
• Involved building data warehouse using Oracle, Teradata and Netezza.
• Automated server and database health checks using PowerShell scripts.
• Expert in providing dedicated support for production database servers
• Expert in creating Backup and restore strategies following strict RPO and RTO guidelines
• Administration of large and complex databases in SQL Server 2008/2008R2/2012 and 2014.
• Configured and managed High Availability solutions (Clustering, database Mirroring, Log shipping
• Implemented and support of database replication in a different data center.
• Experienced in Migrating from SQL server 2008, 2012 and 2014 and documented complete Upgrade Process.
• Configured Always-ON for High availability as a disaster recovery (DR) solutions.
• Maintained indexes at regular intervals for better performance
• Scheduled jobs to automate different database related activities including backup, monitoring database health.
• Expert on creating reports using SSRS for different purposes
• Designed and implemented SSIS package to migrate data from multiple data sources
• Troubleshoot and resolved issues performance, database integrity, security issues
• Participating in 24/7 ‘on-call’ support for SQL Server database systems.

Environment: - Windows Server 2008/2012R2, MS SQL Server 2012/2014, T-SQL, SQL Profiler, Performance Monitor, Activity Monitor, ETL, Quest Spot Light, PowerShell, Hyper-V, Data Warehousing, High Availability/AlwaysOn, TFS, Visual Studio, SharePoint and Others.

Confidential, Arlington, VA

MSSQL Server DBA

Responsibilities:

• Managed databases, from planning and testing stages through implementation and production support
• Created logins, groups, users, roles, databases, alerts checking for database consistency
• Expert in creating automation for routine tasks and per need basis
• Expert in creating automation for routine tasks and per need basis
• Migrated/upgraded SQL Server 2008/2008R2 to 2012
• Applied service packs, extensive experience in migrating and new installations of SQL Server on Hyper-V and VMWARE environments
• Configured, Scheduled and check SQL Server agent Jobs/ Alerts for Maintenance plans, Backup and Recovery plans, Database Mail Configuration, facets and Transparent Data Encryption.
• Check database conditions, rebuilding indexes and other database maintenance purposes as well
• Troubleshoot performance issues
• Applied performance tuning techniques and maintained the functionalities of ongoing databases
• Deployment administration and operational support of production.
• Performed day-to-day activities/tickets including full, differential and log backups, database restores/refreshes and proactive monitoring of SQL server health.
• Worked with database developers to optimize SQL queries and stored procedures
• Provided constant online or on-call assistance to end users for handling their queries

Environment: - Windows Server 2008/2012R2, MS SQL Server 2008/2008R2, 2012/2014, T-SQL, SQL Profiler, Performance Monitor, Activity Monitor, ETL, SCCM, Quest Spot Light, PowerShell, Hyper-V, Data Warehousing, High Availability/AlwaysOn, TFS, Visual Studio, SharePoint and Others.