SUMMARY

• A certified SQL Server DBA with over 6 and half years of experience in Database Administration, Design, Development and support of Microsoft SQL Server 2016, 2014, 2012, 2008R2 and 2005 in Production, UAT and Development Environments.
• Experience in Performance Tuning, Index Tuning, Execution Plan, Query analysis and Optimization, Creating and Deploying Reports, Backup and Disaster Recovery.
• Solid experience in SQL Server High Availability Solutions, including AlwaysOn, SQL Server Clustering, Replication, Database Mirroring and Log Shipping.
• Proficient in SQL/T - SQL, Indexes, Stored Procedures, Functions and Triggers.
• Ability to identify root cause of database issues and expertise to troubleshoot and resolve the issues promptly.
• Hold exclusive knowledge of SQL server Upgrade and Migrate using various versions and editions.
• Expertise in using SQL server native tools as well as third party tools.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008 R2, 2003 R2

Virtualization: VMWare, and vSphere.

Database: MS SQL Server 2014/2012/2008 R2/2005, MS Access, PostgreSQL, MySQL, Oracle

SQL Server Tools: SSMS, Query Analyzer, Performance Monitor, SQL Server Profiler, BIDS/Data Tools, DTA, SSIS, SQL, Activity Monitor, Job Activity Monitor, Execution Plan, DMVs, DMFs, DBCC

Data Modeling Tools: ERWin, Toad Data Modeler

Reporting Tools: SSRS, Report Builder, Crystal Reports

Data Migration: SSIS, Backup/Recovery, Detach/Attach, Import/Export Tool

ETL: SSIS, DTS

Hardware/Storage: SAN, RAID

Third Party Tools: ERWin, Toad Data Modeler, SolarWinds, OpNet, SQL Sentry/SentryOne, Redgate

Cloud: AWS

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

SQL Database Administrator

Responsibilities:

• Manage, maintain and secure production databases environment as well as test and Development environments
• Install, Configure, Manage and apply Service pack to SQL Server 2014 and 2012, 2008R2 in development, test and production environment
• Perform different routine backup jobs by using maintenance plan
• Performed manual and automation schedule backup job
• Perform tail log backup for point in time recovery based on the disaster recovery.
• Restore Database from backup file Server to production.
• Create documentations for upgrade and migrate databases.
• Migrate/upgrade SQL Server /2008R2 & SQL Server 2005, 2008/2008R2 to 2012 and 2014 and apply service packs
• Monitoring Server and databases Performance routinely
• Schedule jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification
• Monitor SQL Temp DB, Server Error Logs, and Usage space
• Configure and Maintain AlwaysOn in 2012 on Virtual machine using VMware
• Configure, Manage and maintain Transactional Replication
• Manage and maintain two NODE active passive cluster.
• Install, Configure, and administer SQL Server Reporting Services
• Develop and Deploy Reports using SSRS
• Import data from text file, excel file to SQL Server Database using SSIS packages
• Deploy and Debug SSIS packages for import, export and bulk insert data with transformation
• Writing T-SQL, Stored procedures and Functions,
• Assist Database Developers to optimize SQL queries and Stored Procedures
• Create, modify tables, Indexes (Clustered/Non-Clustered) as needed
• Use DBCC and DMV command to check database conditions, Rebuilding indexes and other database Maintenance purposes
• Perform database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.
• Analyzing the execution plan and index management for better Query Optimization.
• Apply Service Pack on SQL Server 2008 (SP4), 2012(SP3)
• Tuning queries which are running slow using Perfmon, Profiler and Statistics
• Work with windows team to failover the cluster when needed after windows patching.
• Working with developers to tune SQL queries to improve the performance
• Create and schedule Jobs, Alerts using SQL Server agent, check error logs to troubleshoot
• TDE: Create DB master key, symmetric keys, asymmetric keys and certificates for encryption.
• SSL: Configured and managed to encrypt data travelling over the internet.
• Performing partition for efficient management of database tables.
• Troubleshoot performance issues such as locking, blocking and deadlocks on production database using tools like SQL Server profiler.

Confidential, Hillsboro, OR

SQL Database Administrator

Responsibilities:

• Supported day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks
• Installed, Configured, and Maintained SQL Server 2008 R2, 2012, 2014 in development, test, and production environments
• Installed SQL Server 2014 on a test environment to be the future production environment
• Implemented TDE, and worked with System Admin to setup IPSec, and SSL
• Researched and recommended innovative, and where possible automated approaches for system administration tasks.
• Implemented high availability with Mirroring, Log shipping and Failover Clustering
• Upgraded SQL Server 2000 to SQL Server 2008 R2 and SQL Server 2005 to SQL Server 2012
• Applied SP (Service Pack) and Hot Fixes on SQL Server 2008 R2, and 2012
• Installed, Configured, and Administered SQL Server Reporting Services (SSRS), and Developed
• Deployed and Managed Reports for associates and upper management using SSRS, Crystal Reports and Report Builder
• Involved in complete database design including conceptual, logical and physical data models
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity
• Responsible for the systems administration, monitoring and maintenance of SQL and its related servers.
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources
• Imported data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server
• Migrated Oracle 10g/11g, MySQL 5.1/5.5 databases to SQL Server 2008R2 and 2012
• Performed Performance Monitoring, and troubleshooting using SQL Profiler, Execution Plan, Database Tuning Advisor and tracing and optimizing long running queries
• Wrote T-SQL scripts including Stored Procedures, triggers, and functions
• Created and Deployed Scripts like tables, views, Stored Procedures, triggers, and functions
• Scheduled to Rebuild and reorganize the index
• Worked on managing Locks, Blocks and deadlocks
• Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance
• Created, and Managed Jobs, Setup Alerts, SQL Mail Agent and scheduling SSIS Packages
• Implemented SQL Server security and Object permissions