SUMMARY

• Microsoft certified SQL Server DBA with extensive experience in database administration, monitoring, designing, troubleshooting and performance tuning, seeking for a challenging position with a prospective and growing company to utilize and expand my technical knowledge, skills and expertise using SQL Server Database 2017,2016, 2014, 2012, 2008 R2, 2005, 2000.
• My expertise entails in database optimization, installation, backup/recovery, DR/HA, database design, security management including data encryption/decryption, ETL, SSIS and SSRS. Ability to identify root causes, bottlenecks and other database issues to troubleshoot and resolve promptly.
• Skilled in installation and management on high availability solutions including AlwaysOn, Clustering, Mirroring, Replications and Log Shipping. I also hold skills such as effective communication, strong work ethic, and good team player.
• Working experience entails strong knowledge on using database third party tools like OpNet, SolarWinds, Idera, ERWin, Visio, and Toad Data Modeler.
• Expertise in MSSQL Database Administration in server configuration, monitoring, performance tuning and maintenance with efficient troubleshooting capabilities
• Strong technical ability to perform business analysis, write documentations
• Knowledgeable in T - SQL, stored procedures, triggers and functions
• Administered SQL Server High Availability and Disaster Recovery strategies
• Skilled in ETL operations by SSIS using DTS, BIDS and SSDT tools
• Worked on logical and physical data base modeling with Toad and ERwin tools
• Experienced in using DMV and dynamic management functions for queries optimization
• Worked briefly on Cluster (active/active and active/passive nodes) and server consolidation
• Experienced in High Availability solutions and Security Management operations
• Proficient in SQL Server Backup/Recovery and Disaster Recovery solutions
• Obtained experience in DR process including Replication, Log Shipping and Database Mirroring
• Experienced on SQL Server 2012 upgrade (in place and side/side) from SQL Server 2008 / 2005
• Worked on SQL Server 2012 database migration from SQL Server 2008 / 2005
• Knowledgeable on 64/32-bit SQL servers and Windows server systems
• Maintained individual and group service accounts for SQL Server security
• Familiar with Data Center servers and handling VLDB databases
• Handled Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012
• Skilled in Import, Export, Backup, Database Monitoring tools and Application support
• Implemented Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g
• Strong knowledge in Integration Services (SSIS) and Reporting Services (SSRS)
• Working knowledge in Data Encryption and Data Decryption for data security
• Experienced in mentoring, coaching and writing documentation
• 24 X 7 SQL Database on Call Support

TECHNICAL SKILLS

Database: SQL Server 2016, 2014/2012/2008 R2/2005/2000, MS Access 2007 & 2003

Operating System: Windows 2012/2008 R2/2003 R2/2000, Windows XP/7/8, VMware

Languages: SQL, T-SQL, HTML, XML, ASP, ASP.net, PowerShell

ETL Tools: Native Tools (SSDT, BIDS, DTS and SSIS)

Reporting: SSRS (SQL Server Reporting Services) in HTML, Excel, Text

Data Modeling: ERwin, Toad Data Modeler, SSDD (SQL Server Database Diagram)

Third-Party Tools: Idera, Redgate, ServiceNow, JIRA

Networking: Active Directory, TCP/IP, SSL Certificate, TLS

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE

Confidential, Cerritos, Ca

SQL Server Database Admin/DBA/Analyst

Responsibilities:

• Installed, Configured, and Managed Instances and Databases in SQL Server 2016,2014 and 2012, in development, Training, Staging, Test/UAT, and Production Environment
• Designed and Managed Database Backups and Restoring strategies based on RPO, RTO, and SLA for development, Training, Staging, Test/UAT, and Production Environment
• Implemented Service Packs (SP) and HOT Fixes on stand-alone and HA (High Availability) instances
• Configured and Managed HA (High Availability) Solutions like, AlwaysOn, Failover Clustering, Replications, Mirroring, and Log Shipping
• Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Performed Data Modeling, Databases Design/Architecture and capacity planning using data modeling tools such as ERWin and Toad Data Modeler
• Developed SQL, T-SQL (DDL, DML), stored procedures, functions, triggers and user defined functions (UDF).
• Involved in Performance Tuning, Query optimization, identifying and troubleshooting I/O and memory bottle necks, lock, block and deadlocks, monitoring sessions, and query executing
• Hands on experience on Query Execution plans, Database Tuning Advisor, PerfMon, Server Logs, Agent Logs and Error Logs, Event Logs, DMV (Dynamic Management View), Profiler and Indexing, Index and Statistics Management
• Designed and Managed Data partitioning for large tables to increase performance
• Created and Managed Indexes including Managing Statistics
• Used different monitoring and troubleshooting tools for server, database and performance tuning purposes such as SQL Server Activity monitor, profiler, Dynamic Management Views (DMV), Query Execution plan, SQL Server Logs, Agent Logs, Solar Winds, OpNet and so on
• Designed, configured, and managed Maintenance plans, Jobs, Alerts, and Notifications
• Data dump and import from Excel and Flat file into MS SQL Server
• Installed, Configured, and Managed SSIS (SQL Server Integration Services) Instance and performed related tasks such as
• Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources
• Migrated and Upgraded SSIS Packaged, Setup jobs using SSIS Packages, Managed security, Used SSIS packages for many other purposes - Moving logins, databases, data, and for other objects
• Upgraded SQL Server Instances from older version to higher version like from 2008 R2, 2012 to SQL Server 2014, 2016 using In-place and Side by Side Upgrade Methods
• Worked with application team members to improve performance of queries and applications
• Applied Data Masking, Transparent Data Encryption (TDE), Database Role, Server Role and Custom Role
• Worked ChM (Change Management) Team for release management and Deployment related tasks

Confidential, Richmond, VA

SQL Server Database Admin/DBA/Analyst

Responsibilities:

• Configured and Managed HA solutions on Log Shipping, Mirroring, Replication, Clustering, and AlwaysOn
• Created the Backup and Restore strategy for production and development environments.
• Installed, configured, monitored, troubleshooting and Administered of SQL Server 2016, 2014, 2012, 2008R2 and Windows Server 2012 and 2008 R2.
• Expertise in Database Backup and Recovery procedures by using N ative and third-party tools.
• Experienced on RTO and RPO in SLA level.
• Migrated and Upgraded SQL Server instances and Databases from older version to higher version
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity
• Performed performance tuning activities in different aspect using different tools like Execution Plan, SQL Profiler, Performance Monitor/Profiler, Index Tuning, Index rebuild, reorganize, setup automated jobs for index management tasks, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Resolve Dead locks/Long running queries
• Proven working experience on Query Optimization, Indexing, and Troubleshooting SQL Server related issues.
• Experienced in using DMV, DBCC
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Used Business Intelligence Tools to Create SSRS Reports and SSIS packages
• Configured and managed Reporting Servers, Deployed, migrated, upgraded Reporting Server
• Implemented Data Encryption and Decryption in database and column level for data security.
• Performed Table partitioning, data archival activities
• Monitored and recommend ideas to create, modify, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures, Triggers in various tables for better performance
• System performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability
• Defining SQL Server standards for HA based on Applications requirements.
• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
• DR planning, coordination and implementation.
• Capacity planning for Database and generating the Database growth.
• Managing cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment
• Planned, and Developed Backup strategies, setup backup jobs, maintenance plan jobs, monitoring and troubleshooting jobs
• Upgraded and Migrated Databases and Database Servers/Instances
• Applied SP, Hot Fix, Featured Pack, Cumulative updates
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Worked with developers for writing TSQL Scripts for applications and tuning up application performance

Environment: SQL Server 2008R2, 2012 R2, 2014 Enterprise Edition with AlwaysOn, Clustering, Replication and Stand-Alone, OLTP & OLAP environment, SSAS, ETL (SSIS, DTS), SSRS, Windows Server 2008 R2, 2012R2 Server, IIS Application Server, File Server, Ticketing System

Confidential, Reston, VA

SQL Server DBA

Responsibilities:

