SUMMARY:

• A certified SQL Server DBA with over 8 years of experience in Database Administration, Design, Development and Support of MS SQL Server 2016/2014/2012/2008 R2/2005/2000 in Production, UAT and Development Environments.
• Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Reports, Backup and Disaster Recovery.
• Solid expertise entails SQL Server high availability (HA) solutions including Always - On, Clustering (Active/Active, Active/Passive).
• Proficient in SQL/T-SQL, indexes, stored procedures, triggers and functions. Proven ability to identify root cause of database issues with expertise to troubleshoot and resolve issues promptly.
• Hold exclusive knowledge of database security including data encryption and decryption. Strong knowledge of SQL server upgrades and migrate using various versions and editions.
• Expertise also includes high proficiency in using third party tools like Toad Data Modeler, SQL Sentry, Idera, ERWin, Redgate, SolarWinds, and Ultrabac.
• Extensive experience in Database Administration for very large and complex databases in SQL Server 2012/2008 R 2/2005/2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Proficient in performance tuning of T-SQL queries, stored procedures and debugging the poorly written code and helping application teams in development life cycle.
• Extensive experience in Installation, Upgrades, Patches, Configuration and Administration for SQL Server in a Clustered and Non-Clustered Environment.
• Experience in controlling and co-coordinating with Patch management (Security patches, Service packs) and any system performance before pre-deployment.
• Highly proficient in Database Backup, Restore, Pont-in-Time Recovery, Linked Servers, and Database Maintenance Plans.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Expertise in RDBMS concepts and constructs. Working with data modelers on logical and physical data modeling and DBAs/Developers in implementing and updating physical data models in databases.
• Exquisite skills in creating, setting up, configuring and scheduling jobs, database mail, notifications and alerts for database administration.
• Expertise in performance tuning, index tuning, maintenance, troubleshooting, query optimization and database consistency checks using DBCC utilities, DMVs and DMFs.
• Experience in resolving locks, deadlocks, Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Strong knowledge and experience in configuring and administering high availability solutions like database Mirroring, Replication, Log shipping, Clustering and AlwaysOn Availability Groups.
• Experience with Data Extraction, Transformation and Loading (ETL) using SSIS, BIDS/SSDT, BCP and Import/Export Wizard.
• Adequate knowledge of Configuring and Maintaining SQL Server Reporting Services (SSRS).
• Experience with schema management, database reorganization, partition, database maintenance and optimization.
• Expert level of Capacity Planning, Release Management and Incident Management.
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Providing 24x7 supports to Production servers (On-Call support on a rotational basis).

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012/2008R2/2003R2, VMware, Windows8/7/XP

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

SQL Server Tools: SSMS, Query Analyzer, Performance Monitor, SQL Server Profiler/Extended Events, BIDS/Data Tools, Database Tuning Advisor, SSIS, SQL Server Configuration Manager, Activity Monitor, Job Activity Monitor, Execution Plan, DMVs, DMFs, DBCC, Index Tuning Advisor

Data Modeling Tools: ERWin, Toad Data Modeler

Reporting Tools: SSRS, Report Builder

Data Migration: DTS, SSIS, BCP, Import/Export Wizard

Networking: TCP/IP, DNS, WAN, LAN

Hardware/Storage: SAN, RAID

Third Party Tools: Toad Data Modeler, SQL Sentry, Ultrabac, Idera, ERWin, Redgate, SolarWinds

PROFESSIONAL EXPERIENCE:

Confidential, Melville, New York

SQL Server Database Administrator

