SUMMARY:

Expert SQL Database Administrator (DBA) with 8 years of experience seeking a position in which I can become a significant asset while both enhancing and utilizing my skills and expertise in designing implementing and maintaining SQL Server solutions in an Enterprise Environment. Extensive experience in Disaster Recovery and High Availability solutions (including backup/ restore, log shipping, database mirroring, failover clustering and AlwaysOn Availability Groups), Security, Performance Monitoring, Performance Tuning and Capacity Planning. Skilled in writing complex T - SQL including Dynamic Queries, Sub-Queries, Joins, Stored Procedures, Triggers, User-defined Functions, Views, CTEs and Cursors, developing SSIS packages, creating SSRS reports and SSAS reports. Adept in database administration for development, test and production environments for very large and complex databases in MS SQL Server 2016/2014/2012/2008/ R2/2005. Experience working with Version Control System tools for deploying scripts in various stages of SQL Server.

DBA SKILLS:

• SQL Server installation and configuration
• SQL Database Administration
• SQL Server consolidation
• SQL Server Virtualization
• Standby/Failover Administration
• Relational databases
• Backup and recovery
• High Availability and Disaster recovery
• Performance tuning and Capacity monitoring
• Troubleshooting
• Query Optimization
• Dynamic management views (DMV)
• Dynamic management functions (DMF)
• Data security
• Database migration
• T-SQL Scripts
• Microsoft Power Shell Scripts
• Creating, managing, and delivering server based reports(SSIS, SSRS and SSAS)

TECHNICAL SKILLS:

Relational DBMS: Microsoft SQL Server 2016/2014/2012/2008/ R2/2005, Microsoft Access and Oracle

Server operating systems: Windows Server 2012R2/2008/2008R2/2003

Database Programming: T-SQL, PL/SQL, MySQL

Programming: C++, Java, Python, JavaScript, XML, VB.NET, ASP.NET

Database modeling: VISIO, ERWIN, Dezign

ETL tools: MS SQL Server integration services, DTS

Reporting: SQL Reporting Service /SSRS/

Analysis: SQL Analysis Service /SSAS/

Third party tools: Red Gate, Idera

Applications: IIS, Visual Studio, FTP, TFS, Dreamweaver, Oracle, Eclipse

Networking: SAN, NAS, LAN, WAN

PROFESSIONAL EXPERIENCE:

Confidential, Pentagon City, VA

SQL Server Database Administrator (DBA)

Responsibilities:

• Apply periodic service packs and hot fixes, cumulative updates for Dev, Quality assurance and Production environment
• Perform daily checkups on SQL jobs, replication, backups, SQL and windows error logs as part of proactive maintenance plan
• Develop complex T-SQL scripts to create database objects and perform DML and DDL tasks
• Create databases, tables, indexes, stored procedures, views, database management policies, constraints, defaults, rules, functions, triggers, cursors and dynamic SQL queries
• Manage users and groups (roles) from Active directory, provide appropriate server/database roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity
• Design disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures
• Setup and manage transactional log shipping, SQL server Mirroring (Synchronous/ Asynchronous), Fail over clustering and Transactional replication in multiple environments as part of disaster recovery plan and load balancing strategy
• Use SQL native tools such as Database Tuning Advisor (DTA), SQL profiler, performance monitor, Activity monitor, Event viewer, Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) for monitoring, performance tuning/analysis and troubleshooting
• Analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), statistics, partitions, client/server connectivity
• Monitor locks, blocks, deadlocks, resource utilization; handle isolation level and concurrency issues
• Analyze and deploy scripts and packages in production/test environments from different developers
• Configure SMTP Server for database mail setup to receive alerts
• Migrate SQL server 2008R2 to SQL Server 2014 in Microsoft Windows Server 2012 R2 Data Center Edition using SQL Server Integration Services (SSIS)
• Develop automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS) packages
• Develop reports using SQL Server Reporting Services (SSRS)
• Improve performance, reliability, security and scalability by improving internal processes; recommend new storage hardware (RAID 5)
• Document processes of installations, clustering, Always-On availability group setup, Database mirroring, replication, migration steps, patching, common errors reported by users during call, and improvement

Confidential

SQL Server Database Administrator (DBA)/ Developer

Responsibilities:

• Managed and administered 800+ databases in 95 instances, and worked in a project to consolidate servers and to remove unused databases; reduced the number of databases to700 on 75 instances
• Created constraints, defaults, tables, indexes, views, stored procedures, functions, triggers, cursors, temporary tables and dynamic SQL queries
• Performed normalization, database design, performance analysis and production support
• Scheduled and automated maintenance plans using SQL Server job agent
• Installed and configured SQL 2012 clustered environment with availability groups
• Installed and configured SQL 2008 clustered test environment
• Upgraded from MS SQL 2008 to MS SQL 2012 clustered test environment and worked on cluster manager
• Setup, supported and managed transactional log shipping, SQL server mirroring (Synchronous/ Asynchronous), fail over clustering and replication in both SQL 2008 and 2012
• Developed configuration file for SQL Server installation
• Practiced performance tuning including updating statistics, re-indexing, query optimization
• Utilized native tools like database tuning advisor, SQL profiler, performance monitor, activity monitor, Event viewer for performance analysis
• Resolved database fragmentation, resulting in improved performance and effective space management
• Analyzed locks, deadlocks and handling the isolation level and concurrency effects
• Analyzed execution plans and index management for better query optimization
• Configured SMTP Server for database mail setup and received alerts
• Implemented databases and server audit
• Upgraded and downgraded SQL server instances
• Developed reports using SQL Server Reporting Services (SSRS)
• Created an application for Sales department using ASP.Net, VB.Net and SQL Server 2005 and collected report
• Created database objects like tables, stored procedures, views, triggers, user defined data types and functions
• Experience with T-SQL (in writing procedures, triggers and functions)

Confidential

SQL Server Database Administrator (DBA) & Data Analyst

Responsibilities:

• Installed and configured database software and corresponding tools
• Installed, configured and administered development and test servers
• Created and optimized database objects such as tables, views, indexes, cursors, stored procedures, functions and triggers
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability
• Achieved data migration from MS SQL 2005 and other flat files to MS SQL 2008
• Used database consistency checks using DBCC utilities
• Scheduled and automated full/differential/ transactional backups
• Configured and monitored database replication as high availability and disaster recovery strategy
• Upgraded the SQL Server Databases; monitored SQL Server and databases performance
• Developed reports using SSRS with T-SQL, MS Excel
• Developed automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS)
• Implemented database mirroring with automatic/manual failover for high availability