• Installed, Configured, and Managed Instances and Databases in SQL Server 2016,2014 and 2012, in development, Training, Staging, Test/UAT, and Production Environment
• Designed and Managed Database Backups and Restoring strategies based on RPO, RTO, and SLA for development, Training, Staging, Test/UAT, and Production Environment
• Implemented Service Packs (SP) and HOT Fixes on stand-alone and HA (High Availability) instances
• Configured and Managed HA (High Availability) Solutions like, AlwaysOn, Failover Clustering, Replications, Mirroring, and Log Shipping
• Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Performed Data Modeling, Databases Design/Architecture and capacity planning using data modeling tools such as ERWin and Toad Data Modeler
• Developed SQL, T-SQL (DDL, DML), stored procedures, functions, triggers and functions (UDF).
• Involved in Performance Tuning, Query optimization, identifying and troubleshooting I/O and memory bottle necks, lock, block and deadlocks, monitoring sessions, and query executing
• Designed and Managed Data partitioning for large tables to increase performance
• Created and Managed Indexes including Managing Statistics
• Hands on experience on Query Execution plans, Database Tuning Advisor, PerfMon, Server Logs, Agent Logs and Error Logs, Event Logs, DMV (Dynamic Management View), Profiler and Indexing, Index and Statistics Management
• Used different monitoring and troubleshooting tools for server, database and performance tuning purposes such as SQL Server Activity monitor, profiler, Dynamic Management Views (DMV), Query Execution plan, SQL Server Logs, Agent Logs, Solar Winds, OpNet and so on
• Designed, configured, and managed Maintenance plans, Jobs, Alerts, and Notifications
• Data dump and import from Excel and Flat file into MS SQL Server
• Installed, Configured, and Managed SSIS (SQL Server Integration Services) Instance and performed related tasks such as
• Developed, Deployed and Managed SSIS Packages using different types of sources such as Database, Flat file, CSV, Excel and OLE DB supporting sources
• Migrated and Upgraded SSIS Packaged, Setup jobs using SSIS Packages, Managed security, Used SSIS packages for many other purposes - Moving logins, databases, data, and for other objects
• Upgraded SQL Server Instances from older version to higher version like from 2008 R2, 2012 to SQL Server 2014, 2016 using In-place and Side by Side Upgrade Methods
• Worked with application team members to improve performance of queries and applications
• Applied Data Masking, Transparent Data Encryption (TDE), Database Role, Server Role and Custom Role
• Worked ChM (Change Management) Team for release and Deployment related tasks
• Attended and contributor of different meetings such as RCA (Root Cause Analysis), CCB (Change Control Board) and represented database team for different tickets/CR (Change Request)
• Closely worked with System Admin, Network Admin, VM Team for different areas like Web and Application Server, File Transfer System

Environment: SQL Server 2005, 2008R2, 2012, 2014, IIS 7.5, 8.5, Windows Server, 2003R2, 2008R2, 2012, ASP, ASP.net, Java, ETL and AD (Active Directory), Expand-IT, Financial Application, My SQL, Service-Now, JIRA, VM Server, OpNet, SQL Sentry One

Confidential, NYC NY

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2008 and 2008 R2 in dev, test and prod environment
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Customized support for Client’s Applications and maintaining database objects and structures such as tables, indexes, views, triggers, functions, procedures.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services such as ETL using SSIS, Exp/imp Data and query for ETL purposes
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Used DMV for finding out long running queries and routine database management purposes
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Expertise in Disaster Recovery Planning and Security Management operations.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Developed & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities like database status, logs, space utilization, checkpoints, locks and blocks
• Suggested database application level tuning for queries and SQL objects for optimum performance
• Experience on 64-bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Experience in mentoring team members and writing documentation.

Environment: SQL Server 2008R2, 2012, 2014, IIS 7.5, 8.5, Windows Server, 2003R2, 2008R2, 2012, ASP, ASP.net, Java, ETL and AD (Active Directory), Expand-IT, Financial Application, My SQL, Service-Now, JIRA, VM Server, OpNet