• Working as a Production DBA and Responsible for performance of the SQL Server Instance and safety of the data in database
• Configured, and Maintained SQL Server 2008 R2, 2012 in development, test, and production environments
• Installed SQL Server 2014/2016 on a test environment to be the future production environment
• Involved in technical decisions for Business requirements, Interaction with Business Analysts, Client team, Development team, Capacity Planning, and Up gradation of System Configuration.
• Involved in Migration of Database from SQL Server 2012 to SQL Server 2016.
• Responsible to provide 24x7 DBA and Production support for SQL Server Database in Production Servers
• Involved controlling and co-coordinating the installations (Security Patches, Service Packs) and System Performance before pre-deployment in production.
• Responsible for monitoring and troubleshooting database issues and make tuning adjustments to ensure database integrity, security and system performance.
• Responsible for overall configuration management of the database technologies, including initial database installations, upgrades, and the installation of service packs.
• Managed backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensured that the backup schedules met recovery requirements.
• Assisted and reviewed Developer SQL queries (T-SQL) and Stored Procedures for optimization and Security purposes.
• Extensive work experience in TempDB configuration, partitioning, shrinking, compression, and database optimization
• Configured Backups, involved in restoring database to point in time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events
• Implemented high availability with Mirroring, AlwaysOn Availability Groups and Failover Clustering
• 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
• Ensured all database servers are backed up in a way that meets the business RPO and RTO.
• Monitored and Scheduled jobs and created maintenance plans to automate different database administration related tasks including backup and database consistency check.
• Working Knowledge on Azure cloud technologies
• Implemented business rules in databases, set up referential integrity to maintain data integrity and other database level constraints.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling
• Involved in partitioning (Horizontal and Vertical) large tables to improve performance
• Involved in Source Data Analysis, analysis and designing mapping for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
• Work Environment: Windows Server 2012/2008R2, SQL Server 2008R2/2012/2016, Access, MySQL, Oracle, Linux, Java, C#.Net, .Net Framework, ASP.Net, MS TFS, Microsoft Reporting Services.

Confidential, Manhattan, New York

SQL Server Database Administrator

• Supports 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 2000, 2005, 2008 R2, 2012 in development, test, and production environments
• Installed SQL Server 2014 on a test environment to be the future production environment
• Configured Backups, involved in restoring database to point in time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events
• Implementing high availability with Mirroring, Log shipping, Replication, AlwaysOn Availability Groups and Failover Clustering
• Involved in SQL Server Configuration, Administration, Implementation and Troubleshooting for Business work
• 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 2005, 2008R2 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 monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases
• Performed Database refresh tasks from Production to Development and Staging Servers
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server
• Work Environment: Windows Server 2012/2008R2/2003R2/2000, SQL Server 2000/2005/2008 R2/2012, Access, MySQL, Oracle, Linux, Java & PHP Applications, ASP, ASP.Net, IIS 7.5/6.5, and Apache Server

Confidential, Hillsboro, OR

SQL Server Database Administrator

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers.
• Installed, Configured, and Managed SQL Server 2000, 2005, 2008R2 in Dev, Test, and Prod environments
• Responsible for Performance tuning, Index Tuning, Troubleshooting, Client/Server connectivity and Database Consistency checks using DBCC Utilities, DMVs and DMFs
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminate redundant and inconsistent data, normalized tables, established joins and created indexes as needed
• Regularly inspected SQL Server Error Logs, Space Usage, Disk Utilization, Backup status, Jobs, Customer Complaints, Windows Event Viewer for information, errors and warnings and Daily routine works
• Secured, managed and created logins, users, roles and granted permissions of database objects
• Created Backup strategy for production and development environments and managed Backup to different medias such as Local Drive, Network Drive/Backup Server, Tape Media and Restored databases
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, cleaning history, deleting old files, index and fragmentation managements
• Performed Physical and Logical Data Modeling, data analysis, database design and developing E-R diagram
• Assisted SQL Server Database Developers in code review and optimize SQL queries
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis
• Solving the request by user support and Participate in implementation of new release into production
• Upgraded SQL server 2005 to SQL Server 2008R2 in Microsoft Windows Server 2008 R2 Enterprise Edition
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Configured and Managed Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Managed Database Replication, Mirroring and Clustering using SQL Server 2008R2 and 2005
• Developed Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports
• Applied SP (Service Pack) and Hot Fixes on SQL Server 2005 and 2008R2.
• Work Environment: Windows Server 2008R2/2003R2, SQL Server 2000/2005/2008 R2/2012, Access, Oracle, Linux, Java & PHP Applications, ASP, ASP.Net, IIS 7.5/6.5, and Apache Tomcat.