SUMMARY:

• Expertise in MSSQL Database Administration, installation, configuration, monitoring and maintenance with effective troubleshooting and root cause capabilities
• Proven experience in the areas of Database Performance Tuning using SQL Server Profiler, Extended event, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC
• Strong work experience and knowledge with SQL Server Database High availability solution using Standby, Replication, Database Mirroring, Clustering, Log shipping - includes Installation, Configuration, Administration
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Experienced in upgrading SQL Server (2005/2008/2008 R2) instances to SQL Server 2012/2014 and migrating (instances and databases) from Oracle, MySQL to SQL Server
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, user defined data types and functions
• Experience in Database administration activities for DB Security ( encryption/decryption, creating logins, users, roles, and assigning permission to them)
• Extensive work experience in Database Partition, Compression TempDB and Database Optimization
• Strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines
• Solid experience in SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Experience in ETL processes, developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert
• Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, union all etc.
• Effective communication, multi-tasking and prioritizing skills, excellent interpersonal skills, strong customer focus, quick learner, reliable and dependable
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload
• Performed Production support and on Call duties

TECHNICAL SKILLS:

Database: SQL Server 2016/2014/2012/2008 R2/2005, MS Access 2007 & 2003/Excel 2007/2010/2013/ MySQL

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

Languages: T-SQL, My/SQL, HTML, XML, JavaScript, ASP, ASP.net, PHP

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

Reporting: SSRS (SQL Server Reporting Services) Report Builder 3.0/2.0

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

Third-Party Tools: Idera, ERwin, Toad Data Modeler,Sentry One, Service Now, ExpandIT

Networking: Active Directory, TCP/IP, DHCP/,LAN/,DNS/,HTTP/, HTTPS/,SMPT

Hardware/Storage: SAN, NAS, RAID, ISCSI

Native Tools: SSMS, Performance Tuning, Query Analyzer, Extended Event, SQL Profiler, Execution Plan, Activity Monitor, Database Tuning Advisor, DMV, DBCC

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

SQL Database Administrator/SQL DBA

Major Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor
• Installed, Configured, and Maintained SQL Server 2014, 2012, 2008 R2 in development, test, and production environment and SQL Server 2016 on Test environment.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/ R2 and SQL Server 2012/2014
• Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012
• Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgrade related issues
• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server
• Configured and Maintained Always-On Availability Group using SQL Server 2014/2012 with Synchronous automatic-failover mode
• Configured, managed, and monitored Transactional/Snapshot Replication and Log Shipping
• Wrote T-SQL queries, Stored-Procedures, functions, View, Index, Variable and Triggers
• Scheduled many jobs to automate different database related activities including monitoring database health, disk space, backup verification
• Involved in monitoring, troubleshooting, optimizing, and tuning lock, block, deadlock, index fragmentation, slow running queries, etc. using native and third party tools
• Developed Different Maintenance Plans for database monitoring
• Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications Implementation of SQL Logins,
• Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Deploying new code base release to UAT and Production Environments.
• Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Deployed SSIS packages to move data across server, move logins, load data from different data sources
• Used Import/Export Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Installed, Configured, and administered SQL Server Reporting Services (SSRS) and Reports development, deployment, distribution and reports subscriptions
• Monitor Server Activity, Error Log, space usage and solving problem as needed
• Working on call rotation 24/7 on Production environment

Environment: Windows Server 2012, 2008r2, 2003r2, IIS 8.5, 7.5, SQL Server, 2014, 2012, 2008r2, 2008, 2005, AD (Active Directory), JavaScript, ASP and ASP.net. VM server, TFS

Confidential, McLean, VA

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, configured, optimized and managed enterprise-wide SQL Server 2008 R2 and 2012 instances in development, test and production environment
• Applied SQL Server Service Packs and Cumulative Updates as required
• Setup, Configured, monitors and Maintained Database Replications and Mirroring
• Setup, configured, maintain and monitored troubleshoots SQL Server Clustering
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes
• Data Encryption and Data Decryption for data security in Database & Column level
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security
• Monitored data activities such as logs, space utilization, locks, long transaction
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Used T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using export/import tools and SSIS
• Installed and Configured SQL Server Reporting Services (SSRS) and Report migration
• Developed and Managed Report in SSRS (SQL Server Reporting Services) including securities
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files

Environment: SQL Server 2005, 2008R2, 2012, IIS 7.5, 8.5, Windows Server, 2003, 2003R2, 2008R2, 2012, ASP, ASP.net, Java, ETL and AD (Active Directory)SQL Sentry, Service Now, TFS

Confidential, MANHATTAN, NY

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured and Maintained SQL 2005, 2008 r2 in development, test, and production environment
• Responsible for implementing different types of Replication Models such as Transactional, Snapshot
• Implemented high availability SQL Server solutions with SQL Server Failover Clustering and Database Mirroring
• Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports OLEDB Data sources
• Applied SP (Service Pack) and patches on SQL Server 2005, 2008r2
• Fixed Missing Indexes and Excess indexes using DMV/Profiler/Execution Plan
• Worked on database Performance tuning, Server tuning and Query tuning
• Managed Database Backup, Restore and Point-in-Time Recovery process based on RPO/RTO.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Installed and Configured SSRS and Generated Report using SSRS/Report Builder
• Export/Import data from Excel/Flat/CSV files, and Oracle to SQL Server Database using DTS, SSIS, and BCP utility

Environment: SQL Server 2005, 2008R2 IIS Server 6.5, 7.5, Windows Server 2008R2, ASP.net, Java, ETL and AD (Active Directory) Share Point, Visual Studio, Service Now, OpNet